Difference between revisions of "SQL"
From Bcontrol
m |
|||
| Line 7: | Line 7: | ||
*'''<tt>[[load_data_from_sql]]</tt>''' | *'''<tt>[[load_data_from_sql]]</tt>''' | ||
:Loads the saved and saved_history structs from the [[Schemas#solodata|solodata]] schema. | :Loads the saved and saved_history structs from the [[Schemas#solodata|solodata]] schema. | ||
| + | |||
| + | |||
| + | *'''<tt>[[check_sphDB]]</tt>''' | ||
| + | :A way to check the value of sph's that live in the [[Schemas#protocol|protocol]] schema | ||
| + | |||
| + | *'''<tt>[[get_sessdata]]</tt>''' | ||
| + | :Gets sessids, dates and protocol_data from a list of sessids or a ratname, experimenter, and dates. | ||
| + | |||
| + | |||
| + | *'''<tt>[[get_celldata]]</tt>''' | ||
| + | :Gets cellids, timestamps, waveforms, and sessids from a list of cellids or a ratname, experimenter and dates | ||
Revision as of 00:11, 26 May 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.
- 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
