thelinuxlich Posts - Answer Overflow

thelinuxlich

Explore posts from servers

CDCloudflare Developers RRailway KKysely

Posts Comments

KKysely

•Created by thelinuxlich on 9/20/2024 in #help

eb.fn.coalesce on a subquery

Is it possible somehow?

6 replies

KKysely

•Created by thelinuxlich on 12/14/2023 in #help

CASE with subquery clause

How can I return the column value from the subquery in a CASE? With this example, Kysely thinks the second condition is { name: string }:

eb.case()
.when('re.type', '=', 'company')
.then(eb.ref('cd.name'))
.else(
    eb
        .selectFrom('rise.companies_data as cd')
        .select(['cd.name'])
        .where(
            'cd.riseid',
            '=',
            eb.selectFrom('rise.rise_entities as re2')
                .select(['re2.parent_riseid'])
                .where('re2.type', '=', 'team')
                .whereRef('re2.riseid', '=', 're.riseid'),
            ),
    )
    .end()
    .as('company_name')

eb.case()
.when('re.type', '=', 'company')
.then(eb.ref('cd.name'))
.else(
    eb
        .selectFrom('rise.companies_data as cd')
        .select(['cd.name'])
        .where(
            'cd.riseid',
            '=',
            eb.selectFrom('rise.rise_entities as re2')
                .select(['re2.parent_riseid'])
                .where('re2.type', '=', 'team')
                .whereRef('re2.riseid', '=', 're.riseid'),
            ),
    )
    .end()
    .as('company_name')

13 replies

KKysely

•Created by thelinuxlich on 10/19/2023 in #help

How do I create a helper to be used on a select array of fields?

I want to create a toBool helper to convert from tinyint, however I'm lost on the type I need to pass to get autocomplete of the possible fields in the select

import { sql } from 'kysely'

export const toBool = (
  field: string // what type should I add here?
) => {
  return sql<boolean>`IF(${field} > 0, true, false)`
}

import { sql } from 'kysely'

export const toBool = (
  field: string // what type should I add here?
) => {
  return sql<boolean>`IF(${field} > 0, true, false)`
}