Lims query changes - Githubissues

AllenInstitute / visual_behavior_analysis

Python package for analyzing behavioral data for Brain Observatory: Visual Behavior

Other

21 stars 6 forks source link

Closed dougollerenshaw closed 3 years ago

dougollerenshaw commented 3 years ago

adds a new method to data_access.utilities which will query LIMS for all IDs given a single ID Example use:

adds options to various data_access.utilities queries that allow them to work without passing a cache. Instead, they go straight to LIMS. This should make them more convenient for internal users.
modifies the query format in a single method in database.py

dougollerenshaw commented 3 years ago

Good idea! Seems easier said than done, though! I added

    oe.experiment_container_id as experiment_container_id,
    os.visual_behavior_supercontainer_id as supercontainer_id

to the query. For my example, though, experiment_container_id is all None. I don't know why.

is experiment_container_id not the same as what we've generally called 'container_id'?

dougollerenshaw commented 3 years ago

@djkapner came to the rescue on slack. See my last commit. The example query above now returns this: