Mercurial > hg > ltpda
diff m-toolbox/classes/tests/database/@ltpda_database/getDataIdFromAoTable.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/getDataIdFromAoTable.m Wed Nov 23 19:22:13 2011 +0100 @@ -0,0 +1,24 @@ +% +% DESCRIPTION: Returns the data ID (different only in a old databases) for +% the given object ID +% +% VERSION: $Id: getDataIdFromAoTable.m,v 1.1 2011/05/25 16:23:53 ingo Exp $ +% +function val = getDataIdFromAoTable(utp, objID) + + utp.conn.setLocked(true); + utp.conn.openConnection(); + c = utp.conn.getConn(); + + q = sprintf('SELECT data_id FROM ao WHERE ao.obj_id=%d', 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