Louistiti Comments - Answer Overflow

Topics

Louistiti

•Created by Louistiti on 7/15/2023 in #help

Use Drizzle in NestJS app

Ohhhh awesome !

16 replies

•Created by Louistiti on 7/15/2023 in #help

Use Drizzle in NestJS app

What does that change exactly ? (I am new to NestJS)

16 replies

•Created by Louistiti on 7/15/2023 in #help

Use Drizzle in NestJS app

Yes it works

16 replies

•Created by sexnine on 7/6/2023 in #help

[Relational Queries] Nullable one-to-one relationship

I think you should explain this in the docs...

8 replies

•Created by zendev on 9/26/2023 in #help

environment variables undefined in drizzle.config.ts

you can use dotenv-cli https://www.npmjs.com/package/dotenv-cli

4 replies

•Created by Louistiti on 9/23/2023 in #help

Where does the onDelete on relation is applying ?

which is fixed when I remove the .references()

14 replies

•Created by Louistiti on 9/23/2023 in #help

Where does the onDelete on relation is applying ?

When I try to create an entity without specifying a relation, I get a foreign key constraint error

14 replies

•Created by Louistiti on 9/23/2023 in #help

Where does the onDelete on relation is applying ?

https://github.com/drizzle-team/drizzle-orm/issues/1264

14 replies

•Created by Louistiti on 9/23/2023 in #help

Where does the onDelete on relation is applying ?

it shouldn't but it does unfortunately

14 replies

•Created by Louistiti on 9/23/2023 in #help

Where does the onDelete on relation is applying ?

but as using .references() makes the relation mandatory (cannot be null) I cannot put an onDelete on my product table's side

14 replies

•Created by Louistiti on 9/23/2023 in #help

Where does the onDelete on relation is applying ?

one to one but my logistics table is used with other tables as well

14 replies

•Created by Louistiti on 9/23/2023 in #help

Where does the onDelete on relation is applying ?

Alright, thanks anyway !

14 replies

•Created by Louistiti on 9/23/2023 in #help

Where does the onDelete on relation is applying ?

Thanks for your answer ! So I have to delete manually logistics on product delete ?

14 replies

•Created by benjick on 9/23/2023 in #help

How to handle relations during insert?

This should be the good way to go !

8 replies

•Created by benjick on 9/23/2023 in #help

How to handle relations during insert?

return this.db.query.products.findMany({
        where: () => eq(products.shop_id, shopId),
        with: {
          imagesToProduct: {
            columns: {
              image_id: true,
            },
            with: {
              image: {
                columns: {
                  url: true,
                },
              },
            },
          },
          variants: true,
          informations: true,
          logistics: true,
        },
      });

return this.db.query.products.findMany({
        where: () => eq(products.shop_id, shopId),
        with: {
          imagesToProduct: {
            columns: {
              image_id: true,
            },
            with: {
              image: {
                columns: {
                  url: true,
                },
              },
            },
          },
          variants: true,
          informations: true,
          logistics: true,
        },
      });

8 replies

•Created by benjick on 9/23/2023 in #help

How to handle relations during insert?

let me find an example in may codebase

8 replies

•Created by benjick on 9/23/2023 in #help

How to handle relations during insert?

I think you should use db transactions to do that https://orm.drizzle.team/docs/transactions

8 replies

•Created by Louistiti on 7/18/2023 in #help

Clear the whole database?

ohhhhhhh yeah ! I remember now struggling with that ! I had the same issue as you and this fixed everything... sorry I forgot 🫠

59 replies

•Created by Louistiti on 7/18/2023 in #help

Clear the whole database?

this is mandatory

59 replies

•Created by Louistiti on 7/18/2023 in #help

Clear the whole database?

did you await the db.execute ?

59 replies