spyglass

spyglass copied to clipboard

Incorrect Delete propagation in decoding

3

**Describe the bug** Running a delete in `UnitWaveformFeaturesGroup` is trying to delete entries in `DecodingOutput.SortedSpikesDecoding` (which is not dependent on this table). Note: The attempted deletes in `DecodingOutput.SortedSpikesDecoding` correspond to...

samuelbray32

WIP: support .nwb.lindi.json files

3

# Description These are the changes needed to support .nwb.lindi.json files in addition to .nwb in spyglass. * The copied file name will be of the form filename_.nwb.lindi.json * In...

magland

Low verbosity error `1217` on delete prevents cascade

31

**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...

samuelbray32

`IntervalList` cautious insert

4

# Description We have previously discussed redundancy in `IntervalList` in #778. This PR makes pervasive edits to the codebase to check existing entries before inserting new ones. This comes with...

CBroz1

By peripheral tables, I refer to tables like `IntervalList` and `AnalysisNwbfile`. These tables ... - Have many foreign key references throughout various pipelines - Centralize a data type (e.g., interval,...

CBroz1

CurationV1 does not track a metrics source.

1

**Describe the bug** - The table `CurationV1` sources metrics manually passed by the user in `insert_curation` to make the table entries. - As far as I can tell, there is...

samuelbray32

`IntervalList` is hard to use and highly redundant in contents

4

## Description `IntervalList` is a central table shared across many pipelines. It is sufficiently generic to suit the needs of any pipeline, but I would argue that the lack of...

CBroz1

`delete_downstream_merge` should capture all parts with fk-refs

4

im trying to run this command: ```python (Nwbfile & {'nwb_file_name':'BS2820231107_.nwb'}).delete() ``` and i get this error: Error stack ```python --------------------------------------------------------------------------- NetworkXError Traceback (most recent call last) File ~/spyglass/src/spyglass/utils/dj_mixin.py:237, in SpyglassMixin._merge_tables(self)...

MichaelCoulter

Implement adding data from config file

1

# Implement adding data from config file Allows users to specify Institution, Lab, LabMember, Subject, and CameraDevice information for an nwb file in the associated config file. - Fixes #919...

calderast

Keys too large for MySQL defaults

7

[common_backup](https://github.com/LorenFrankLab/spyglass/blob/master/src/spyglass/common/common_backup.py#L7-L21) has some unnecessarily long primary keys with `varchar(500)`. @akgillespie8 found this to be an issue when declaring tables for her MySQL instance. We should either... 1. Add instructions for...

CBroz1