Is old LFP and LFPBand altered in anyway?

[shijiegu]

Hi I know new ones are under way and Mike has switched the new one. This whole summer 2023 though, I have still been using the old LFP and LFPBand. No issues so far until today: are there changes done today?

(LFPSelection() & {'nwb_file_name' :'eliot20221024_.nwb'}).delete()

gives

---------------------------------------------------------------------------
IntegrityError                            Traceback (most recent call last)
File ~/anaconda3/envs/spyglass/lib/python3.8/site-packages/datajoint/table.py:504, in Table.delete.<locals>.cascade(table)
    503 try:
--> 504     delete_count = table.delete_quick(get_count=True)
    505 except IntegrityError as error:

File ~/anaconda3/envs/spyglass/lib/python3.8/site-packages/datajoint/table.py:463, in Table.delete_quick(self, get_count)
    462 query = "DELETE FROM " + self.full_table_name + self.where_clause()
--> 463 self.connection.query(query)
    464 count = (
    465     self.connection.query("SELECT ROW_COUNT()").fetchone()[0]
    466     if get_count
    467     else None
    468 )

File ~/anaconda3/envs/spyglass/lib/python3.8/site-packages/datajoint/connection.py:340, in Connection.query(self, query, args, as_dict, suppress_warnings, reconnect)
    339 try:
--> 340     self._execute_query(cursor, query, args, suppress_warnings)
    341 except errors.LostConnectionError:

File ~/anaconda3/envs/spyglass/lib/python3.8/site-packages/datajoint/connection.py:296, in Connection._execute_query(cursor, query, args, suppress_warnings)
    295 except client.err.Error as err:
--> 296     raise translate_query_error(err, query)

IntegrityError: Cannot delete or update a parent row: a foreign key constraint fails (`common_ephys`.`_l_f_p`, CONSTRAINT `_l_f_p_ibfk_1` FOREIGN KEY (`nwb_file_name`) REFERENCES `l_f_p_selection` (`nwb_file_name`) ON DELETE RESTRICT ON UPDATE CASCADE)

[edeno]

@CBroz1 could you take a look at this?

[CBroz1]

Hi @shijiegu

• Have you fetched upstream to get the latest Spyglass changes?
• Do you remember when this last worked? Specifically, I'm wondering if it's worked after Daniel and Ryan did the LFPElectrode move around 7/16