testing extension xml parser for producer.xml

[mir.git] / source / mircoders / storage / DatabaseCommentToMedia.java

diff --git a/source/mircoders/storage/DatabaseCommentToMedia.java b/source/mircoders/storage/DatabaseCommentToMedia.java
index e0424d4..475f208 100755 (executable)
--- a/source/mircoders/storage/DatabaseCommentToMedia.java
+++ b/source/mircoders/storage/DatabaseCommentToMedia.java
@@ -30,24 +30,24 @@
 
 package mircoders.storage;
 
-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 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 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.2.1 2003/09/03 17:49:41 zapata Exp $
+ * @version $Id: DatabaseCommentToMedia.java,v 1.3.2.2 2003/11/24 23:37:18 rk Exp $
  *
  */
 
@@ -76,6 +76,7 @@ public class DatabaseCommentToMedia extends Database implements StorageObject{
       StorageObjectExc {
     if (comment != null) {
       try {
+        // TODO make this a count statement
         if (selectByWhereClause("comment_id=" + comment.getId(), -1).size() ==
             0)
           return false;
@@ -102,6 +103,7 @@ public class DatabaseCommentToMedia extends Database implements StorageObject{
   public EntityList getAudio(EntityComment comment) throws StorageObjectFailure {
     EntityList returnList = null;
     if (comment != null) {
+//    TODO rewrite as relational sql
       // get all to_topic from media_x_topic
       String id = comment.getId();
       //this is not supported by mysql
@@ -131,6 +133,7 @@ public class DatabaseCommentToMedia extends Database implements StorageObject{
   public EntityList getVideo(EntityComment comment) throws StorageObjectFailure {
     EntityList returnList = null;
     if (comment != null) {
+//    TODO rewrite as relational sql
       // get all to_topic from media_x_topic
       String id = comment.getId();
       //this is not supported by mysql
@@ -161,6 +164,7 @@ public class DatabaseCommentToMedia extends Database implements StorageObject{
       StorageObjectFailure {
     EntityList returnList = null;
     if (comment != null) {
+//    TODO rewrite as relational sql
       // get all to_topic from media_x_topic
       String id = comment.getId();
       //this is not supported by mysql
@@ -192,6 +196,7 @@ public class DatabaseCommentToMedia extends Database implements StorageObject{
 
     EntityList returnList = null;
     if (comment != null) {
+//    TODO rewrite as relational sql
       // get all to_topic from media_x_topic
       String id = comment.getId();
       //this is not supported by mysql
@@ -223,6 +228,7 @@ public class DatabaseCommentToMedia extends Database implements StorageObject{
 
     EntityList returnList = null;
     if (comment != null) {
+//    TODO rewrite as relational sql
       // get all to_topic from media_x_topic
       String id = comment.getId();
       //this is not supported by mysql
@@ -446,6 +452,7 @@ public class DatabaseCommentToMedia extends Database implements StorageObject{
       StorageObjectFailure {
     EntityList returnList = null;
     if (media != null) {
+      // TODO rewrite as relational sql
       String id = media.getId();
       String select = "select comment_id from " + theTable + " where media_id=" +
           id;
@@ -491,6 +498,7 @@ public class DatabaseCommentToMedia extends Database implements StorageObject{
   public EntityList getComment() throws StorageObjectFailure {
     EntityList returnList = null;
 
+//  TODO rewrite as relational sql
     String select = "select distinct comment_id from " + theTable;
     // execute select statement
     Connection con = null;