sqlite-nw.test.ts — drizzle-orm Source File

Source Code

/// <reference types="bun-types" />
import { Database } from 'bun:sqlite';
import { DefaultLogger, sql } from 'drizzle-orm';
import type { BunSQLiteDatabase } from 'drizzle-orm/bun-sqlite';
import { drizzle } from 'drizzle-orm/bun-sqlite';
import { integer, real, sqliteTable, text } from 'drizzle-orm/sqlite-core';
import { suite } from 'uvu';

const order = sqliteTable('Order', {
	id: integer('Id'),
	customerId: text('CustomerId'),
	employeeId: integer('EmployeeId'),
	orderDate: text('OrderDate'),
	requiredDate: text('RequiredDate'),
	shippedDate: text('ShippedDate'),
	shipVia: integer('ShipVia'),
	freight: real('Freight'),
	shipName: text('ShipName'),
	shipAddress: text('ShipAddress'),
	shipCity: text('ShipCity'),
	shipRegion: text('ShipRegion'),
	shipPostalCode: text('ShipPostalCode'),
	shipCountry: text('ShipCountry'),
});

interface Context {
	db: BunSQLiteDatabase;
}

const test = suite<Context>('sqlite-bun');

test.before((ctx) => {
	try {
		const dbPath = process.env['SQLITE_DB_PATH'] ?? ':memory:';

		const client = new Database(dbPath);
		ctx.db = drizzle(client, { logger: new DefaultLogger() });
	} catch (e) {
		console.error(e);
	}
});

// test.before.each((ctx) => {
// 	try {
// 		const { db } = ctx;

// 		db.run(sql`drop table if exists ${usersTable}`);
// 		db.run(sql`
// 		create table ${usersTable} (
// 			id integer primary key,
// 			name text not null,
// 			verified integer not null default 0,
// 			json blob,
// 			created_at text not null default (strftime('%s', 'now'))
// 		)`);
// 	} catch (e) {
// 		console.error(e);
// 	}
// });

// ... (222 more lines)