imoby Comments - Answer Overflow

I believe a big aspect of it is to define the order of your migrations. each one references previous migration id's especially if they need to happen in order. thats at least 'one' thing it does

3 replies

DTDrizzle Team

•Created by imoby on 9/21/2023 in #help

Help migrating a nested Prisma update

We only have the unique index in the result not the note. Not sure if that needs to be corrected

14 replies

DTDrizzle Team

•Created by imoby on 9/21/2023 in #help

Help migrating a nested Prisma update

logically that seems to break it down well but I get a following error when I run it I'm guessing it has to do with the constraint: "there is no unique or exclusion constraint matching the ON CONFLICT specification"

14 replies

DTDrizzle Team

•Created by imoby on 9/21/2023 in #help

Help migrating a nested Prisma update

So basically each result can optionally have one note associated with it. But a note does not have to be associated with an a result. It can be used for non result scenarios

14 replies

DTDrizzle Team

•Created by imoby on 9/21/2023 in #help

Help migrating a nested Prisma update

It’s an optional relation

14 replies

DTDrizzle Team

•Created by imoby on 9/21/2023 in #help

Help migrating a nested Prisma update

Result has a noteId foreign key

14 replies

DTDrizzle Team

•Created by imoby on 9/19/2023 in #help

Best practice on running migrations

I had to change it to be commonjs because it was complaining about using imports

16 replies

DTDrizzle Team

•Created by imoby on 9/19/2023 in #help

Best practice on running migrations

thank you

16 replies

DTDrizzle Team

•Created by imoby on 9/19/2023 in #help

Best practice on running migrations

I think I got it figured out, it was due to my tsconfig

16 replies

DTDrizzle Team

•Created by imoby on 9/19/2023 in #help

Best practice on running migrations

@Raphaël M (@rphlmr) ⚡ this might be a silly question but how did you get around this specific error:

SyntaxError: Cannot use import statement outside a module
    at internalCompileFunction (node:internal/vm:73:18)
    at wrapSafe (node:internal/modules/cjs/loader:1176:20)
    at Module._compile (node:internal/modules/cjs/loader:1218:27)
    at Module.m._compile

SyntaxError: Cannot use import statement outside a module
    at internalCompileFunction (node:internal/vm:73:18)
    at wrapSafe (node:internal/modules/cjs/loader:1176:20)
    at Module._compile (node:internal/modules/cjs/loader:1218:27)
    at Module.m._compile

16 replies

DTDrizzle Team

•Created by imoby on 9/19/2023 in #help

Best practice on running migrations

thank you! I was having issues with running it locally especially because it needed to be transpiled first. I"ll try this out but would love to still have a local alternative

16 replies

DTDrizzle Team

•Created by imoby on 9/18/2023 in #help

Help migrating raw query from prisma to drizzle

As part of this I'd love to also know how to rename column names

2 replies

DTDrizzle Team

•Created by imoby on 9/16/2023 in #help

Manually create migration file

thats great! pretty much what I needed. thank you!

13 replies

DTDrizzle Team

•Created by imoby on 9/16/2023 in #help

Manually create migration file

thanks. I feel like that might still be a good feature to add where you generate an empty script file but its still in history

13 replies

DTDrizzle Team

•Created by imoby on 9/12/2023 in #help

Unable to generate uuid as primary key

yes that was my fear too, but Ill see if I can do it in a secure way

17 replies

DTDrizzle Team

•Created by imoby on 9/12/2023 in #help

Unable to generate uuid as primary key

my issue is/was that I am trying to convert my current text one to a uuid one and its not letting me because of foreign key mappings. seems like a very much sql specific issue not related to drizzle. not sure whats the best route here though

17 replies

Gaming

Programming