drizzle-orm Architecture Docs
Home / File/ sqlite.test.ts — drizzle-orm Source File

sqlite.test.ts — drizzle-orm Source File

Architecture documentation for sqlite.test.ts, a typescript file in the drizzle-orm codebase. 4 imports, 0 dependents.

File typescript 4 imports

Entity Profile

Dependency Diagram

graph LR
  655bce8d_2147_8322_1c83_2eada8e7cde6["sqlite.test.ts"]
  690f7dfc_0aea_9ee8_d6e7_26bbb3689031["drizzle-orm"]
  655bce8d_2147_8322_1c83_2eada8e7cde6 --> 690f7dfc_0aea_9ee8_d6e7_26bbb3689031
  28ab9394_054d_e176_bc32_0ec8b0808e2a["libsql"]
  655bce8d_2147_8322_1c83_2eada8e7cde6 --> 28ab9394_054d_e176_bc32_0ec8b0808e2a
  25248a9d_ba06_2b33_4421_8575da2f9c34["sqlite-core"]
  655bce8d_2147_8322_1c83_2eada8e7cde6 --> 25248a9d_ba06_2b33_4421_8575da2f9c34
  8d35eaf2_a542_cfd4_fa1a_fafca0f02686["vitest"]
  655bce8d_2147_8322_1c83_2eada8e7cde6 --> 8d35eaf2_a542_cfd4_fa1a_fafca0f02686
  style 655bce8d_2147_8322_1c83_2eada8e7cde6 fill:#6366f1,stroke:#818cf8,color:#fff

Relationship Graph

Source Code

import { sql } from 'drizzle-orm';
import { drizzle } from 'drizzle-orm/libsql';
import { int, sqliteTable, text, withReplicas } from 'drizzle-orm/sqlite-core';
import { describe, expect, it, vi } from 'vitest';

const usersTable = sqliteTable('users', {
	id: int('id' as string).primaryKey(),
	name: text('name').notNull(),
	verified: text('verified').notNull().default('true'),
});

const users = sqliteTable('users', {
	id: int('id' as string).primaryKey(),
});

describe('[select] read replicas sqlite', () => {
	it('primary select', () => {
		const primaryDb = drizzle.mock();
		const read1 = drizzle.mock();
		const read2 = drizzle.mock();

		const db = withReplicas(primaryDb, [read1, read2]);

		const spyPrimary = vi.spyOn(primaryDb, 'select');
		const spyRead1 = vi.spyOn(read1, 'select');
		const spyRead2 = vi.spyOn(read2, 'select');

		const query = db.$primary.select().from(users);

		expect(spyPrimary).toHaveBeenCalledTimes(1);
		expect(query.toSQL().sql).toEqual('select "id" from "users"');

		expect(spyRead1).toHaveBeenCalledTimes(0);
		expect(spyRead2).toHaveBeenCalledTimes(0);
	});

	it('random replica select', () => {
		const primaryDb = drizzle.mock();
		const read1 = drizzle.mock();
		const read2 = drizzle.mock();

		const randomMockReplica = vi.fn().mockReturnValueOnce(read1).mockReturnValueOnce(read2);

		const db = withReplicas(primaryDb, [read1, read2], () => {
			return randomMockReplica();
		});

		const spyPrimary = vi.spyOn(primaryDb, 'select');
		const spyRead1 = vi.spyOn(read1, 'select');
		const spyRead2 = vi.spyOn(read2, 'select');

		const query1 = db.select({ count: sql`count(*)`.as('count') }).from(users).limit(1);

		expect(spyPrimary).toHaveBeenCalledTimes(0);
		expect(spyRead1).toHaveBeenCalledTimes(1);
		expect(spyRead2).toHaveBeenCalledTimes(0);

		expect(query1.toSQL().sql).toEqual('select count(*) as "count" from "users" limit ?');

		const query2 = db.select().from(users);
// ... (850 more lines)

Dependencies

  • drizzle-orm
  • libsql
  • sqlite-core
  • vitest

Source

Frequently Asked Questions

What does sqlite.test.ts do?
sqlite.test.ts is a source file in the drizzle-orm codebase, written in typescript.
What does sqlite.test.ts depend on?
sqlite.test.ts imports 4 module(s): drizzle-orm, libsql, sqlite-core, vitest.
Where is sqlite.test.ts in the architecture?
sqlite.test.ts is located at integration-tests/tests/replicas/sqlite.test.ts (directory: integration-tests/tests/replicas).

Analyze Your Own Codebase

Get architecture documentation, dependency graphs, and domain analysis for your codebase in minutes.

Try Supermodel Free