count.ts — drizzle-orm Source File

Architecture documentation for count.ts, a typescript file in the drizzle-orm codebase. 5 imports, 0 dependents.

File typescript DrizzleORM 5 imports

Entity Profile

DrizzleORM→ count.ts — drizzle-orm Source File

Dependency Diagram

graph LR
  60f98d9e_c6e1_6738_f132_6fa1f93a2cea["count.ts"]
  0e3c50de_fbb6_eb17_22a4_8121934f6fdf["db.ts"]
  60f98d9e_c6e1_6738_f132_6fa1f93a2cea --> 0e3c50de_fbb6_eb17_22a4_8121934f6fdf
  25b05299_f48f_bceb_01ca_1343d330a8f7["utils.ts"]
  60f98d9e_c6e1_6738_f132_6fa1f93a2cea --> 25b05299_f48f_bceb_01ca_1343d330a8f7
  1da0a48e_f7fe_5ea4_cee2_3ed7d3f39f31["index.ts"]
  60f98d9e_c6e1_6738_f132_6fa1f93a2cea --> 1da0a48e_f7fe_5ea4_cee2_3ed7d3f39f31
  5c46beaf_8b59_d2e3_def3_8af6daf1fccd["index.ts"]
  60f98d9e_c6e1_6738_f132_6fa1f93a2cea --> 5c46beaf_8b59_d2e3_def3_8af6daf1fccd
  ecce3253_1e75_a87f_27b3_ca87e81a3024["utils.ts"]
  60f98d9e_c6e1_6738_f132_6fa1f93a2cea --> ecce3253_1e75_a87f_27b3_ca87e81a3024
  style 60f98d9e_c6e1_6738_f132_6fa1f93a2cea fill:#6366f1,stroke:#818cf8,color:#fff

Relationship Graph

Source Code

import { Expect } from 'type-tests/utils.ts';
import { int, mysqlTable, serial, text } from '~/mysql-core/index.ts';
import { and, gt, ne } from '~/sql/expressions/index.ts';
import type { Equal } from '~/utils.ts';
import { db } from './db.ts';

const names = mysqlTable('names', {
	id: serial('id').primaryKey(),
	name: text('name'),
	authorId: int('author_id'),
});

const separate = await db.$count(names);

const separateFilters = await db.$count(names, and(gt(names.id, 1), ne(names.name, 'forbidden')));

const embedded = await db
	.select({
		id: names.id,
		name: names.name,
		authorId: names.authorId,
		count1: db.$count(names).as('count1'),
	})
	.from(names);

const embeddedFilters = await db
	.select({
		id: names.id,
		name: names.name,
		authorId: names.authorId,
		count1: db.$count(names, and(gt(names.id, 1), ne(names.name, 'forbidden'))).as('count1'),
	})
	.from(names);

Expect<Equal<number, typeof separate>>;

Expect<Equal<number, typeof separateFilters>>;

Expect<
	Equal<
		{
			id: number;
			name: string | null;
			authorId: number | null;
			count1: number;
		}[],
		typeof embedded
	>
>;

Expect<
	Equal<
		{
			id: number;
			name: string | null;
			authorId: number | null;
			count1: number;
		}[],
		typeof embeddedFilters
	>
>;