Drizzle Team•12mo ago

Can't save json via prepared statements

I am getting a strange entry in my db while trying to save json through a prepared statement This is my simplified prepared statement

const saveData = db.
  insert(tableName)
  .values({
    jsonData: sql.placeholder("jsonData")
  })
  .prepare()

const saveData = db.
  insert(tableName)
  .values({
    jsonData: sql.placeholder("jsonData")
  })
  .prepare()

This is how I am calling it

// Neither of these work
await saveData.execute({ jsonData: jsonData })
await saveData.execute({ 
  jsonData: JSON.stringify(jsonData)
})

// Neither of these work
await saveData.execute({ jsonData: jsonData })
await saveData.execute({ 
  jsonData: JSON.stringify(jsonData)
})

Finally this is what shows up in the json column in the db

{"name": "jsonData"}

{"name": "jsonData"}

What am I missing?

1 Reply

chronosOP•12mo ago

Seems like a github issue is open for the same. Added this comment there too https://github.com/drizzle-team/drizzle-orm/issues/1117

GitHub

[BUG]: Placeholder does not work with Json for prepared statement ·...

What version of drizzle-orm are you using? ^0.28.2 What version of drizzle-kit are you using? ^0.19.12 Describe the Bug Creating a prepared statement and using placeholder for dynamic data that is ...

Gaming

Programming

Can't save json via prepared statements