Mercurial > hg > ltpda
diff m-toolbox/classes/tests/database/@ltpda_database/getTableEntry.m @ 0:f0afece42f48
Import.
author | Daniele Nicolodi <nicolodi@science.unitn.it> |
---|---|
date | Wed, 23 Nov 2011 19:22:13 +0100 |
parents | |
children | 79dc7091dbbc |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/m-toolbox/classes/tests/database/@ltpda_database/getTableEntry.m Wed Nov 23 19:22:13 2011 +0100 @@ -0,0 +1,24 @@ +% +% DESCRIPTION: Returns a table enty for the given inputs: database table, +% column name, object ID +% +% VERSION: $Id: getTableEntry.m,v 1.2 2011/05/25 16:20:37 ingo Exp $ +% +function val = getTableEntry(utp, dbTable, tableField, objID) + + utp.conn.setLocked(true); + utp.conn.openConnection(); + c = utp.conn.getConn(); + + q = sprintf('SELECT %s.%s FROM %s WHERE %s.obj_id=%d', dbTable, tableField, dbTable, dbTable, objID); + try + val = utils.jmysql.execute(c, q); + catch Me + utp.conn.setLocked(false); + utp.conn.closeConnection(); + rethrow(Me); + end + + utp.conn.setLocked(false); + utp.conn.closeConnection(); +end