view m-toolbox/classes/tests/database/@ltpda_xydata_table/getTableEntry.m @ 16:91f21a0aab35
database-connection-manager
Update utils.jquery
* * *
Update utils.jmysql.getsinfo
author
Daniele Nicolodi <nicolodi@science.unitn.it>
date
Mon, 05 Dec 2011 16:20:06 +0100 (2011-12-05)
parents
f0afece42f48
children
79dc7091dbbc
line source
+ − %
+ − % DESCRIPTION: Returns a table enty for the given inputs: database table,
+ − % column name, object ID
+ − %
+ − % VERSION: $Id: getTableEntry.m,v 1.1 2011/05/25 16:25:31 ingo Exp $
+ − %
+ − function val = getTableEntry(utp, dbTable, tableField, objID)
+ −
+ − % Check database version
+ − if 1==1
+ − %%% old database layout
+ −
+ − try
+ − % Get the data ID from the ao table
+ − dataID = getDataIdFromAoTable(utp, objID);
+ −
+ − % Check that we get only one result for the query
+ − assert(numel(dataID)==1, sprintf('Found more than one data ID for the given object ID %d', objID));
+ −
+ − % Create query to get the field 'xunits' from the 'cdata' table
+ − query = sprintf('SELECT %s FROM %s WHERE %s.id=%d', tableField, dbTable, dbTable, dataID{1});
+ − val = executeQuery(utp, query);
+ − catch Me
+ − rethrow(Me);
+ − end
+ −
+ − elseif 1~=1
+ − %%% new database layout
+ − else
+ − throw(MException('ltpda_cdata_table:getTableEntry', 'Unknown database layout.'));
+ − end
+ −
+ − utp.conn.setLocked(false);
+ − utp.conn.closeConnection();
+ − end