Difference between revisions of "SQL"

From Bcontrol
Line 19: Line 19:
 
*'''<tt>[[get_celldata]]</tt>'''
 
*'''<tt>[[get_celldata]]</tt>'''
 
:Gets cellids, timestamps, waveforms, and sessids from a list of cellids or a ratname, experimenter and dates
 
:Gets cellids, timestamps, waveforms, and sessids from a list of cellids or a ratname, experimenter and dates
 +
 +
[[handle_histDB]]

Revision as of 10:00, 10 June 2009

bdata is a wrapper function for accessing a mysql database that contains bcontrol data.
Like check_settings, except uses mysql schema solodata as the source instead of settings files. Calls load_data_from_sql.
Tells you what changed in settings from one day to the next.
Loads the saved and saved_history structs from the solodata schema.
A way to check the value of sph's that live in the protocol schema
Gets sessids, dates and protocol_data from a list of sessids or a ratname, experimenter, and dates.
Gets cellids, timestamps, waveforms, and sessids from a list of cellids or a ratname, experimenter and dates

handle_histDB