Kysely•2y ago

Transform Postgres array into JS array

Hey, I was wondering if there's a helper or something to transform Postgres arrays {one, two} into JS arrays ['one', 'two']. Right I know the Postgres array is turned into a string when executing queries

Solution:

Message Not Public

Jump to solution

13 Replies

Unknown User•2y ago

Message Not Public

Daniel CruzOP•2y ago

I'm getting a string. Maybe is the fact that my column type is an enum array?

Unknown User•2y ago

Message Not Public

Daniel CruzOP•2y ago

Unknown User•2y ago

Message Not Public

Daniel CruzOP•2y ago

Seems I have to add a parser https://github.com/brianc/node-pg-types/issues/56#issuecomment-323223477

GitHub

ENUM ARRAY types get parsed as single string · Issue #56 · brianc/n...

Hi, I found that currently there is an issue with the way pg-types parses ENUM ARRAY column types. Currently the array is not parsed at all and a simple string is returned with the SQL array serial...

Daniel CruzOP•2y ago

do you know how can I define the custom types with Kysely? 😅

Unknown User•2y ago

Message Not Public

Daniel CruzOP•2y ago

Yep, I ended up doing

...
.selectAll("Collection")
.select((eb) => [
  sql<string[]>`categories::text[]`.as("categories"),
...

...
.selectAll("Collection")
.select((eb) => [
  sql<string[]>`categories::text[]`.as("categories"),
...

As using oid seems brittle, for any reason the id could change between dev and prod

koskimas•2y ago

As using oid seems brittle, for any reason the id could change between dev and prod

You mean the data type oid in setTypeParser? ~~It won't change~~ Actually with custom types, I'm not so sure

Daniel CruzOP•2y ago

Yeah, the custom type oid was different in my local db and prod db, idk why 🤷‍♂️ but better not to risk it

Igal•2y ago

This can be more type-safe:

.select((eb) => sql<string[]>`${eb.ref('categories')}::text[]`.as('categories'))

.select((eb) => sql<string[]>`${eb.ref('categories')}::text[]`.as('categories'))

Daniel CruzOP•2y ago

You're the best

Gaming

Programming

Transform Postgres array into JS array