Newline causing SQL error when migrating
If I run a migration that contains many SQL statements, it fails. If I generate the migration SQL one table at a time, the migration will succeed when being executed...
Conclusion is that the newline character between statements is causing issues...
breakpoints is true in drizzle.config.ts but that doesn't seem to be working at all, not breakpoints are added.
is there a way to preprocess the SQL files before execution?
context: MacOS,
node 18.18.2
drizzle-orm 0.25.3
drizzle-kit 0.17.6
1 Reply
According to the documentation here https://orm.drizzle.team/kit-docs/config-reference
the drizzle.config can be js or ts, but in fact it expects JSON... not sure who wrote that...
Configuring Drizzle kit - Drizzle ORM
Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.