Difference between revisions of "SQL"

From Bcontrol
m
Line 4: Line 4:
 
*'''<tt>[[check_settingsDB]]</tt>'''
 
*'''<tt>[[check_settingsDB]]</tt>'''
 
:Like check_settings, except uses mysql schema [[Schemas#solodata|solodata]] as the source instead of settings files.  Calls [[load_data_from_sql]].
 
:Like check_settings, except uses mysql schema [[Schemas#solodata|solodata]] as the source instead of settings files.  Calls [[load_data_from_sql]].
 +
 +
*'''<tt>[[diff_settingsDB]]</tt>'''
 +
:Tells you what changed in settings from one day to the next. 
  
 
*'''<tt>[[load_data_from_sql]]</tt>'''
 
*'''<tt>[[load_data_from_sql]]</tt>'''

Revision as of 01:56, 4 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