Drizzle Team•9mo ago

Cascade doesn't work

Hello I use drizzle with bun:sqlite , I use onDelete cascade in reference but it doesn't work on app leve , it seem work on database level when deleting from dbviewer.

3 Replies

SandCatOP•9mo ago

Any Solution please am migrating my project from sequelize evrything work nice am just stuck with delete cascade doesn't work now

san4d•9mo ago

Can you provide some code examples? I use this feature fine in Drizzle. Make sure you're specifying the attribute on the table definition:

parentId: uuid('parent_id')
.references(() => parent.id, { onDelete: 'cascade' })
.notNull(),

parentId: uuid('parent_id')
.references(() => parent.id, { onDelete: 'cascade' })
.notNull(),

SandCatOP•9mo ago

I use it like this too

achat_id: integer('achat_id').references(() => achats.id, { onDelete: 'cascade' }).notNull()

achat_id: integer('achat_id').references(() => achats.id, { onDelete: 'cascade' }).notNull()

But i use it with Bun:sqlite

Gaming

Programming

Cascade doesn't work