Skip to content
CI - CD

implement postgres adapter #197

Sign in to view logs

implement postgres adapter

implement postgres adapter #197

Triggered via pull request July 26, 2024 10:32
@JeromeBuJeromeBu
synchronize #122
implement-postgres-adapter
Status Failure
Total duration 1m 20s
Artifacts –

ci.yaml

on: pull_request
validations
1m 9s
validations
Check if version upgrade
0s
Check if version upgrade
Create version tag
0s
Create version tag
pre-release
0s
pre-release
docker
0s
docker
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

8 errors
validations
api#test: command (/home/runner/work/sill/sill/api) /tmp/yarn--1721990023286-0.4302966144084279/yarn run test exited (1)
src/core/adapters/dbApi/kysely/pgDbApi.integration.test.ts > pgDbApi > getCompiledDataPrivate > gets private compiled data: node_modules/kysely/dist/esm/dialect/postgres/postgres-driver.js#L73
error: relation "software_referents" does not exist ❯ ../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 ❯ DeleteQueryBuilder.execute ../node_modules/kysely/dist/esm/query-builder/delete-query-builder.js:477:24 ❯ src/core/adapters/dbApi/kysely/pgDbApi.integration.test.ts:80: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 ❯ DeleteQueryBuilder.execute ../node_modules/kysely/dist/esm/query-builder/delete-query-builder.js:477:24 ❯ src/core/adapters/dbApi/kysely/pgDbApi.integration.test.ts:80:9 ⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯ Serialized Error: { length: 117, severity: 'ERROR', code: '42P01', detail: undefined, hint: undefined, position: '13', internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, column: undefined, dataType: undefined, constraint: undefined, file: 'parse_relation.c', line: '1449', routine: 'parserOpenTable' }
src/core/adapters/dbApi/kysely/pgDbApi.integration.test.ts > pgDbApi > software > creates a software, than gets it with getAll: node_modules/kysely/dist/esm/dialect/postgres/postgres-driver.js#L73
error: relation "software_referents" does not exist ❯ ../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 ❯ DeleteQueryBuilder.execute ../node_modules/kysely/dist/esm/query-builder/delete-query-builder.js:477:24 ❯ src/core/adapters/dbApi/kysely/pgDbApi.integration.test.ts:80: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 ❯ DeleteQueryBuilder.execute ../node_modules/kysely/dist/esm/query-builder/delete-query-builder.js:477:24 ❯ src/core/adapters/dbApi/kysely/pgDbApi.integration.test.ts:80:9 ⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯ Serialized Error: { length: 117, severity: 'ERROR', code: '42P01', detail: undefined, hint: undefined, position: '13', internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, column: undefined, dataType: undefined, constraint: undefined, file: 'parse_relation.c', line: '1449', routine: 'parserOpenTable' }
src/core/adapters/dbApi/kysely/pgDbApi.integration.test.ts > pgDbApi > instance > creates an instance, than gets it with getAll: node_modules/kysely/dist/esm/dialect/postgres/postgres-driver.js#L73
error: relation "software_referents" does not exist ❯ ../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 ❯ DeleteQueryBuilder.execute ../node_modules/kysely/dist/esm/query-builder/delete-query-builder.js:477:24 ❯ src/core/adapters/dbApi/kysely/pgDbApi.integration.test.ts:80: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 ❯ DeleteQueryBuilder.execute ../node_modules/kysely/dist/esm/query-builder/delete-query-builder.js:477:24 ❯ src/core/adapters/dbApi/kysely/pgDbApi.integration.test.ts:80:9 ⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯ Serialized Error: { length: 117, severity: 'ERROR', code: '42P01', detail: undefined, hint: undefined, position: '13', internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, column: undefined, dataType: undefined, constraint: undefined, file: 'parse_relation.c', line: '1449', routine: 'parserOpenTable' }
src/core/adapters/dbApi/kysely/pgDbApi.integration.test.ts > pgDbApi > agents > adds an agent, get it by email, updates it, getAll: node_modules/kysely/dist/esm/dialect/postgres/postgres-driver.js#L73
error: relation "software_referents" does not exist ❯ ../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 ❯ DeleteQueryBuilder.execute ../node_modules/kysely/dist/esm/query-builder/delete-query-builder.js:477:24 ❯ src/core/adapters/dbApi/kysely/pgDbApi.integration.test.ts:80: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 ❯ DeleteQueryBuilder.execute ../node_modules/kysely/dist/esm/query-builder/delete-query-builder.js:477:24 ❯ src/core/adapters/dbApi/kysely/pgDbApi.integration.test.ts:80:9 ⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯ Serialized Error: { length: 117, severity: 'ERROR', code: '42P01', detail: undefined, hint: undefined, position: '13', internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, column: undefined, dataType: undefined, constraint: undefined, file: 'parse_relation.c', line: '1449', routine: 'parserOpenTable' }
src/core/adapters/dbApi/kysely/pgDbApi.integration.test.ts > pgDbApi > users and referents > cannot add a user or referent if the software or agent is missing in db: node_modules/kysely/dist/esm/dialect/postgres/postgres-driver.js#L73
error: relation "software_referents" does not exist ❯ ../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 ❯ DeleteQueryBuilder.execute ../node_modules/kysely/dist/esm/query-builder/delete-query-builder.js:477:24 ❯ src/core/adapters/dbApi/kysely/pgDbApi.integration.test.ts:80: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 ❯ DeleteQueryBuilder.execute ../node_modules/kysely/dist/esm/query-builder/delete-query-builder.js:477:24 ❯ src/core/adapters/dbApi/kysely/pgDbApi.integration.test.ts:80:9 ⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯ Serialized Error: { length: 117, severity: 'ERROR', code: '42P01', detail: undefined, hint: undefined, position: '13', internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, column: undefined, dataType: undefined, constraint: undefined, file: 'parse_relation.c', line: '1449', routine: 'parserOpenTable' }
src/core/adapters/dbApi/kysely/pgDbApi.integration.test.ts > pgDbApi > users and referents > adds the user or referent correctly, than removes them: node_modules/kysely/dist/esm/dialect/postgres/postgres-driver.js#L73
error: relation "software_referents" does not exist ❯ ../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 ❯ DeleteQueryBuilder.execute ../node_modules/kysely/dist/esm/query-builder/delete-query-builder.js:477:24 ❯ src/core/adapters/dbApi/kysely/pgDbApi.integration.test.ts:80: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 ❯ DeleteQueryBuilder.execute ../node_modules/kysely/dist/esm/query-builder/delete-query-builder.js:477:24 ❯ src/core/adapters/dbApi/kysely/pgDbApi.integration.test.ts:80:9 ⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯ Serialized Error: { length: 117, severity: 'ERROR', code: '42P01', detail: undefined, hint: undefined, position: '13', internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, column: undefined, dataType: undefined, constraint: undefined, file: 'parse_relation.c', line: '1449', routine: 'parserOpenTable' }
validations
Process completed with exit code 1.