adrtivv Comments - Answer Overflow

adrtivv

•Created by adrtivv on 11/6/2024 in #help

column is of type date but expression is of type text

await db.update(users).set({ dateOfBirth: null }).where(eq(users.id, id)).returning();

{
    sql: `
        update
          "users" 
        set
          "date_of_birth" = $1 
        where
          "users"."id" = $2 returning "date_of_birth", "id"
          `,
    params: [null, "01930105-b607-7f81-ada2-d5ea49b393f3"],
}

await db.update(users).set({ dateOfBirth: null }).where(eq(users.id, id)).returning();

{
    sql: `
        update
          "users" 
        set
          "date_of_birth" = $1 
        where
          "users"."id" = $2 returning "date_of_birth", "id"
          `,
    params: [null, "01930105-b607-7f81-ada2-d5ea49b393f3"],
}

await db.update(users).set({
 dateOfBirth: sql`(case when ${users.id} = ${id} then ${null} end)`
}).where(inArray(users.id, [id])).returning();

{
    sql: `
        update
          "users" 
        set
          "date_of_birth" = 
          (
            case
              when
                "users"."id" = $1 
              then
                $2 
            end
          )
        where
          "users"."id" in 
          (
            $3
          )
          returning "date_of_birth", "id"
          `,
    params: [
        "01930105-b607-7f81-ada2-d5ea49b393f3",
        null,
        "01930105-b607-7f81-ada2-d5ea49b393f3",
    ],
}

await db.update(users).set({
 dateOfBirth: sql`(case when ${users.id} = ${id} then ${null} end)`
}).where(inArray(users.id, [id])).returning();

{
    sql: `
        update
          "users" 
        set
          "date_of_birth" = 
          (
            case
              when
                "users"."id" = $1 
              then
                $2 
            end
          )
        where
          "users"."id" in 
          (
            $3
          )
          returning "date_of_birth", "id"
          `,
    params: [
        "01930105-b607-7f81-ada2-d5ea49b393f3",
        null,
        "01930105-b607-7f81-ada2-d5ea49b393f3",
    ],
}

Both update operations have the same functionality, but in the second case I get column \"date_of_birth\" is of type date but expression is of type text error.

6 replies

DTDrizzle Team

•Created by adrtivv on 11/4/2024 in #help

How to resolve mutiple queries in a single request to postgres database?

I would need to use Promise.all at multiple places so it can compound a lot. I'm not relying on postgres exceptions so in my code I have to do constraint checks, there's also authorization checks and business logic checks etc., and all that in a single operation. So, for example in a bulk update operation this could result in too many promises.

6 replies

DTDrizzle Team

•Created by Acro on 3/21/2024 in #help

When to use what? drizzle-kit push:* Vs. having a file with drizzle migrate client?

any difference between drizzle kit migrate command and migrate() function if both are executed against the same migration files?

6 replies

DTDrizzle Team