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
  d67a670c_6b8c_31cd_efb7_f819b0c97367["count.ts"]
  9c290d96_894a_8e33_3455_d9f3a1fa1518["db.ts"]
  d67a670c_6b8c_31cd_efb7_f819b0c97367 --> 9c290d96_894a_8e33_3455_d9f3a1fa1518
  25b05299_f48f_bceb_01ca_1343d330a8f7["utils.ts"]
  d67a670c_6b8c_31cd_efb7_f819b0c97367 --> 25b05299_f48f_bceb_01ca_1343d330a8f7
  cf530c77_bff8_0def_5c6c_6cf067e6c757["index.ts"]
  d67a670c_6b8c_31cd_efb7_f819b0c97367 --> cf530c77_bff8_0def_5c6c_6cf067e6c757
  5c46beaf_8b59_d2e3_def3_8af6daf1fccd["index.ts"]
  d67a670c_6b8c_31cd_efb7_f819b0c97367 --> 5c46beaf_8b59_d2e3_def3_8af6daf1fccd
  ecce3253_1e75_a87f_27b3_ca87e81a3024["utils.ts"]
  d67a670c_6b8c_31cd_efb7_f819b0c97367 --> ecce3253_1e75_a87f_27b3_ca87e81a3024
  style d67a670c_6b8c_31cd_efb7_f819b0c97367 fill:#6366f1,stroke:#818cf8,color:#fff

Relationship Graph

Source Code

import { Expect } from 'type-tests/utils.ts';
import { int, serial, singlestoreTable, text } from '~/singlestore-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 = singlestoreTable('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
	>
>;