wehub-resource-sync
40 lines
933 B
TypeScript
40 lines
933 B
TypeScript
import { int, sqliteTable, text } from 'drizzle-orm/sqlite-core';
|
|
import { diffTestSchemasSqlite } from 'tests/schemaDiffer';
|
|
import { expect } from 'vitest';
|
|
import { DialectSuite, run } from '../common';
|
|
|
|
const sqliteSuite: DialectSuite = {
|
|
async columns1() {
|
|
const schema1 = {
|
|
users: sqliteTable('users', {
|
|
id: int('id').primaryKey({ autoIncrement: true }),
|
|
}),
|
|
};
|
|
|
|
const schema2 = {
|
|
users: sqliteTable('users', {
|
|
id: int('id').primaryKey({ autoIncrement: true }),
|
|
name: text('name'),
|
|
}),
|
|
};
|
|
|
|
const { statements } = await diffTestSchemasSqlite(schema1, schema2, []);
|
|
|
|
expect(statements.length).toBe(1);
|
|
expect(statements[0]).toStrictEqual({
|
|
type: 'sqlite_alter_table_add_column',
|
|
tableName: 'users',
|
|
referenceData: undefined,
|
|
column: {
|
|
name: 'name',
|
|
type: 'text',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
});
|
|
},
|
|
};
|
|
|
|
run(sqliteSuite);
|