diff m-toolbox/classes/+utils/@repository/getCollectionIDs.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
parents
children
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/m-toolbox/classes/+utils/@repository/getCollectionIDs.m	Mon Dec 05 16:20:06 2011 +0100
@@ -0,0 +1,26 @@
+function ids = getCollectionIDs(conn, cid)
+% GETCOLLECTIONIDS  Return the IDs of the object composing a collection.
+%
+% CALL:
+%
+%   ids = utils.repository.getCollectionIDs(conn, cid)
+%
+% PARAMETERS:
+%
+%   CONN   database connection implementing java.sql.Connection
+%   CID    collection id
+%
+
+  rows = utils.mysql.execute(conn, 'SELECT nobjs, obj_ids FROM collections WHERE id = ?', cid);
+  if isempty(rows)
+    error('### collection %d not found', cid);
+  end
+  nobjs = rows{1};
+  ids = strread(rows{2}, '%d', 'delimiter', ',');
+  if length(ids) ~= nobjs
+    error('### inconsistent collection description');
+  end
+  % transform column vector in row vector
+  ids = ids';
+  
+end