DT
Drizzle Team•16mo ago
rushil1o1

Is it recommended to create a SQL transaction every time we try to create a foreign relationship?

prisma used to wrap every foreign upsert (2 entities) within a transaction to guarantee that both rows are created or the changes are rolled back in case of a failure. Is there a way in drizzle to achieve the same? or is it better to individually create the entities?
1 Reply
bloberenober
bloberenober•16mo ago
We don't have first-level support of transactions yet https://github.com/drizzle-team/drizzle-orm/issues/190 But in general, you would do it in Drizzle the same as you would in raw SQL
Want results from more Discord servers?
Add your server
More Posts
Doesn't drizzle-kit generate:pg work yet when schema imports from esm package?``` > drizzle-kit generate:pg --out src/db/migrations --schema src/db/schemas drizzle-kit: v0.17.0 Is there `.returning()` in insert statement in MySQL like SQLite?There is `.returning()` insert statement in SQLite but MySQL not. how do I `.returning()` in insertCan you please release this commit?https://github.com/drizzle-team/drizzle-orm/commit/63134f21ab5ccbdb651a63c1ac0f6d5e8bbe2002 I'm getGetting results in document form rather than recordHi, new to drizzle but liking it so far. Is there away to get the results in more of a 'document' strequire() of ES Module is not supported planetscale serverless + sveltekitHi, I am getting this error when I user planetscale serverless with drizzle orm ``` require() of ESMySQL Standalone queryBuilder?https://discord.com/channels/1043890932593987624/1052239146699210863/1085708651374837810 Where shou