Mercurial > hg > ltpda
diff m-toolbox/classes/+utils/@mysql/getUserID.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/getUserID.m Wed Nov 23 19:22:13 2011 +0100 @@ -0,0 +1,32 @@ +% GETUSERID gets the user ID number corresponding to the given user name. +%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% +% +% DESCRIPTION: GETUSERID gets the user ID number corresponding to the +% user name that connected to the MySQL database. +% +% CALL: userid = getUserID(conn) +% +% VERSION: $Id: getUserID.m,v 1.3 2010/01/22 12:46:08 ingo Exp $ +% +% HISTORY: 24-05-2007 M Hewitson +% Creation +% +%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% + +function [userid,dbuser] = getUserID(conn, username) + + error('### Obsolete as of LTPDA version 2.2. Replaced my the utils class jmysql (utils.jmysql.%s)', mfilename()); + + userid = []; + try + q = sprintf('select id from users where username="%s"', conn.Username); + curs = exec(conn, q); + curs = fetch(curs); + userid = curs.Data{1}; + close(curs); + catch curs + warning('!!! Unable to retrieve user ID. [Server returned: %s]', curs.message); + end + +end +