10 replies

parameterized insert and update

How does one do parameterized inserts and updates?

When I try and do something like this:

const preparedUpdate = db
    .update(TaskTable)
    .set({
        title: eq(TaskTable.id, sql.placeholder('title')),
    })
    .where(eq(TaskTable.id, sql.placeholder('id')))
    .returning()
    .prepare('Task.update');

const preparedUpdate = db
    .update(TaskTable)
    .set({
        title: eq(TaskTable.id, sql.placeholder('title')),
    })
    .where(eq(TaskTable.id, sql.placeholder('id')))
    .returning()
    .prepare('Task.update');

I get "expression is of type boolean" for all the columns.

ERR PostgresError: column "title" is of type status but expression is of type boolean
   ...

ERR PostgresError: column "title" is of type status but expression is of type boolean
   ...

Is there another syntax necessary for placeholder in set?

Thanks for your help.

Drizzle Team•3y ago•

10 replies

enalmada

parameterized insert and update

How does one do parameterized inserts and updates?

When I try and do something like this:

const preparedUpdate = db
    .update(TaskTable)
    .set({
        title: eq(TaskTable.id, sql.placeholder('title')),
    })
    .where(eq(TaskTable.id, sql.placeholder('id')))
    .returning()
    .prepare('Task.update');

const preparedUpdate = db
    .update(TaskTable)
    .set({
        title: eq(TaskTable.id, sql.placeholder('title')),
    })
    .where(eq(TaskTable.id, sql.placeholder('id')))
    .returning()
    .prepare('Task.update');

I get "expression is of type boolean" for all the columns.

ERR PostgresError: column "title" is of type status but expression is of type boolean
   ...

ERR PostgresError: column "title" is of type status but expression is of type boolean
   ...

Is there another syntax necessary for placeholder in set?

Thanks for your help.

parameterized insert and update

Similar Threads

parameterized insert and update

Similar Threads

Similar Threads

Similar Threads