X-Git-Url: http://erislabs.net/gitweb/?a=blobdiff_plain;f=source%2Fmircoders%2Fentity%2FEntityContent.java;h=96ab2dc9b29a75d8b41a8cdbc48beab677e37acc;hb=b7ea95152eaddbf069564a5f2f117774165d36e6;hp=e08494ed5d828db8ac95d43b6ae70446087022d0;hpb=3a661e8f0f659ab5ed2ac0e4d982ac0b398d11f1;p=mir.git diff --git a/source/mircoders/entity/EntityContent.java b/source/mircoders/entity/EntityContent.java index e08494ed..96ab2dc9 100755 --- a/source/mircoders/entity/EntityContent.java +++ b/source/mircoders/entity/EntityContent.java @@ -1,205 +1,128 @@ -package mircoders.entity; - -import java.lang.*; -import java.io.*; -import java.util.*; -import java.sql.*; +/* + * Copyright (C) 2001, 2002 The Mir-coders group + * + * This file is part of Mir. + * + * Mir is free software; you can redistribute it and/or modify + * it under the terms of the GNU General Public License as published by + * the Free Software Foundation; either version 2 of the License, or + * (at your option) any later version. + * + * Mir is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU General Public License for more details. + * + * You should have received a copy of the GNU General Public License + * along with Mir; if not, write to the Free Software + * 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 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. + */ -import freemarker.template.*; +package mircoders.entity; -import mir.entity.*; -import mir.misc.*; -import mir.storage.*; +import java.sql.Connection; +import java.sql.SQLException; +import java.sql.Statement; +import java.util.Map; -import mircoders.storage.*; +import mir.entity.AbstractEntity; +import mir.log.LoggerWrapper; +import mir.storage.DatabaseFailure; +import mircoders.storage.DatabaseContentToMedia; /** * this class implements mapping of one line of the database table content * to a java object * - * @author RK - * @version 2001 + * @version $Id: EntityContent.java,v 1.19.2.12 2005/10/30 00:46:58 zapata Exp $ + * @author mir-coders group + * */ -public class EntityContent extends AbstractEntity implements Entity -{ - - private static int instances; - - // constructors - - public EntityContent() - { - super(); - instances++; - //content_data is now filed-type "text" - //streamedInput = new ArrayList(); - //streamedInput.add("content_data"); - } - - public EntityContent(StorageObject theStorage) { - this(); - setStorage(theStorage); - } - - public void finalize() { - instances--; - super.finalize(); +public class EntityContent extends AbstractEntity { + /** + * set is_produced flag for the article + */ + public void setProduced(boolean yesno) throws DatabaseFailure + { + String value = (yesno) ? "1":"0"; + 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 = database.obtainConnection(); + /** todo should be preparedStatement: faster!! */ + stmt = con.createStatement(); + database.executeUpdate(stmt,sql); + } + catch (DatabaseFailure e) { + throw e; + } + catch (SQLException e) { + throw new DatabaseFailure(e); + } + finally { + database.freeConnection(con,stmt); + } } - // - // methods - - /** - * set is_produced flag for the article - */ - - public void setProduced(boolean yesno) - { - Connection con=null;Statement stmt=null; - String value = (yesno) ? "1":"0"; - String sql = "update content set is_produced='" + value + "' where id='" + getId()+"'"; - try { - con = theStorageObject.getPooledCon(); - /** @todo should be preparedStatement: faster!! */ - stmt = con.createStatement(); - theStorageObject.executeUpdate(stmt,sql); - } catch (StorageObjectException e) { - theLog.printDebugInfo(e.toString() + "\n -- set produced failed"); - } catch (SQLException e) { - theLog.printDebugInfo(e.toString() + "\n -- set produced failed"); - } finally { - theStorageObject.freeConnection(con,stmt); - } - } - - - /** - * make openposting to newswire - */ - - public void newswire() - { - String sql = "update content set to_article_type='1', is_produced='0' where id='" + getId()+"'"; - try { - theStorageObject.executeUpdate(sql); - } catch (StorageObjectException e) { - theLog.printError(e.toString() + "newswire failed"); - } catch (SQLException e) { - theLog.printError(e.toString() + "newswire failed"); - } - } - - - /** - * dettach from media - */ - - public void dettach() - { - String sql = "update content set to_media=null, is_produced='0' where id='" + getId()+"'"; - try { - theStorageObject.executeUpdate(sql); - } catch (StorageObjectException e) { - theLog.printError(e.toString() + "dettach failed"); - } catch (SQLException e) { - theLog.printError(e.toString() + "dettach failed"); - } - } - - /** - * attach to media - */ - - public void attach(String mid) - { - if (mid!=null) { - String sql = "update content set to_media='" + mid + "', is_produced='0' where id='" + getId()+"'"; - try { - theStorageObject.executeUpdate(sql); - } catch (StorageObjectException e) { - theLog.printError(e.toString() + "attach failed"); - } catch (SQLException e) { - theLog.printError(e.toString() + "attach failed"); - } - } - else - theLog.printError("EntityContent: attach without mid"); - } - - /** - * overridden method getValues to include formatted date into every - * entityContent - */ - - public HashMap getValues() { - HashMap returnHash = super.getValues(); - String date=null; + /** + * Deattaches media from an article + * + * @param anArticleId + * @param aMediaId + * @throws DatabaseFailure + */ + public void dettach(String anArticleId, String aMediaId) throws DatabaseFailure + { + if (aMediaId!=null){ + DatabaseContentToMedia.getInstance().delete(anArticleId, aMediaId); + + setProduced(false); + } + } - if ((date=(String)returnHash.get("date"))!=null) - returnHash.put("date_formatted", StringUtil.webdbDate2readableDate(date)); - if ((date=(String)returnHash.get("webdb_create"))!=null) - returnHash.put("webdb_create_formatted", StringUtil.dateToReadableDate(date)); - if ((date=(String)returnHash.get("webdb_lastchange"))!=null) - returnHash.put("webdb_lastchange_formatted", StringUtil.dateToReadableDate(date)); - return returnHash; - } + /** + * Attaches media to the article + */ + + public void attach(String aMediaId) throws DatabaseFailure + { + if (aMediaId!=null) { + DatabaseContentToMedia.getInstance().addMedia(getId(),aMediaId); + setProduced(false); + } + else { + getLogger().error("EntityContent: attach without mid"); + } + } - /** - * overridden method setValues to patch creator_main_url - */ - public void setValues(HashMap 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://")){ + /** + * overridden method setFieldValues to patch creator_main_url + */ + public void setFieldValues(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); - } - - /** - * return the content_data as string - * is obsolete, because content_data is now sql-type text - - public String getContentData() - { - Connection con=null;Statement stmt=null; - byte[] content_data=null; - - try { - con = theStorageObject.getPooledCon(); - con.setAutoCommit(false); - stmt = con.createStatement(); - ResultSet rs = theStorageObject.executeSql(stmt,"select content_data from content where id="+getId()); - if(rs!=null) { - if (rs.next()) { - content_data = rs.getBytes(1); - } - rs.close(); - } - } - catch (Exception e) {theLog.printError("EntityContent :: getContent failed! "+e.toString());} - finally { - try {con.setAutoCommit(true); } catch (Exception e) {;} - theStorageObject.freeConnection(con,stmt); } - - return StringUtil.encodeHtml(StringUtil.unquote( new String(content_data) )); - } -*/ - - /** - * fetches all the comments belonging to an article - * - * @return freemarker.template.SimpleList - */ - public SimpleList getComments() { - return ((DatabaseContent)theStorageObject).getComments(this); - } - - + } + super.setFieldValues(theStringValues); + } }