Home > m > gui > ltpdaRepoGUI > callbacks > cb_connectBtn.m

cb_connectBtn

PURPOSE ^

Callback to connect to server

SYNOPSIS ^

function cb_connectBtn(varargin)

DESCRIPTION ^

 Callback to connect to server
 
 M Hewitson
 
 $Id: cb_connectBtn.html,v 1.10 2008/03/31 10:27:44 hewitson Exp $

CROSS-REFERENCE INFORMATION ^

This function calls: This function is called by:

SOURCE CODE ^

0001 function cb_connectBtn(varargin)
0002 
0003 % Callback to connect to server
0004 %
0005 % M Hewitson
0006 %
0007 % $Id: cb_connectBtn.html,v 1.10 2008/03/31 10:27:44 hewitson Exp $
0008 %
0009 
0010 myh     = varargin{1};
0011 mainfig = varargin{4};
0012 status  = findobj('Tag', 'statusTxt');
0013 panels = getappdata(mainfig, 'panels');
0014 
0015 % Get conn
0016 conn = getappdata(mainfig, 'connection');
0017 
0018 if isempty(conn)
0019   
0020   % get hostname
0021   hostname = get(findobj('Tag','serverTxt'), 'String');
0022   
0023   % get the database
0024   db = get(findobj('Tag','databaseTxt'), 'String');
0025   
0026   % check for username and password
0027   dbuser = getappdata(mainfig, 'dbuser');
0028   dbpass = getappdata(mainfig, 'dbpass');  
0029   
0030   % connect
0031   if ~isempty(dbpass) && ~isempty(dbuser)
0032     conn = mysql_connect(hostname, db, dbuser, dbpass);
0033   else
0034     [conn, dbpass] = mysql_connect(hostname, db);
0035   end
0036   if isa(conn, 'database')
0037     setappdata(mainfig, 'connection', conn);
0038     setappdata(mainfig, 'username', conn.Username);
0039     set(myh, 'String', 'disconnect');
0040     set(status, 'String', sprintf('connected to %s on %s as %s', db, hostname, conn.Username));
0041     
0042     % Set tables on query panel
0043     buildConditions(panels(3));
0044     
0045     % store the connection
0046     setappdata(mainfig, 'dbuser', conn.Username);
0047     setappdata(mainfig, 'dbpass', dbpass);
0048   else
0049     set(status, 'String', 'not connected');    
0050     error('Invalid connection.');
0051   end
0052 else
0053   % disconnect
0054   close(conn);
0055   conn = [];
0056   disp('* disconnected.');
0057   setappdata(mainfig, 'connection', conn);
0058   setappdata(mainfig, 'username', '');
0059   set(myh, 'String', 'connect');
0060   set(status, 'String', 'not connected');
0061   setappdata(mainfig, 'dbuser', '');
0062   setappdata(mainfig, 'dbpass', '');
0063 end
0064

Generated on Mon 31-Mar-2008 12:20:24 by m2html © 2003