DT
Drizzle Teamhunt

Help building queries based on multiple conditions from an array of objects

Hello, I'm having trouble formulating a query that will match rows to multiple conditions at the same time. Suppose I have an array of objects like : 
const arr = [ 
    { param1 : "val1", param2 : "val2" }, 
    { param2 : "val3", param2 : "val4" }
  ]
const arr = [ 
    { param1 : "val1", param2 : "val2" }, 
    { param2 : "val3", param2 : "val4" }
  ]
and a Table1 with : 
col1 : VarChar
col2 : VarChar
col1 : VarChar
col2 : VarChar
where param1 should match up with col1, and param2 should match with col2. In this example, how can I query Table1 so that I only retrieve rows where (col1 == "val1" && col2 == "val2") or (col1 == "val3" && col2 == "val4") ? If I extract all the values of param1 and param2, and use them each in an inArray, like : 
const param1s = arr.map(x => x.param1)
const param2s = arr.map(x => x.param2)

select().from(table1).where(and(inArray(table1.col1, param1s), inArray(table1.col2, param2s)))
const param1s = arr.map(x => x.param1)
const param2s = arr.map(x => x.param2)

select().from(table1).where(and(inArray(table1.col1, param1s), inArray(table1.col2, param2s)))
I run the risk of also returning values such as col1 == "val1" col2 == "val4" and col1 == "val3" col2 == "val2" which were not in the original array. Is there a way to do this? Thank you
Sillvva
Sillvva•17d ago
Something like this: 
const arr = [
    { id: "1", name: "test" },
    { id: "2", name: "test2" }
];

or(
  ...arr.map(t => and(
    eq(characters.id, t.id),
    eq(characters.name, t.name)
  ))
)
const arr = [
    { id: "1", name: "test" },
    { id: "2", name: "test2" }
];

or(
  ...arr.map(t => and(
    eq(characters.id, t.id),
    eq(characters.name, t.name)
  ))
)
Want results from more Discord servers?
Add your server
More Posts
Postgres.js type error string/dateI'm running the following where clause in a select query: ``` .where( and( gt( sql`${e.add a prefix to UUID?I am wondering if there is a functionality where I can add a custom prefix the uuid's. These uuids w[BUG?] Handling Postgresql schemas when using enums"drizzle-orm": "^0.30.10" Hello. I have a simple table with a status column ```ts export const BaseSHelp needed for Nested QueryFor this example, I have 4 tables - `user`, `podcast`, `episodes`, and `bookmarks`. - bookmarks tabl