Merge table multi-source error specificity

[MichaelCoulter]

i'm trying to get position (to get speed) for ripple detection.

this will find a single entry in IntervalPositionInfo
IntervalPositionInfo() & {"nwb_file_name": 'tonks20211027_.nwb'} & {'interval_list_name':'pos 1 valid times'}

but when i try this:

nwb_file_name = 'tonks20211027_.nwb'
interval_list_name = "pos 1 valid times"

pos_key = PositionOutput.merge_get_part({
        "nwb_file_name": nwb_file_name,
        "position_info_param_name": "default_decoding",
        "interval_list_name": interval_list_name,
    }).fetch1("KEY")
(PositionOutput & pos_key).fetch1_dataframe()`

i get this error:

ValueError                                Traceback (most recent call last)
Cell In [18], line 5
      2 nwb_file_name = 'tonks20211027_.nwb'
      3 interval_list_name = "pos 1 valid times"
----> 5 pos_key = PositionOutput.merge_get_part({
      6         "nwb_file_name": nwb_file_name,
      7         "position_info_param_name": "default_decoding",
      8         "interval_list_name": interval_list_name,
      9     }).fetch1("KEY")
     10 (PositionOutput & pos_key).fetch1_dataframe()

File ~/spyglass/src/spyglass/utils/dj_merge_tables.py:543, in Merge.merge_get_part(cls, restriction, join_master, restrict_part, multi_source)
    532 sources = [
    533     to_camel_case(n.split("__")[-1].strip("`"))  # friendly part name
    534     for n in cls._merge_restrict_parts(
   (...)
    539     )
    540 ]
    542 if not multi_source and len(sources) != 1:
--> 543     raise ValueError(
    544         f"Found multiple potential parts: {sources}\n\t"
    545         + "Try adding a restriction before invoking `get_part`.\n\t"
    546         + "Or permitting multiple sources with `multi_source=True`."
    547     )
    549 parts = [
    550     getattr(cls, source)().restrict(restriction)
    551     if restrict_part  # Re-apply restriction or don't
    552     else getattr(cls, source)()
    553     for source in sources
    554 ]
    555 if join_master:

ValueError: Found multiple potential parts: []
	Try adding a restriction before invoking `get_part`.
	Or permitting multiple sources with `multi_source=True`.

any ideas how to have a more specific query? thanks.

[dpeg22]

Hi Mike, it looks like that entry doesn't exist in PositionOutput.CommonPos, which is the PositionOutput part table for IntervalPositionInfo, so that is something you'll need to do prior to querying PositionOutput.
@CBroz1 might have better suggestions, but if you know your entries are coming from IntervalPositionInfo and they've been inserted into PositionOutput, then you could run:

pos_key = (PositionOutput.CommonPos & {
    "nwb_file_name": nwb_file_name,
    "position_info_param_name": "default_decoding", 
    "interval_list_name": interval_list_name,
}).fetch1("KEY")

[MichaelCoulter]

Here is a command to insert entries from IntervalPositionInfo into PositionOutput

position_insert = (IntervalPositionInfo & {'nwb_file_name':'tonks20211027_.nwb'}).fetch(as_dict=True) PositionOutput._merge_insert(position_insert, part_name="CommonPos")

[CBroz1]

Reopening to track adding error specificity to dj_merge_tables.py:544, to

f"Found {len(sources)} potential part(s): {sources}\n\t"