package mircoders.storage;
-import java.sql.Connection;
-import java.sql.ResultSet;
-import java.sql.Statement;
-
-import mir.entity.EntityList;
-import mir.log.LoggerWrapper;
-import mir.storage.Database;
-import mir.storage.StorageObject;
-import mir.storage.StorageObjectExc;
-import mir.storage.StorageObjectFailure;
-import mircoders.entity.EntityComment;
+import java.sql.Connection;\r
+import java.sql.ResultSet;\r
+import java.sql.Statement;\r
+\r
+import mir.entity.EntityList;\r
+import mir.log.LoggerWrapper;\r
+import mir.storage.Database;\r
+import mir.storage.StorageObject;\r
+import mir.storage.StorageObjectExc;\r
+import mir.storage.StorageObjectFailure;\r
+import mircoders.entity.EntityComment;\r
import mircoders.entity.EntityUploadedMedia;
/**
* <b>implements abstract DB connection to the comment_x_media SQL table
*
* @author RK, mir-coders group
- * @version $Id: DatabaseCommentToMedia.java,v 1.3 2003/05/03 00:21:22 zapata Exp $
+ * @version $Id: DatabaseCommentToMedia.java,v 1.3.2.1 2003/09/03 17:49:41 zapata Exp $
*
*/
theEntityClass = mir.entity.GenericEntity.class;
}
- /**
- * get all the media-files belonging to a comment entity
- *
- */
- public EntityList getMedia(EntityComment comment) throws StorageObjectFailure {
- EntityList returnList = null;
- if (comment != null) {
- // get all to_topic from media_x_topic
- String id = comment.getId();
- String subselect = "id in (select media_id from " + theTable +
- " where comment_id=" + id + ")";
-
- try {
- // media should stay in uploaded order. this is especially important
- // for photo stories which require a specific chronologic order.
- // this is why we have the the second parameter "id"
- returnList = DatabaseMedia.getInstance().selectByWhereClause(subselect,
- "id", -1);
- }
- catch (Throwable e) {
- logger.debug("-- get media failed " + e.toString());
- throw new StorageObjectFailure("-- get media failed ", e);
- }
- }
- return returnList;
- }
-
public boolean hasMedia(EntityComment comment) throws StorageObjectFailure,
StorageObjectExc {
if (comment != null) {