DT
Drizzle Team•15mo ago
Cory

how to use placeholders for Prepared Insert statements?

Is this possible?
3 Replies
bloberenober
bloberenober•15mo ago
don't think it's supported
Cory
Cory•15mo ago
ok thanks
Alpap
Alpap•8mo ago
this worked for me db.insert(users) .values({ email: sql.placeholder('email'), name: sql.placeholder('name'), emailVerified: sql.placeholder('emailVerified'), image: sql.placeholder('image'), }) .prepare('insert_users')
Want results from more Discord servers?
Add your server
More Posts
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! Typescript error that doesn't make a whole lot of sense when calling db.select or db.insertThis is my account model ``` export const accounts = mysqlTable("accounts", { id: nanoid("id", {Are default values not transferred over via drizzle-zod?It seems like when I use a `default([])` in my `schema` file that when I create a Zod object, I haveReplace on InsertI can see that there is a `.ignore()` option added to insert, but is there an equivalent `.replace()Is there a way to modify the select() on an existing query ?Let's say I have this query that I pass to a function ```ts const query = db.select().from(myTable)The inferred type of '<tableName>' cannot be named without a reference to '.pnpm/zod@3.21.4I'm trying to use the `drizzle-zod` but I keep getting this error... Any idea on where it comes froMigration failure on fresh DBI'm currently experiencing a migration failure on a fresh Postgres DB with both postgres.js and node