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
+