wehub-resource-sync
59 lines
1.2 KiB
TypeScript
59 lines
1.2 KiB
TypeScript
import { createClient } from '@libsql/client';
|
|
import { connectToLibSQL } from 'src/cli/connections';
|
|
import { expect, test } from 'vitest';
|
|
|
|
test('validate migrate function', async () => {
|
|
const credentials = {
|
|
url: ':memory:',
|
|
};
|
|
const { migrate, query } = await connectToLibSQL(credentials);
|
|
|
|
await migrate({ migrationsFolder: 'tests/migrate/migrations' });
|
|
|
|
const res = await query(`PRAGMA table_info("users");`);
|
|
|
|
expect(res).toStrictEqual([{
|
|
cid: 0,
|
|
name: 'id',
|
|
type: 'INTEGER',
|
|
notnull: 0,
|
|
dflt_value: null,
|
|
pk: 0,
|
|
}, {
|
|
cid: 1,
|
|
name: 'name',
|
|
type: 'INTEGER',
|
|
notnull: 1,
|
|
dflt_value: null,
|
|
pk: 0,
|
|
}]);
|
|
});
|
|
|
|
// test('validate migrate function', async () => {
|
|
// const credentials = {
|
|
// url: '',
|
|
// authToken: '',
|
|
// };
|
|
// const { migrate, query } = await connectToLibSQL(credentials);
|
|
|
|
// await migrate({ migrationsFolder: 'tests/migrate/migrations' });
|
|
|
|
// const res = await query(`PRAGMA table_info("users");`);
|
|
|
|
// expect(res).toStrictEqual([{
|
|
// cid: 0,
|
|
// name: 'id',
|
|
// type: 'INTEGER',
|
|
// notnull: 0,
|
|
// dflt_value: null,
|
|
// pk: 0,
|
|
// }, {
|
|
// cid: 1,
|
|
// name: 'name',
|
|
// type: 'INTEGER',
|
|
// notnull: 1,
|
|
// dflt_value: null,
|
|
// pk: 0,
|
|
// }]);
|
|
// });
|