3/25 까지의 대표님 작업사항

1 files changed, 43 insertions, 0 deletions

diff --git a/db/seeds/projects.ts b/db/seeds/projects.ts
new file mode 100644
index 00000000..64bf3173
--- /dev/null
+++ b/db/seeds/projects.ts
@@ -0,0 +1,43 @@
+// /scripts/seedProjects.ts (예시 경로)
+
+import db from "@/db/db"
+import { projects } from "@/db/schema/projects"
+import { faker } from "@faker-js/faker"
+import { eq } from "drizzle-orm"
+
+async function main() {
+  console.log("Seeding projects...")
+
+  // (선택) 기존 데이터 삭제
+  await db.delete(projects)
+
+  // N개의 프로젝트 생성
+  const NUM_PROJECTS = 10
+
+  for (let i = 0; i < NUM_PROJECTS; i++) {
+    // 무작위 프로젝트 코드 (ex: "P-1234")
+    const projectCode = `P-${faker.number.int({ min: 1000, max: 9999 })}`
+    // 무작위 프로젝트 이름 (ex: "Project" + adjective/noun)
+    const projectName = `Project ${faker.word.adjective()} ${faker.word.noun()}`
+
+    // Insert
+    const [inserted] = await db
+      .insert(projects)
+      .values({
+        code: projectCode,
+        name: projectName,
+      })
+      .returning({ id: projects.id })
+
+    console.log(`Inserted Project #${inserted.id}: ${projectCode} - ${projectName}`)
+  }
+
+  console.log("Seeding projects completed.")
+  process.exit(0)
+}
+
+// 실행
+main().catch((err) => {
+  console.error(err)
+  process.exit(1)
+})
\ No newline at end of file