pgSuite.indexesTestCase1() — drizzle-orm Function Reference

Architecture documentation for the pgSuite.indexesTestCase1() function in pg.test.ts from the drizzle-orm codebase.

Function typescript DrizzleORM DatabaseDrivers

Entity Profile

DrizzleORM→ DatabaseDrivers→ pgSuite.indexesTestCase1() — drizzle-orm Function Reference

Dependency Diagram

graph TD
  7df27de3_e728_a4f8_9c68_eb8a25c532fa["pgSuite.indexesTestCase1()"]
  0408ab8f_6d6f_cdae_29f3_25c8efadbfae["pg.test.ts"]
  7df27de3_e728_a4f8_9c68_eb8a25c532fa -->|defined in| 0408ab8f_6d6f_cdae_29f3_25c8efadbfae
  style 7df27de3_e728_a4f8_9c68_eb8a25c532fa fill:#6366f1,stroke:#818cf8,color:#fff

Relationship Graph

Source Code

drizzle-kit/tests/push/pg.test.ts lines 725–767

	async indexesTestCase1() {
		const client = new PGlite();

		const schema1 = {
			users: pgTable(
				'users',
				{
					id: uuid('id').defaultRandom().primaryKey(),
					name: text('name').notNull(),
					description: text('description'),
					imageUrl: text('image_url'),
					inStock: boolean('in_stock').default(true),
				},
				(t) => ({
					indx: index().on(t.id.desc().nullsFirst()),
					indx1: index('indx1').on(t.id, t.imageUrl),
					indx2: index('indx4').on(t.id),
				}),
			),
		};

		const schema2 = {
			users: pgTable(
				'users',
				{
					id: uuid('id').defaultRandom().primaryKey(),
					name: text('name').notNull(),
					description: text('description'),
					imageUrl: text('image_url'),
					inStock: boolean('in_stock').default(true),
				},
				(t) => ({
					indx: index().on(t.id.desc().nullsFirst()),
					indx1: index('indx1').on(t.id, t.imageUrl),
					indx2: index('indx4').on(t.id),
				}),
			),
		};

		const { statements, sqlStatements } = await diffTestSchemasPush(client, schema1, schema2, [], false, ['public']);

		expect(statements.length).toBe(0);
	},