K
Kysely•15mo ago
ohmi

.where('x', 'is not', null) and correspond type's nullability

Not sure if this even possible in typescript (although all of the work Kysely already makes it seem magical). But let's say we have a column 'x' that has type string | null. Is it possible to write a query that ends up resulting in a final type of string after using .where('x', 'is not', null) or any similar method?
Solution:
Message Not Public
Sign In & Join Server To View
Jump to solution
7 Replies
Solution
Unknown User
Unknown User•15mo ago
Message Not Public
Sign In & Join Server To View
ohmi
ohmi•15mo ago
but in theory, it would be possible?
Unknown User
Unknown User•15mo ago
Message Not Public
Sign In & Join Server To View
ohmi
ohmi•15mo ago
magic awesome, thanks again
ohmi
ohmi•15mo ago
what part of the instance should i be calling it on? did a quick search of this channel, and the docs but didnt see any examples
ohmi
ohmi•15mo ago
ah not in the most recent npm release?
Igal
Igal•15mo ago
Sorry, my bad, this is release pending
Want results from more Discord servers?
Add your server
More Posts
What is the suggested way of adding/removing methods to expression builders?Context: I am building a custom dialect for YDB https://github.com/Gaspero/kysely-ydb YDB is slightlRunning database agnostic queries (MySQL)As part of my test suite, I drop/create databases programmatically. Is it possible to have a Kysely Asserting type of .countAll() (MySQL)I've noticed that the return type from the result of aggregation functions like `countAll()` and `suCoalesce return empty arrayHey is there a way to return an empty array rather than `null` when an array column is empty? I alrkysely-codegen for multiple databasesI have two MySQL 'databases' within the same instance. From the documentation, it doesn't look like Using MySQL functions in SELECT statementHi! Just trying to migrate over from Knex. Skimmed over the documentation but still unsure of how tExtract OrderBy TS KeysHey I have the following query ```ts const getBaseQuery = ({ offset, pageSize, slug }: GetBaseQuerinsert into with mix of static and table valuesHow might I execute an insert into that combines JS-side values with a select, like: ``` INSERT INTOMigration error "TypeError: Cannot read properties of undefined (reading 'getExecutor')"I am trying to run a migration using Kysely, and its returning this error: ``` file:///Users/brunocrwhere clause with lengthHow do I have a where clause with a length, e.g. `select * from data where length(prodcode) = 3`