valderman / selda

A type-safe, high-level SQL library for Haskell
https://selda.link
MIT License
478 stars 58 forks source link

Foreign Keys with Cascade Delete #173

Open DaQuirm opened 2 years ago

DaQuirm commented 2 years ago

As far as I can see on delete cascade support for foreign keys is missing. Is there any technical reason for this? I'd like to try implementing it if that's not something dangerous 🙂

valderman commented 2 years ago

There's no technical reason for not having on delete cascade. I'd be happy to merge support for it.

stefichjo commented 10 months ago

One would have to touch the Database.Selda.Table module among others, am I correct? What other modules are involved?

In the meantime, can I issue a raw SQL statement like this in Selda? I can use Database.Selda.Unsafe.rawStm.