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
  baf50bd8_54a5_9af0_12e2_6470eef3a437["count.ts"]
  02ee7a70_490f_3b80_fa60_d59aaa62cd1d["db.ts"]
  baf50bd8_54a5_9af0_12e2_6470eef3a437 --> 02ee7a70_490f_3b80_fa60_d59aaa62cd1d
  25b05299_f48f_bceb_01ca_1343d330a8f7["utils.ts"]
  baf50bd8_54a5_9af0_12e2_6470eef3a437 --> 25b05299_f48f_bceb_01ca_1343d330a8f7
  076448f5_e30d_7700_bbe9_f5d1e76b579a["index.ts"]
  baf50bd8_54a5_9af0_12e2_6470eef3a437 --> 076448f5_e30d_7700_bbe9_f5d1e76b579a
  5c46beaf_8b59_d2e3_def3_8af6daf1fccd["index.ts"]
  baf50bd8_54a5_9af0_12e2_6470eef3a437 --> 5c46beaf_8b59_d2e3_def3_8af6daf1fccd
  ecce3253_1e75_a87f_27b3_ca87e81a3024["utils.ts"]
  baf50bd8_54a5_9af0_12e2_6470eef3a437 --> ecce3253_1e75_a87f_27b3_ca87e81a3024
  style baf50bd8_54a5_9af0_12e2_6470eef3a437 fill:#6366f1,stroke:#818cf8,color:#fff

Relationship Graph

Source Code

import { Expect } from 'type-tests/utils.ts';
import { gelTable, integer, text } from '~/gel-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 = gelTable('names', {
	id: integer('id').primaryKey(),
	name: text('name'),
	authorId: integer('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
	>
>;