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