Torbaz Comments - Answer Overflow

Torbaz

•Created by gfung on 4/14/2024 in #help

Updating multiple rows with single SQL query doesn't work.

Is there any reason that you would not just use this?

await db
    .update(users)
    .set({
        approved: true,
    })
    .where(inArray(users.id, ids));

await db
    .update(users)
    .set({
        approved: true,
    })
    .where(inArray(users.id, ids));

4 replies

DTDrizzle Team

•Created by shahidcodes on 4/13/2024 in #help

Fetching many to many along with some aggregation using select

If you otherwise want to just use the select functions, you will have to manually group things I believe

16 replies

DTDrizzle Team

•Created by shahidcodes on 4/13/2024 in #help

Fetching many to many along with some aggregation using select

Have a look into this https://orm.drizzle.team/docs/rqb

16 replies

DTDrizzle Team

•Created by Jonathan on 4/13/2024 in #help

How do I recursively fetch tables?

https://orm.drizzle.team/docs/rqb

5 replies

DTDrizzle Team

•Created by Jonathan on 4/13/2024 in #help

How do I recursively fetch tables?

Have a look into this, you will need to define the relations as shown under "Declaring relations" even if you already have the relations defined using .references() You will then be able to do db.query.person which the docs go into

5 replies

DTDrizzle Team

•Created by Md. Redwan Hossain on 11/16/2023 in #help

"table name specified more than once error in relational query

hi, i couldnt find the issue opened by @Md. Redwan Hossain, however I have opened this for the same issue. https://github.com/drizzle-team/drizzle-orm/issues/2066

11 replies

Gaming

Programming