Incorrect synapse number are shown when filters are enabled

zhenlab-ltri / NemaNode

Interactive map of neural connections in the nematode C. elegans. Online at http://nemanode.org.

http://nemanode.org

GNU General Public License v3.0

8 stars 4 forks source link

Incorrect synapse number are shown when filters are enabled #39

Closed dwitvliet closed 4 years ago

dwitvliet commented 4 years ago

For example, see http://nemanode.org/?db=head&ds=witvliet_2020_2__witvliet_2020_6__witvliet_2020_8&c=type&la=concentric&tc=2&te=2&sl=0&si=0&se=1&sp=1&sa=1&in=AVB__AVH&sp=1&cor=AVB_896_477__AVH_581_479

The connection should say 1,0,5 but it says 0,0,5.

d2fong commented 4 years ago

Pretty sure it is related to this:

https://github.com/dwitvliet/NemaNode/blob/development/src/server/db/nematode-connections.js#L41

dwitvliet commented 4 years ago

Yep, I broke it when changing the database. I think there used to be a GROUP BY ensuring it wouldn't happen. I'll look back when I have a few minutes of spare time.