summaryrefslogtreecommitdiff
path: root/lib/procurement-rfqs/repository.ts
diff options
context:
space:
mode:
Diffstat (limited to 'lib/procurement-rfqs/repository.ts')
-rw-r--r--lib/procurement-rfqs/repository.ts50
1 files changed, 0 insertions, 50 deletions
diff --git a/lib/procurement-rfqs/repository.ts b/lib/procurement-rfqs/repository.ts
deleted file mode 100644
index eb48bc42..00000000
--- a/lib/procurement-rfqs/repository.ts
+++ /dev/null
@@ -1,50 +0,0 @@
-// src/lib/tasks/repository.ts
-import db from "@/db/db";
-import { procurementRfqsView } from "@/db/schema";
-import {
- eq,
- inArray,
- not,
- asc,
- desc,
- and,
- ilike,
- gte,
- lte,
- count,
- gt, sql
-} from "drizzle-orm";
-import { PgTransaction } from "drizzle-orm/pg-core";
-
-/**
- * 단건/복수 조회 시 공통으로 사용 가능한 SELECT 함수 예시
- * - 트랜잭션(tx)을 받아서 사용하도록 구현
- */
-export async function selectPORfqs(
- tx: PgTransaction<any, any, any>,
- params: {
- where?: any;
- orderBy?: (ReturnType<typeof asc> | ReturnType<typeof desc>)[];
- offset?: number;
- limit?: number;
- }
-) {
- const { where, orderBy, offset = 0, limit = 10 } = params;
-
- return tx
- .select()
- .from(procurementRfqsView)
- .where(where ?? undefined)
- .orderBy(...(orderBy ?? []))
- .offset(offset)
- .limit(limit);
-}
-/** 총 개수 count */
-export async function countPORfqs(
- tx: PgTransaction<any, any, any>,
- where?: any
-) {
- const res = await tx.select({ count: count() }).from(procurementRfqsView).where(where);
- return res[0]?.count ?? 0;
-}
-