summaryrefslogtreecommitdiff
path: root/packages/db/test/unit/reference-queries.test.js
diff options
context:
space:
mode:
Diffstat (limited to 'packages/db/test/unit/reference-queries.test.js')
-rw-r--r--packages/db/test/unit/reference-queries.test.js29
1 files changed, 14 insertions, 15 deletions
diff --git a/packages/db/test/unit/reference-queries.test.js b/packages/db/test/unit/reference-queries.test.js
index 76f6341e1..1660922a1 100644
--- a/packages/db/test/unit/reference-queries.test.js
+++ b/packages/db/test/unit/reference-queries.test.js
@@ -1,5 +1,5 @@
-import { expect } from 'chai';
-import { describe, it } from 'mocha';
+import { describe, it } from "node:test";
+import assert from "node:assert/strict";
import { getTableChangeQueries } from '../../dist/core/cli/migration-queries.js';
import { tablesSchema } from '../../dist/core/schemas.js';
import { column, defineTable } from '../../dist/runtime/virtual.js';
@@ -59,11 +59,11 @@ describe('reference queries', () => {
const { queries } = await userChangeQueries(Initial, Final);
- expect(queries[0]).to.not.be.undefined;
+ assert.equal(queries[0] !== undefined, true);
const tempTableName = getTempTableName(queries[0]);
- expect(tempTableName).to.not.be.undefined;
+ assert.notEqual(typeof tempTableName, "undefined");
- expect(queries).to.deep.equal([
+ assert.deepEqual(queries, [
`CREATE TABLE \"${tempTableName}\" (_id INTEGER PRIMARY KEY, \"to\" integer NOT NULL REFERENCES \"User\" (\"id\"), \"toName\" text NOT NULL, \"subject\" text NOT NULL, \"body\" text NOT NULL)`,
`INSERT INTO \"${tempTableName}\" (\"_id\", \"to\", \"toName\", \"subject\", \"body\") SELECT \"_id\", \"to\", \"toName\", \"subject\", \"body\" FROM \"User\"`,
'DROP TABLE "User"',
@@ -84,11 +84,11 @@ describe('reference queries', () => {
const { queries } = await userChangeQueries(Initial, Final);
- expect(queries[0]).to.not.be.undefined;
+ assert.equal(queries[0] !== undefined, true);
const tempTableName = getTempTableName(queries[0]);
- expect(tempTableName).to.not.be.undefined;
+ assert.notEqual(typeof tempTableName, "undefined");
- expect(queries).to.deep.equal([
+ assert.deepEqual(queries, [
`CREATE TABLE \"${tempTableName}\" (_id INTEGER PRIMARY KEY, \"to\" integer NOT NULL, \"toName\" text NOT NULL, \"subject\" text NOT NULL, \"body\" text NOT NULL)`,
`INSERT INTO \"${tempTableName}\" (\"_id\", \"to\", \"toName\", \"subject\", \"body\") SELECT \"_id\", \"to\", \"toName\", \"subject\", \"body\" FROM \"User\"`,
'DROP TABLE "User"',
@@ -108,10 +108,10 @@ describe('reference queries', () => {
});
const { queries } = await userChangeQueries(Initial, Final);
- expect(queries[0]).to.not.be.undefined;
+ assert.equal(queries[0] !== undefined, true);
const tempTableName = getTempTableName(queries[0]);
- expect(queries).to.deep.equal([
+ assert.deepEqual(queries, [
`CREATE TABLE \"${tempTableName}\" (_id INTEGER PRIMARY KEY, \"to\" integer NOT NULL, \"toName\" text NOT NULL, \"subject\" text NOT NULL, \"body\" text NOT NULL, \"from\" integer REFERENCES \"User\" (\"id\"))`,
`INSERT INTO \"${tempTableName}\" (\"_id\", \"to\", \"toName\", \"subject\", \"body\") SELECT \"_id\", \"to\", \"toName\", \"subject\", \"body\" FROM \"User\"`,
'DROP TABLE "User"',
@@ -149,14 +149,13 @@ describe('reference queries', () => {
const addedForeignKey = await userChangeQueries(InitialWithoutFK, Final);
const updatedForeignKey = await userChangeQueries(InitialWithDifferentFK, Final);
- expect(addedForeignKey.queries[0]).to.not.be.undefined;
- expect(updatedForeignKey.queries[0]).to.not.be.undefined;
-
- expect(addedForeignKey.queries).to.deep.equal(
+ assert.notEqual(typeof addedForeignKey.queries[0], "undefined");
+ assert.notEqual(typeof updatedForeignKey.queries[0], "undefined");
+ assert.deepEqual(addedForeignKey.queries,
expected(getTempTableName(addedForeignKey.queries[0]))
);
- expect(updatedForeignKey.queries).to.deep.equal(
+ assert.deepEqual(updatedForeignKey.queries,
expected(getTempTableName(updatedForeignKey.queries[0]))
);
});