X-Git-Url: http://erislabs.net/gitweb/?a=blobdiff_plain;f=source%2Fmircoders%2Fstorage%2FDatabaseUploadedMedia.java;h=97294fb989b5d8a646100794c4330535e28fcb83;hb=d06e23e638f2538f263af76bd32da6b140f20ac6;hp=1fd6eee5be6e53c58a408b61a761b54a365cdef9;hpb=b5dfdb12e72c15762c6a9d21a3d37db9ba97c92a;p=mir.git

diff --git a/source/mircoders/storage/DatabaseUploadedMedia.java b/source/mircoders/storage/DatabaseUploadedMedia.java
index 1fd6eee5..97294fb9 100755
--- a/source/mircoders/storage/DatabaseUploadedMedia.java
+++ b/source/mircoders/storage/DatabaseUploadedMedia.java
@@ -1,5 +1,5 @@
 /*
- * Copyright (C) 2001, 2002  The Mir-coders group
+ * Copyright (C) 2001, 2002 The Mir-coders group
  *
  * This file is part of Mir.
  *
@@ -18,82 +18,68 @@
  * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
  *
  * In addition, as a special exception, The Mir-coders gives permission to link
- * the code of this program with the com.oreilly.servlet library, any library
- * licensed under the Apache Software License, The Sun (tm) Java Advanced
- * Imaging library (JAI), The Sun JIMI library (or with modified versions of
- * the above that use the same license as the above), and distribute linked
- * combinations including the two.  You must obey the GNU General Public
- * License in all respects for all of the code used other than the above
- * mentioned libraries.  If you modify this file, you may extend this exception
- * to your version of the file, but you are not obligated to do so.  If you do
- * not wish to do so, delete this exception statement from your version.
+ * the code of this program with  any library licensed under the Apache Software License,
+ * The Sun (tm) Java Advanced Imaging library (JAI), The Sun JIMI library
+ * (or with modified versions of the above that use the same license as the above),
+ * and distribute linked combinations including the two.  You must obey the
+ * GNU General Public License in all respects for all of the code used other than
+ * the above mentioned libraries.  If you modify this file, you may extend this
+ * exception to your version of the file, but you are not obligated to do so.
+ * If you do not wish to do so, delete this exception statement from your version.
  */
 
 package mircoders.storage;
 
-import mir.log.LoggerWrapper;
+import java.util.Iterator;
+
 import mir.entity.Entity;
-import mir.entity.EntityRelation;
+import mir.entity.EntityBrowser;
+import mir.log.LoggerWrapper;
 import mir.storage.Database;
-import mir.storage.StorageObject;
-import mir.storage.StorageObjectExc;
-import mir.storage.StorageObjectFailure;
-
-/**
- * <b>this class implements the access to the content-table</b>
- *
- *
- */
-
-public class DatabaseUploadedMedia extends Database implements StorageObject {
+import mir.storage.DatabaseFailure;
+import mircoders.entity.EntityUploadedMedia;
 
-  private static DatabaseUploadedMedia  instance;
-  private static EntityRelation         relationMediaType;
-
-  // Contructors / Singleton
-
-  public static DatabaseUploadedMedia getInstance()
-    throws StorageObjectFailure {
+public class DatabaseUploadedMedia extends Database  {
+  private static DatabaseUploadedMedia instance;
 
+  public static synchronized DatabaseUploadedMedia getInstance() {
     if (instance == null ) {
       instance = new DatabaseUploadedMedia();
-      instance.myselfDatabase = instance;
     }
+
     return instance;
   }
 
-  private DatabaseUploadedMedia()
-    throws StorageObjectFailure {
-
-    super();
-
+  private DatabaseUploadedMedia() {
     logger = new LoggerWrapper("Database.UploadedMedia");
 
-    this.theTable="uploaded_media";
-    this.theCoreTable="media";
-    relationMediaType = new EntityRelation("to_media_type", "id", DatabaseMediaType.getInstance(), EntityRelation.TO_ONE);
-    try { this.theEntityClass = Class.forName("mircoders.entity.EntityUploadedMedia"); }
-    catch (Exception e) { throw new StorageObjectFailure(e); }
+    mainTable="uploaded_media";
+    entityClass = EntityUploadedMedia.class;
   }
 
-  // methods
-
 
   /**
    * returns the media_type that belongs to the media item (via entityrelation)
    * where db-flag is_published is true
    */
-  public Entity getMediaType(Entity ent) throws StorageObjectFailure {
+  public Entity getMediaType(Entity aMedia) throws DatabaseFailure {
     Entity type=null;
     try {
-      type = relationMediaType.getOne(ent);
+      Iterator i = new EntityBrowser(DatabaseMediaType.getInstance(), aMedia.getFieldValue("to_media_type") + " = id" , "id", 1);
+
+      if (i.hasNext()) {
+        type = (Entity) i.next();
+      }
     }
     catch (Throwable t) {
       logger.error("DatabaseUploadedMedia :: failed to get media_type: " + t.getMessage());
 
-      throw new StorageObjectFailure("DatabaseUploadedMedia :: failed to get media_type", t);
+      throw new DatabaseFailure("DatabaseUploadedMedia :: failed to get media_type", t);
     }
     return type;
   }
 
+  protected String getPrimaryKeySequence() {
+    return "media_id_seq";
+  }
 }