Home > m > mysql > mysql_connect.m

mysql_connect

PURPOSE ^

MYSQL_CONNECT connects to an AO repository and returns the connection object.

SYNOPSIS ^

function [conn, dbuser] = mysql_connect(varargin)

DESCRIPTION ^

 MYSQL_CONNECT connects to an AO repository and returns the connection object.

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

 DESCRIPTION: MYSQL_CONNECT connects to an AO repository and returns the
              connection object.

 CALL:        conn = mysql_connect(hostname, dbname)

 VERSION:     $Id: mysql_connect.m,v 1.7 2007/09/15 04:52:07 hewitson Exp $

 HISTORY:     24-05-2007 M Hewitson
                 Creation

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

CROSS-REFERENCE INFORMATION ^

This function calls: This function is called by:

SOURCE CODE ^

0001 function [conn, dbuser] = mysql_connect(varargin)
0002 % MYSQL_CONNECT connects to an AO repository and returns the connection object.
0003 %
0004 %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
0005 %
0006 % DESCRIPTION: MYSQL_CONNECT connects to an AO repository and returns the
0007 %              connection object.
0008 %
0009 % CALL:        conn = mysql_connect(hostname, dbname)
0010 %
0011 % VERSION:     $Id: mysql_connect.m,v 1.7 2007/09/15 04:52:07 hewitson Exp $
0012 %
0013 % HISTORY:     24-05-2007 M Hewitson
0014 %                 Creation
0015 %
0016 %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
0017 
0018 if nargin < 1
0019   error('### Incorrect inputs')
0020 end
0021 
0022 if nargin == 1
0023   dbhost = varargin{1};
0024   dbname = 'mysql';
0025 else
0026   dbhost = varargin{1};
0027   dbname = varargin{2};
0028 end
0029 
0030 %% Prompt for username and password
0031 
0032 % first try defaults
0033 dbuser = getappdata(0, 'ltpda_repo_user');
0034 dbpass = getappdata(0, 'ltpda_repo_pass');
0035 
0036 if isempty(dbuser) || isempty(dbpass)  
0037   [dbuser, dbpass] = logindlg('Title','LTPDA Repository Access');
0038 
0039   if isempty(dbuser) || isempty(dbpass)
0040     warning('!!! Login process cancelled.');
0041     conn = [];
0042     return
0043   end
0044 end
0045 
0046 %% Database settings
0047 
0048 dbdriver = getappdata(0, 'mysql_driver');
0049 dburl    = sprintf('jdbc:mysql://%s/%s',dbhost,dbname);
0050 
0051 disp(sprintf('** Connecting to %s as %s...', dbhost, dbuser))
0052 
0053 conn     = database(dbname,dbuser,dbpass,dbdriver,dburl);
0054 
0055 disp('** Connection status:')
0056 disp(ping(conn))
0057 
0058 
0059 % END

Generated on Fri 02-Nov-2007 19:39:27 by m2html © 2003