libsql-statements-combiner.test.ts — drizzle-orm Source File

Source Code

import { JsonAddColumnStatement, JsonSqliteAddColumnStatement, JsonStatement } from 'src/jsonStatements';
import { SQLiteSchemaSquashed } from 'src/serializer/sqliteSchema';
import { SQLiteAlterTableAddColumnConvertor } from 'src/sqlgenerator';
import { libSQLCombineStatements } from 'src/statementCombiner';
import { expect, test } from 'vitest';

/**
 * ! before:
 *
 * user: {
 *    id INT;
 *    first_name INT;
 *    iq INT;
 *    PRIMARY KEY (id, iq)
 *    INDEXES: {
 *      UNIQUE id;
 *    }
 * }
 *
 * ! after:
 *
 *  new_user: {
 *    id INT;
 *    first_name INT;
 *    iq INT;
 *    PRIMARY KEY (id, iq)
 *    INDEXES: {}
 * }
 *
 * rename table and drop unique index
 * expect to get "rename_table" statement and then "recreate_table"
 */
test(`rename table and drop index`, async (t) => {
	const statements: JsonStatement[] = [
		{
			type: 'rename_table',
			fromSchema: '',
			toSchema: '',
			tableNameFrom: 'user',
			tableNameTo: 'new_user',
		},
		{
			type: 'drop_index',
			tableName: 'new_user',
			data: 'user_first_name_unique;first_name;true;',
			schema: '',
		},
	];
	const json1: SQLiteSchemaSquashed = {
		version: '6',
		dialect: 'sqlite',
		tables: {
			user: {
				name: 'user',
				columns: {
					id: {
						name: 'id',
						type: 'int',
						primaryKey: false,
						notNull: false,
// ... (1753 more lines)