Skip to content

use pg repository

use pg repository #245

Triggered via pull request October 9, 2024 09:12
Status Failure
Total duration 1m 25s
Artifacts

ci.yaml

on: pull_request
Check if version upgrade
0s
Check if version upgrade
Create version tag
0s
Create version tag
pre-release
0s
pre-release
Poke gitops
0s
Poke gitops
Trigger production deploy
0s
Trigger production deploy
Create release notes
0s
Create release notes
Fit to window
Zoom out
Zoom in

Annotations

5 errors
validations
api#test: command (/home/runner/work/sill/sill/api) /tmp/yarn--1728465202222-0.7984075335968019/yarn run test exited (1)
src/core/adapters/fetchExternalData.test.ts > fetches software extra data (from different providers) > does nothing if the software is not found: node_modules/kysely/dist/esm/dialect/postgres/postgres-driver.js#L73
error: duplicate key value violates unique constraint "softwares_pkey" ❯ ../node_modules/pg/lib/client.js:526:17 ❯ PostgresConnection.executeQuery ../node_modules/kysely/dist/esm/dialect/postgres/postgres-driver.js:73:28 ❯ ../node_modules/kysely/dist/esm/query-executor/query-executor-base.js:38:28 ❯ DefaultConnectionProvider.provideConnection ../node_modules/kysely/dist/esm/driver/default-connection-provider.js:10:20 ❯ DefaultQueryExecutor.executeQuery ../node_modules/kysely/dist/esm/query-executor/query-executor-base.js:37:16 ❯ insertApacheWithCorrectId src/core/adapters/fetchExternalData.test.ts:37:5 ❯ src/core/adapters/fetchExternalData.test.ts:87:9 ❯ PostgresConnection.executeQuery ../node_modules/kysely/dist/esm/dialect/postgres/postgres-driver.js:93:63 ❯ ../node_modules/kysely/dist/esm/query-executor/query-executor-base.js:38:28 ❯ DefaultConnectionProvider.provideConnection ../node_modules/kysely/dist/esm/driver/default-connection-provider.js:10:20 ❯ DefaultQueryExecutor.executeQuery ../node_modules/kysely/dist/esm/query-executor/query-executor-base.js:37:16 ❯ insertApacheWithCorrectId src/core/adapters/fetchExternalData.test.ts:37:5 ❯ src/core/adapters/fetchExternalData.test.ts:87:9 ⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯ Serialized Error: { length: 192, severity: 'ERROR', code: '23505', detail: 'Key (id)=(6) already exists.', hint: undefined, position: undefined, internalPosition: undefined, internalQuery: undefined, where: undefined, schema: 'public', table: 'softwares', column: undefined, dataType: undefined, constraint: 'softwares_pkey', file: 'nbtinsert.c', line: '666', routine: '_bt_check_unique' }
src/core/adapters/fetchExternalData.test.ts > fetches software extra data (from different providers) > gets software external data and saves it, and does not save other extra data if there is nothing relevant: node_modules/kysely/dist/esm/dialect/postgres/postgres-driver.js#L73
error: insert or update on table "compiled_softwares" violates foreign key constraint "compiled_softwares_softwareId_fkey" ❯ ../node_modules/pg/lib/client.js:526:17 ❯ PostgresConnection.executeQuery ../node_modules/kysely/dist/esm/dialect/postgres/postgres-driver.js:73:28 ❯ ../node_modules/kysely/dist/esm/query-executor/query-executor-base.js:38:28 ❯ DefaultConnectionProvider.provideConnection ../node_modules/kysely/dist/esm/driver/default-connection-provider.js:10:20 ❯ DefaultQueryExecutor.executeQuery ../node_modules/kysely/dist/esm/query-executor/query-executor-base.js:37:16 ❯ InsertQueryBuilder.execute ../node_modules/kysely/dist/esm/query-builder/insert-query-builder.js:795:24 ❯ InsertQueryBuilder.executeTakeFirst ../node_modules/kysely/dist/esm/query-builder/insert-query-builder.js:813:26 ❯ Object.save src/core/adapters/dbApi/kysely/createPgOtherSoftwareExtraDataRepositiory.ts:21:9 ❯ src/core/adapters/fetchExternalData.ts:53:40 ❯ PostgresConnection.executeQuery ../node_modules/kysely/dist/esm/dialect/postgres/postgres-driver.js:93:63 ❯ ../node_modules/kysely/dist/esm/query-executor/query-executor-base.js:38:28 ❯ DefaultConnectionProvider.provideConnection ../node_modules/kysely/dist/esm/driver/default-connection-provider.js:10:20 ❯ DefaultQueryExecutor.executeQuery ../node_modules/kysely/dist/esm/query-executor/query-executor-base.js:37:16 ❯ InsertQueryBuilder.execute ../node_modules/kysely/dist/esm/query-builder/insert-query-builder.js:795:24 ❯ InsertQueryBuilder.executeTakeFirst ../node_modules/kysely/dist/esm/query-builder/insert-query-builder.js:813:26 ❯ Object.save src/core/adapters/dbApi/kysely/createPgOtherSoftwareExtraDataRepositiory.ts:21:9 ❯ src/core/adapters/fetchExternalData.ts:53:40 ❯ it.timeout src/core/adapters/fetchExternalData.test.ts:119:13 ⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯ Serialized Error: { length: 307, severity: 'ERROR', code: '23503', detail: 'Key (softwareId)=(7) is not present in table "softwares".', hint: undefined, position: undefined, internalPosition: undefined, internalQuery: undefined, where: undefined, schema: 'public', table: 'compiled_softwares', column: undefined, dataType: undefined, constraint: 'compiled_softwares_softwareId_fkey', file: 'ri_triggers.c', line: '2608', routine: 'ri_ReportViolation' }
src/core/adapters/hal/getHalSoftware.test.ts > HAL > getHalSoftware > gets data from Hal and converts it to ExternalSoftware: api/src/tools/test.helpers.ts#L12
AssertionError: expected { externalId: '1715545', …(11) } to deeply equal { description: { en: '-' }, …(11) } - Expected + Received Object { "description": Object { "en": "-", + "fr": undefined, }, "developers": Array [ Object { "id": "gruenpeter,-morane", "name": "Gruenpeter, Morane", }, ], - "documentationUrl": "https://inria.hal.science/hal-01715545", + "documentationUrl": "https://inria.hal.science/hal-01715545v1", "externalDataOrigin": "HAL", "externalId": "1715545", "framaLibreId": "", "isLibreSoftware": true, "label": Object { "en": "Battleship exercise", "fr": "Battleship exercise", }, "license": "MIT License", "logoUrl": "", "sourceUrl": "https://github.com/moranegg/Battleship", "websiteUrl": "https://inria.hal.science/hal-01715545", } ❯ Module.expectToEqual src/tools/test.helpers.ts:12:20 ❯ src/core/adapters/hal/getHalSoftware.test.ts:13:13
validations
Process completed with exit code 1.