X-Git-Url: http://erislabs.net/gitweb/?a=blobdiff_plain;f=source%2Fmircoders%2Fentity%2FEntityImages.java;h=019ee22cf2f1c3e1d885493b0f89e2889a0d32c5;hb=d74a52d5f65389e5cf89d3fcf14d07afbb78a9f9;hp=d495f0b784cbf5301d93852c4b9ab1a9b0283e6f;hpb=c6a2204d8d75293256fd17c07e54971d7672359a;p=mir.git diff --git a/source/mircoders/entity/EntityImages.java b/source/mircoders/entity/EntityImages.java index d495f0b7..019ee22c 100755 --- a/source/mircoders/entity/EntityImages.java +++ b/source/mircoders/entity/EntityImages.java @@ -1,218 +1,114 @@ -package mircoders.entity; - -import java.lang.*; -import java.io.*; -import java.util.*; -import java.sql.*; - /* - * kind of hack for postgres non-standard LargeObjects that Poolman - * doesn't know about. see all the casting, LargeObj stuff in getIcon, getImage - * at some point when postgres has normal BLOB support, this should go. + * 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 org.postgresql.Connection; -import org.postgresql.largeobject.LargeObject; -import org.postgresql.largeobject.LargeObjectManager; -import mir.entity.*; -import mir.misc.*; -import mir.storage.*; +package mircoders.entity; -/** - * Diese Klasse enthält die Daten eines MetaObjekts - * - * @author RK - * @version 11.11.2000 - */ +import mir.log.LoggerWrapper; +import mir.media.image.ImageMagickImageProcessor; +import mir.media.image.ImageProcessor; +import mir.storage.DatabaseFailure; +import java.io.ByteArrayOutputStream; +import java.io.InputStream; +import java.sql.SQLException; public class EntityImages extends EntityUploadedMedia { - public EntityImages() - { - super(); - } - - public EntityImages(StorageObject theStorage) { - this(); - setStorage(theStorage); - } - - // - // methods - - - - public byte[] getImage() throws StorageObjectException - { - theLog.printDebugInfo("--getimage started"); - java.sql.Connection con=null;Statement stmt=null; - byte[] img_data=null; - - try { - con = theStorageObject.getPooledCon(); - con.setAutoCommit(false); - LargeObjectManager lom; - java.sql.Connection jCon; - stmt = con.createStatement(); - ResultSet rs = theStorageObject.executeSql(stmt, - "select image_data from images where id="+getId()); - jCon = ((com.codestudio.sql.PoolManConnectionHandle)con) - .getNativeConnection(); - lom = ((org.postgresql.Connection)jCon).getLargeObjectAPI(); - if(rs!=null) { - if (rs.next()) { - LargeObject lob = lom.open(rs.getInt(1)); - img_data = lob.read(lob.size()); - System.err.println("LOB IMG SIZE: "+lob.size()); - lob.close(); - System.err.println("res set img NOT NULL2"); - //img_data = rs.getBytes(1); - } - rs.close(); - } - } catch (Exception e) { - e.printStackTrace(); - theLog.printError("EntityImages -- getImage failed"+e.toString()); - throwStorageObjectException(e, "EntityImages -- getImage failed: "); - } - finally { - try { - con.setAutoCommit(true); - } catch (Exception e) { - e.printStackTrace(); - theLog.printError( - "EntityImages -- getImage reseting transaction mode failed" - +e.toString()); - } - theStorageObject.freeConnection(con,stmt); - } - - return img_data; - } - - public void setImage(byte[] uploadData) - throws StorageObjectException { - - if (uploadData!=null) { - java.sql.Connection con=null;PreparedStatement pstmt=null; - try { - - theLog.printDebugInfo("settimage :: making internal representation of image"); - WebdbImage webdbImage= new WebdbImage(uploadData); - theLog.printDebugInfo("settimage :: made internal representation of image"); - byte[] imageData = webdbImage.getImage(); - theLog.printDebugInfo("settimage :: getImage"); - byte[] iconData = webdbImage.getIcon(); - theLog.printDebugInfo("settimage :: getIcon"); - - if (iconData!=null && imageData!=null) { - con = theStorageObject.getPooledCon(); - con.setAutoCommit(false); - theLog.printDebugInfo("settimage :: trying to insert image"); - - // setting values - LargeObjectManager lom; - java.sql.Connection jCon; - jCon = ((com.codestudio.sql.PoolManConnectionHandle)con) - .getNativeConnection(); - lom = ((org.postgresql.Connection)jCon).getLargeObjectAPI(); - int oidImage = lom.create(); - int oidIcon = lom.create(); - LargeObject lobImage = lom.open(oidImage); - LargeObject lobIcon = lom.open(oidIcon); - lobImage.write(imageData); - lobIcon.write(iconData); - lobImage.close(); - lobIcon.close(); - String sql = "update images set img_height='" - +webdbImage.getImageHeight() + - "',img_width='" + webdbImage.getImageWidth() + - "',icon_height='" + webdbImage.getIconHeight() + - "',icon_width='" + webdbImage.getIconWidth() - + "', image_data="+oidImage+", icon_data="+oidIcon - +" where id="+getId(); - theLog.printDebugInfo("settimage :: updating sizes: "+ sql); - pstmt = con.prepareStatement(sql); - //pstmt.setBytes(1, imageData); - //pstmt.setBytes(2, iconData); - pstmt.executeUpdate(); - sql="update content set is_produced='0' where to_media="+getId(); - pstmt = con.prepareStatement(sql); - pstmt.executeUpdate(); - } - } - catch (Exception e) {throwStorageObjectException(e, "settimage :: setImage gescheitert: ");} - finally { - try { if (con!=null) con.setAutoCommit(true); } catch (Exception e) {;} - theStorageObject.freeConnection(con,pstmt); } - } - } - - public void update() throws StorageObjectException { - super.update(); - try { - theStorageObject.executeUpdate("update content set is_produced='0' where to_media="+getId()); - } catch (SQLException e) { - throwStorageObjectException(e, "EntityImages :: update :: failed!! "); - } - } - - public void setValues(HashMap theStringValues) - { - if (theStringValues != null) { - if (!theStringValues.containsKey("is_published")) - theStringValues.put("is_published","0"); - } - super.setValues(theStringValues); - } - - public byte[] getIcon() throws StorageObjectException - { - java.sql.Connection con=null;Statement stmt=null; - byte[] img_data=null; - - try { - con = theStorageObject.getPooledCon(); - con.setAutoCommit(false); - LargeObjectManager lom; - java.sql.Connection jCon; - stmt = con.createStatement(); - ResultSet rs = theStorageObject.executeSql(stmt, - "select icon_data from images where id="+getId()); - jCon = ((com.codestudio.sql.PoolManConnectionHandle)con) - .getNativeConnection(); - lom = ((org.postgresql.Connection)jCon).getLargeObjectAPI(); - if(rs!=null) { - System.err.println("res set NOT NULL"); - if (rs.next()) { - LargeObject lob = lom.open(rs.getInt(1)); - img_data = lob.read(lob.size()); - System.err.println("LOB SIZE: "+lob.size()); - lob.close(); - System.err.println("res set NOT NULL2"); - //img_data = rs.getBytes(1); - System.err.println("res set NOT NULL3"); - } - rs.close(); - } - } catch (Exception e) { - e.printStackTrace(); - theLog.printError("EntityImages -- getIcon failed"+e.toString()); - throwStorageObjectException(e, "EntityImages -- getIcon failed:"); - } finally { - try { - con.setAutoCommit(true); - } catch (Exception e) { - e.printStackTrace(); - theLog.printError( - "EntityImages -- getIcon reseting transaction mode failed" - +e.toString()); - } - theStorageObject.freeConnection(con,stmt); - } - - return img_data; - } - + private int maxImageSize = configuration.getInt("Producer.Image.MaxSize"); + private int maxIconSize = configuration.getInt("Producer.Image.MaxIconSize"); + private float minDescaleRatio = configuration.getFloat("Producer.Image.MinDescalePercentage")/100; + private int minDescaleReduction = configuration.getInt("Producer.Image.MinDescaleReduction"); + + + public EntityImages() + { + super(); + } + + /** + * Retrieves the image data + */ + public byte[] getImage() throws DatabaseFailure { + try { + return database.getBinaryField("select image_data from images where id="+getId()); + } + catch (SQLException e) { + throw new DatabaseFailure(e); + } + } + + /** + * Processes and saves image data + */ + public void setImage(InputStream anInputStream, String type) throws DatabaseFailure { + if (anInputStream != null) { + try { + ImageProcessor processor = new ImageMagickImageProcessor(anInputStream); + + processor.descaleImage(maxImageSize, minDescaleRatio, minDescaleReduction); + + ByteArrayOutputStream imageData = new ByteArrayOutputStream(); + processor.writeScaledData(imageData, type); + database.setBinaryField("image_data", getId(), imageData.toByteArray()); + + setFieldValue("img_height", Integer.toString(processor.getScaledHeight())); + setFieldValue("img_width", Integer.toString(processor.getScaledWidth())); + + imageData.reset(); + processor.descaleImage(maxIconSize, minDescaleRatio, minDescaleReduction); + processor.writeScaledData(imageData, type); + database.setBinaryField("icon_data", getId(), imageData.toByteArray()); + + setFieldValue("icon_height", Integer.toString(processor.getScaledHeight())); + setFieldValue("icon_width", Integer.toString(processor.getScaledWidth())); + processor.cleanup(); + update(); + } + catch (Exception e) { + throw new DatabaseFailure(e); + } + } + } + + /** + * Takes an OutputStream as an argument and reads in the data + * from the DB and writes it to the OutputStream. + * + * It will also take care of closing the OutputStream. + */ + public byte[] getIcon() throws DatabaseFailure { + try { + return database.getBinaryField("select icon_data from images where id="+getId()); + } + catch (SQLException e) { + throw new DatabaseFailure(e); + } + } }