Unable to delete security due to lingering activities

[andrzejressel]

After removing accounts, activities stay in the database and they block removal od securities:

Perhaps foreign key with cascade delete is needed there?

Tested on 2.1.0

[andrzejressel]

Weird:

https://github.com/afadil/wealthfolio/blob/main/src-core/migrations/2023-11-08-162221_init_db/up.sql#L63

There is constraint already set.

I also see that the PRAGMA is set correctly - I'll have to take a deeper look, because maybe it's set incorrectly or in the wrong place.

I think migrations/2025-03-18-222805_add_amount_field_and_use_decimal/up.sql broke it - the constraint were not copied

[sticilface]

I've got the same issue. I'm trying to delete securities but it is saying I cannot as there are 'still activities that reference it' despite that not being the case.

Could you maybe add a 'force delete' that removes a security even if its still used... the program can then re-add them if it encounters it on the next update cycle... ?