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
