this.hasTimestamp = false;
this.theTable="content_x_media";
}
-
+
/**
* get all the media-files belonging to a content entity
*
}
return returnList;
}
-
+
/**
* get all the images belonging to a content entity
*
*
*/
public EntityList getUploadedMedia(EntityContent content)
- throws StorageObjectException {
+ throws StorageObjectException
+ {
+ /** @todo this should only fetch published media / rk */
+
EntityList returnList=null;
if (content != null) {
// get all to_topic from media_x_topic
String subselect = "id in (select media_id from " + theTable + " where content_id=" + id+")";
try {
- returnList = DatabaseMedia.getInstance().selectByWhereClause(subselect,-1);
+ returnList = DatabaseMedia.getInstance().selectByWhereClause(subselect,"id");
} catch (Exception e) {
+ e.printStackTrace();
theLog.printDebugInfo("-- get uploadedMedia failed " + e.toString());
throw new StorageObjectException("-- get uploadedMedia failed " + e.toString());
}
}
//first delete all row with content_id=contentId
String sql = "delete from "+ theTable +" where content_id=" + contentId;
-
+
Connection con=null;Statement stmt=null;
try {
con = getPooledCon();
} finally {
freeConnection(con,stmt);
}
-
+
//now insert
//first delete all row with content_id=contentId
for (int i=0;i<mediaId.length;i++) {
if (contentId == null && mediaId == null) {
return;
}
-
+
Connection con=null;Statement stmt=null;
//now insert
-
+
String sql = "insert into "+ theTable +" (content_id,media_id) values ("
+ contentId + "," + mediaId + ")";
try {
freeConnection(con,stmt);
}
}
-
+
public void setMedia(String contentId, String mediaId)
throws StorageObjectException {
if (contentId == null && mediaId == null) {
freeConnection(con,stmt);
}
}
-
+
public void delete(String contentId, String mediaId)
throws StorageObjectException {
if (mediaId == null || contentId==null) {
}
return returnList;
}
-
+
/**
* Returns a EntityList with all content-objects having a relation to a media
*/
-
+
public EntityList getContent()
throws StorageObjectException {
EntityList returnList=null;
-
+
String select = "select distinct content_id from " + theTable;
// execute select statement
Connection con=null;Statement stmt=null;