Kysely•17mo ago

Unions in a loop

I'm trying to do a UnionAll in a loop. My issue is I don't know how to initialise the query:

    let query = ...// ???

    labels.forEach( label => {
        let codes = get_codes(label);
        query = query.unionAll(
            db.selectFrom("data")
            .select(eb => [
                eb.val(label).as('label'),
                'data.product',
                'data.period',
            ])
            .where("codes", "in", codes)
        );
    })

    return await query.execute()

    let query = ...// ???

    labels.forEach( label => {
        let codes = get_codes(label);
        query = query.unionAll(
            db.selectFrom("data")
            .select(eb => [
                eb.val(label).as('label'),
                'data.product',
                'data.period',
            ])
            .where("codes", "in", codes)
        );
    })

    return await query.execute()