Drizzle Team•2y ago

Dynamic where query

With a relational query, is there a way to change the where query based on user input? In Knex.js, we could do something like this:

knex('questions')
    .select('question', 'correct', 'incorrect')
    .modify(function(queryBuilder) {
        if (req.query.param) {
            queryBuilder.where('somecolumn', req.query.param);
        }
    });

knex('questions')
    .select('question', 'correct', 'incorrect')
    .modify(function(queryBuilder) {
        if (req.query.param) {
            queryBuilder.where('somecolumn', req.query.param);
        }
    });

3 Replies

mr_pablo•2y ago

Perhaps map the query params to a variable, then implement the logic, adding to the params object, then call the query with the params variable name psuedo code

const params = {...query pararms}

if (something if true) {
params.where = ...
}

db.query.findMany(params)

const params = {...query pararms}

if (something if true) {
params.where = ...
}

db.query.findMany(params)

Maston•2y ago

just do something like this idk

db.query.table.findFirst({
    where: (table, { eq }) => {
        if (condition) {
            return eq(...);
        }
        return eq(...);
    },
});

db.query.table.findFirst({
    where: (table, { eq }) => {
        if (condition) {
            return eq(...);
        }
        return eq(...);
    },
});

Andrii Sherman•2y ago

https://discord.com/channels/1043890932593987624/1109091751341342820/1109095820827037737 This should help you

Gaming

Programming

Dynamic where query