wehub-resource-sync
1813 lines
35 KiB
TypeScript
1813 lines
35 KiB
TypeScript
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,
|
|
autoincrement: false,
|
|
},
|
|
first_name: {
|
|
name: 'first_name',
|
|
type: 'int',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
iq: {
|
|
name: 'iq',
|
|
type: 'int',
|
|
primaryKey: false,
|
|
notNull: true,
|
|
autoincrement: false,
|
|
},
|
|
},
|
|
indexes: {
|
|
user_first_name_unique: 'user_first_name_unique;first_name;true;',
|
|
},
|
|
foreignKeys: {},
|
|
compositePrimaryKeys: {
|
|
user_id_iq_pk: 'id,iq',
|
|
},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
},
|
|
enums: {},
|
|
views: {},
|
|
};
|
|
const json2: SQLiteSchemaSquashed = {
|
|
version: '6',
|
|
dialect: 'sqlite',
|
|
tables: {
|
|
new_user: {
|
|
name: 'new_user',
|
|
columns: {
|
|
id: {
|
|
name: 'id',
|
|
type: 'int',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
first_name: {
|
|
name: 'first_name',
|
|
type: 'int',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
iq: {
|
|
name: 'iq',
|
|
type: 'int',
|
|
primaryKey: false,
|
|
notNull: true,
|
|
autoincrement: false,
|
|
},
|
|
},
|
|
indexes: {},
|
|
foreignKeys: {},
|
|
compositePrimaryKeys: {
|
|
new_user_id_iq_pk: 'id,iq',
|
|
},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
},
|
|
enums: {},
|
|
views: {},
|
|
};
|
|
|
|
const newJsonStatements = [
|
|
{
|
|
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: '',
|
|
},
|
|
];
|
|
expect(libSQLCombineStatements(statements, json2)).toStrictEqual(
|
|
newJsonStatements,
|
|
);
|
|
});
|
|
|
|
/**
|
|
* ! before:
|
|
*
|
|
* autoincrement1: {
|
|
* id INT PRIMARY KEY;
|
|
* }
|
|
*
|
|
* autoincrement2: {
|
|
* id INT PRIMARY KEY AUTOINCREMENT;
|
|
* }
|
|
*
|
|
* dropNotNull: {
|
|
* id INT NOT NULL;
|
|
* }
|
|
*
|
|
* ! after:
|
|
*
|
|
* autoincrement1: {
|
|
* id INT PRIMARY KEY AUTOINCREMENT;
|
|
* }
|
|
*
|
|
* autoincrement2: {
|
|
* id INT PRI<ARY KEY;
|
|
* }
|
|
*
|
|
* dropNotNull: {
|
|
* id INT;
|
|
* }
|
|
*
|
|
* drop autoincrement for autoincrement1
|
|
* set autoincrement for autoincrement2
|
|
*
|
|
* expect to:
|
|
* - get "recreate_table" for autoincrement1
|
|
* - get "recreate_table" for autoincrement2
|
|
* - get "drop_notnull" for dropNotNull
|
|
*/
|
|
test(`drop, set autoincrement. drop not null`, async (t) => {
|
|
const statements: JsonStatement[] = [
|
|
{
|
|
type: 'alter_table_alter_column_set_autoincrement',
|
|
tableName: 'autoincrement1',
|
|
columnName: 'id',
|
|
schema: '',
|
|
newDataType: 'int',
|
|
columnDefault: undefined,
|
|
columnOnUpdate: undefined,
|
|
columnNotNull: true,
|
|
columnAutoIncrement: true,
|
|
columnPk: true,
|
|
} as unknown as JsonStatement,
|
|
{
|
|
type: 'alter_table_alter_column_drop_autoincrement',
|
|
tableName: 'autoincrement2',
|
|
columnName: 'id',
|
|
schema: '',
|
|
newDataType: 'int',
|
|
columnDefault: undefined,
|
|
columnOnUpdate: undefined,
|
|
columnNotNull: true,
|
|
columnAutoIncrement: false,
|
|
columnPk: true,
|
|
} as unknown as JsonStatement,
|
|
{
|
|
type: 'alter_table_alter_column_drop_notnull',
|
|
tableName: 'dropNotNull',
|
|
columnName: 'id',
|
|
schema: '',
|
|
newDataType: 'int',
|
|
columnDefault: undefined,
|
|
columnOnUpdate: undefined,
|
|
columnNotNull: false,
|
|
columnAutoIncrement: false,
|
|
columnPk: false,
|
|
} as unknown as JsonStatement,
|
|
];
|
|
const json1: SQLiteSchemaSquashed = {
|
|
version: '6',
|
|
dialect: 'sqlite',
|
|
tables: {
|
|
autoincrement1: {
|
|
name: 'autoincrement1',
|
|
columns: {
|
|
id: {
|
|
name: 'id',
|
|
type: 'int',
|
|
primaryKey: true,
|
|
notNull: true,
|
|
autoincrement: false,
|
|
},
|
|
},
|
|
indexes: {},
|
|
foreignKeys: {},
|
|
compositePrimaryKeys: {},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
autoincrement2: {
|
|
name: 'autoincrement2',
|
|
columns: {
|
|
id: {
|
|
name: 'id',
|
|
type: 'int',
|
|
primaryKey: true,
|
|
notNull: false,
|
|
autoincrement: true,
|
|
},
|
|
},
|
|
indexes: {},
|
|
foreignKeys: {},
|
|
compositePrimaryKeys: {},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
dropNotNull: {
|
|
name: 'dropNotNull',
|
|
columns: {
|
|
id: {
|
|
name: 'id',
|
|
type: 'int',
|
|
primaryKey: false,
|
|
notNull: true,
|
|
autoincrement: false,
|
|
},
|
|
},
|
|
indexes: {},
|
|
foreignKeys: {},
|
|
compositePrimaryKeys: {},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
},
|
|
enums: {},
|
|
views: {},
|
|
};
|
|
const json2: SQLiteSchemaSquashed = {
|
|
version: '6',
|
|
dialect: 'sqlite',
|
|
tables: {
|
|
autoincrement1: {
|
|
name: 'autoincrement1',
|
|
columns: {
|
|
id: {
|
|
name: 'id',
|
|
type: 'int',
|
|
primaryKey: true,
|
|
notNull: true,
|
|
autoincrement: true,
|
|
},
|
|
},
|
|
indexes: {},
|
|
foreignKeys: {},
|
|
compositePrimaryKeys: {},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
autoincrement2: {
|
|
name: 'autoincrement2',
|
|
columns: {
|
|
id: {
|
|
name: 'id',
|
|
type: 'int',
|
|
primaryKey: true,
|
|
notNull: true,
|
|
autoincrement: false,
|
|
},
|
|
},
|
|
indexes: {},
|
|
foreignKeys: {},
|
|
compositePrimaryKeys: {},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
dropNotNull: {
|
|
name: 'dropNotNull',
|
|
columns: {
|
|
id: {
|
|
name: 'id',
|
|
type: 'int',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
},
|
|
indexes: {},
|
|
foreignKeys: {},
|
|
compositePrimaryKeys: {},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
},
|
|
enums: {},
|
|
views: {},
|
|
};
|
|
|
|
const newJsonStatements = [
|
|
{
|
|
type: 'recreate_table',
|
|
tableName: 'autoincrement1',
|
|
columns: [
|
|
{
|
|
name: 'id',
|
|
type: 'int',
|
|
primaryKey: true,
|
|
notNull: true,
|
|
autoincrement: true,
|
|
},
|
|
],
|
|
compositePKs: [],
|
|
referenceData: [],
|
|
uniqueConstraints: [],
|
|
checkConstraints: [],
|
|
},
|
|
{
|
|
type: 'recreate_table',
|
|
tableName: 'autoincrement2',
|
|
columns: [
|
|
{
|
|
name: 'id',
|
|
type: 'int',
|
|
primaryKey: true,
|
|
notNull: true,
|
|
autoincrement: false,
|
|
},
|
|
],
|
|
compositePKs: [],
|
|
referenceData: [],
|
|
uniqueConstraints: [],
|
|
checkConstraints: [],
|
|
},
|
|
{
|
|
type: 'alter_table_alter_column_drop_notnull',
|
|
tableName: 'dropNotNull',
|
|
columnName: 'id',
|
|
schema: '',
|
|
newDataType: 'int',
|
|
columnDefault: undefined,
|
|
columnOnUpdate: undefined,
|
|
columnNotNull: false,
|
|
columnAutoIncrement: false,
|
|
columnPk: false,
|
|
},
|
|
];
|
|
expect(libSQLCombineStatements(statements, json2)).toStrictEqual(
|
|
newJsonStatements,
|
|
);
|
|
});
|
|
|
|
/**
|
|
* ! before:
|
|
*
|
|
* pk1: {
|
|
* id INT;
|
|
* }
|
|
*
|
|
* pk2: {
|
|
* id INT PRIMARY KEY;
|
|
* }
|
|
*
|
|
* ref_table: {
|
|
* id INT;
|
|
* }
|
|
*
|
|
* create_reference: {
|
|
* id INT;
|
|
* }
|
|
*
|
|
* ! after:
|
|
*
|
|
* pk1: {
|
|
* id INT PRIMARY KEY;
|
|
* }
|
|
*
|
|
* pk2: {
|
|
* id INT;
|
|
* }
|
|
*
|
|
* ref_table: {
|
|
* id INT;
|
|
* }
|
|
*
|
|
* create_reference: {
|
|
* id INT -> ref_table INT;
|
|
* }
|
|
*
|
|
* drop primary key for pk2
|
|
* set primary key for pk1
|
|
* "create_reference" reference on "ref_table"
|
|
*
|
|
* expect to:
|
|
* - "recreate_table" statement for pk1
|
|
* - "recreate_table" statement for pk2
|
|
* - "create_reference" statement for create_reference
|
|
*/
|
|
test(`drop and set primary key. create reference`, async (t) => {
|
|
const statements: JsonStatement[] = [
|
|
{
|
|
type: 'alter_table_alter_column_set_pk',
|
|
tableName: 'pk1',
|
|
schema: '',
|
|
columnName: 'id',
|
|
},
|
|
{
|
|
type: 'alter_table_alter_column_set_notnull',
|
|
tableName: 'pk1',
|
|
columnName: 'id',
|
|
schema: '',
|
|
newDataType: 'int',
|
|
columnDefault: undefined,
|
|
columnOnUpdate: undefined,
|
|
columnNotNull: true,
|
|
columnAutoIncrement: false,
|
|
columnPk: true,
|
|
} as unknown as JsonStatement,
|
|
{
|
|
type: 'alter_table_alter_column_drop_pk',
|
|
tableName: 'pk2',
|
|
columnName: 'id',
|
|
schema: '',
|
|
},
|
|
{
|
|
type: 'alter_table_alter_column_drop_notnull',
|
|
tableName: 'pk2',
|
|
columnName: 'id',
|
|
schema: '',
|
|
newDataType: 'int',
|
|
columnDefault: undefined,
|
|
columnOnUpdate: undefined,
|
|
columnNotNull: false,
|
|
columnAutoIncrement: false,
|
|
columnPk: false,
|
|
} as unknown as JsonStatement,
|
|
{
|
|
type: 'create_reference',
|
|
tableName: 'create_reference',
|
|
data: 'create_reference_id_ref_table_id_fk;create_reference;id;ref_table;id;no action;no action',
|
|
schema: '',
|
|
columnNotNull: false,
|
|
columnDefault: undefined,
|
|
columnType: 'int',
|
|
},
|
|
];
|
|
const json1: SQLiteSchemaSquashed = {
|
|
version: '6',
|
|
dialect: 'sqlite',
|
|
tables: {
|
|
create_reference: {
|
|
name: 'create_reference',
|
|
columns: {
|
|
id: {
|
|
name: 'id',
|
|
type: 'int',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
},
|
|
indexes: {},
|
|
foreignKeys: {},
|
|
compositePrimaryKeys: {},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
pk1: {
|
|
name: 'pk1',
|
|
columns: {
|
|
id: {
|
|
name: 'id',
|
|
type: 'int',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
},
|
|
indexes: {},
|
|
foreignKeys: {},
|
|
compositePrimaryKeys: {},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
pk2: {
|
|
name: 'pk2',
|
|
columns: {
|
|
id: {
|
|
name: 'id',
|
|
type: 'int',
|
|
primaryKey: true,
|
|
notNull: true,
|
|
autoincrement: false,
|
|
},
|
|
},
|
|
indexes: {},
|
|
foreignKeys: {},
|
|
compositePrimaryKeys: {},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
ref_table: {
|
|
name: 'ref_table',
|
|
columns: {
|
|
id: {
|
|
name: 'id',
|
|
type: 'int',
|
|
primaryKey: true,
|
|
notNull: true,
|
|
autoincrement: false,
|
|
},
|
|
},
|
|
indexes: {},
|
|
foreignKeys: {},
|
|
compositePrimaryKeys: {},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
},
|
|
enums: {},
|
|
views: {},
|
|
};
|
|
const json2: SQLiteSchemaSquashed = {
|
|
version: '6',
|
|
dialect: 'sqlite',
|
|
tables: {
|
|
create_reference: {
|
|
name: 'create_reference',
|
|
columns: {
|
|
id: {
|
|
name: 'id',
|
|
type: 'int',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
},
|
|
indexes: {},
|
|
foreignKeys: {
|
|
create_reference_id_ref_table_id_fk:
|
|
'create_reference_id_ref_table_id_fk;create_reference;id;ref_table;id;no action;no action',
|
|
},
|
|
compositePrimaryKeys: {},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
pk1: {
|
|
name: 'pk1',
|
|
columns: {
|
|
id: {
|
|
name: 'id',
|
|
type: 'int',
|
|
primaryKey: true,
|
|
notNull: true,
|
|
autoincrement: false,
|
|
},
|
|
},
|
|
indexes: {},
|
|
foreignKeys: {},
|
|
compositePrimaryKeys: {},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
pk2: {
|
|
name: 'pk2',
|
|
columns: {
|
|
id: {
|
|
name: 'id',
|
|
type: 'int',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
},
|
|
indexes: {},
|
|
foreignKeys: {},
|
|
compositePrimaryKeys: {},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
ref_table: {
|
|
name: 'ref_table',
|
|
columns: {
|
|
id: {
|
|
name: 'id',
|
|
type: 'int',
|
|
primaryKey: true,
|
|
notNull: true,
|
|
autoincrement: false,
|
|
},
|
|
},
|
|
indexes: {},
|
|
foreignKeys: {},
|
|
compositePrimaryKeys: {},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
},
|
|
enums: {},
|
|
views: {},
|
|
};
|
|
|
|
const newJsonStatements = [
|
|
{
|
|
type: 'recreate_table',
|
|
tableName: 'pk1',
|
|
columns: [
|
|
{
|
|
name: 'id',
|
|
type: 'int',
|
|
primaryKey: true,
|
|
notNull: true,
|
|
autoincrement: false,
|
|
},
|
|
],
|
|
compositePKs: [],
|
|
referenceData: [],
|
|
uniqueConstraints: [],
|
|
checkConstraints: [],
|
|
},
|
|
{
|
|
type: 'recreate_table',
|
|
tableName: 'pk2',
|
|
columns: [
|
|
{
|
|
name: 'id',
|
|
type: 'int',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
],
|
|
compositePKs: [],
|
|
referenceData: [],
|
|
uniqueConstraints: [],
|
|
checkConstraints: [],
|
|
},
|
|
{
|
|
type: 'create_reference',
|
|
tableName: 'create_reference',
|
|
data: 'create_reference_id_ref_table_id_fk;create_reference;id;ref_table;id;no action;no action',
|
|
schema: '',
|
|
columnNotNull: false,
|
|
columnDefault: undefined,
|
|
columnType: 'int',
|
|
},
|
|
];
|
|
expect(libSQLCombineStatements(statements, json2)).toStrictEqual(
|
|
newJsonStatements,
|
|
);
|
|
});
|
|
|
|
/**
|
|
* ! before:
|
|
*
|
|
* fk1: {
|
|
* fk_id INT;
|
|
* fk_id1 INT;
|
|
* }
|
|
*
|
|
* fk2: {
|
|
* fk2_id INT; -> composite reference on ref_table id INT
|
|
* fk2_id1 INT; -> composite reference on ref_table id1 INT
|
|
* }
|
|
*
|
|
* ref_table: {
|
|
* id INT;
|
|
* id1 INT;
|
|
* }
|
|
*
|
|
* ! after:
|
|
*
|
|
* fk1: {
|
|
* fk_id INT; -> composite reference on ref_table id INT
|
|
* fk_id1 INT; -> composite reference on ref_table id1 INT
|
|
* }
|
|
*
|
|
* fk2: {
|
|
* fk2_id INT;
|
|
* fk2_id1 INT;
|
|
* }
|
|
*
|
|
* ref_table: {
|
|
* id INT;
|
|
* id1 INT;
|
|
* }
|
|
*
|
|
* set multi column reference for fk1
|
|
* drop multi column reference for fk2
|
|
*
|
|
* expect to:
|
|
* - "recreate_table" statement for fk1
|
|
* - "recreate_table" statement for fk2
|
|
*/
|
|
test(`set and drop multiple columns reference`, async (t) => {
|
|
const statements: JsonStatement[] = [
|
|
{
|
|
type: 'delete_reference',
|
|
tableName: 'fk1',
|
|
data: 'fk1_fk_id_fk_id1_ref_table_id_id1_fk;fk1;fk_id,fk_id1;ref_table;id,id1;no action;no action',
|
|
schema: '',
|
|
isMulticolumn: true,
|
|
},
|
|
{
|
|
type: 'create_reference',
|
|
tableName: 'fk2',
|
|
data: 'fk2_fk2_id_fk2_id1_ref_table_id_id1_fk;fk2;fk2_id,fk2_id1;ref_table;id,id1;no action;no action',
|
|
schema: '',
|
|
isMulticolumn: true,
|
|
},
|
|
];
|
|
const json1: SQLiteSchemaSquashed = {
|
|
version: '6',
|
|
dialect: 'sqlite',
|
|
tables: {
|
|
fk1: {
|
|
name: 'fk1',
|
|
columns: {
|
|
fk_id: {
|
|
name: 'fk_id',
|
|
type: 'int',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
fk_id1: {
|
|
name: 'fk_id1',
|
|
type: 'int',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
},
|
|
indexes: {},
|
|
foreignKeys: {
|
|
fk1_fk_id_fk_id1_ref_table_id_id1_fk:
|
|
'fk1_fk_id_fk_id1_ref_table_id_id1_fk;fk1;fk_id,fk_id1;ref_table;id,id1;no action;no action',
|
|
},
|
|
compositePrimaryKeys: {},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
fk2: {
|
|
name: 'fk2',
|
|
columns: {
|
|
fk2_id: {
|
|
name: 'fk2_id',
|
|
type: 'int',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
fk2_id1: {
|
|
name: 'fk2_id1',
|
|
type: 'int',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
},
|
|
indexes: {},
|
|
foreignKeys: {},
|
|
compositePrimaryKeys: {},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
ref_table: {
|
|
name: 'ref_table',
|
|
columns: {
|
|
id: {
|
|
name: 'id',
|
|
type: 'int',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
id1: {
|
|
name: 'id1',
|
|
type: 'int',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
},
|
|
indexes: {},
|
|
foreignKeys: {},
|
|
compositePrimaryKeys: {},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
},
|
|
enums: {},
|
|
views: {},
|
|
};
|
|
const json2: SQLiteSchemaSquashed = {
|
|
version: '6',
|
|
dialect: 'sqlite',
|
|
tables: {
|
|
fk1: {
|
|
name: 'fk1',
|
|
columns: {
|
|
fk_id: {
|
|
name: 'fk_id',
|
|
type: 'int',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
fk_id1: {
|
|
name: 'fk_id1',
|
|
type: 'int',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
},
|
|
indexes: {},
|
|
foreignKeys: {},
|
|
compositePrimaryKeys: {},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
fk2: {
|
|
name: 'fk2',
|
|
columns: {
|
|
fk2_id: {
|
|
name: 'fk2_id',
|
|
type: 'int',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
fk2_id1: {
|
|
name: 'fk2_id1',
|
|
type: 'int',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
},
|
|
indexes: {},
|
|
foreignKeys: {
|
|
fk2_fk2_id_fk2_id1_ref_table_id_id1_fk:
|
|
'fk2_fk2_id_fk2_id1_ref_table_id_id1_fk;fk2;fk2_id,fk2_id1;ref_table;id,id1;no action;no action',
|
|
},
|
|
compositePrimaryKeys: {},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
ref_table: {
|
|
name: 'ref_table',
|
|
columns: {
|
|
id: {
|
|
name: 'id',
|
|
type: 'int',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
id1: {
|
|
name: 'id1',
|
|
type: 'int',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
},
|
|
indexes: {},
|
|
foreignKeys: {},
|
|
compositePrimaryKeys: {},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
},
|
|
enums: {},
|
|
views: {},
|
|
};
|
|
|
|
const newJsonStatements = [
|
|
{
|
|
type: 'recreate_table',
|
|
tableName: 'fk1',
|
|
columns: [
|
|
{
|
|
name: 'fk_id',
|
|
type: 'int',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
{
|
|
name: 'fk_id1',
|
|
type: 'int',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
],
|
|
compositePKs: [],
|
|
referenceData: [],
|
|
uniqueConstraints: [],
|
|
checkConstraints: [],
|
|
},
|
|
{
|
|
type: 'recreate_table',
|
|
tableName: 'fk2',
|
|
columns: [
|
|
{
|
|
name: 'fk2_id',
|
|
type: 'int',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
{
|
|
name: 'fk2_id1',
|
|
type: 'int',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
],
|
|
compositePKs: [],
|
|
referenceData: [
|
|
{
|
|
name: 'fk2_fk2_id_fk2_id1_ref_table_id_id1_fk',
|
|
tableFrom: 'fk2',
|
|
tableTo: 'ref_table',
|
|
columnsFrom: ['fk2_id', 'fk2_id1'],
|
|
columnsTo: ['id', 'id1'],
|
|
onDelete: 'no action',
|
|
onUpdate: 'no action',
|
|
},
|
|
],
|
|
uniqueConstraints: [],
|
|
checkConstraints: [],
|
|
},
|
|
];
|
|
expect(libSQLCombineStatements(statements, json2)).toStrictEqual(
|
|
newJsonStatements,
|
|
);
|
|
});
|
|
|
|
/**
|
|
* ! before:
|
|
*
|
|
* pk: {
|
|
* pk TEXT PRIMARY KEY;
|
|
* }
|
|
*
|
|
* simple: {
|
|
* simple TEXT;
|
|
* }
|
|
*
|
|
* unique: {
|
|
* unique INT UNIQUE;
|
|
* }
|
|
*
|
|
* ! after:
|
|
*
|
|
* pk: {
|
|
* pk INT PRIMARY KEY;
|
|
* }
|
|
*
|
|
* simple: {
|
|
* simple INT;
|
|
* }
|
|
*
|
|
* unique: {
|
|
* unique TEXT UNIQUE;
|
|
* }
|
|
*
|
|
* set new type for primary key column
|
|
* set new type for unique column
|
|
* set new type for column without pk or unique
|
|
*
|
|
* expect to:
|
|
* - "recreate_table" statement for pk
|
|
* - "recreate_table" statement for unique
|
|
* - "alter_table_alter_column_set_type" statement for simple
|
|
* - "create_index" statement for unique
|
|
*/
|
|
test(`set new type for primary key, unique and normal column`, async (t) => {
|
|
const statements: JsonStatement[] = [
|
|
{
|
|
type: 'alter_table_alter_column_set_type',
|
|
tableName: 'pk',
|
|
columnName: 'pk',
|
|
newDataType: 'int',
|
|
oldDataType: 'text',
|
|
schema: '',
|
|
columnDefault: undefined,
|
|
columnOnUpdate: undefined,
|
|
columnNotNull: true,
|
|
columnAutoIncrement: false,
|
|
columnPk: true,
|
|
} as unknown as JsonStatement,
|
|
{
|
|
type: 'alter_table_alter_column_set_type',
|
|
tableName: 'simple',
|
|
columnName: 'simple',
|
|
newDataType: 'int',
|
|
oldDataType: 'text',
|
|
schema: '',
|
|
columnDefault: undefined,
|
|
columnOnUpdate: undefined,
|
|
columnNotNull: false,
|
|
columnAutoIncrement: false,
|
|
columnPk: false,
|
|
} as unknown as JsonStatement,
|
|
{
|
|
type: 'alter_table_alter_column_set_type',
|
|
tableName: 'unique',
|
|
columnName: 'unique',
|
|
newDataType: 'text',
|
|
oldDataType: 'int',
|
|
schema: '',
|
|
columnDefault: undefined,
|
|
columnOnUpdate: undefined,
|
|
columnNotNull: false,
|
|
columnAutoIncrement: false,
|
|
columnPk: false,
|
|
} as unknown as JsonStatement,
|
|
];
|
|
const json1: SQLiteSchemaSquashed = {
|
|
version: '6',
|
|
dialect: 'sqlite',
|
|
tables: {
|
|
pk: {
|
|
name: 'pk',
|
|
columns: {
|
|
pk: {
|
|
name: 'pk',
|
|
type: 'text',
|
|
primaryKey: true,
|
|
notNull: true,
|
|
autoincrement: false,
|
|
},
|
|
},
|
|
indexes: {},
|
|
foreignKeys: {},
|
|
compositePrimaryKeys: {},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
simple: {
|
|
name: 'simple',
|
|
columns: {
|
|
simple: {
|
|
name: 'simple',
|
|
type: 'text',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
},
|
|
indexes: {},
|
|
foreignKeys: {},
|
|
compositePrimaryKeys: {},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
unique: {
|
|
name: 'unique',
|
|
columns: {
|
|
unique: {
|
|
name: 'unique',
|
|
type: 'int',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
},
|
|
indexes: {
|
|
unique_unique_unique: 'unique_unique_unique;unique;true;',
|
|
},
|
|
foreignKeys: {},
|
|
compositePrimaryKeys: {},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
},
|
|
enums: {},
|
|
views: {},
|
|
};
|
|
const json2: SQLiteSchemaSquashed = {
|
|
version: '6',
|
|
dialect: 'sqlite',
|
|
tables: {
|
|
pk: {
|
|
name: 'pk',
|
|
columns: {
|
|
pk: {
|
|
name: 'pk',
|
|
type: 'int',
|
|
primaryKey: true,
|
|
notNull: true,
|
|
autoincrement: false,
|
|
},
|
|
},
|
|
indexes: {},
|
|
foreignKeys: {},
|
|
compositePrimaryKeys: {},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
simple: {
|
|
name: 'simple',
|
|
columns: {
|
|
simple: {
|
|
name: 'simple',
|
|
type: 'int',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
},
|
|
indexes: {},
|
|
foreignKeys: {},
|
|
compositePrimaryKeys: {},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
unique: {
|
|
name: 'unique',
|
|
columns: {
|
|
unique: {
|
|
name: 'unique',
|
|
type: 'text',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
},
|
|
indexes: {
|
|
unique_unique_unique: 'unique_unique_unique;unique;true;',
|
|
},
|
|
foreignKeys: {},
|
|
compositePrimaryKeys: {},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
},
|
|
enums: {},
|
|
views: {},
|
|
};
|
|
|
|
const newJsonStatements = [
|
|
{
|
|
type: 'recreate_table',
|
|
tableName: 'pk',
|
|
columns: [
|
|
{
|
|
name: 'pk',
|
|
type: 'int',
|
|
primaryKey: true,
|
|
notNull: true,
|
|
autoincrement: false,
|
|
},
|
|
],
|
|
compositePKs: [],
|
|
referenceData: [],
|
|
uniqueConstraints: [],
|
|
checkConstraints: [],
|
|
},
|
|
{
|
|
type: 'alter_table_alter_column_set_type',
|
|
tableName: 'simple',
|
|
columnName: 'simple',
|
|
newDataType: 'int',
|
|
oldDataType: 'text',
|
|
schema: '',
|
|
columnDefault: undefined,
|
|
columnOnUpdate: undefined,
|
|
columnNotNull: false,
|
|
columnAutoIncrement: false,
|
|
columnPk: false,
|
|
},
|
|
{
|
|
type: 'alter_table_alter_column_set_type',
|
|
tableName: 'unique',
|
|
columnName: 'unique',
|
|
newDataType: 'text',
|
|
oldDataType: 'int',
|
|
schema: '',
|
|
columnDefault: undefined,
|
|
columnOnUpdate: undefined,
|
|
columnNotNull: false,
|
|
columnAutoIncrement: false,
|
|
columnPk: false,
|
|
},
|
|
];
|
|
expect(libSQLCombineStatements(statements, json2)).toStrictEqual(
|
|
newJsonStatements,
|
|
);
|
|
});
|
|
|
|
test(`add columns. set fk`, async (t) => {
|
|
const statements: JsonStatement[] = [
|
|
{
|
|
type: 'sqlite_alter_table_add_column',
|
|
tableName: 'ref',
|
|
column: {
|
|
name: 'test',
|
|
type: 'integer',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
referenceData: undefined,
|
|
},
|
|
{
|
|
type: 'sqlite_alter_table_add_column',
|
|
tableName: 'ref',
|
|
column: {
|
|
name: 'test1',
|
|
type: 'integer',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
referenceData: undefined,
|
|
},
|
|
{
|
|
type: 'create_reference',
|
|
tableName: 'ref',
|
|
data: 'ref_new_age_user_new_age_fk;ref;new_age;user;new_age;no action;no action',
|
|
schema: '',
|
|
columnNotNull: false,
|
|
columnDefault: undefined,
|
|
columnType: 'integer',
|
|
},
|
|
];
|
|
const json1: SQLiteSchemaSquashed = {
|
|
version: '6',
|
|
dialect: 'sqlite',
|
|
tables: {
|
|
ref: {
|
|
name: 'ref',
|
|
columns: {
|
|
id1: {
|
|
name: 'id1',
|
|
type: 'text',
|
|
primaryKey: false,
|
|
notNull: true,
|
|
autoincrement: false,
|
|
},
|
|
new_age: {
|
|
name: 'new_age',
|
|
type: 'integer',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
},
|
|
indexes: {},
|
|
foreignKeys: {},
|
|
compositePrimaryKeys: {},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
user: {
|
|
name: 'user',
|
|
columns: {
|
|
id1: {
|
|
name: 'id1',
|
|
type: 'text',
|
|
primaryKey: false,
|
|
notNull: true,
|
|
autoincrement: false,
|
|
},
|
|
new_age: {
|
|
name: 'new_age',
|
|
type: 'integer',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
},
|
|
indexes: {},
|
|
foreignKeys: {},
|
|
compositePrimaryKeys: {},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
},
|
|
enums: {},
|
|
views: {},
|
|
};
|
|
const json2: SQLiteSchemaSquashed = {
|
|
version: '6',
|
|
dialect: 'sqlite',
|
|
tables: {
|
|
ref: {
|
|
name: 'ref',
|
|
columns: {
|
|
id1: {
|
|
name: 'id1',
|
|
type: 'text',
|
|
primaryKey: false,
|
|
notNull: true,
|
|
autoincrement: false,
|
|
},
|
|
new_age: {
|
|
name: 'new_age',
|
|
type: 'integer',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
test: {
|
|
name: 'test',
|
|
type: 'integer',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
test1: {
|
|
name: 'test1',
|
|
type: 'integer',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
},
|
|
indexes: {},
|
|
foreignKeys: {
|
|
ref_new_age_user_new_age_fk: 'ref_new_age_user_new_age_fk;ref;new_age;user;new_age;no action;no action',
|
|
},
|
|
compositePrimaryKeys: {},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
user: {
|
|
name: 'user',
|
|
columns: {
|
|
id1: {
|
|
name: 'id1',
|
|
type: 'text',
|
|
primaryKey: false,
|
|
notNull: true,
|
|
autoincrement: false,
|
|
},
|
|
new_age: {
|
|
name: 'new_age',
|
|
type: 'integer',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
},
|
|
indexes: {},
|
|
foreignKeys: {},
|
|
compositePrimaryKeys: {},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
},
|
|
enums: {},
|
|
views: {},
|
|
};
|
|
|
|
const newJsonStatements = [
|
|
{
|
|
type: 'sqlite_alter_table_add_column',
|
|
tableName: 'ref',
|
|
column: {
|
|
name: 'test',
|
|
type: 'integer',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
referenceData: undefined,
|
|
},
|
|
{
|
|
type: 'sqlite_alter_table_add_column',
|
|
tableName: 'ref',
|
|
column: {
|
|
name: 'test1',
|
|
type: 'integer',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
referenceData: undefined,
|
|
},
|
|
{
|
|
type: 'create_reference',
|
|
tableName: 'ref',
|
|
data: 'ref_new_age_user_new_age_fk;ref;new_age;user;new_age;no action;no action',
|
|
schema: '',
|
|
columnNotNull: false,
|
|
columnDefault: undefined,
|
|
columnType: 'integer',
|
|
},
|
|
];
|
|
expect(libSQLCombineStatements(statements, json2)).toStrictEqual(
|
|
newJsonStatements,
|
|
);
|
|
});
|
|
|
|
test(`add column and fk`, async (t) => {
|
|
const statements: JsonStatement[] = [
|
|
{
|
|
type: 'sqlite_alter_table_add_column',
|
|
tableName: 'ref',
|
|
column: {
|
|
name: 'test1',
|
|
type: 'integer',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
referenceData: 'ref_test1_user_new_age_fk;ref;test1;user;new_age;no action;no action',
|
|
},
|
|
{
|
|
type: 'create_reference',
|
|
tableName: 'ref',
|
|
data: 'ref_test1_user_new_age_fk;ref;test1;user;new_age;no action;no action',
|
|
schema: '',
|
|
columnNotNull: false,
|
|
columnDefault: undefined,
|
|
columnType: 'integer',
|
|
},
|
|
];
|
|
const json1: SQLiteSchemaSquashed = {
|
|
version: '6',
|
|
dialect: 'sqlite',
|
|
tables: {
|
|
ref: {
|
|
name: 'ref',
|
|
columns: {
|
|
id1: {
|
|
name: 'id1',
|
|
type: 'text',
|
|
primaryKey: false,
|
|
notNull: true,
|
|
autoincrement: false,
|
|
},
|
|
new_age: {
|
|
name: 'new_age',
|
|
type: 'integer',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
test1: {
|
|
name: 'test1',
|
|
type: 'integer',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
},
|
|
indexes: {},
|
|
foreignKeys: {
|
|
ref_test1_user_new_age_fk: 'ref_test1_user_new_age_fk;ref;test1;user;new_age;no action;no action',
|
|
},
|
|
compositePrimaryKeys: {},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
user: {
|
|
name: 'user',
|
|
columns: {
|
|
id1: {
|
|
name: 'id1',
|
|
type: 'text',
|
|
primaryKey: false,
|
|
notNull: true,
|
|
autoincrement: false,
|
|
},
|
|
new_age: {
|
|
name: 'new_age',
|
|
type: 'integer',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
},
|
|
indexes: {},
|
|
foreignKeys: {},
|
|
compositePrimaryKeys: {},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
},
|
|
enums: {},
|
|
views: {},
|
|
};
|
|
const json2: SQLiteSchemaSquashed = {
|
|
version: '6',
|
|
dialect: 'sqlite',
|
|
tables: {
|
|
ref: {
|
|
name: 'ref',
|
|
columns: {
|
|
id1: {
|
|
name: 'id1',
|
|
type: 'text',
|
|
primaryKey: false,
|
|
notNull: true,
|
|
autoincrement: false,
|
|
},
|
|
new_age: {
|
|
name: 'new_age',
|
|
type: 'integer',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
test: {
|
|
name: 'test',
|
|
type: 'integer',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
test1: {
|
|
name: 'test1',
|
|
type: 'integer',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
},
|
|
indexes: {},
|
|
foreignKeys: {
|
|
ref_new_age_user_new_age_fk: 'ref_new_age_user_new_age_fk;ref;new_age;user;new_age;no action;no action',
|
|
},
|
|
compositePrimaryKeys: {},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
user: {
|
|
name: 'user',
|
|
columns: {
|
|
id1: {
|
|
name: 'id1',
|
|
type: 'text',
|
|
primaryKey: false,
|
|
notNull: true,
|
|
autoincrement: false,
|
|
},
|
|
new_age: {
|
|
name: 'new_age',
|
|
type: 'integer',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
},
|
|
indexes: {},
|
|
foreignKeys: {},
|
|
compositePrimaryKeys: {},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
},
|
|
enums: {},
|
|
views: {},
|
|
};
|
|
|
|
const newJsonStatements = [
|
|
{
|
|
type: 'sqlite_alter_table_add_column',
|
|
tableName: 'ref',
|
|
column: {
|
|
name: 'test1',
|
|
type: 'integer',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
referenceData: 'ref_test1_user_new_age_fk;ref;test1;user;new_age;no action;no action',
|
|
},
|
|
];
|
|
expect(libSQLCombineStatements(statements, json2)).toStrictEqual(
|
|
newJsonStatements,
|
|
);
|
|
});
|
|
|
|
test(`add column and fk`, async (t) => {
|
|
const statements: JsonStatement[] = [
|
|
{
|
|
type: 'sqlite_alter_table_add_column',
|
|
tableName: 'ref',
|
|
column: {
|
|
name: 'test1',
|
|
type: 'integer',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
referenceData: 'ref_test1_user_new_age_fk;ref;test1;user;new_age;no action;no action',
|
|
},
|
|
{
|
|
type: 'create_reference',
|
|
tableName: 'ref',
|
|
data: 'ref_test1_user_new_age_fk;ref;test1;user;new_age;no action;no action',
|
|
schema: '',
|
|
columnNotNull: false,
|
|
columnDefault: undefined,
|
|
columnType: 'integer',
|
|
},
|
|
];
|
|
const json1: SQLiteSchemaSquashed = {
|
|
version: '6',
|
|
dialect: 'sqlite',
|
|
tables: {
|
|
ref: {
|
|
name: 'ref',
|
|
columns: {
|
|
id1: {
|
|
name: 'id1',
|
|
type: 'text',
|
|
primaryKey: false,
|
|
notNull: true,
|
|
autoincrement: false,
|
|
},
|
|
new_age: {
|
|
name: 'new_age',
|
|
type: 'integer',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
test1: {
|
|
name: 'test1',
|
|
type: 'integer',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
},
|
|
indexes: {},
|
|
foreignKeys: {
|
|
ref_test1_user_new_age_fk: 'ref_test1_user_new_age_fk;ref;test1;user;new_age;no action;no action',
|
|
},
|
|
compositePrimaryKeys: {},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
user: {
|
|
name: 'user',
|
|
columns: {
|
|
id1: {
|
|
name: 'id1',
|
|
type: 'text',
|
|
primaryKey: false,
|
|
notNull: true,
|
|
autoincrement: false,
|
|
},
|
|
new_age: {
|
|
name: 'new_age',
|
|
type: 'integer',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
},
|
|
indexes: {},
|
|
foreignKeys: {},
|
|
compositePrimaryKeys: {},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
},
|
|
enums: {},
|
|
views: {},
|
|
};
|
|
const json2: SQLiteSchemaSquashed = {
|
|
version: '6',
|
|
dialect: 'sqlite',
|
|
tables: {
|
|
ref: {
|
|
name: 'ref',
|
|
columns: {
|
|
id1: {
|
|
name: 'id1',
|
|
type: 'text',
|
|
primaryKey: false,
|
|
notNull: true,
|
|
autoincrement: false,
|
|
},
|
|
new_age: {
|
|
name: 'new_age',
|
|
type: 'integer',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
test: {
|
|
name: 'test',
|
|
type: 'integer',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
test1: {
|
|
name: 'test1',
|
|
type: 'integer',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
},
|
|
indexes: {},
|
|
foreignKeys: {
|
|
ref_new_age_user_new_age_fk: 'ref_new_age_user_new_age_fk;ref;new_age;user;new_age;no action;no action',
|
|
},
|
|
compositePrimaryKeys: {},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
user: {
|
|
name: 'user',
|
|
columns: {
|
|
id1: {
|
|
name: 'id1',
|
|
type: 'text',
|
|
primaryKey: false,
|
|
notNull: true,
|
|
autoincrement: false,
|
|
},
|
|
new_age: {
|
|
name: 'new_age',
|
|
type: 'integer',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
},
|
|
indexes: {},
|
|
foreignKeys: {},
|
|
compositePrimaryKeys: {},
|
|
uniqueConstraints: {},
|
|
checkConstraints: {},
|
|
},
|
|
},
|
|
enums: {},
|
|
views: {},
|
|
};
|
|
|
|
const newJsonStatements = [
|
|
{
|
|
type: 'sqlite_alter_table_add_column',
|
|
tableName: 'ref',
|
|
column: {
|
|
name: 'test1',
|
|
type: 'integer',
|
|
primaryKey: false,
|
|
notNull: false,
|
|
autoincrement: false,
|
|
},
|
|
referenceData: 'ref_test1_user_new_age_fk;ref;test1;user;new_age;no action;no action',
|
|
},
|
|
];
|
|
expect(libSQLCombineStatements(statements, json2)).toStrictEqual(
|
|
newJsonStatements,
|
|
);
|
|
});
|