rodrigo Comments - Answer Overflow

I've found a trick. You can define the view natively in the db, and then a table in the schema, and it works. I guess there's still WIP with view ... https://github.com/drizzle-team/drizzle-orm/issues/769

3 replies

DTDrizzle Team

•Created by azn4lifee on 8/8/2023 in #help

How can I declare a relationship with a SELECT statement?

I'm also interesting in inserting a view in a relation and I see it's not possible? Is there any workaround? Would it be implemented?

8 replies

DTDrizzle Team

•Created by rodrigo on 7/22/2023 in #help

Insert multiple rows + onConflictDoUpdate

set: {
  ...Object.fromEntries(
    Object.keys(form.data.processings[0] ?? {}).map(x => [x, sql.raw(`excluded."${x}"`)])
  ),
  // optionally override specific values
  // ...
},

set: {
  ...Object.fromEntries(
    Object.keys(form.data.processings[0] ?? {}).map(x => [x, sql.raw(`excluded."${x}"`)])
  ),
  // optionally override specific values
  // ...
},

4 replies

DTDrizzle Team

•Created by rodrigo on 7/22/2023 in #help

Insert multiple rows + onConflictDoUpdate

Thanks, I've seen this thread where it allows to programatically applied the 'excluded' to all fields! https://github.com/drizzle-team/drizzle-orm/issues/675

4 replies

DTDrizzle Team

•Created by rodrigo on 7/12/2023 in #help

Error when deploying migrations with GH Action in Cloudflare D!

I've tried to install drizzle-orm in the root folde as said in other comments ... but not success!

6 replies

Gaming

Programming