initial commit

1 files changed, 44 insertions, 0 deletions

diff --git a/lib/pq/repository.ts b/lib/pq/repository.ts
new file mode 100644
index 00000000..95daf9a3
--- /dev/null
+++ b/lib/pq/repository.ts
@@ -0,0 +1,44 @@
+import db from "@/db/db";
+import { pqCriterias } from "@/db/schema/pq";
+import {
+    eq,
+    inArray,
+    not,
+    asc,
+    desc,
+    and,
+    ilike,
+    gte,
+    lte,
+    count,
+    gt,
+} from "drizzle-orm";
+import { PgTransaction } from "drizzle-orm/pg-core";
+
+export async function selectPqs(
+    tx: PgTransaction<any, any, any>,
+    params: {
+        where?: any; // drizzle-orm의 조건식 (and, eq...) 등
+        orderBy?: (ReturnType<typeof asc> | ReturnType<typeof desc>)[];
+        offset?: number;
+        limit?: number;
+    }
+) {
+    const { where, orderBy, offset = 0, limit = 10 } = params;
+
+    return tx
+        .select()
+        .from(pqCriterias)
+        .where(where)
+        .orderBy(...(orderBy ?? []))
+        .offset(offset)
+        .limit(limit);
+}
+/** 총 개수 count */
+export async function countPqs(
+    tx: PgTransaction<any, any, any>,
+    where?: any
+) {
+    const res = await tx.select({ count: count() }).from(pqCriterias).where(where);
+    return res[0]?.count ?? 0;
+}