Mercurial > hg > ltpda
diff m-toolbox/classes/+utils/@mysql/mysql.m @ 0:f0afece42f48
Import.
author | Daniele Nicolodi <nicolodi@science.unitn.it> |
---|---|
date | Wed, 23 Nov 2011 19:22:13 +0100 |
parents | |
children |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/m-toolbox/classes/+utils/@mysql/mysql.m Wed Nov 23 19:22:13 2011 +0100 @@ -0,0 +1,73 @@ +% MYSQL class for tools to manipulate the current object/figure/axis. +%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% +% +% DESCRIPTION: MYSQL class for tools to manipulate the current +% object/figure/axis. +% +% MYSQL METHODS: +% +% Static methods: +% yticks - Set the input vector as the y-ticks of the current axis +% %%% GENERAL TOOLS +% logindlg - creates a login dialog box. +% dbquery - query an AO repository database. +% getAOsInTimeSpan - performs high-level queries to retrieve AOs from +% a LTPDA repository. +% insert - inserts values into a single row of a table using +% JDBC driver specified by the input connection. +% +% %%% MYSQL TOOLS +% connect - connects to an LTPDA repository and returns +% the connection object. +% getMaxId - get the maximum Id from the objs table. +% getMD5hash - gets the md5 hash string of a given object ID. +% getObjIds - gets a list of object ids from a given collection id. +% getObjType - gets the object type associated with the given object id. +% getUserID - gets the user ID number corresponding to the given +% user name. +% getXdoc - retrieves an object with given id from the +% LTPDA repository +% +% HELP: To see the available static methods, call +% >> methods utils.mysql +% +% HISTORY: 26-05-2008 Diepholz +% Creation +% +% VERSION: $Id: mysql.m,v 1.3 2009/08/11 12:02:46 hewitson Exp $ +% +%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% + +classdef mysql + + %------------------------------------------------ + %--------- Declaration of Static methods -------- + %------------------------------------------------ + methods (Static) + + %------------------------------------------------------------- + % List other methods + %------------------------------------------------------------- + + %%% GENERAL TOOLS + varargout = getsinfo(varargin) % return sinfo structure of repository object + varargout = logindlg(varargin) % creates a login dialog box. + varargout = dbquery(varargin) % query an AO repository database. + varargout = getAOsInTimeSpan(varargin) % performs high-level queries to retrieve AOs from an LTPDA repository. + message = insert(conn, table, varargin) % inserts values into a single row of a table using JDBC driver specified by the input connection. + varargout = getRepositoryVersion(varargin); + + + %%% MYSQL TOOLS + varargout = connect(varargin) % connects to an LTPDA repository and returns the connection object. + id = getMaxId(conn) % get the maximum Id from the objs table. + h = getMD5hash(conn, id) % gets the md5 hash string of a given object ID. + ids = getObjIds(conn, cid) % gets a list of object ids from a given collection id. + type = getObjType(conn, id) % gets the object type associated with the given object id. + [userid,dbuser] = getUserID(conn, username) % gets the user ID number corresponding to the given user name. + xdoc = getXdoc(conn, id) % retrieves an object with given id from the LTPDA repository + + end % End static methods + +end +