Fault-permitting insert and print-out

[khl02007]

@MichaelCoulter

[edeno]

@MichaelCoulter could you leave a more detailed description of what you want in the output?

[MichaelCoulter]

it would be great to have: a list of associated and video files that are linked to the nwb file and actually exist, a list of intervals of the position data (including estimated time in minutes), a list of intervals of the neural data (including estimated time in minutes), a check that the timestamps of the position and neural intervals are overlapping.

[CBroz1]

One approach here would be to run the insert permissively (if one insert fails, note it and keep moving), and then run generate a printout with TableChains showing the connections between NwbFile and the respective endpoints of insert_all_common

If you have some time, @MichaelCoulter, I would be interested in your feedback on the the current printouts of TableChain.

from spyglass.utils.dj_chains import TableChain
from spyglass.common import Nwbfile, OtherTable

my_chain = TableChain(Nwbfile, OtherTable)
my_restr = 'nwb_file_name LIKE "name%"'
print(str(my_chain)) # quick  A -> D
print(repr(my_chain)) # longer A -> B -> C -> D 
my_chain.join(my_restr) # join of all A-D with restriction

Is this a useful representation of the data for the inserted data? Or would it be better to have:

New IntervalList: 2, 'name1', 'name2'
New VideoFile: 1, 'video_name'
etc.

[CBroz1]

I'm currently implementing a solution that will keep track of errors, and not log successes. I plan to close this issue when merged, but if a successes or combined printout is needed, lmk and we can reopen

[edeno]

Fixed by #824