sqliteTest.ts — drizzle-orm Source File

Source Code

import 'dotenv/config';
import path from 'path';

import betterSqlite3 from 'better-sqlite3';
import { drizzle } from 'drizzle-orm/better-sqlite3';
import { migrate } from 'drizzle-orm/better-sqlite3/migrator';

import { seed } from '../../src/index.ts';
import * as schema from './sqliteSchema.ts';

const { Sqlite_PATH } = process.env;
const sqliteDb = betterSqlite3(Sqlite_PATH);
const db = drizzle(sqliteDb);

console.log('database connection was established successfully.');

(async () => {
	migrate(db, { migrationsFolder: path.join(__dirname, '../../../sqliteMigrations') });
	console.log('database was migrated.');

	const titlesOfCourtesy = ['Ms.', 'Mrs.', 'Dr.'];
	const unitsOnOrders = [0, 10, 20, 30, 50, 60, 70, 80, 100];
	const reorderLevels = [0, 5, 10, 15, 20, 25, 30];
	const quantityPerUnit = [
		'100 - 100 g pieces',
		'100 - 250 g bags',
		'10 - 200 g glasses',
		'10 - 4 oz boxes',
		'10 - 500 g pkgs.',
		'10 - 500 g pkgs.',
		'10 boxes x 12 pieces',
		'10 boxes x 20 bags',
		'10 boxes x 8 pieces',
		'10 kg pkg.',
		'10 pkgs.',
		'12 - 100 g bars',
		'12 - 100 g pkgs',
		'12 - 12 oz cans',
		'12 - 1 lb pkgs.',
		'12 - 200 ml jars',
		'12 - 250 g pkgs.',
		'12 - 355 ml cans',
		'12 - 500 g pkgs.',
		'750 cc per bottle',
		'5 kg pkg.',
		'50 bags x 30 sausgs.',
		'500 ml',
		'500 g',
		'48 pieces',
		'48 - 6 oz jars',
		'4 - 450 g glasses',
		'36 boxes',
		'32 - 8 oz bottles',
		'32 - 500 g boxes',
	];
	const discounts = [0.05, 0.15, 0.2, 0.25];

	await seed(db, schema).refine((funcs) => ({
		customers: {
			count: 10000,
// ... (103 more lines)