Function indexesTestCase1

drizzle-kit/tests/push/pg.test.ts: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);
	},

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