+ throw new StorageObjectException("-- get media failed " + e.toString());
+ }
+ }
+ return returnList;
+ }
+
+ public boolean hasMedia(EntityContent content)
+ throws StorageObjectException {
+ String wc = "content_id="+content.getId();
+ if( content != null) {
+ try {
+ if(selectByWhereClause(wc,-1).size() == 0)
+ return false;
+ else
+ return true;
+ } catch (Exception e) {
+ theLog.printError("-- hasMedia failed " + e.toString());
+ throw new StorageObjectException("-- hasMedia failed " + e.toString());
+ }
+ } else {
+ theLog.printError("-- hasMedia failed: content is NULL");
+ throw new StorageObjectException("-- hasMedia failed: content is NULL");
+ }
+ }
+
+
+
+
+ /**
+ * get all the audio belonging to a content entity
+ *
+ */
+ public EntityList getAudio(EntityContent content)
+ throws StorageObjectException {
+ EntityList returnList=null;
+ if (content != null) {
+ // get all to_topic from media_x_topic
+ String id = content.getId();
+ //this is not supported by mysql
+ String subselect = "id in (select media_id from " + theTable + " where content_id=" + id+")";
+
+ try {
+ returnList = DatabaseAudio.getInstance().selectByWhereClause(subselect,-1);
+ } catch (Exception e) {
+ theLog.printDebugInfo("-- get audio failed " + e.toString());
+ throw new StorageObjectException("-- get audio failed " + e.toString());
+ }
+ }
+ return returnList;
+ }
+
+ /**
+ * get all the video belonging to a content entity
+ *
+ */
+ public EntityList getVideo(EntityContent content)
+ throws StorageObjectException {
+ EntityList returnList=null;
+ if (content != null) {
+ // get all to_topic from media_x_topic
+ String id = content.getId();
+ //this is not supported by mysql
+ String subselect = "id in (select media_id from " + theTable + " where content_id=" + id+")";
+
+ try {
+ returnList = DatabaseVideo.getInstance().selectByWhereClause(subselect,-1);
+ } catch (Exception e) {
+ theLog.printDebugInfo("-- get video failed " + e.toString());
+ throw new StorageObjectException("-- get video failed " + e.toString());