X-Git-Url: http://erislabs.net/gitweb/?a=blobdiff_plain;f=source%2Fmircoders%2Fentity%2FEntityContent.java;h=64488d4958292726770af37eebf3f8fc42885435;hb=c26251faa299ed62d0e47c32636f440c554610ec;hp=4c76c9e90a07ddb018b8ece8b83e1e2fc8aaa314;hpb=12e4a04e3d6b16aa91029f125997d38a1f05aeb5;p=mir.git diff --git a/source/mircoders/entity/EntityContent.java b/source/mircoders/entity/EntityContent.java index 4c76c9e9..64488d49 100755 --- a/source/mircoders/entity/EntityContent.java +++ b/source/mircoders/entity/EntityContent.java @@ -30,92 +30,48 @@ package mircoders.entity; +import mir.entity.AbstractEntity; +import mir.storage.DatabaseFailure; +import mircoders.storage.DatabaseContentToMedia; + import java.sql.Connection; import java.sql.SQLException; import java.sql.Statement; -import java.util.HashMap; -import java.util.Map; - -import mir.entity.Entity; -import mir.entity.EntityList; -import mir.log.LoggerWrapper; -import mir.storage.StorageObject; -import mir.storage.StorageObjectExc; -import mir.storage.StorageObjectFailure; -import mircoders.storage.DatabaseContent; -import mircoders.storage.DatabaseContentToMedia; -import mircoders.storage.DatabaseContentToTopics; -import freemarker.template.SimpleScalar; -import freemarker.template.TemplateModel; -import freemarker.template.TemplateModelException; /** * this class implements mapping of one line of the database table content * to a java object * - * @version $Id: EntityContent.java,v 1.19.2.1 2003/06/19 02:24:12 zapata Exp $ + * @version $Id: EntityContent.java,v 1.19.2.13 2007/12/15 00:24:43 zapata Exp $ * @author mir-coders group * */ -public class EntityContent extends Entity -{ - - String mirconf_extLinkName = configuration.getString("Producer.ExtLinkName"); - String mirconf_intLinkName = configuration.getString("Producer.IntLinkName"); - String mirconf_mailLinkName = configuration.getString("Producer.MailLinkName"); - String mirconf_imageRoot = configuration.getString("Producer.ImageRoot"); - - //this should always be transient i.e it can never be stored in the db - //or ObjectStore. (so the ObjectStore should only be caching what comes - //directly out of the DB. @todo confirm this with rk. -mh - Map _entCache = new HashMap(); - Boolean _hasMedia = null; - - // constructors - - public EntityContent() - { - super(); - - logger = new LoggerWrapper("Entity.Content"); - } - - public EntityContent(StorageObject theStorage) { - this(); - - setStorage(theStorage); - } - - // - // methods - +public class EntityContent extends AbstractEntity { /** * set is_produced flag for the article */ - - public void setProduced(boolean yesno) throws StorageObjectFailure - { + public void setProduced(boolean yesno) throws DatabaseFailure { String value = (yesno) ? "1":"0"; - if (value.equals( getValue("is_produced") )) return; + if (value.equals( getFieldValue("is_produced") )) return; Connection con=null;Statement stmt=null; String sql = "update content set is_produced='" + value + "' where id='" + getId()+"'"; try { - con = theStorageObject.getPooledCon(); - /** @todo should be preparedStatement: faster!! */ + con = database.obtainConnection(); + /** todo should be preparedStatement: faster!! */ stmt = con.createStatement(); - theStorageObject.executeUpdate(stmt,sql); + database.executeUpdate(stmt,sql); } - catch (StorageObjectFailure e) { - throwStorageObjectFailure(e, "\n -- set produced failed"); + catch (DatabaseFailure e) { + throw e; } catch (SQLException e) { - throwStorageObjectFailure(e, "\n -- set produced failed"); + throw new DatabaseFailure(e); } finally { - theStorageObject.freeConnection(con,stmt); + database.freeConnection(con,stmt); } } @@ -124,201 +80,27 @@ public class EntityContent extends Entity * * @param anArticleId * @param aMediaId - * @throws StorageObjectFailure + * @throws DatabaseFailure */ - public void dettach(String anArticleId, String aMediaId) throws StorageObjectFailure - { + public void dettach(String anArticleId, String aMediaId) throws DatabaseFailure { if (aMediaId!=null){ - try{ - DatabaseContentToMedia.getInstance().delete(anArticleId, aMediaId); - } - catch (Exception e){ - throwStorageObjectFailure(e, "\n -- failed to get instance"); - } + DatabaseContentToMedia.getInstance().delete(anArticleId, aMediaId); setProduced(false); } } /** - * Attaches media to an article - * - * @param mid - * @throws StorageObjectFailure + * Attaches media to the article */ - public void attach(String aMediaId) throws StorageObjectFailure - { - if (aMediaId!=null) { - try{ - DatabaseContentToMedia.getInstance().addMedia(getId(),aMediaId); - } - catch(StorageObjectFailure e){ - throwStorageObjectFailure(e, "attach: could not get the instance"); - } + public void attach(String aMediaId) throws DatabaseFailure { + if (aMediaId != null) { + DatabaseContentToMedia.getInstance().addMedia(getId(),aMediaId); setProduced(false); } else { - logger.error("EntityContent: attach without mid"); + getLogger().error("EntityContent: attach without mid"); } } - - /** - * overridden method getValue to include formatted date into every - * entityContent - */ - - public TemplateModel get(java.lang.String key) throws TemplateModelException - { - if (key!=null) { - if (_entCache.containsKey(key)) { - return (TemplateModel)_entCache.get(key); - } -/* if (key.equals("to_comments")) { - try { - _entCache.put(key, getComments()); - return (TemplateModel)_entCache.get(key); - } - catch (Exception ex) { - logger.warn("EntityContent.getComments: could not fetch data " + ex.toString()); - - throw new TemplateModelException(ex.toString()); - } - } - if (key.equals("to_media_images")) { - try { - _entCache.put(key, getImagesForContent()); - return (TemplateModel)_entCache.get(key); - } - catch (Exception ex) { - logger.warn("EntityContent.getImagesForContent: could not fetch data " + ex.toString()); - throw new TemplateModelException(ex.toString()); - } - } - if (key.equals("to_media_audio")) { - try { - _entCache.put(key, getAudioForContent()); - return (TemplateModel)_entCache.get(key); - } - catch (Exception ex) { - logger.warn("EntityContent.getAudioForContent: could not fetch data " + ex.toString()); - throw new TemplateModelException(ex.toString()); - } - } - if (key.equals("to_media_video")) { - try { - _entCache.put(key, getVideoForContent()); - return (TemplateModel)_entCache.get(key); - } - catch (Exception ex) { - logger.warn("EntityContent.getVideoForContent: could not fetch data " + ex.toString()); - throw new TemplateModelException(ex.toString()); - } - } - if (key.equals("to_media_other")) { - try { - _entCache.put(key, getOtherMediaForContent()); - return (TemplateModel)_entCache.get(key); - } - catch (Exception ex) { - logger.warn("EntityContent.getOtherMediaForContent: could not fetch data " + ex.toString()); - throw new TemplateModelException(ex.toString()); - } - } - else if (key.equals("to_topics")) { - try { - _entCache.put(key, - DatabaseContentToTopics.getInstance().getTopics(this)); - return (TemplateModel)_entCache.get(key); - } - catch (Exception ex) { - logger.warn("EntityContent.getTopics: could not fetch data " + ex.toString()); - throw new TemplateModelException(ex.toString()); - } - } - else { - return new SimpleScalar(getValue(key)); - } -*/ - } - return null; - } - - /** - * overridden method setValues to patch creator_main_url - */ - public void setValues(Map theStringValues) { - if (theStringValues != null) { - if (theStringValues.containsKey("creator_main_url")){ - if (((String)theStringValues.get("creator_main_url")).equalsIgnoreCase("http://")){ - theStringValues.remove("creator_main_url"); - } - else if (!((String)theStringValues.get("creator_main_url")).startsWith("http://")){ - theStringValues.put("creator_main_url","http://"+((String)theStringValues.get("creator_main_url"))); - } - } - } - super.setValues(theStringValues); - } - - /** - * fetches all the comments belonging to an article - * - * @return freemarker.template.SimpleList - */ -// private EntityList getComments() throws StorageObjectFailure { -// return ((DatabaseContent)theStorageObject).getComments(this); -// } - - private boolean hasMedia() throws StorageObjectFailure - { - if (_hasMedia == null) { - try { - _hasMedia = - new Boolean(DatabaseContentToMedia.getInstance().hasMedia(this)); - } catch (StorageObjectExc e) { - throw new StorageObjectFailure(e); - } - } - return _hasMedia.booleanValue(); - } - - //######## @todo all of the following getBlahForContent should have - // and optimized version where LIMIT=1 sql for list view. - private EntityList getImagesForContent() - throws StorageObjectFailure, TemplateModelException - { - if (hasMedia()) - return DatabaseContentToMedia.getInstance().getImages(this); - else - return null; - } - - private EntityList getAudioForContent() - throws StorageObjectFailure, TemplateModelException - { - if (hasMedia()) - return DatabaseContentToMedia.getInstance().getAudio(this) ; - else - return null; - } - - private EntityList getVideoForContent() - throws StorageObjectFailure, TemplateModelException - { - if (hasMedia()) - return DatabaseContentToMedia.getInstance().getVideo(this) ; - else - return null; - } - - private EntityList getOtherMediaForContent() - throws StorageObjectFailure, TemplateModelException - { - if (hasMedia()) - return DatabaseContentToMedia.getInstance().getOther(this); - else - return null; - } - }