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

mysql.test.ts — drizzle-orm Source File

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

File typescript 4 imports

Entity Profile

Dependency Diagram

graph LR
  6086930d_04f4_117a_b3ca_62d702d19135["mysql.test.ts"]
  690f7dfc_0aea_9ee8_d6e7_26bbb3689031["drizzle-orm"]
  6086930d_04f4_117a_b3ca_62d702d19135 --> 690f7dfc_0aea_9ee8_d6e7_26bbb3689031
  93ed9350_daa0_6c21_81a6_ed6b2a48bbdf["mysql-core"]
  6086930d_04f4_117a_b3ca_62d702d19135 --> 93ed9350_daa0_6c21_81a6_ed6b2a48bbdf
  da5f49c7_67eb_d6c6_2fa2_c3592f35dc62["mysql2"]
  6086930d_04f4_117a_b3ca_62d702d19135 --> da5f49c7_67eb_d6c6_2fa2_c3592f35dc62
  8d35eaf2_a542_cfd4_fa1a_fafca0f02686["vitest"]
  6086930d_04f4_117a_b3ca_62d702d19135 --> 8d35eaf2_a542_cfd4_fa1a_fafca0f02686
  style 6086930d_04f4_117a_b3ca_62d702d19135 fill:#6366f1,stroke:#818cf8,color:#fff

Relationship Graph

Source Code

import { sql } from 'drizzle-orm';
import { boolean, mysqlTable, serial, text, withReplicas } from 'drizzle-orm/mysql-core';
import { drizzle } from 'drizzle-orm/mysql2';
import { describe, expect, it, vi } from 'vitest';

const usersTable = mysqlTable('users', {
	id: serial('id' as string).primaryKey(),
	name: text('name').notNull(),
	verified: boolean('verified').notNull().default(false),
});

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

describe('[select] read replicas mysql', () => {
	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);
// ... (854 more lines)

Dependencies

  • drizzle-orm
  • mysql-core
  • mysql2
  • vitest

Source

Frequently Asked Questions

What does mysql.test.ts do?
mysql.test.ts is a source file in the drizzle-orm codebase, written in typescript.
What does mysql.test.ts depend on?
mysql.test.ts imports 4 module(s): drizzle-orm, mysql-core, mysql2, vitest.
Where is mysql.test.ts in the architecture?
mysql.test.ts is located at integration-tests/tests/replicas/mysql.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