Option filter parameters

Hi! Love using drizzle so far! Had a quick question (not a bug):

  const res = await ctx.database
    .select()
    .from(worker)
    .where(
      and(
        eq(worker.locationUid, input.location),
        isNull(worker.deletedAt),
        ilike(worker.name, "%{input.name}%")
      )
    )

  const res = await ctx.database
    .select()
    .from(worker)
    .where(
      and(
        eq(worker.locationUid, input.location),
        isNull(worker.deletedAt),
        ilike(worker.name, "%{input.name}%")
      )
    )

  const res = await ctx.database
    .select()
    .from(worker)
    .where(
      and(
        eq(worker.locationUid, input.location),
        isNull(worker.deletedAt),
        ilike(worker.name, "%{input.name}%")
      )
    )

  const res = await ctx.database
    .select()
    .from(worker)
    .where(
      and(
        eq(worker.locationUid, input.location),
        isNull(worker.deletedAt),
        ilike(worker.name, "%{input.name}%")
      )
    )

If I have a query like this, and

input.name

input.name

input.name

input.name might be

null

null

(in which case I want to skip filtering by this), is there a short-hand for enabling that behavior? Right now I'm putting filters into an array like:

[..., input.name && ilike(worker.name, "%{input.name}%) : null].filter(v => v)

[..., input.name && ilike(worker.name, "%{input.name}%) : null].filter(v => v)

[..., input.name && ilike(worker.name, "%{input.name}%) : null].filter(v => v)

[..., input.name && ilike(worker.name, "%{input.name}%) : null].filter(v => v)

which is fine, just wondering if this is a good approach. thanks!

Andrii Sherman•5/24/23, 6:25 PM

Hi!

Andrii Sherman•5/24/23, 6:25 PM

here you go

Andrii Sherman•5/24/23, 6:25 PM

Conditional logic within template strings not supported on raw MySQL query

Andrii Sherman•5/24/23, 6:25 PM

just small example I did for another thread

Andrii Sherman•5/24/23, 6:25 PM

but should work well for you

Andrii Sherman•5/24/23, 6:26 PM

we will also add this case to docs

Andrii Sherman•5/24/23, 6:26 PM

will work on examples section for different cases like this one

Andrii Sherman•5/24/23, 6:26 PM

all you need from this examples is that filter statements can be grouped in array

Andrii Sherman•5/24/23, 6:27 PM

and then used like this

.where(and(...filters))

.where(and(...filters))

scout_capOP•5/24/23, 7:06 PM

great thanks, looks good

Option filter parameters

Similar Threads

Similar Threads

Similar Threads