Blitz Posts - Answer Overflow

Blitz

Explore posts from servers

•Created by Blitz on 10/9/2024 in #help

mapping data inside select function

Hi. Is there no other way to map data with nested object with select() function other than array.reduce? I would like to do it using the query, not JS as the amount of data can be big and take a long time. For now I am doing this by writing a big query using sql function in execute() but then I don't get real TS support for my types and I feel uncertain about possible bugs.

1 replies

DTDrizzle Team

•Created by Blitz on 1/8/2024 in #help

Migrations problem

Hi! I'm trying to perform migration in my app. Drizzle-kit doesn't connect to my postgres that is working on docker. My migrate() function is however working partially. It connects but before doing any meaningful work it drops with error from postgres.

/home/blitz/kids-app/kids-app-nest/node_modules/postgres/cjs/src/connection.js:790
    const error = Errors.postgres(parseError(x))
                         ^
PostgresError: syntax error at or near "on"
    at ErrorResponse (/home/blitz/kids-app/kids-app-nest/node_modules/postgres/cjs/src/connection.js:790:26)
    at handle (/home/blitz/kids-app/kids-app-nest/node_modules/postgres/cjs/src/connection.js:476:6)
    at Socket.data (/home/blitz/kids-app/kids-app-nest/node_modules/postgres/cjs/src/connection.js:315:9)
    at Socket.emit (node:events:514:28)
    at addChunk (node:internal/streams/readable:324:12)
    at readableAddChunk (node:internal/streams/readable:297:9)
    at Socket.Readable.push (node:internal/streams/readable:234:10)
    at TCP.onStreamRead (node:internal/stream_base_commons:190:23)

/home/blitz/kids-app/kids-app-nest/node_modules/postgres/cjs/src/connection.js:790
    const error = Errors.postgres(parseError(x))
                         ^
PostgresError: syntax error at or near "on"
    at ErrorResponse (/home/blitz/kids-app/kids-app-nest/node_modules/postgres/cjs/src/connection.js:790:26)
    at handle (/home/blitz/kids-app/kids-app-nest/node_modules/postgres/cjs/src/connection.js:476:6)
    at Socket.data (/home/blitz/kids-app/kids-app-nest/node_modules/postgres/cjs/src/connection.js:315:9)
    at Socket.emit (node:events:514:28)
    at addChunk (node:internal/streams/readable:324:12)
    at readableAddChunk (node:internal/streams/readable:297:9)
    at Socket.Readable.push (node:internal/streams/readable:234:10)
    at TCP.onStreamRead (node:internal/stream_base_commons:190:23)

3 replies

Gaming

Programming