com.buckosoft.PicMan.db

Class PicsDaoJdbc

java.lang.Object

com.buckosoft.PicMan.db.PicsDaoJdbc

All Implemented Interfaces:

PicsDao

public class PicsDaoJdbc
extends java.lang.Object
implements PicsDao

Implement the Dao Interface for the Pics.

Since:

2005/07/31

Author:

Dick Balaska

See Also:

PicsDaoJdbc.java

Constructor Summary

Constructors

Constructor and Description
PicsDaoJdbc()

Method Summary

Modifier and Type	Method and Description
void	addPic(Pic pic) Add this Pic to the database.
int	getMaxThumbCacheDirUsed() Determine the highest numbered thumb cache subdirectory used.
Pic	getNewestPic() Get the newest pic in the database.
Pic	getPic(int pid) Get a single Pic
Pic	getPic(java.lang.String name) Get a single named Pic
int	getPicCount()
int	getPicCount(int rid) Return how many pics live in this root.
java.util.List<java.lang.String>	getPicNames() Get a List of names all of the pics in the database.
java.util.List<java.lang.String>	getPicNamesByDateFunc(java.lang.String operator, java.lang.String operand) Get a list of pic names that pass this date function.
java.util.List<java.lang.String>	getPicNamesByRootFunc(java.lang.String operator, int rid)
java.util.List<Pic>	getPics() Get a List of all the pics in the database
java.util.List<Pic>	getPics(java.util.List<java.lang.String> list) Get a List of Pics from this List of picNames.
java.util.List<Pic>	getPics(java.lang.String name) Get a list of Pics, wildcards supported
java.util.List<Pic>	getPicsByMD5Sum(long md5sum) Return a list of Pics that have this md5Sum
java.util.List<Pic>	getPicsInDir(int rid, java.lang.String dirName) Get a list of Pics that are in this subdirectory
java.util.HashMap<java.lang.String,java.util.Date>	getPicsMap() Get a HashMap of all of the Pic names in the database.
java.util.List<Pic>	getPicsNewerThan(java.util.Calendar calendar) Get a list of Pics that are newer than this date
Pic	getRandomPic() Return a random pic from the database
Pic	getRandomPic(int rid) Return a random pic from the database that lives in this root
int	getThumbCacheFillCount(int cacheDir) Determine how many thumb cache entries are in this thumb dir
void	setDataSource(javax.sql.DataSource ds) Set the reference to the JDBC datasource.
void	updatePic(Pic pic) Update this Pic in the database

Methods inherited from class java.lang.Object

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

Constructor Detail

PicsDaoJdbc

public PicsDaoJdbc()

Method Detail

setDataSource

public void setDataSource(javax.sql.DataSource ds)

Set the reference to the JDBC datasource.

Parameters:

ds - The datasource as configured by Spring.

See Also:

picManDatabase.xml

getPics

public java.util.List<Pic> getPics()

Get a List of all the pics in the database

Specified by:

getPics in interface PicsDao

Returns:

The (probably big) List

getPic

public Pic getPic(java.lang.String name)

Get a single named Pic

Specified by:

getPic in interface PicsDao

Parameters:

name - The name of the pic to fetch

Returns:

The Pic that matches this picName or null.

getPic

public Pic getPic(int pid)

Get a single Pic

Specified by:

getPic in interface PicsDao

Parameters:

pid - The pid of the pic to fetch

Returns:

The Pic

getNewestPic

public Pic getNewestPic()

Description copied from interface: PicsDao

Get the newest pic in the database.

Specified by:

getNewestPic in interface PicsDao

Returns:

The Pic with the newest Timestamp

getRandomPic

public Pic getRandomPic()

Description copied from interface: PicsDao

Return a random pic from the database

Specified by:

getRandomPic in interface PicsDao

Returns:

Any pic from the database

getRandomPic

public Pic getRandomPic(int rid)

Description copied from interface: PicsDao

Return a random pic from the database that lives in this root

Specified by:

getRandomPic in interface PicsDao

Returns:

Any pic from the database

getPics

public java.util.List<Pic> getPics(java.lang.String name)

Get a list of Pics, wildcards supported

Specified by:

getPics in interface PicsDao

Parameters:

name - The name of the Pic to match (user must supply sql '%' for wildcards)

Returns:

The List

getPicsByMD5Sum

public java.util.List<Pic> getPicsByMD5Sum(long md5sum)

Description copied from interface: PicsDao

Return a list of Pics that have this md5Sum

Specified by:

getPicsByMD5Sum in interface PicsDao

Returns:

The list, may be empty

getPics

public java.util.List<Pic> getPics(java.util.List<java.lang.String> list)

Description copied from interface: PicsDao

Get a List of Pics from this List of picNames.

Specified by:

getPics in interface PicsDao

Parameters:

list - A List of picNames to fetch

Returns:

The List

getPicsInDir

public java.util.List<Pic> getPicsInDir(int rid,
                                        java.lang.String dirName)

Description copied from interface: PicsDao

Get a list of Pics that are in this subdirectory

Specified by:

getPicsInDir in interface PicsDao

Parameters:

rid - Root id to search under

dirName - The directory, i.e. "2002/20021225"

Returns:

A List of Pic. The dirname will match any and all Roots

getPicsNewerThan

public java.util.List<Pic> getPicsNewerThan(java.util.Calendar calendar)

Description copied from interface: PicsDao

Get a list of Pics that are newer than this date

Specified by:

getPicsNewerThan in interface PicsDao

Parameters:

calendar - The date to compare to

Returns:

A List of Pics.

getPicsMap

public java.util.HashMap<java.lang.String,java.util.Date> getPicsMap()

Description copied from interface: PicsDao

Get a HashMap of all of the Pic names in the database.

Specified by:

getPicsMap in interface PicsDao

Returns:

The map

getPicNames

public java.util.List<java.lang.String> getPicNames()

Description copied from interface: PicsDao

Get a List of names all of the pics in the database.

Specified by:

getPicNames in interface PicsDao

Returns:

A big List of picNames

getPicNamesByDateFunc

public java.util.List<java.lang.String> getPicNamesByDateFunc(java.lang.String operator,
                                                              java.lang.String operand)

Description copied from interface: PicsDao

Get a list of pic names that pass this date function.

Specified by:

getPicNamesByDateFunc in interface PicsDao

Parameters:

operator - An index into the MetaSet rateOps table. i.e. = != < >

operand - the date to check. i.e. "2009-07-26"

Returns:

A List of pic names

getPicNamesByRootFunc

public java.util.List<java.lang.String> getPicNamesByRootFunc(java.lang.String operator,
                                                              int rid)

Specified by:

getPicNamesByRootFunc in interface PicsDao

addPic

public void addPic(Pic pic)

Description copied from interface: PicsDao

Add this Pic to the database.

Specified by:

addPic in interface PicsDao

Parameters:

pic - The Pic to add. pid is assumed to be 0.

updatePic

public void updatePic(Pic pic)
               throws DataAccessException

Update this Pic in the database

Specified by:

updatePic in interface PicsDao

Parameters:

pic - The Pic to store

Throws:

DataAccessException

getMaxThumbCacheDirUsed

public int getMaxThumbCacheDirUsed()

Description copied from interface: PicsDao

Determine the highest numbered thumb cache subdirectory used.

Specified by:

getMaxThumbCacheDirUsed in interface PicsDao

Returns:

the highest number, or 0 if no thumbs are cached.

getPicCount

public int getPicCount()

getPicCount

public int getPicCount(int rid)

Description copied from interface: PicsDao

Return how many pics live in this root.

Specified by:

getPicCount in interface PicsDao

Parameters:

rid - The root id to query.

Returns:

The number of Pics in this root.

getThumbCacheFillCount

public int getThumbCacheFillCount(int cacheDir)

Description copied from interface: PicsDao

Determine how many thumb cache entries are in this thumb dir

Specified by:

getThumbCacheFillCount in interface PicsDao

Parameters:

cacheDir - Which thumb cache directory to check

Returns:

The Count