yayza_ Comments - Answer Overflow

I recently came a cross this as well , when a property is numeric i have to cast it to text or it will change the value to a number and i lose precision price: sql<string>${eb.ref('product.price')}::TEXT,

10 replies

KKysely

•Created by yayza_ on 7/11/2024 in #help

How do I compare to a value in a jsonb column?

oh, my problem was that kysely-codegen doesn't support json columns yet, but i used the codegen and modified those manually now it works . thanks for the point in the right direction!

7 replies

KKysely

•Created by yayza_ on 7/11/2024 in #help

How do I compare to a value in a jsonb column?

oh okay, I just ran the codegen I didnt create the type myself for that column but i'll do that now 🙏

7 replies

KKysely

•Created by yayza_ on 7/11/2024 in #help

How do I compare to a value in a jsonb column?

7 replies

KKysely

•Created by yayza_ on 7/11/2024 in #help

How do I compare to a value in a jsonb column?

this works and it's based on what I read from hovering over ref() and reading the documentation:

// In the next example we use ref to reference a nested JSON property:

db.selectFrom('person')
  .where(({ eb, ref }) => eb(
    ref('address', '->').key('state').key('abbr'),
    '=',
    'CA'
  ))
  .selectAll()

// In the next example we use ref to reference a nested JSON property:

db.selectFrom('person')
  .where(({ eb, ref }) => eb(
    ref('address', '->').key('state').key('abbr'),
    '=',
    'CA'
  ))
  .selectAll()

The only problem is that I have to use //@ts-ignore to bypass that error 😅 , which makes me assume I'm doing it wrong

7 replies

Gaming

Programming