com.silverpeas.gallery.dao
Class PhotoDAO

java.lang.Object
  com.silverpeas.gallery.dao.PhotoDAO

public class PhotoDAO
extends Object

Method Summary

static void	addPhotoPath(Connection con, String photoId, String albumId, String instanceId)
static void	createPath(Connection con, Photo photo, String albumId)
static String	createPhoto(Connection con, Photo photo)
static void	deletePhotoPath(Connection con, String photoId, String instanceId)
static Collection<Photo>	getAllPhoto(Connection con, String albumId, String instanceId, MediaCriteria.VISIBILITY visibility)
static Collection<Photo>	getAllPhotoEndVisible(Connection con, int nbDays)
static Collection<Photo>	getLastRegisteredMedia(Connection con, String instanceId) Gets last uploaded media.
static Photo	getPhoto(Connection con, String photoId)
static Collection<Photo>	getPhotoNotVisible(Connection con, String instanceId)
static void	removePhoto(Connection con, String photoId)
static void	updatePhoto(Connection con, Photo photo)

Methods inherited from class java.lang.Object

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

Method Detail

getPhoto

public static Photo getPhoto(Connection con,
                             String photoId)
                      throws SQLException

Throws:

SQLException

getAllPhoto

public static Collection<Photo> getAllPhoto(Connection con,
                                            String albumId,
                                            String instanceId,
                                            MediaCriteria.VISIBILITY visibility)
                                     throws SQLException

Throws:

SQLException

getPhotoNotVisible

public static Collection<Photo> getPhotoNotVisible(Connection con,
                                                   String instanceId)
                                            throws SQLException

Throws:

SQLException

getAllPhotoEndVisible

public static Collection<Photo> getAllPhotoEndVisible(Connection con,
                                                      int nbDays)
                                               throws SQLException

Throws:

SQLException

createPhoto

public static String createPhoto(Connection con,
                                 Photo photo)
                          throws SQLException,
                                 com.stratelia.webactiv.util.exception.UtilException

Throws:

SQLException

com.stratelia.webactiv.util.exception.UtilException

createPath

public static void createPath(Connection con,
                              Photo photo,
                              String albumId)
                       throws SQLException,
                              com.stratelia.webactiv.util.exception.UtilException

Throws:

SQLException

com.stratelia.webactiv.util.exception.UtilException

updatePhoto

public static void updatePhoto(Connection con,
                               Photo photo)
                        throws SQLException

Throws:

SQLException

removePhoto

public static void removePhoto(Connection con,
                               String photoId)
                        throws SQLException

Throws:

SQLException

getLastRegisteredMedia

public static Collection<Photo> getLastRegisteredMedia(Connection con,
                                                       String instanceId)
                                                throws SQLException

Gets last uploaded media.

Parameters:

con - a database connection

instanceId - the gallery application instance identifier

Returns:

a collection of last uploaded photos

Throws:

SQLException

deletePhotoPath

public static void deletePhotoPath(Connection con,
                                   String photoId,
                                   String instanceId)
                            throws SQLException

Throws:

SQLException

addPhotoPath

public static void addPhotoPath(Connection con,
                                String photoId,
                                String albumId,
                                String instanceId)
                         throws SQLException

Throws:

SQLException