spyglass
spyglass copied to clipboard
Low verbosity error `1217` on delete prevents cascade
Describe the bug
Attempting to delete an entry within the Session table results in the following error: IntegrityError: (1217, 'Cannot delete or update a parent row: a foreign key constraint fails')
To Reproduce Steps to reproduce the behavior:
- Run
(Session & {"nwb_file_name": 'samtest20230817_.nwb'}).delete({"nwb_file_name": 'samtest20230817_.nwb'})
Expected behavior The entry and all other downstream should be removed
Additional context The only thing done with this nwb_file was insertion into spyglass, if that helps narrow down potential schema permission errors