DT
Drizzle Team•15mo ago
Fil

InArray Function not Working

Why is the drizzle Function inArray mapping my array from ['1ed01d30-d16d-4b8f-b5d0-01b2a5d94d13', '37fdf74f-4069-4eab-8eee-5ad282c66667'] to (('1ed01d30-d16d-4b8f-b5d0-01b2a5d94d13', '37fdf74f-4069-4eab-8eee-5ad282c66667')) the Double brackets are messing everything up what is goin on
12 Replies
Andrii Sherman
Andrii Sherman•15mo ago
What version of drizzle-orm are you using?
Fil
Fil•15mo ago
0.17.6
Andrii Sherman
Andrii Sherman•15mo ago
drizzle-orm not drizzle-kit
Fil
Fil•15mo ago
0.25.4
Andrii Sherman
Andrii Sherman•15mo ago
Seems like a regression from 0.23.6 https://github.com/drizzle-team/drizzle-orm/issues/382
GitHub
[BUG]: "inArray" operator doesn't work as expected · Issue #382 · d...
What version of drizzle-orm are you using? 0.23.5 Describe the Bug
Andrii Sherman
Andrii Sherman•15mo ago
will reopen this issue and fix asap
Fil
Fil•15mo ago
Okay thanks is there a way to do the inArray function in raw SQL for now?
Andrii Sherman
Andrii Sherman•15mo ago
yes 
.where(sql`${table.column} in (${}, ${})`)
.where(sql`${table.column} in (${}, ${})`)
use column and values you need in templates
Fil
Fil•15mo ago
could I do ${(,)} or do the brackets have to be strings?
Andrii Sherman
Andrii Sherman•15mo ago
each string should be separate template to make proper query parameterizing
Fil
Fil•15mo ago
aight then I wont use In cuz i need a way to search an unknown length of variables oh wait u can just pass an array in the sql statement
bloberenober
bloberenober•15mo ago
yes, array param should be parens-escaped automatically
Want results from more Discord servers?
Add your server
More Posts
Raw sql nullable types, sql<Type | undefined>``` const result = await db.select({ customField: sql<Type | null>`...` ``` This gets inferred toUsing with NestJS and ZodI'm trying to use `drizzle-zod` and `nestjs-zod` together to create Zod schemas and classes for inseMany-to-Many joins results in weird valuesHey, I am new to Prisma, switching here from prisma so I can use a typesafe orm with D1 properly. I Is drizzle fully framework agnostic?I saw a lot of people use drizzle in NextJS, but i didn't find a lot of information about usage in fTyping columns based on TableI'm trying to make a generic `paginateQuery` function that would let me pass in the table and then aDoes onConflictDoUpdate work with composite primary keys?I have a model defined below: ```ts export const userDevices = pgTable( 'user_devices', { iSupport for multiple with statements?Is it possible to have multiple with statements? ``` const carriers = await tx .with(cahow to use placeholders for Prepared Insert statements?Is this possible?use constant in between operatorHello guys, Is there any way to use constant in between filter instead of column?Type error: Could not find a declaration file for module 'drizzle-kit'.Any idea how to fix this problem? I try to run this: npm i --save-dev @types/drizzle-kit: npm ERR!