-
Notifications
You must be signed in to change notification settings - Fork 0
/
drizzle-seed.ts
36 lines (30 loc) · 1.14 KB
/
drizzle-seed.ts
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
import { drizzle } from "drizzle-orm/better-sqlite3";
import Database from "better-sqlite3";
import { analytics } from "@/drizzle/schemas/analytics.db.server";
import { mails } from "@/drizzle/schemas/mails.db.server";
import { sales } from "@/drizzle/schemas/sales.db.server";
import { transactions } from "@/drizzle/schemas/transactions.db.server";
import analyticsData from "./seeds/analytics.json"
import mailsData from "./seeds/mails.json"
import salesData from "./seeds/sales.json"
import transactionsData from "./seeds/transactions.json"
async function main() {
const betterSqlite = new Database("sqlite.db");
const db = drizzle(betterSqlite);
console.log("Seed start");
try {
console.log("started seeding database");
await db.insert(analytics).values(analyticsData);
await db.insert(mails).values(mailsData)
await db.insert(sales).values(salesData)
await db.insert(transactions).values(transactionsData);
console.log("database seeded successfully")
betterSqlite.close()
process.exit();
} catch (error) {
console.log("Error seeding database", error);
betterSqlite.close()
process.exit(1);
}
}
main();