summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat
-rw-r--r--packages/db/test/basics.test.js32
-rw-r--r--packages/db/test/db-in-src.test.js14
-rw-r--r--packages/db/test/error-handling.test.js8
-rw-r--r--packages/db/test/integration-only.test.js24
-rw-r--r--packages/db/test/integrations.test.js44
-rw-r--r--packages/db/test/local-prod.test.js12
-rw-r--r--packages/db/test/no-seed.test.js24
-rw-r--r--packages/db/test/ssr-no-apptoken.test.js6
-rw-r--r--packages/db/test/static-remote.test.js6
-rw-r--r--packages/db/test/unit/column-queries.test.js36
-rw-r--r--packages/db/test/unit/index-queries.test.js8
-rw-r--r--packages/db/test/unit/reference-queries.test.js18
-rw-r--r--packages/db/test/unit/reset-queries.test.js4
13 files changed, 84 insertions, 152 deletions
diff --git a/packages/db/test/basics.test.js b/packages/db/test/basics.test.js
index 58e23ac7f..c85880bef 100644
--- a/packages/db/test/basics.test.js
+++ b/packages/db/test/basics.test.js
@@ -1,5 +1,5 @@
-import { describe, it, before, after } from "node:test";
-import assert from "node:assert/strict";
+import assert from 'node:assert/strict';
+import { after, before, describe, it } from 'node:test';
import { load as cheerioLoad } from 'cheerio';
import testAdapter from '../../astro/test/test-adapter.js';
import { loadFixture } from '../../astro/test/test-utils.js';
@@ -31,14 +31,8 @@ describe('astro:db', () => {
const $ = cheerioLoad(html);
const ul = $('.authors-list');
- assert.equal(
- ul.children().length,
- 5
- );
- assert.match(
- ul.children().eq(0).text(),
- /Ben/
- )
+ assert.equal(ul.children().length, 5);
+ assert.match(ul.children().eq(0).text(), /Ben/);
});
it('Allows expression defaults for date columns', async () => {
@@ -46,7 +40,7 @@ describe('astro:db', () => {
const $ = cheerioLoad(html);
const themeAdded = $($('.themes-list .theme-added')[0]).text();
- assert.equal(Number.isNaN(new Date(themeAdded).getTime()), false);
+ assert.equal(Number.isNaN(new Date(themeAdded).getTime()), false);
});
it('Defaults can be overridden for dates', async () => {
@@ -118,14 +112,8 @@ describe('astro:db', () => {
const $ = cheerioLoad(html);
const ul = $('.authors-list');
- assert.equal(
- ul.children().length,
- 5
- );
- assert.match(
- ul.children().eq(0).text(),
- /Ben/
- )
+ assert.equal(ul.children().length, 5);
+ assert.match(ul.children().eq(0).text(), /Ben/);
});
it('Allows expression defaults for date columns', async () => {
@@ -150,7 +138,6 @@ describe('astro:db', () => {
const themeOwner = $($('.themes-list .theme-owner')[0]).text();
assert.equal(themeOwner, '');
-
});
it('Allows expression defaults for boolean columns', async () => {
@@ -159,7 +146,6 @@ describe('astro:db', () => {
const themeDark = $($('.themes-list .theme-dark')[0]).text();
assert.match(themeDark, /dark mode/);
-
});
it('text fields an be used as references', async () => {
@@ -210,9 +196,7 @@ describe('astro:db', () => {
const $ = cheerioLoad(html);
const ul = $('.authors-list');
- assert.equal(
- ul.children().length,5
- )
+ assert.equal(ul.children().length, 5);
});
});
});
diff --git a/packages/db/test/db-in-src.test.js b/packages/db/test/db-in-src.test.js
index 5445585b4..5e29b7372 100644
--- a/packages/db/test/db-in-src.test.js
+++ b/packages/db/test/db-in-src.test.js
@@ -1,5 +1,5 @@
-import { describe, it, before, after } from "node:test";
-import assert from "node:assert/strict";
+import assert from 'node:assert/strict';
+import { after, before, describe, it } from 'node:test';
import { load as cheerioLoad } from 'cheerio';
import testAdapter from '../../astro/test/test-adapter.js';
import { loadFixture } from '../../astro/test/test-utils.js';
@@ -31,14 +31,8 @@ describe('astro:db', () => {
const $ = cheerioLoad(html);
const ul = $('.users-list');
- assert.equal(
- ul.children().length,
- 1
- );
- assert.match(
- $('.users-list li').text(),
- /Mario/
- )
+ assert.equal(ul.children().length, 1);
+ assert.match($('.users-list li').text(), /Mario/);
});
});
});
diff --git a/packages/db/test/error-handling.test.js b/packages/db/test/error-handling.test.js
index 01b701346..5ca9ce5c2 100644
--- a/packages/db/test/error-handling.test.js
+++ b/packages/db/test/error-handling.test.js
@@ -1,7 +1,7 @@
-import { describe, it, before, after } from "node:test";
+import assert from 'node:assert/strict';
+import { after, before, describe, it } from 'node:test';
import { loadFixture } from '../../astro/test/test-utils.js';
import { setupRemoteDbServer } from './test-utils.js';
-import assert from "node:assert/strict"
const foreignKeyConstraintError =
'LibsqlError: SQLITE_CONSTRAINT_FOREIGNKEY: FOREIGN KEY constraint failed';
@@ -30,7 +30,7 @@ describe('astro:db - error handling', () => {
assert.deepEqual(json, {
message: foreignKeyConstraintError,
code: 'SQLITE_CONSTRAINT_FOREIGNKEY',
- })
+ });
});
});
@@ -51,7 +51,7 @@ describe('astro:db - error handling', () => {
assert.deepEqual(JSON.parse(json), {
message: foreignKeyConstraintError,
code: 'SQLITE_CONSTRAINT_FOREIGNKEY',
- })
+ });
});
});
});
diff --git a/packages/db/test/integration-only.test.js b/packages/db/test/integration-only.test.js
index 290fbc5db..b95d7d141 100644
--- a/packages/db/test/integration-only.test.js
+++ b/packages/db/test/integration-only.test.js
@@ -1,5 +1,5 @@
-import { describe, it, before, after } from "node:test";
-import assert from "node:assert/strict";
+import assert from 'node:assert/strict';
+import { after, before, describe, it } from 'node:test';
import { load as cheerioLoad } from 'cheerio';
import { loadFixture } from '../../astro/test/test-utils.js';
@@ -26,14 +26,8 @@ describe('astro:db with only integrations, no user db config', () => {
const $ = cheerioLoad(html);
const ul = $('ul.menu');
- assert.equal(
- ul.children().length,
- 4
- );
- assert.match(
- ul.children().eq(0).text(),
- /Pancakes/
- )
+ assert.equal(ul.children().length, 4);
+ assert.match(ul.children().eq(0).text(), /Pancakes/);
});
});
@@ -47,14 +41,8 @@ describe('astro:db with only integrations, no user db config', () => {
const $ = cheerioLoad(html);
const ul = $('ul.menu');
- assert.equal(
- ul.children().length,
- 4
- );
- assert.match(
- ul.children().eq(0).text(),
- /Pancakes/
- )
+ assert.equal(ul.children().length, 4);
+ assert.match(ul.children().eq(0).text(), /Pancakes/);
});
});
});
diff --git a/packages/db/test/integrations.test.js b/packages/db/test/integrations.test.js
index d7a8a2d77..fb68d20f4 100644
--- a/packages/db/test/integrations.test.js
+++ b/packages/db/test/integrations.test.js
@@ -1,5 +1,5 @@
-import { describe, it, before, after } from "node:test";
-import assert from "node:assert/strict";
+import assert from 'node:assert/strict';
+import { after, before, describe, it } from 'node:test';
import { load as cheerioLoad } from 'cheerio';
import { loadFixture } from '../../astro/test/test-utils.js';
@@ -28,14 +28,8 @@ describe('astro:db with integrations', () => {
const $ = cheerioLoad(html);
const ul = $('.authors-list');
- assert.equal(
- ul.children().length,
- 5
- );
- assert.match(
- ul.children().eq(0).text(),
- /Ben/
- )
+ assert.equal(ul.children().length, 5);
+ assert.match(ul.children().eq(0).text(), /Ben/);
});
it('Prints the list of menu items from integration-defined table', async () => {
@@ -43,14 +37,8 @@ describe('astro:db with integrations', () => {
const $ = cheerioLoad(html);
const ul = $('ul.menu');
- assert.equal(
- ul.children().length,
- 4
- );
- assert.match(
- ul.children().eq(0).text(),
- /Pancakes/
- )
+ assert.equal(ul.children().length, 4);
+ assert.match(ul.children().eq(0).text(), /Pancakes/);
});
});
@@ -64,14 +52,8 @@ describe('astro:db with integrations', () => {
const $ = cheerioLoad(html);
const ul = $('.authors-list');
- assert.equal(
- ul.children().length,
- 5
- );
- assert.match(
- ul.children().eq(0).text(),
- /Ben/
- )
+ assert.equal(ul.children().length, 5);
+ assert.match(ul.children().eq(0).text(), /Ben/);
});
it('Prints the list of menu items from integration-defined table', async () => {
@@ -79,14 +61,8 @@ describe('astro:db with integrations', () => {
const $ = cheerioLoad(html);
const ul = $('ul.menu');
- assert.equal(
- ul.children().length,
- 4
- );
- assert.match(
- ul.children().eq(0).text(),
- /Pancakes/
- )
+ assert.equal(ul.children().length, 4);
+ assert.match(ul.children().eq(0).text(), /Pancakes/);
});
});
});
diff --git a/packages/db/test/local-prod.test.js b/packages/db/test/local-prod.test.js
index 1fb8d1436..134ee6b56 100644
--- a/packages/db/test/local-prod.test.js
+++ b/packages/db/test/local-prod.test.js
@@ -1,7 +1,7 @@
+import assert from 'node:assert/strict';
+import { after, before, describe, it } from 'node:test';
import { relative } from 'path';
import { fileURLToPath } from 'url';
-import { describe, it, before, after } from "node:test";
-import assert from "node:assert/strict";
import testAdapter from '../../astro/test/test-adapter.js';
import { loadFixture } from '../../astro/test/test-utils.js';
@@ -64,8 +64,8 @@ describe('astro:db local database', () => {
} catch (err) {
buildError = err;
}
-
- assert.equal(buildError instanceof Error, true)
+
+ assert.equal(buildError instanceof Error, true);
});
it('should throw during the build for hybrid output', async () => {
@@ -82,8 +82,8 @@ describe('astro:db local database', () => {
} catch (err) {
buildError = err;
}
-
- assert.equal(buildError instanceof Error, true)
+
+ assert.equal(buildError instanceof Error, true);
});
});
});
diff --git a/packages/db/test/no-seed.test.js b/packages/db/test/no-seed.test.js
index 7641f909f..058352176 100644
--- a/packages/db/test/no-seed.test.js
+++ b/packages/db/test/no-seed.test.js
@@ -1,5 +1,5 @@
-import { describe, it, before, after } from "node:test";
-import assert from "node:assert/strict";
+import assert from 'node:assert/strict';
+import { after, before, describe, it } from 'node:test';
import { load as cheerioLoad } from 'cheerio';
import { loadFixture } from '../../astro/test/test-utils.js';
@@ -26,14 +26,8 @@ describe('astro:db with no seed file', () => {
const $ = cheerioLoad(html);
const ul = $('.authors-list');
- assert.equal(
- ul.children().length,
- 5
- );
- assert.match(
- ul.children().eq(0).text(),
- /Ben/
- )
+ assert.equal(ul.children().length, 5);
+ assert.match(ul.children().eq(0).text(), /Ben/);
});
});
@@ -47,14 +41,8 @@ describe('astro:db with no seed file', () => {
const $ = cheerioLoad(html);
const ul = $('.authors-list');
- assert.equal(
- ul.children().length,
- 5
- );
- assert.match(
- ul.children().eq(0).text(),
- /Ben/
- )
+ assert.equal(ul.children().length, 5);
+ assert.match(ul.children().eq(0).text(), /Ben/);
});
});
});
diff --git a/packages/db/test/ssr-no-apptoken.test.js b/packages/db/test/ssr-no-apptoken.test.js
index e8c7ba69b..c570306e5 100644
--- a/packages/db/test/ssr-no-apptoken.test.js
+++ b/packages/db/test/ssr-no-apptoken.test.js
@@ -1,5 +1,5 @@
-import { describe, it, before, after } from "node:test";
-import assert from "node:assert/strict";
+import assert from 'node:assert/strict';
+import { after, before, describe, it } from 'node:test';
import testAdapter from '../../astro/test/test-adapter.js';
import { loadFixture } from '../../astro/test/test-utils.js';
import { setupRemoteDbServer } from './test-utils.js';
@@ -31,7 +31,7 @@ describe('missing app token', () => {
try {
await response.text();
} catch {
- assert.equal(response.status, 501)
+ assert.equal(response.status, 501);
}
});
});
diff --git a/packages/db/test/static-remote.test.js b/packages/db/test/static-remote.test.js
index 42b18b1a4..1f38683c7 100644
--- a/packages/db/test/static-remote.test.js
+++ b/packages/db/test/static-remote.test.js
@@ -1,5 +1,5 @@
-import { describe, it, before, after } from "node:test";
-import assert from "node:assert/strict";
+import assert from 'node:assert/strict';
+import { after, before, describe, it } from 'node:test';
import { load as cheerioLoad } from 'cheerio';
import { loadFixture } from '../../astro/test/test-utils.js';
import { setupRemoteDbServer } from './test-utils.js';
@@ -29,7 +29,7 @@ describe('astro:db', () => {
const html = await fixture.readFile('/index.html');
const $ = cheerioLoad(html);
- assert.equal($('li').length, 1)
+ assert.equal($('li').length, 1);
});
it('Returns correct shape from db.run()', async () => {
diff --git a/packages/db/test/unit/column-queries.test.js b/packages/db/test/unit/column-queries.test.js
index 62db6b110..ebb865670 100644
--- a/packages/db/test/unit/column-queries.test.js
+++ b/packages/db/test/unit/column-queries.test.js
@@ -1,5 +1,5 @@
-import { describe, it } from "node:test";
-import assert from "node:assert/strict";
+import assert from 'node:assert/strict';
+import { describe, it } from 'node:test';
import {
getMigrationQueries,
getTableChangeQueries,
@@ -121,7 +121,7 @@ describe('column queries', () => {
'DROP TABLE "Users"',
'CREATE TABLE "Users" (_id INTEGER PRIMARY KEY, "date" text NOT NULL)',
]);
- assert.equal(confirmations.length, 1)
+ assert.equal(confirmations.length, 1);
});
it('should return warning if new required column added', async () => {
@@ -140,7 +140,7 @@ describe('column queries', () => {
'DROP TABLE "Users"',
'CREATE TABLE "Users" (_id INTEGER PRIMARY KEY, "date" text NOT NULL)',
]);
- assert.equal(confirmations.length, 1)
+ assert.equal(confirmations.length, 1);
});
it('should return warning if non-number primary key with no default added', async () => {
@@ -159,7 +159,7 @@ describe('column queries', () => {
'DROP TABLE "Users"',
'CREATE TABLE "Users" ("id" text PRIMARY KEY)',
]);
- assert.equal(confirmations.length, 1)
+ assert.equal(confirmations.length, 1);
});
it('should be empty when type updated to same underlying SQL type', async () => {
@@ -299,10 +299,10 @@ describe('column queries', () => {
};
const { queries } = await userChangeQueries(userInitial, userFinal);
- assert.equal(queries.length, 4)
+ assert.equal(queries.length, 4);
const tempTableName = getTempTableName(queries[0]);
- assert.equal(typeof tempTableName, "string");
+ assert.equal(typeof tempTableName, 'string');
assert.deepEqual(queries, [
`CREATE TABLE "${tempTableName}" (_id INTEGER PRIMARY KEY, "name" text NOT NULL, "age" integer NOT NULL, "email" text NOT NULL UNIQUE, "mi" text, "phoneNumber" text UNIQUE)`,
`INSERT INTO "${tempTableName}" ("_id", "name", "age", "email", "mi") SELECT "_id", "name", "age", "email", "mi" FROM "Users"`,
@@ -321,11 +321,11 @@ describe('column queries', () => {
delete userFinal.columns.email;
const { queries } = await userChangeQueries(userInitial, userFinal);
- assert.equal(queries.length, 4)
- assert.equal(queries.length, 4)
+ assert.equal(queries.length, 4);
+ assert.equal(queries.length, 4);
const tempTableName = getTempTableName(queries[0]);
- assert.equal(typeof tempTableName, "string");
+ assert.equal(typeof tempTableName, 'string');
assert.deepEqual(queries, [
`CREATE TABLE "${tempTableName}" (_id INTEGER PRIMARY KEY, "name" text NOT NULL, "age" integer NOT NULL, "mi" text)`,
`INSERT INTO "${tempTableName}" ("_id", "name", "age", "mi") SELECT "_id", "name", "age", "mi" FROM "Users"`,
@@ -352,10 +352,10 @@ describe('column queries', () => {
});
const { queries } = await userChangeQueries(initial, userFinal);
- assert.equal(queries.length, 4)
+ assert.equal(queries.length, 4);
const tempTableName = getTempTableName(queries[0]);
- assert.equal(typeof tempTableName, "string");
+ assert.equal(typeof tempTableName, 'string');
assert.deepEqual(queries, [
`CREATE TABLE "${tempTableName}" (_id INTEGER PRIMARY KEY, "name" text NOT NULL, "age" text NOT NULL DEFAULT CURRENT_TIMESTAMP, "email" text NOT NULL UNIQUE, "mi" text)`,
`INSERT INTO "${tempTableName}" ("_id", "name", "age", "email", "mi") SELECT "_id", "name", "age", "email", "mi" FROM "Users"`,
@@ -374,10 +374,10 @@ describe('column queries', () => {
});
const { queries } = await userChangeQueries(userInitial, userFinal);
- assert.equal(queries.length, 4)
+ assert.equal(queries.length, 4);
const tempTableName = getTempTableName(queries[0]);
- assert.equal(typeof tempTableName, "string");
+ assert.equal(typeof tempTableName, 'string');
assert.deepEqual(queries, [
`CREATE TABLE "${tempTableName}" (_id INTEGER PRIMARY KEY, "name" text NOT NULL, "age" integer NOT NULL, "email" text NOT NULL UNIQUE, "mi" text, "birthday" text NOT NULL DEFAULT CURRENT_TIMESTAMP)`,
`INSERT INTO "${tempTableName}" ("_id", "name", "age", "email", "mi") SELECT "_id", "name", "age", "email", "mi" FROM "Users"`,
@@ -404,10 +404,10 @@ describe('column queries', () => {
const { queries } = await userChangeQueries(userInitial, userFinal);
- assert.equal(queries.length, 4)
+ assert.equal(queries.length, 4);
const tempTableName = getTempTableName(queries[0]);
- assert.equal(typeof tempTableName, "string");
+ assert.equal(typeof tempTableName, 'string');
assert.deepEqual(queries, [
`CREATE TABLE "${tempTableName}" (_id INTEGER PRIMARY KEY, "name" text NOT NULL, "age" integer NOT NULL, "email" text NOT NULL UNIQUE, "mi" text NOT NULL)`,
`INSERT INTO "${tempTableName}" ("_id", "name", "age", "email", "mi") SELECT "_id", "name", "age", "email", "mi" FROM "Users"`,
@@ -426,10 +426,10 @@ describe('column queries', () => {
};
const { queries } = await userChangeQueries(userInitial, userFinal);
- assert.equal(queries.length, 4)
+ assert.equal(queries.length, 4);
const tempTableName = getTempTableName(queries[0]);
- assert.equal(typeof tempTableName, "string");
+ assert.equal(typeof tempTableName, 'string');
assert.deepEqual(queries, [
`CREATE TABLE "${tempTableName}" (_id INTEGER PRIMARY KEY, "name" text NOT NULL, "age" integer NOT NULL UNIQUE, "email" text NOT NULL UNIQUE, "mi" text)`,
`INSERT INTO "${tempTableName}" ("_id", "name", "age", "email", "mi") SELECT "_id", "name", "age", "email", "mi" FROM "Users"`,
diff --git a/packages/db/test/unit/index-queries.test.js b/packages/db/test/unit/index-queries.test.js
index 8f32ac7fe..4b4722baa 100644
--- a/packages/db/test/unit/index-queries.test.js
+++ b/packages/db/test/unit/index-queries.test.js
@@ -1,5 +1,5 @@
-import { describe, it } from "node:test";
-import assert from "node:assert/strict";
+import assert from 'node:assert/strict';
+import { describe, it } from 'node:test';
import { getTableChangeQueries } from '../../dist/core/cli/migration-queries.js';
import { dbConfigSchema, tableSchema } from '../../dist/core/schemas.js';
import { column } from '../../dist/runtime/virtual.js';
@@ -76,7 +76,7 @@ describe('index queries', () => {
newTable: final.tables.user,
});
- assert.equal(queries.length, 0)
+ assert.equal(queries.length, 0);
});
it('does not trigger queries when changing from legacy to new format', async () => {
@@ -110,7 +110,7 @@ describe('index queries', () => {
newTable: final.tables.user,
});
- assert.equal(queries.length, 0)
+ assert.equal(queries.length, 0);
});
it('adds indexes', async () => {
diff --git a/packages/db/test/unit/reference-queries.test.js b/packages/db/test/unit/reference-queries.test.js
index 1660922a1..791344146 100644
--- a/packages/db/test/unit/reference-queries.test.js
+++ b/packages/db/test/unit/reference-queries.test.js
@@ -1,5 +1,5 @@
-import { describe, it } from "node:test";
-import assert from "node:assert/strict";
+import assert from 'node:assert/strict';
+import { describe, it } from 'node:test';
import { getTableChangeQueries } from '../../dist/core/cli/migration-queries.js';
import { tablesSchema } from '../../dist/core/schemas.js';
import { column, defineTable } from '../../dist/runtime/virtual.js';
@@ -61,7 +61,7 @@ describe('reference queries', () => {
assert.equal(queries[0] !== undefined, true);
const tempTableName = getTempTableName(queries[0]);
- assert.notEqual(typeof tempTableName, "undefined");
+ assert.notEqual(typeof tempTableName, 'undefined');
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)`,
@@ -86,7 +86,7 @@ describe('reference queries', () => {
assert.equal(queries[0] !== undefined, true);
const tempTableName = getTempTableName(queries[0]);
- assert.notEqual(typeof tempTableName, "undefined");
+ assert.notEqual(typeof tempTableName, 'undefined');
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)`,
@@ -149,13 +149,15 @@ describe('reference queries', () => {
const addedForeignKey = await userChangeQueries(InitialWithoutFK, Final);
const updatedForeignKey = await userChangeQueries(InitialWithDifferentFK, Final);
- assert.notEqual(typeof addedForeignKey.queries[0], "undefined");
- assert.notEqual(typeof updatedForeignKey.queries[0], "undefined");
- assert.deepEqual(addedForeignKey.queries,
+ assert.notEqual(typeof addedForeignKey.queries[0], 'undefined');
+ assert.notEqual(typeof updatedForeignKey.queries[0], 'undefined');
+ assert.deepEqual(
+ addedForeignKey.queries,
expected(getTempTableName(addedForeignKey.queries[0]))
);
- assert.deepEqual(updatedForeignKey.queries,
+ assert.deepEqual(
+ updatedForeignKey.queries,
expected(getTempTableName(updatedForeignKey.queries[0]))
);
});
diff --git a/packages/db/test/unit/reset-queries.test.js b/packages/db/test/unit/reset-queries.test.js
index ac77cf695..13da6ac91 100644
--- a/packages/db/test/unit/reset-queries.test.js
+++ b/packages/db/test/unit/reset-queries.test.js
@@ -1,5 +1,5 @@
-import { describe, it } from "node:test";
-import assert from "node:assert/strict";
+import assert from 'node:assert/strict';
+import { describe, it } from 'node:test';
import { getMigrationQueries } from '../../dist/core/cli/migration-queries.js';
import { MIGRATION_VERSION } from '../../dist/core/consts.js';
import { tableSchema } from '../../dist/core/schemas.js';
generated by cgit v1.2.3 (git 2.46.0) at 2025-08-11 12:29:53 +0000