singlestoreSuite.renameTableWithCompositePrimaryKey() — drizzle-orm Function Reference

Source Code

drizzle-kit/tests/push/singlestore.test.ts lines 370–404

	renameTableWithCompositePrimaryKey: async function(context?: any): Promise<void> {
		const productsCategoriesTable = (tableName: string) => {
			return singlestoreTable(tableName, {
				productId: varchar('product_id', { length: 10 }).notNull(),
				categoryId: varchar('category_id', { length: 10 }).notNull(),
			}, (t) => ({
				pk: primaryKey({
					columns: [t.productId, t.categoryId],
				}),
			}));
		};

		const schema1 = {
			table: productsCategoriesTable('products_categories'),
		};
		const schema2 = {
			test: productsCategoriesTable('products_to_categories'),
		};

		const { sqlStatements } = await diffTestSchemasPushSingleStore(
			context.client as Connection,
			schema1,
			schema2,
			['public.products_categories->public.products_to_categories'],
			'drizzle',
			false,
		);

		// It's not possible to create/alter/drop primary keys in SingleStore
		expect(sqlStatements).toStrictEqual([
			'ALTER TABLE `products_categories` RENAME TO `products_to_categories`;',
		]);

		await context.client.query(`DROP TABLE \`products_categories\``);
	},