32 lines
921 B
TypeScript
32 lines
921 B
TypeScript
import { drizzle } from "drizzle-orm/node-postgres";
|
|
import pkg from "pg";
|
|
const { Pool } = pkg;
|
|
import { projects } from "./src/drizzle/projects";
|
|
|
|
async function seed() {
|
|
const pool = new Pool({
|
|
host: process.env.POSTGRES_HOST ?? "localhost",
|
|
port: Number(process.env.POSTGRES_PORT ?? 5432),
|
|
user: process.env.POSTGRES_USER ?? "postgres",
|
|
password: process.env.POSTGRES_PASSWORD ?? "postgres",
|
|
database: process.env.POSTGRES_DB ?? "work_hub",
|
|
});
|
|
|
|
const db = drizzle(pool);
|
|
|
|
console.log("Seeding database...");
|
|
|
|
await db.insert(projects).values([
|
|
{ name: "Sample Project", description: "A sample project for development", status: "active" },
|
|
{ name: "Archived Project", description: "An archived test project", status: "archived" },
|
|
]);
|
|
|
|
console.log("Seed complete.");
|
|
await pool.end();
|
|
}
|
|
|
|
seed().catch((err) => {
|
|
console.error("Seed failed:", err);
|
|
process.exit(1);
|
|
});
|