cyclicTables.test.ts — drizzle-orm Source File

Source Code

import BetterSqlite3 from 'better-sqlite3';
import { sql } from 'drizzle-orm';
import type { BetterSQLite3Database } from 'drizzle-orm/better-sqlite3';
import { drizzle } from 'drizzle-orm/better-sqlite3';
import { afterAll, afterEach, beforeAll, expect, test } from 'vitest';
import { reset, seed } from '../../../src/index.ts';
import * as schema from './sqliteSchema.ts';

let client: BetterSqlite3.Database;
let db: BetterSQLite3Database;

beforeAll(async () => {
	client = new BetterSqlite3(':memory:');

	db = drizzle(client);

	db.run(
		sql`
			create table model
			(
			    id             integer not null
			        primary key,
			    name           text    not null,
			    defaultImageId integer,
				foreign key (defaultImageId) references model_image
			);
		`,
	);

	db.run(
		sql`
			create table model_image
			(
			    id      integer not null
			        primary key,
			    url     text    not null,
			    caption text,
			    modelId integer not null
			        references model
			);
		`,
	);

	// 3 tables case
	db.run(
		sql`
			create table model1
			(
			    id             integer not null
			        primary key,
			    name           text    not null,
			    userId         integer,
			    defaultImageId integer,
				foreign key (defaultImageId) references model_image1,
				foreign key (userId) references user
			);
		`,
	);

	db.run(
// ... (79 more lines)