Difference between revisions of "SQL"

From Bcontrol
Line 15: Line 15:
  
 
*'''<tt>[[get_sessdata]]</tt>'''
 
*'''<tt>[[get_sessdata]]</tt>'''
:Gets sessids, dates and protocol_data from a list of sessids or a ratname, experimenter, and dates.
+
:Gets sessids, dates, parsed_events_history, protocol and protocol_data from a list of sessids or a ratname, experimenter, and dates.
  
 
*'''<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]]
+
*'''<tt>[[handle_histDB]]</tt>'''
 +
:Much like handle_hist, but instead of working on the currently open protocol it works on the session specified by sessid

Revision as of 10:02, 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, parsed_events_history, protocol 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
Much like handle_hist, but instead of working on the currently open protocol it works on the session specified by sessid