Kysely•6mo ago

How to like left value to right raw statement?

Unsuccessful attempts: https://old.kyse.link/?p=s&i=RXSid8MMyDZRXfcl8Jdq Expected result:

SELECT *
FROM geography.postal_areas
WHERE $1 LIKE "postalCode" || '%';

SELECT *
FROM geography.postal_areas
WHERE $1 LIKE "postalCode" || '%';

13 Replies

Igal•6mo ago

Hey 👋 Here's a way of doing this:

  .where((eb) =>
    eb(
      eb.val("Paulee"),
      "like",
      eb("first_name", "||", sql.lit("%")),
    ),
  )

  .where((eb) =>
    eb(
      eb.val("Paulee"),
      "like",
      eb("first_name", "||", sql.lit("%")),
    ),
  )

https://kyse.link/4Tq7n

mikeOP•6mo ago

great! thank you very much

mikeOP•6mo ago

@Igal any idea why I get this?

Igal•6mo ago

What kysely version are you on?

mikeOP•6mo ago

❯ npm -v kysely >>> 8.19.2

Igal•6mo ago

that's npm version. try npm explain kysely

mikeOP•6mo ago

❯ npm explain kysely [email protected] node_modules/kysely kysely@"^0.25.0" from the root project

Igal•6mo ago

kysely's latest version is 0.27.3 For 0.25.0:

  .where((eb) =>
    eb.cmpr(
      eb.val("Paulee"),
      "like",
      eb.bxp("first_name", "||", sql.lit("%")),
    ),
  )

  .where((eb) =>
    eb.cmpr(
      eb.val("Paulee"),
      "like",
      eb.bxp("first_name", "||", sql.lit("%")),
    ),
  )

https://kyse.link/GKkwI

mikeOP•6mo ago

I installated the latest one and it works! thanks a lot @Igal however after upgrade to the latest version I get following error. I checked the release history and fixed multiple deprecated things but this one is hard to identify...

.where((eb) => 
  eb.or([ //  // Type 'RawBuilder<unknown>' is not assignable to type 'OperandExpression<SqlBool>'.  Property 'isSelectQueryBuilder' is missing in type 'RawBuilder<unknown>' but required in type 'SelectQueryBuilderExpression<Record<string, SqlBool>>'.
    sql`row-sql`, // when removing this line it's ok
    eb('column1', 'is', null),
  ])
)

.where((eb) => 
  eb.or([ //  // Type 'RawBuilder<unknown>' is not assignable to type 'OperandExpression<SqlBool>'.  Property 'isSelectQueryBuilder' is missing in type 'RawBuilder<unknown>' but required in type 'SelectQueryBuilderExpression<Record<string, SqlBool>>'.
    sql`row-sql`, // when removing this line it's ok
    eb('column1', 'is', null),
  ])
)

Igal•6mo ago

sql<SqlBool>`row-sql`,

sql<SqlBool>`row-sql`,

mikeOP•6mo ago

yeah, it fixed the issue. can you provide a link to a source explaining the SqlBool type and why/how to use it? I don't want to bother with stupid questions. I prefer to read docs and understand it.

koskimas•6mo ago

You don't need to use SqlBool. boolean is is just fine or 0|1 if you're on a dialect that doesn't have booleans. SqlBool is just boolean | 1 | 0 which is the union of each dialects' boolean types. If you know your dialect (as you always should with Kysely) you can use its boolean type

mikeOP•6mo ago

I am on psql dialect btw

Gaming

Programming

How to like left value to right raw statement?