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. 11 imports, 0 dependents.

File typescript ValidationAdapters TypeMapping 11 imports 3 functions

Entity Profile

Dependency Diagram

graph LR
  71c2ebf3_f234_9142_ac74_a0e4736cfe56["sqlite.test.ts"]
  ff684fca_1bf3_44b7_31ea_13a57f1e853d["index.ts"]
  71c2ebf3_f234_9142_ac74_a0e4736cfe56 --> ff684fca_1bf3_44b7_31ea_13a57f1e853d
  a613cfae_0db3_657f_d051_120c70da7539["utils.ts"]
  71c2ebf3_f234_9142_ac74_a0e4736cfe56 --> a613cfae_0db3_657f_d051_120c70da7539
  70d5e558_f261_97fa_a887_7d6f05ebdc71["Expect"]
  71c2ebf3_f234_9142_ac74_a0e4736cfe56 --> 70d5e558_f261_97fa_a887_7d6f05ebdc71
  13da7f47_c488_1c05_a7ef_a5bccb3b8a71["expectSchemaShape"]
  71c2ebf3_f234_9142_ac74_a0e4736cfe56 --> 13da7f47_c488_1c05_a7ef_a5bccb3b8a71
  690f7dfc_0aea_9ee8_d6e7_26bbb3689031["drizzle-orm"]
  71c2ebf3_f234_9142_ac74_a0e4736cfe56 --> 690f7dfc_0aea_9ee8_d6e7_26bbb3689031
  25248a9d_ba06_2b33_4421_8575da2f9c34["sqlite-core"]
  71c2ebf3_f234_9142_ac74_a0e4736cfe56 --> 25248a9d_ba06_2b33_4421_8575da2f9c34
  e3330aa9_fee9_b340_1093_1c8a98953c05["json-rules-engine"]
  71c2ebf3_f234_9142_ac74_a0e4736cfe56 --> e3330aa9_fee9_b340_1093_1c8a98953c05
  8d35eaf2_a542_cfd4_fa1a_fafca0f02686["vitest"]
  71c2ebf3_f234_9142_ac74_a0e4736cfe56 --> 8d35eaf2_a542_cfd4_fa1a_fafca0f02686
  2eba3e52_10ef_4b48_38fc_0e1540a5fc3e["v4"]
  71c2ebf3_f234_9142_ac74_a0e4736cfe56 --> 2eba3e52_10ef_4b48_38fc_0e1540a5fc3e
  05f0a280_d0c9_693a_a4bf_83cc671012d2["column.ts"]
  71c2ebf3_f234_9142_ac74_a0e4736cfe56 --> 05f0a280_d0c9_693a_a4bf_83cc671012d2
  45e26f9d_6717_943d_0371_5d349b8c9472["constants.ts"]
  71c2ebf3_f234_9142_ac74_a0e4736cfe56 --> 45e26f9d_6717_943d_0371_5d349b8c9472
  style 71c2ebf3_f234_9142_ac74_a0e4736cfe56 fill:#6366f1,stroke:#818cf8,color:#fff

Relationship Graph

Source Code

import { type Equal, sql } from 'drizzle-orm';
import { blob, customType, int, sqliteTable, sqliteView, text } from 'drizzle-orm/sqlite-core';
import type { TopLevelCondition } from 'json-rules-engine';
import { test } from 'vitest';
import { z } from 'zod/v4';
import { bufferSchema, jsonSchema } from '~/column.ts';
import { CONSTANTS } from '~/constants.ts';
import { createInsertSchema, createSchemaFactory, createSelectSchema, createUpdateSchema } from '../src';
import { Expect, expectSchemaShape } from './utils.ts';

const intSchema = z.int().gte(Number.MIN_SAFE_INTEGER).lte(Number.MAX_SAFE_INTEGER);
const textSchema = z.string();

test('table - select', (t) => {
	const table = sqliteTable('test', {
		id: int().primaryKey({ autoIncrement: true }),
		generated: int().generatedAlwaysAs(1).notNull(),
		name: text().notNull(),
	});

	const result = createSelectSchema(table);
	const expected = z.object({ id: intSchema, generated: intSchema, name: textSchema });
	expectSchemaShape(t, expected).from(result);
	Expect<Equal<typeof result, typeof expected>>();
});

test('table - insert', (t) => {
	const table = sqliteTable('test', {
		id: int().primaryKey({ autoIncrement: true }),
		name: text().notNull(),
		age: int(),
	});

	const result = createInsertSchema(table);
	const expected = z.object({ id: intSchema.optional(), name: textSchema, age: intSchema.nullable().optional() });
	expectSchemaShape(t, expected).from(result);
	Expect<Equal<typeof result, typeof expected>>();
});

test('table - update', (t) => {
	const table = sqliteTable('test', {
		id: int().primaryKey({ autoIncrement: true }),
		name: text().notNull(),
		age: int(),
	});

	const result = createUpdateSchema(table);
	const expected = z.object({
		id: intSchema.optional(),
		name: textSchema.optional(),
		age: intSchema.nullable().optional(),
	});
	expectSchemaShape(t, expected).from(result);
	Expect<Equal<typeof result, typeof expected>>();
});

test('view qb - select', (t) => {
	const table = sqliteTable('test', {
		id: int().primaryKey({ autoIncrement: true }),
		name: text().notNull(),
// ... (392 more lines)

Domain

Subdomains

Functions

Dependencies

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. It belongs to the ValidationAdapters domain, TypeMapping subdomain.
What functions are defined in sqlite.test.ts?
sqlite.test.ts defines 3 function(s): TopLevelCondition, nestedSelect, view.
What does sqlite.test.ts depend on?
sqlite.test.ts imports 11 module(s): Expect, column.ts, constants.ts, drizzle-orm, expectSchemaShape, index.ts, json-rules-engine, sqlite-core, and 3 more.
Where is sqlite.test.ts in the architecture?
sqlite.test.ts is located at drizzle-zod/tests/sqlite.test.ts (domain: ValidationAdapters, subdomain: TypeMapping, directory: drizzle-zod/tests).

Analyze Your Own Codebase

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

Try Supermodel Free