view m-toolbox/classes/+utils/@repository/getUser.m @ 11:9174aadb93a5
database-connection-manager
Add LTPDA Repository utility functions into utils.repository
author
Daniele Nicolodi <nicolodi@science.unitn.it>
date
Mon, 05 Dec 2011 16:20:06 +0100 (2011-12-05)
parents
children
line source
+ − function [username, userid] = getUser(conn)
+ − % GETUSER Return username and userid of the current database user.
+ − %
+ − % CALL:
+ − %
+ − % [username, userid] = utils.repository.getUser(conn)
+ − %
+ −
+ − % current database user
+ − rows = utils.mysql.execute(conn, 'SELECT SUBSTRING_INDEX(USER(),''@'',1)');
+ − username = rows{1};
+ −
+ − % userid
+ − rows = utils.mysql.execute(conn, 'SELECT id FROM users WHERE username = ?', username);
+ − if isempty(rows)
+ − error('### could not determine user id');
+ − end
+ − userid = rows{1};
+ −
+ − end