Difference between revisions of "SQL"

From Bcontrol
m
(mym (MySQL Database Connector Utility for Matlab) on Mac)
 
(8 intermediate revisions by 3 users not shown)
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>'''
 
: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, parsed_events_history, protocol 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
 +
 +
*'''<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
 +
 +
===mym (MySQL Database Connector Utility for Matlab) on Mac===
 +
Small Quirk:
 +
Type the following command if mym says that it cannot find the 'libmysqlclient.15.dylib' library on a Mac:
 +
<pre>sudo cp ~/ratter/ExperPort/MySQLUtility/libmysqlclient.15.dylib /usr/local/mysql/lib/libmysqlclient.15.dylib</pre>
 +
If you don't have mysql on your Mac, just create a dummy directory structure of 'usr/local/mysql/lib' and make the symlink as mentioned above.
 +
 +
 +
'''PREVIOUS: [[Plugins:SessionModel]]'''

Latest revision as of 15:11, 30 October 2015

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

mym (MySQL Database Connector Utility for Matlab) on Mac[edit]

Small Quirk: Type the following command if mym says that it cannot find the 'libmysqlclient.15.dylib' library on a Mac:

sudo cp ~/ratter/ExperPort/MySQLUtility/libmysqlclient.15.dylib /usr/local/mysql/lib/libmysqlclient.15.dylib

If you don't have mysql on your Mac, just create a dummy directory structure of 'usr/local/mysql/lib' and make the symlink as mentioned above.


PREVIOUS: Plugins:SessionModel