Skip to content

Implement the standard IO library and features for the Stitches app #22

Implement the standard IO library and features for the Stitches app

Implement the standard IO library and features for the Stitches app #22

Triggered via pull request November 11, 2024 13:06
@calebpitancalebpitan
synchronize #1
feat/io
Status Failure
Total duration 1m 10s
Artifacts

ci.yml

on: pull_request
Fit to window
Zoom out
Zoom in

Annotations

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