24 lines
1.0 KiB
TypeScript
24 lines
1.0 KiB
TypeScript
import type { Db } from "@wrnexus/db";
|
|
|
|
export default async function seed(db: Db): Promise<void> {
|
|
const owner = "demo-owner";
|
|
await db.exec("DELETE FROM crm_activities");
|
|
await db.exec("DELETE FROM crm_deals");
|
|
await db.exec("DELETE FROM crm_contacts");
|
|
await db.exec(
|
|
"INSERT INTO crm_contacts (owner_id,name,email,company,phone,status) VALUES (?,?,?,?,?,?)",
|
|
[owner, "Ada Lovelace", "ada@example.test", "Analytical Engines", "+1 555 0101", "customer"],
|
|
);
|
|
await db.exec(
|
|
"INSERT INTO crm_contacts (owner_id,name,email,company,phone,status) VALUES (?,?,?,?,?,?)",
|
|
[owner, "Grace Hopper", "grace@example.test", "Compiler Labs", "+1 555 0102", "lead"],
|
|
);
|
|
const contact = await db.one<{ id: number }>("SELECT id FROM crm_contacts WHERE email = ?", [
|
|
"ada@example.test",
|
|
]);
|
|
await db.exec(
|
|
"INSERT INTO crm_deals (owner_id,contact_id,title,value_cents,stage,close_date) VALUES (?,?,?,?,?,?)",
|
|
[owner, contact?.id ?? null, "Enterprise rollout", 12500000, "proposal", "2026-12-15"],
|
|
);
|
|
}
|