com.openindex.openestate.impl.db.hsql

Class HSqlDbFilesHandler

java.lang.Object

com.openindex.openestate.impl.db.DbHandlerImpl

com.openindex.openestate.impl.db.DbFilesHandlerImpl

com.openindex.openestate.impl.db.hsql.HSqlDbFilesHandler

All Implemented Interfaces:

DbFilesHandler, DbHandler

public class HSqlDbFilesHandler
extends DbFilesHandlerImpl

HSqlDbFilesHandler.

Author:

Andreas Rudolph

Field Summary

Fields

Modifier and Type	Field and Description
static String	FIELD_FILE_CONTENT
static String	FIELD_FILE_CONTENT_PREVIEW
static String	FIELD_FILE_HASH
static String	FIELD_FILE_ID
static String	FIELD_FILE_IMAGE_HEIGHT
static String	FIELD_FILE_IMAGE_WIDTH
static String	FIELD_FILE_MIMETYPE
static String	FIELD_FILE_NAME
static String	FIELD_FILE_POSITION
static String	FIELD_FILE_PUBLISHED
static String	FIELD_FILE_SIZE
static String	FIELD_FILE_TYPE
static String	FIELD_FILE_URL
static String	FIELD_I18N_TITLE
static String	PROC_REMOVE_FILES
static String	PROC_REMOVE_FILES_I18N
static String	PROC_SAVE_FILES
static String	PROC_SAVE_FILES_I18N
static String	PROC_SET_FILES_CONTENT
static String	VIEW_FILES
static String	VIEW_FILES_CONTENT
static String	VIEW_FILES_I18N
static String	VIEW_FILES_PREVIEW

Constructor Summary

Constructors

Constructor and Description
HSqlDbFilesHandler()
HSqlDbFilesHandler(String schema)

Method Summary

Modifier and Type	Method and Description
protected DbFile	buildFile(ResultSet result)
boolean	downloadContent(Connection c, long fileId, OutputStream output)
boolean	downloadPreview(Connection c, long fileId, OutputStream output)
long[]	getFileIds(Connection c, long objectId, Boolean published, String mimeType)
DbFile[]	getFiles(Connection c, long[] ids)
DbFile[]	getFiles(Connection c, long objectId, Boolean published, String mimeType)
DbFile[]	getFiles(Connection c, String[] hashes)
void	loadFileTranslations(Connection c, DbFile[] files, Map<Long,String> languageMap)
void	removeFiles(Connection c, long[] ids)
void	saveFile(Connection c, DbFile file, File content, File preview, Map<Long,String> languageMap)
protected void	saveFileAdditionally(Connection c, DbFile file, long fileId, List<Statement> statements)
void	setFileContent(Connection c, long fileId, File content, File preview)

Methods inherited from class com.openindex.openestate.impl.db.DbFilesHandlerImpl

createFile, getFile, getFile, getFileIds, getFiles, loadFileTranslations, loadFileTranslations, loadFileTranslations, removeFile, saveFile, saveFile

Methods inherited from class com.openindex.openestate.impl.db.DbHandlerImpl

getSchema, getSchemaPath, setSchema

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface com.openindex.openestate.impl.db.DbHandler

getSchema, setSchema

Field Detail

PROC_REMOVE_FILES

public static final String PROC_REMOVE_FILES

See Also:

Constant Field Values

PROC_REMOVE_FILES_I18N

public static final String PROC_REMOVE_FILES_I18N

See Also:

Constant Field Values

PROC_SAVE_FILES

public static final String PROC_SAVE_FILES

See Also:

Constant Field Values

PROC_SAVE_FILES_I18N

public static final String PROC_SAVE_FILES_I18N

See Also:

Constant Field Values

PROC_SET_FILES_CONTENT

public static final String PROC_SET_FILES_CONTENT

See Also:

Constant Field Values

VIEW_FILES

public static final String VIEW_FILES

See Also:

Constant Field Values

VIEW_FILES_CONTENT

public static final String VIEW_FILES_CONTENT

See Also:

Constant Field Values

VIEW_FILES_I18N

public static final String VIEW_FILES_I18N

See Also:

Constant Field Values

VIEW_FILES_PREVIEW

public static final String VIEW_FILES_PREVIEW

See Also:

Constant Field Values

FIELD_FILE_ID

public static final String FIELD_FILE_ID

See Also:

Constant Field Values

FIELD_FILE_NAME

public static final String FIELD_FILE_NAME

See Also:

Constant Field Values

FIELD_FILE_URL

public static final String FIELD_FILE_URL

See Also:

Constant Field Values

FIELD_FILE_CONTENT

public static final String FIELD_FILE_CONTENT

See Also:

Constant Field Values

FIELD_FILE_CONTENT_PREVIEW

public static final String FIELD_FILE_CONTENT_PREVIEW

See Also:

Constant Field Values

FIELD_FILE_HASH

public static final String FIELD_FILE_HASH

See Also:

Constant Field Values

FIELD_FILE_MIMETYPE

public static final String FIELD_FILE_MIMETYPE

See Also:

Constant Field Values

FIELD_FILE_PUBLISHED

public static final String FIELD_FILE_PUBLISHED

See Also:

Constant Field Values

FIELD_FILE_TYPE

public static final String FIELD_FILE_TYPE

See Also:

Constant Field Values

FIELD_FILE_SIZE

public static final String FIELD_FILE_SIZE

See Also:

Constant Field Values

FIELD_FILE_IMAGE_WIDTH

public static final String FIELD_FILE_IMAGE_WIDTH

See Also:

Constant Field Values

FIELD_FILE_IMAGE_HEIGHT

public static final String FIELD_FILE_IMAGE_HEIGHT

See Also:

Constant Field Values

FIELD_FILE_POSITION

public static final String FIELD_FILE_POSITION

See Also:

Constant Field Values

FIELD_I18N_TITLE

public static final String FIELD_I18N_TITLE

See Also:

Constant Field Values

Constructor Detail

HSqlDbFilesHandler

public HSqlDbFilesHandler()

HSqlDbFilesHandler

public HSqlDbFilesHandler(String schema)

Method Detail

buildFile

protected DbFile buildFile(ResultSet result)
                    throws SQLException

Throws:

SQLException

downloadContent

public boolean downloadContent(Connection c,
                               long fileId,
                               OutputStream output)
                        throws SQLException,
                               IOException

Specified by:

downloadContent in interface DbFilesHandler

Specified by:

downloadContent in class DbFilesHandlerImpl

Throws:

SQLException

IOException

downloadPreview

public boolean downloadPreview(Connection c,
                               long fileId,
                               OutputStream output)
                        throws SQLException,
                               IOException

Specified by:

downloadPreview in interface DbFilesHandler

Specified by:

downloadPreview in class DbFilesHandlerImpl

Throws:

SQLException

IOException

getFiles

public DbFile[] getFiles(Connection c,
                         long[] ids)
                  throws SQLException

Specified by:

getFiles in interface DbFilesHandler

Specified by:

getFiles in class DbFilesHandlerImpl

Throws:

SQLException

getFiles

public DbFile[] getFiles(Connection c,
                         String[] hashes)
                  throws SQLException

Specified by:

getFiles in interface DbFilesHandler

Specified by:

getFiles in class DbFilesHandlerImpl

Throws:

SQLException

getFiles

public DbFile[] getFiles(Connection c,
                         long objectId,
                         Boolean published,
                         String mimeType)
                  throws SQLException

Specified by:

getFiles in interface DbFilesHandler

Specified by:

getFiles in class DbFilesHandlerImpl

Throws:

SQLException

getFileIds

public long[] getFileIds(Connection c,
                         long objectId,
                         Boolean published,
                         String mimeType)
                  throws SQLException

Specified by:

getFileIds in interface DbFilesHandler

Specified by:

getFileIds in class DbFilesHandlerImpl

Throws:

SQLException

loadFileTranslations

public void loadFileTranslations(Connection c,
                                 DbFile[] files,
                                 Map<Long,String> languageMap)
                          throws SQLException

Specified by:

loadFileTranslations in interface DbFilesHandler

Specified by:

loadFileTranslations in class DbFilesHandlerImpl

Throws:

SQLException

removeFiles

public void removeFiles(Connection c,
                        long[] ids)
                 throws SQLException

Specified by:

removeFiles in interface DbFilesHandler

Specified by:

removeFiles in class DbFilesHandlerImpl

Throws:

SQLException

saveFile

public void saveFile(Connection c,
                     DbFile file,
                     File content,
                     File preview,
                     Map<Long,String> languageMap)
              throws SQLException,
                     IOException

Specified by:

saveFile in interface DbFilesHandler

Specified by:

saveFile in class DbFilesHandlerImpl

Throws:

SQLException

IOException

saveFileAdditionally

protected void saveFileAdditionally(Connection c,
                                    DbFile file,
                                    long fileId,
                                    List<Statement> statements)
                             throws SQLException

Throws:

SQLException

setFileContent

public void setFileContent(Connection c,
                           long fileId,
                           File content,
                           File preview)
                    throws SQLException,
                           IOException

Specified by:

setFileContent in interface DbFilesHandler

Specified by:

setFileContent in class DbFilesHandlerImpl

Throws:

SQLException

IOException