doc: give a more elaborate description of project #25
calebpitanAnnotations
10 errors
|
tests/lib.test.ts > #open > #migrate > should run all migrations to keep the database up to date:
packages/io/src/migrator.ts#L55
DrizzleError: Failed to run the query 'CREATE TABLE `custom_frequencies` (`id` text PRIMARY KEY NOT NULL,`schedule_id` text NOT NULL,`type` text GENERATED ALWAYS AS (custom) VIRTUAL NOT NULL,`crons` text NOT NULL,`created_at` integer DEFAULT (strftime('%s', 'now') || substr(strftime('%f', 'now'), -3)) NOT NULL,`updated_at` integer DEFAULT (strftime('%s', 'now') || substr(strftime('%f', 'now'), -3)) NOT NULL,`deleted_at` integer,FOREIGN KEY (`schedule_id`) REFERENCES `schedules`(`id`) ON UPDATE no action ON DELETE cascade);'
❯ SQLJsSession.run ../../node_modules/src/sqlite-core/session.ts:148:10
❯ SQLJsTransaction.run ../../node_modules/src/sqlite-core/db.ts:533:23
❯ src/migrator.ts:55:42
❯ src/migrator.ts:55:21
❯ src/migrator.ts:51:16
❯ SQLJsSession.transaction ../../node_modules/src/sql-js/session.ts:79:19
❯ BaseSQLiteDatabase.transaction ../../node_modules/src/sqlite-core/db.ts:582:23
❯ Module.migrate src/migrator.ts:50:6
Caused by: Error: no such column: custom
❯ e.handleError ../../node_modules/sql.js/dist/sql-wasm.js:90:254
❯ e.prepare ../../node_modules/sql.js/dist/sql-wasm.js:89:6
❯ SQLJsSession.prepareOneTimeQuery ../../node_modules/src/sql-js/session.ts:59:28
❯ SQLJsSession.run ../../node_modules/src/sqlite-core/session.ts:146:16
❯ SQLJsTransaction.run ../../node_modules/src/sqlite-core/db.ts:533:23
❯ src/migrator.ts:55:42
❯ src/migrator.ts:55:21
❯ src/migrator.ts:51:16
|
|
tests/lib.test.ts > #open > #migrate > should ensure migration history is saved and up to date with deployment:
packages/io/src/migrator.ts#L55
DrizzleError: Failed to run the query 'CREATE TABLE `custom_frequencies` (`id` text PRIMARY KEY NOT NULL,`schedule_id` text NOT NULL,`type` text GENERATED ALWAYS AS (custom) VIRTUAL NOT NULL,`crons` text NOT NULL,`created_at` integer DEFAULT (strftime('%s', 'now') || substr(strftime('%f', 'now'), -3)) NOT NULL,`updated_at` integer DEFAULT (strftime('%s', 'now') || substr(strftime('%f', 'now'), -3)) NOT NULL,`deleted_at` integer,FOREIGN KEY (`schedule_id`) REFERENCES `schedules`(`id`) ON UPDATE no action ON DELETE cascade);'
❯ SQLJsSession.run ../../node_modules/src/sqlite-core/session.ts:148:10
❯ SQLJsTransaction.run ../../node_modules/src/sqlite-core/db.ts:533:23
❯ src/migrator.ts:55:42
❯ src/migrator.ts:55:21
❯ src/migrator.ts:51:16
❯ SQLJsSession.transaction ../../node_modules/src/sql-js/session.ts:79:19
❯ BaseSQLiteDatabase.transaction ../../node_modules/src/sqlite-core/db.ts:582:23
❯ Module.migrate src/migrator.ts:50:6
Caused by: Error: no such column: custom
❯ e.handleError ../../node_modules/sql.js/dist/sql-wasm.js:90:254
❯ e.prepare ../../node_modules/sql.js/dist/sql-wasm.js:89:6
❯ SQLJsSession.prepareOneTimeQuery ../../node_modules/src/sql-js/session.ts:59:28
❯ SQLJsSession.run ../../node_modules/src/sqlite-core/session.ts:146:16
❯ SQLJsTransaction.run ../../node_modules/src/sqlite-core/db.ts:533:23
❯ src/migrator.ts:55:42
❯ src/migrator.ts:55:21
❯ src/migrator.ts:51:16
|
|
tests/lib.test.ts > #open > #migrate > should ensure the database schemas are created:
packages/io/src/migrator.ts#L55
DrizzleError: Failed to run the query 'CREATE TABLE `custom_frequencies` (`id` text PRIMARY KEY NOT NULL,`schedule_id` text NOT NULL,`type` text GENERATED ALWAYS AS (custom) VIRTUAL NOT NULL,`crons` text NOT NULL,`created_at` integer DEFAULT (strftime('%s', 'now') || substr(strftime('%f', 'now'), -3)) NOT NULL,`updated_at` integer DEFAULT (strftime('%s', 'now') || substr(strftime('%f', 'now'), -3)) NOT NULL,`deleted_at` integer,FOREIGN KEY (`schedule_id`) REFERENCES `schedules`(`id`) ON UPDATE no action ON DELETE cascade);'
❯ SQLJsSession.run ../../node_modules/src/sqlite-core/session.ts:148:10
❯ SQLJsTransaction.run ../../node_modules/src/sqlite-core/db.ts:533:23
❯ src/migrator.ts:55:42
❯ src/migrator.ts:55:21
❯ src/migrator.ts:51:16
❯ SQLJsSession.transaction ../../node_modules/src/sql-js/session.ts:79:19
❯ BaseSQLiteDatabase.transaction ../../node_modules/src/sqlite-core/db.ts:582:23
❯ Module.migrate src/migrator.ts:50:6
Caused by: Error: no such column: custom
❯ e.handleError ../../node_modules/sql.js/dist/sql-wasm.js:90:254
❯ e.prepare ../../node_modules/sql.js/dist/sql-wasm.js:89:6
❯ SQLJsSession.prepareOneTimeQuery ../../node_modules/src/sql-js/session.ts:59:28
❯ SQLJsSession.run ../../node_modules/src/sqlite-core/session.ts:146:16
❯ SQLJsTransaction.run ../../node_modules/src/sqlite-core/db.ts:533:23
❯ src/migrator.ts:55:42
❯ src/migrator.ts:55:21
❯ src/migrator.ts:51:16
|
|
tests/repository/tasks.test.ts > #TaskRepository > should construct a new `TaskRepository` object:
packages/io/src/migrator.ts#L55
DrizzleError: Failed to run the query 'CREATE TABLE `custom_frequencies` (`id` text PRIMARY KEY NOT NULL,`schedule_id` text NOT NULL,`type` text GENERATED ALWAYS AS (custom) VIRTUAL NOT NULL,`crons` text NOT NULL,`created_at` integer DEFAULT (strftime('%s', 'now') || substr(strftime('%f', 'now'), -3)) NOT NULL,`updated_at` integer DEFAULT (strftime('%s', 'now') || substr(strftime('%f', 'now'), -3)) NOT NULL,`deleted_at` integer,FOREIGN KEY (`schedule_id`) REFERENCES `schedules`(`id`) ON UPDATE no action ON DELETE cascade);'
❯ SQLJsSession.run ../../node_modules/src/sqlite-core/session.ts:148:10
❯ SQLJsTransaction.run ../../node_modules/src/sqlite-core/db.ts:533:23
❯ src/migrator.ts:55:42
❯ src/migrator.ts:55:21
❯ src/migrator.ts:51:16
❯ SQLJsSession.transaction ../../node_modules/src/sql-js/session.ts:79:19
❯ BaseSQLiteDatabase.transaction ../../node_modules/src/sqlite-core/db.ts:582:23
❯ Module.migrate src/migrator.ts:50:6
Caused by: Error: no such column: custom
❯ e.handleError ../../node_modules/sql.js/dist/sql-wasm.js:90:254
❯ e.prepare ../../node_modules/sql.js/dist/sql-wasm.js:89:6
❯ SQLJsSession.prepareOneTimeQuery ../../node_modules/src/sql-js/session.ts:59:28
❯ SQLJsSession.run ../../node_modules/src/sqlite-core/session.ts:146:16
❯ SQLJsTransaction.run ../../node_modules/src/sqlite-core/db.ts:533:23
❯ src/migrator.ts:55:42
❯ src/migrator.ts:55:21
❯ src/migrator.ts:51:16
|
|
tests/repository/tasks.test.ts > #TaskRepository > should construct a new `TaskRepository` object:
packages/io/tests/repository/tasks.test.ts#L27
TypeError: Cannot read properties of undefined (reading 'close')
❯ tests/repository/tasks.test.ts:27:24
|
|
tests/repository/tasks.test.ts > #TaskRepository > #findMany > should find as many tasks:
packages/io/src/migrator.ts#L55
DrizzleError: Failed to run the query 'CREATE TABLE `custom_frequencies` (`id` text PRIMARY KEY NOT NULL,`schedule_id` text NOT NULL,`type` text GENERATED ALWAYS AS (custom) VIRTUAL NOT NULL,`crons` text NOT NULL,`created_at` integer DEFAULT (strftime('%s', 'now') || substr(strftime('%f', 'now'), -3)) NOT NULL,`updated_at` integer DEFAULT (strftime('%s', 'now') || substr(strftime('%f', 'now'), -3)) NOT NULL,`deleted_at` integer,FOREIGN KEY (`schedule_id`) REFERENCES `schedules`(`id`) ON UPDATE no action ON DELETE cascade);'
❯ SQLJsSession.run ../../node_modules/src/sqlite-core/session.ts:148:10
❯ SQLJsTransaction.run ../../node_modules/src/sqlite-core/db.ts:533:23
❯ src/migrator.ts:55:42
❯ src/migrator.ts:55:21
❯ src/migrator.ts:51:16
❯ SQLJsSession.transaction ../../node_modules/src/sql-js/session.ts:79:19
❯ BaseSQLiteDatabase.transaction ../../node_modules/src/sqlite-core/db.ts:582:23
❯ Module.migrate src/migrator.ts:50:6
Caused by: Error: no such column: custom
❯ e.handleError ../../node_modules/sql.js/dist/sql-wasm.js:90:254
❯ e.prepare ../../node_modules/sql.js/dist/sql-wasm.js:89:6
❯ SQLJsSession.prepareOneTimeQuery ../../node_modules/src/sql-js/session.ts:59:28
❯ SQLJsSession.run ../../node_modules/src/sqlite-core/session.ts:146:16
❯ SQLJsTransaction.run ../../node_modules/src/sqlite-core/db.ts:533:23
❯ src/migrator.ts:55:42
❯ src/migrator.ts:55:21
❯ src/migrator.ts:51:16
|
|
tests/repository/tasks.test.ts > #TaskRepository > #findMany > should find as many tasks:
packages/io/tests/repository/tasks.test.ts#L27
TypeError: Cannot read properties of undefined (reading 'close')
❯ tests/repository/tasks.test.ts:27:24
|
|
tests/repository/tasks.test.ts > #TaskRepository > #findMany > should omit redacted tasks:
packages/io/src/migrator.ts#L55
DrizzleError: Failed to run the query 'CREATE TABLE `custom_frequencies` (`id` text PRIMARY KEY NOT NULL,`schedule_id` text NOT NULL,`type` text GENERATED ALWAYS AS (custom) VIRTUAL NOT NULL,`crons` text NOT NULL,`created_at` integer DEFAULT (strftime('%s', 'now') || substr(strftime('%f', 'now'), -3)) NOT NULL,`updated_at` integer DEFAULT (strftime('%s', 'now') || substr(strftime('%f', 'now'), -3)) NOT NULL,`deleted_at` integer,FOREIGN KEY (`schedule_id`) REFERENCES `schedules`(`id`) ON UPDATE no action ON DELETE cascade);'
❯ SQLJsSession.run ../../node_modules/src/sqlite-core/session.ts:148:10
❯ SQLJsTransaction.run ../../node_modules/src/sqlite-core/db.ts:533:23
❯ src/migrator.ts:55:42
❯ src/migrator.ts:55:21
❯ src/migrator.ts:51:16
❯ SQLJsSession.transaction ../../node_modules/src/sql-js/session.ts:79:19
❯ BaseSQLiteDatabase.transaction ../../node_modules/src/sqlite-core/db.ts:582:23
❯ Module.migrate src/migrator.ts:50:6
Caused by: Error: no such column: custom
❯ e.handleError ../../node_modules/sql.js/dist/sql-wasm.js:90:254
❯ e.prepare ../../node_modules/sql.js/dist/sql-wasm.js:89:6
❯ SQLJsSession.prepareOneTimeQuery ../../node_modules/src/sql-js/session.ts:59:28
❯ SQLJsSession.run ../../node_modules/src/sqlite-core/session.ts:146:16
❯ SQLJsTransaction.run ../../node_modules/src/sqlite-core/db.ts:533:23
❯ src/migrator.ts:55:42
❯ src/migrator.ts:55:21
❯ src/migrator.ts:51:16
|
|
tests/repository/tasks.test.ts > #TaskRepository > #findMany > should omit redacted tasks:
packages/io/tests/repository/tasks.test.ts#L27
TypeError: Cannot read properties of undefined (reading 'close')
❯ tests/repository/tasks.test.ts:27:24
|
|
tests/repository/tasks.test.ts > #TaskRepository > #findById > should find a task by ID:
packages/io/src/migrator.ts#L55
DrizzleError: Failed to run the query 'CREATE TABLE `custom_frequencies` (`id` text PRIMARY KEY NOT NULL,`schedule_id` text NOT NULL,`type` text GENERATED ALWAYS AS (custom) VIRTUAL NOT NULL,`crons` text NOT NULL,`created_at` integer DEFAULT (strftime('%s', 'now') || substr(strftime('%f', 'now'), -3)) NOT NULL,`updated_at` integer DEFAULT (strftime('%s', 'now') || substr(strftime('%f', 'now'), -3)) NOT NULL,`deleted_at` integer,FOREIGN KEY (`schedule_id`) REFERENCES `schedules`(`id`) ON UPDATE no action ON DELETE cascade);'
❯ SQLJsSession.run ../../node_modules/src/sqlite-core/session.ts:148:10
❯ SQLJsTransaction.run ../../node_modules/src/sqlite-core/db.ts:533:23
❯ src/migrator.ts:55:42
❯ src/migrator.ts:55:21
❯ src/migrator.ts:51:16
❯ SQLJsSession.transaction ../../node_modules/src/sql-js/session.ts:79:19
❯ BaseSQLiteDatabase.transaction ../../node_modules/src/sqlite-core/db.ts:582:23
❯ Module.migrate src/migrator.ts:50:6
Caused by: Error: no such column: custom
❯ e.handleError ../../node_modules/sql.js/dist/sql-wasm.js:90:254
❯ e.prepare ../../node_modules/sql.js/dist/sql-wasm.js:89:6
❯ SQLJsSession.prepareOneTimeQuery ../../node_modules/src/sql-js/session.ts:59:28
❯ SQLJsSession.run ../../node_modules/src/sqlite-core/session.ts:146:16
❯ SQLJsTransaction.run ../../node_modules/src/sqlite-core/db.ts:533:23
❯ src/migrator.ts:55:42
❯ src/migrator.ts:55:21
❯ src/migrator.ts:51:16
|