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