joinSubqueryWithJoin() — drizzle-orm Function Reference

Architecture documentation for the joinSubqueryWithJoin() function in index.ts from the drizzle-orm codebase.

Function typescript DrizzleORM SQLDialects calls 1 called by 1

Entity Profile

DrizzleORM→ SQLDialects→ joinSubqueryWithJoin() — drizzle-orm Function Reference

Dependency Diagram

graph TD
  89e9b683_02fd_8c44_6e46_7a226c7b3944["joinSubqueryWithJoin()"]
  34f01008_7c45_3804_1fad_b8b59cd8a413["MyDurableObject"]
  89e9b683_02fd_8c44_6e46_7a226c7b3944 -->|defined in| 34f01008_7c45_3804_1fad_b8b59cd8a413
  7c7acbfe_6328_c8df_feba_552ee62a84d9["default.fetch()"]
  7c7acbfe_6328_c8df_feba_552ee62a84d9 -->|calls| 89e9b683_02fd_8c44_6e46_7a226c7b3944
  b19b108f_def7_3a32_99a3_c8be51ce2fbf["beforeEach()"]
  89e9b683_02fd_8c44_6e46_7a226c7b3944 -->|calls| b19b108f_def7_3a32_99a3_c8be51ce2fbf
  style 89e9b683_02fd_8c44_6e46_7a226c7b3944 fill:#6366f1,stroke:#818cf8,color:#fff

Relationship Graph

Source Code

integration-tests/tests/sqlite/durable-objects/index.ts lines 2201–2251

	async joinSubqueryWithJoin(): Promise<void> {
		try {
			await this.beforeEach();
			const internalStaff = sqliteTable('internal_staff', {
				userId: integer('user_id').notNull(),
			});

			const customUser = sqliteTable('custom_user', {
				id: integer('id').notNull(),
			});

			const ticket = sqliteTable('ticket', {
				staffId: integer('staff_id').notNull(),
			});

			this.db.run(sql`drop table if exists ${internalStaff}`);
			this.db.run(sql`drop table if exists ${customUser}`);
			this.db.run(sql`drop table if exists ${ticket}`);

			this.db.run(sql`create table internal_staff (user_id integer not null)`);
			this.db.run(sql`create table custom_user (id integer not null)`);
			this.db.run(sql`create table ticket (staff_id integer not null)`);

			this.db.insert(internalStaff).values({ userId: 1 }).run();
			this.db.insert(customUser).values({ id: 1 }).run();
			this.db.insert(ticket).values({ staffId: 1 }).run();

			const subq = this.db.select().from(internalStaff).leftJoin(customUser, eq(internalStaff.userId, customUser.id))
				.as('internal_staff');

			const mainQuery = this.db.select().from(ticket).leftJoin(subq, eq(subq.internal_staff.userId, ticket.staffId))
				.all();

			expect(mainQuery).deep.equal([
				{
					ticket: { staffId: 1 },
					internal_staff: {
						internal_staff: { userId: 1 },
						custom_user: { id: 1 },
					},
				},
			]);

			this.db.run(sql`drop table ${internalStaff}`);
			this.db.run(sql`drop table ${customUser}`);
			this.db.run(sql`drop table ${ticket}`);
		} catch (error: any) {
			console.error(error);
			throw new Error(`joinSubqueryWithJoin error`);
		}
	}