main() — drizzle-orm Function Reference

Architecture documentation for the main() function in db.ts from the drizzle-orm codebase.

Function typescript DrizzleORM RelationalQuery

Entity Profile

DrizzleORM→ RelationalQuery→ main() — drizzle-orm Function Reference

Dependency Diagram

graph TD
  12b55151_144a_02b4_4898_1e72e6b2bf04["main()"]
  39b12012_73ee_50de_e31a_969162d619ed["db.ts"]
  12b55151_144a_02b4_4898_1e72e6b2bf04 -->|defined in| 39b12012_73ee_50de_e31a_969162d619ed
  style 12b55151_144a_02b4_4898_1e72e6b2bf04 fill:#6366f1,stroke:#818cf8,color:#fff

Relationship Graph

Source Code

integration-tests/tests/relational/db.ts lines 8–34

async function main() {
	const bdb = new Database(process.env['SQLITE_DB_PATH']!);
	const db = drizzle(bdb, { schema, logger: true });

	const result = db.query.users.findMany({
		columns: {
			id: true,
			name: true,
		},
		with: {
			posts: {
				columns: {
					authorId: true,
				},
				with: {
					comments: true,
				},
				extras: {
					lower: sql<string>`lower(${schema.posts.title})`.as('lower_name'),
				},
			},
		},
	});

	console.log(util.inspect(result, false, null, true));
	bdb.close();
}