textYash Posts - Answer Overflow

textYash

Explore posts from servers

•Created by textYash on 4/11/2024 in #help

How to call a method based on a condition?

I am running two almost similar queries based on a condition. In one of the condition I'm calling the where method and in the other one I'm not. How can I reduce duplicacy by having just one query that works for both conditions? Basically calling the where method only if a condition holds.

if (id === -1)
    chunk = await db
        .select({
            id: posts.id,
            content: posts.content,
        })
        .from(posts)
        .orderBy(desc(posts.id))
        .limit(6);
else
    chunk = await db
        .select({
            id: posts.id,
            content: posts.content,
        })
        .from(posts)
        .where(lt(posts.id, id) && eq(posts.hidden, hidden))
        .orderBy(desc(posts.id))
        .limit(6);

if (id === -1)
    chunk = await db
        .select({
            id: posts.id,
            content: posts.content,
        })
        .from(posts)
        .orderBy(desc(posts.id))
        .limit(6);
else
    chunk = await db
        .select({
            id: posts.id,
            content: posts.content,
        })
        .from(posts)
        .where(lt(posts.id, id) && eq(posts.hidden, hidden))
        .orderBy(desc(posts.id))
        .limit(6);

4 replies

Gaming

Programming