DT
Drizzle Team•5mo ago
ashishansurkar

Insert on migration

Can we insert some data if table is empty while running migration?
3 Replies
Angelelz
Angelelz•5mo ago
Sure, you'll need manually add the queries that you need to run to the migration file
ashishansurkar
ashishansurkar•5mo ago
Thanks, can you please guide more on this. Should I write queries into .sql migrations files or in the trypescript schema/config file ?
Angelelz
Angelelz•5mo ago
I would like to say that unless you have a good reason to do this, is generally considered a bad practice Migrations are supposed to change the structure of your database, not the data inside. When this type of operations is needed, people would have a separated script to seed the database after the migration is successful
Want results from more Discord servers?
Add your server
More Posts
.query.with relationship types don't work unless I manually type them outI thought I had posted this here some time ago, but I can't find the post so I hope I'm not double pMulti-tenancyHey, we are trying to implement an use-case in our project and I need help on how to do it. We haveMany to many relation not enough information```ts export const orderRelations = relations(orders, ({ many, one }) => ({ stripeTransactions: maIssue querying with relations in bun+sqlite👋 repro + context here - https://github.com/sammccord/drizzle-relations-repro It seems like the quHaving trouble understanding type on query with relationHi guys, I'm new to drizzle. I need some help understanding the type that has been infered for my qHow do you define one-to-one relations in the same table?```ts export const listings = pgTable( 'Listing', { id: text('id') .primaryKey() Can i make many to many relationship without define new tableI tried, but I couldn't do it.many-to-many selection as array```tsx const data = await db .select({ id: posts.id, content: posts.content, i[PG] Array values with AWS Data APIhi! I ran into this issue today when working with a schema that has an integer array column: https:Check for insert result in a for loopHi, I am not sure how to do this but I have a for loop that run `insert` for each iteration. I don't