DatabaseImpl

java.lang.Object
- com.buckosoft.PicMan.db.DatabaseImpl

All Implemented Interfaces:

SetChangedListener, DatabaseFacade
```
public class DatabaseImpl
extends java.lang.Object
implements DatabaseFacade, SetChangedListener
```
Implement the API into the PicMan database

Since:

2006/07/17

Author:

Dick Balaska

See Also:

DatabaseImpl.java

Field Summary

Fields
Modifier and Type Field and Description

protected org.apache.commons.logging.Log logger

Fields
Modifier and Type	Field and Description
`protected org.apache.commons.logging.Log`	`logger`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`void`	`addContact(Contact c)` Add this `Contact` to the database.
`void`	`addFilter(Filter filter)` Add a `Filter` to the database, overwriting any existing filter for this pic.
`void`	`addPic(Pic pic)` Add this `Pic` to the database.
`void`	`addRoot(Root r)` Add this `Root` to the Database.
`void`	`addSet(Set s)` Add a new set to the database.
`void`	`addVirgin(java.lang.String pic)` Add this Pic name as a `Virgin` in the database.
`void`	`deleteChain(Chain chain)` Delete this `Chain` from the Database.
`void`	`deleteMosaic(int mid)` Delete the `Mosaic` from the database that has this Mosaic ID.
`void`	`deleteMosaicTiles(int mid)` Delete the `MosaicTile`s for the Mosaic specified by this Mosaic ID.
`void`	`deletePoster(int pid)` Delete the `Poster` from the database that has this Poster ID.
`void`	`deleteRoot(Root root)` Delete this `Root` from the database.
`void`	`deleteSet(Set s)` Delete this set from the database.
`void`	`deleteVirgin(java.lang.String pic)` Delete this Pic name from the `Virgin`s table.
`java.util.List<Root>`	`getActiveRoots()` Get a List of active `Root`s.
`java.util.List<Set>`	`getActiveSets()` Build a list of active sets
`Chain`	`getChain(int cid)` Fetch a `Chain` based on its Chain ID.
`Chain`	`getChain(java.lang.String chainName)` Fetch a `Chain` based on its name.
`int`	`getChainCount()` Return the number of `Chain`s in the Database.
`java.util.List<Chain>`	`getChains()` Get a List of all of the `Chain`s in the database.
`ChainsDao`	`getChainsDao()` Why is this public? Because Spring was freaking out trying to reflect the type.
`java.util.Date`	`getClientSyncTimestamp(java.lang.String host)` Get the last time this client sync'd.
`Contact`	`getContact(int cid, java.lang.String name)` Fetch the `Contact` that was built with these parameters.
`Contact`	`getContact(int cid, java.lang.String setName, int size, int item)` Fetch the `Contact` that was built with these parameters.
`java.util.HashMap<java.lang.String,java.util.Date>`	`getContactOldestMap(Chain chain)` Return the oldest contact in each set/size in a map k = SetName i.e.
`java.lang.String`	`getDbUrl()` Get the url that is accessing the database.
`java.lang.String`	`getDbUser()` Get the user who is accessing the database.
`Filter`	`getFilter(java.lang.String picName)` Get the `Filter` for the pic named.
`java.util.List<java.lang.String>`	`getFilterColumns()` Get a list of the `Filter` column names from the database.
`int`	`getFilterCount()` Get the number of `Filter`s in the database.
`java.util.List<Filter>`	`getFilters()` Get a list of all of the `Filter`s in the database.
`java.util.List<Filter>`	`getFiltersBySet(java.lang.String set, int size)` Get a list of all of the `Filter`s for this set/size.
`java.util.List<Root>`	`getInactiveRoots()` Get a List of Inactive `Root`s.
`java.util.List<Set>`	`getInactiveSets()` Build a list of inactive sets
`MetaSet`	`getMetaSet(int sid)` MetaSet Management
`java.util.List<java.lang.String>`	`getMetaSetColumns()` Get a List of Column names for the MetaSets.
`MetaSetFilter`	`getMetaSetFilter()` Fetch a reference to the MetaSet filter processor.
`Mosaic`	`getMosaic(int mid)` Get a `Mosaic` from the database based on this Mosaic ID.
`Mosaic`	`getMosaic(java.lang.String masterPic, java.lang.String engine, int sid, int tileHeight)` Find the `Mosaic` in the database that matches these parameters.
`MosaicBatch`	`getMosaicBatch(int mbid)` Get the MosaicBatch that matches this mbid
`java.util.List<MosaicBatch>`	`getMosaicBatches()` Get a List of `MosaicBatch`es in the database.
`java.util.List<Mosaic>`	`getMosaics()` Get a List of all of the `Mosaic`s in the database.
`int`	`getMosaicTileCount(int mid)` Return the number of tiles we have stored for this `Mosaic`
`java.util.List<MosaicTile>`	`getMosaicTiles(int mid)` Fetch the already built `MosaicTile`s for this Mosaic
`java.util.List<MosaicVector>`	`getMosaicVectors(java.util.List<Pic> picList)` Get the List of `MosaicVector`s that matches this picList, which probably came from a mosaic Set.
`Contact`	`getNewestContact()` Fetch the newest `Contact` made.
`Pic`	`getNewestPic()` Get the newest pic in the database.
`Pic`	`getPic(int pid)` Get a `Pic` who's pid matches this one.
`Pic`	`getPic(java.lang.String picName)` Get a `Pic` who's name matches this picName.
`java.util.List<java.lang.String>`	`getPicExtensions()` Return a list of file name extensions that denote pics that we are interested in.
`FilterMicroSet`	`getPicFromFilterMicroSet(int pid, int sid)` Get the `FilterMicroSet` for this pic in this set.
`int`	`getPicMaxThumbCacheDirUsed()` Determine the highest numbered thumb cache subdirectory used.
`java.util.List<java.lang.String>`	`getPicNamesByFunc(int func, int size, int rateOp, java.lang.String operand)` Get a List of the Pic Names that pass this function filter.
`java.util.List<java.lang.String>`	`getPicNamesBySet(MetaSet set, int size, int rateOp, int rateVal)` Get a List of the Pic Names of the `Filter`s that match this query.
`java.util.List<java.lang.String>`	`getPicNamesBySet(Set set, int size)` Get a List of the Pic Names of the `Filter`s that match this query.
`java.util.List<java.lang.String>`	`getPicNamesBySet(Set set, int size, int rateOp, int rateVal)` Get a List of the Pic Names of the `Filter`s that match this valued query.
`java.util.List<java.lang.String>`	`getPicNamesBySet(java.lang.String setName, int size)` Get a List of the Pic Names of the `Filter`s that match this query.
`java.util.List<java.lang.String>`	`getPicNamesBySet(java.lang.String setName, int size, int rateOp, int rateVal)` Get a List of the Pic Names of the `Filter`s that match this valued query.
`double`	`getPicRate(java.lang.String picName, MetaSet metaSet, int size)` Get the rating for this pic intersected by this MetaSet at this size
`double`	`getPicRate(java.lang.String picName, Set set, int size)` Get the rating for this pic intersected by this set at this size
`java.util.List<Pic>`	`getPics()` Get a List of all of the Pics.
`java.util.List<Pic>`	`getPics(Set set, int size)` Get a list of `Pic`s for this set at this size.
`java.util.List<Pic>`	`getPics(java.lang.String picName)` Get a List of all of the `Pic`s in the database that match this name.
`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 `Pic`s 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
`int`	`getPicThumbCacheFillCount(int cacheDir)` Determine the number of cached thumbs in this cache directory.
`Poster`	`getPoster(int pid)` Get a `Poster` from the database based on this Poster ID.
`java.util.List<Poster>`	`getPosters()` Get a List of all of the `Mosaic`s in the database.
`java.lang.String`	`getRandomHomePagePicName(User user)` Return a random pic from the database destined to be a thumbnail on the home page
`Pic`	`getRandomPic()` Return a random pic from the database
`Root`	`getRoot(int rid)` Fetch a `Root`
`Root`	`getRoot(java.lang.String name)` Fetch a `Root`
`int`	`getRootCount()` Get the number of `Root`s in the database
`java.util.List<Root>`	`getRoots()` Get a List of all of the `Root`s
`Set`	`getSet(int sid)` Get the `Set` that matches this Set ID
`Set`	`getSet(java.lang.String setName)` Get the `Set` that matches this Set ID
`int`	`getSetCount()` Return the number of `Set`s in the Database.
`java.util.List<Set>`	`getSets()` Get a List of all of the `Set`s in the database.
`java.util.List<Set>`	`getSetsClone()` Get a cloned List of all of the `Set`s in the database.
`java.util.List<Set>`	`getSetsInChain(int cid)` Return a list of Sets in a `Chain`
`java.util.List<SetSize>`	`getSetSizesInChain(int cid, int sid)` Return a list of SetSize for this set that are in this `Chain`
`java.util.HashMap<java.lang.String,java.util.Date>`	`getSetTimestamps()` Return a hash of the newest filter for each set/size.
`int[]`	`getSizeArray()` Get an array of the number of thumbnail sizes.
`int`	`getSizeCount()` Return the number of sizes that we deal with.
`java.util.List<java.lang.Integer>`	`getSizes()` Get the array of Thumbnail Sizes as a List of Integers.
`java.util.List<SyncClient>`	`getSyncClients()`
`java.util.List<SyncServer>`	`getSyncServers()`
`System`	`getSystem()` System Management
`int`	`getThumbHeight()` Get the user's preferred `Thumbnail` height used when running the editors.
`User`	`getUser(int userid)` Get the `User` who has this userid.
`java.lang.String`	`getUuid(java.lang.String setName, int size)` Make a uuid String based on a setName and a size
`int`	`getVirginCount()` Return the number of `Virgin`s in the database.
`java.util.List<Virgin>`	`getVirgins()` Get a List of all of the `Virgin`s in the database.
`java.util.List<Virgin>`	`getVirgins(int max)` Get a List of all of the `Virgin`s in the database up to max number.
`boolean`	`isVirgin(java.lang.String pic)` Is this picName a `Virgin`?
`int`	`normalizeSize(int size)` Given an arbitrary tile height, return a height that we actually know about.
`void`	`onSetChanged(SetSize setSize)` This set/size has changed.
`void`	`renameSet(java.lang.String oldName, java.lang.String newName)` Rename this Set.
`void`	`saveSystem(System sys)` Flush the `System` configuration back to the database.
`void`	`setChainsDao(ChainsDao chainsDao)` AOP setter for the ChainsDao
`void`	`setClientSyncTimestamp(java.lang.String host)` Set the last time this client sync'd to now.
`void`	`setContactsDao(ContactsDao contactsDao)` AOP setter for the ContactsDao
`void`	`setDbUrl(java.lang.String dbUrl)` Set the database url.
`void`	`setDbUser(java.lang.String dbUser)` Set the user who is accessing the database.
`void`	`setDEBUG(boolean debugFlag)` Enable logger output on the database
`void`	`setFiltersDao(FiltersDao filtersDao)` AOP setter for the FiltersDao
`void`	`setFiltersMicroSetsDao(FiltersMicroSetsDao filtersMicroSetsDao)` AOP setter for the FiltersMicroSetsDao
`void`	`setMetaSetsDao(MetaSetsDao metaSetsDao)` AOP setter for the MetaSetsDao
`void`	`setMosaicBatchesDao(MosaicBatchesDao mosaicBatchesDao)` AOP setter for the MosaicsDao
`void`	`setMosaicsDao(MosaicsDao mosaicsDao)` AOP setter for the MosaicsDao
`void`	`setMosaicTilesDao(MosaicTilesDao mosaicTilesDao)` AOP setter for the MosaicTilesDao
`void`	`setMosaicVectorsDao(MosaicVectorsDao mosaicVectorsDao)` AOP setter for the MosaicVectorsDao
`void`	`setPicManCommonFacade(PicManCommonFacade picManCommonFacade)` Set the callback to the partial main business facade.
`void`	`setPicsDao(PicsDao picsDao)` AOP setter for the PicsDao
`void`	`setPostersDao(PostersDao postersDao)` AOP setter for the PostersDao
`void`	`setRoots(java.util.List<Root> roots)` Set the `Root`s in the Database to be this List.
`void`	`setRootsDao(RootsDao rootsDao)` AOP setter for the RootsDao
`void`	`setServer_SyncDao(Server_SyncDao server_SyncDao)` AOP setter for the Server's SyncDao
`void`	`setSets(java.util.List<Set> sets)` Set the `Set`s in the Database to be this List.
`void`	`setSetsDao(SetsDao setsDao)` AOP setter for the SetsDao
`void`	`setSetTimestampsDao(SetTimestampsDao setTimestampsDao)` AOP setter for the SetTimestampsDao
`void`	`setSystemDao(SystemDao systemDao)` AOP setter for the SystemDao
`void`	`setUsersDao(UsersDao usersDao)` AOP setter for the UsersDao
`void`	`setVirginsDao(VirginsDao virginsDao)` AOP setter for the VirginsDao
`void`	`storeChain(Chain chain)` Store this `Chain` in the Database.
`void`	`storeMetaSet(MetaSet mset)` Store this `MetaSet` to the database.
`void`	`storeMosaic(Mosaic mosaic)` Store this `Mosaic` in the database.
`void`	`storeMosaicBatch(MosaicBatch mbatch)` Store this `MosaicBatch`es in the database.
`void`	`storeMosaicTile(MosaicTile tile)` Store this `MosaicTile` in the database.
`void`	`storePoster(Poster poster)` Store this `Poster` in the database.
`void`	`storeRoot(Root root)` Store this existing `Root` in the database.
`void`	`storeSet(Set set)` Store an existing set to the database.
`void`	`storeSyncClient(SyncClient syncClient)`
`void`	`storeSyncServer(SyncServer syncServer)`
`void`	`storeUser(User user)` Store this `User` in the database.
`void`	`updateMosaicVectors(MosaicVector mv)` Store this `MosaicVector` in the database.
`void`	`updatePic(Pic pic)` Update this `Pic` in the database.
`void`	`updateSetTimestamp(java.lang.String setSize)`

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Field Detail
  - logger
```
protected final org.apache.commons.logging.Log logger
```
- Method Detail
  - setPicManCommonFacade
```
public void setPicManCommonFacade(PicManCommonFacade picManCommonFacade)
```
    Description copied from interface: DatabaseFacade
    
    Set the callback to the partial main business facade. We are interested in the error handler.
    
    Specified by:
    
    setPicManCommonFacade in interface DatabaseFacade
    
    Parameters:
    
    picManCommonFacade - Where the error handler lives.
  - setDEBUG
```
public void setDEBUG(boolean debugFlag)
```
    Description copied from interface: DatabaseFacade
    
    Enable logger output on the database
    
    Specified by:
    
    setDEBUG in interface DatabaseFacade
    
    Parameters:
    
    debugFlag - true == turn on debugging.
  - setChainsDao
```
public void setChainsDao(ChainsDao chainsDao)
```
    AOP setter for the ChainsDao
    
    Parameters:
    
    chainsDao - The ChainsDao from the Spring Database Setup
  - setContactsDao
```
public void setContactsDao(ContactsDao contactsDao)
```
    AOP setter for the ContactsDao
    
    Parameters:
    
    contactsDao - The ContactsDao from the Spring Database Setup
  - setFiltersDao
```
public void setFiltersDao(FiltersDao filtersDao)
```
    AOP setter for the FiltersDao
    
    Parameters:
    
    filtersDao - The FiltersDao from the Spring Database Setup
  - setFiltersMicroSetsDao
```
public void setFiltersMicroSetsDao(FiltersMicroSetsDao filtersMicroSetsDao)
```
    AOP setter for the FiltersMicroSetsDao
    
    Parameters:
    
    filtersMicroSetsDao - The FiltersMicroSetsDao from the Spring Database Setup
  - setMetaSetsDao
```
public void setMetaSetsDao(MetaSetsDao metaSetsDao)
```
    AOP setter for the MetaSetsDao
    
    Parameters:
    
    metaSetsDao - The MetaSetsDao from the Spring Database Setup
  - setMosaicTilesDao
```
public void setMosaicTilesDao(MosaicTilesDao mosaicTilesDao)
```
    AOP setter for the MosaicTilesDao
    
    Parameters:
    
    mosaicTilesDao - The MosaicTilesDao from the Spring Database Setup
  - setMosaicsDao
```
public void setMosaicsDao(MosaicsDao mosaicsDao)
```
    AOP setter for the MosaicsDao
    
    Parameters:
    
    mosaicsDao - The MosaicsDao from the Spring Database Setup
  - setMosaicBatchesDao
```
public void setMosaicBatchesDao(MosaicBatchesDao mosaicBatchesDao)
```
    AOP setter for the MosaicsDao
    
    Parameters:
    
    mosaicBatchesDao - The MosaicsBatchDao from the Spring Database Setup
  - setMosaicVectorsDao
```
public void setMosaicVectorsDao(MosaicVectorsDao mosaicVectorsDao)
```
    AOP setter for the MosaicVectorsDao
    
    Parameters:
    
    mosaicVectorsDao - The MosaicVectorsDao from the Spring Database Setup
  - setPicsDao
```
public void setPicsDao(PicsDao picsDao)
```
    AOP setter for the PicsDao
    
    Parameters:
    
    picsDao - The PicsDao from the Spring Database Setup
  - setPostersDao
```
public void setPostersDao(PostersDao postersDao)
```
    AOP setter for the PostersDao
    
    Parameters:
    
    postersDao - The PostersDao from the Spring Database Setup
  - setRootsDao
```
public void setRootsDao(RootsDao rootsDao)
```
    AOP setter for the RootsDao
    
    Parameters:
    
    rootsDao - The RootsDao from the Spring Database Setup
  - setServer_SyncDao
```
public void setServer_SyncDao(Server_SyncDao server_SyncDao)
```
    AOP setter for the Server's SyncDao
    
    Parameters:
    
    server_SyncDao - The Server_SyncDao from the Spring Database Setup
  - setSystemDao
```
public void setSystemDao(SystemDao systemDao)
```
    AOP setter for the SystemDao
    
    Parameters:
    
    systemDao - The SystemDao from the Spring Database Setup
  - setSetsDao
```
public void setSetsDao(SetsDao setsDao)
```
    AOP setter for the SetsDao
    
    Parameters:
    
    setsDao - The SetsDao from the Spring Database Setup
  - setSetTimestampsDao
```
public void setSetTimestampsDao(SetTimestampsDao setTimestampsDao)
```
    AOP setter for the SetTimestampsDao
    
    Parameters:
    
    setTimestampsDao - The SetTimestampsDao from the Spring Database Setup
  - setUsersDao
```
public void setUsersDao(UsersDao usersDao)
```
    AOP setter for the UsersDao
    
    Parameters:
    
    usersDao - The UsersDao from the Spring Database Setup
  - setVirginsDao
```
public void setVirginsDao(VirginsDao virginsDao)
```
    AOP setter for the VirginsDao
    
    Parameters:
    
    virginsDao - The VirginsDao from the Spring Database Setup
  - getChainsDao
```
public ChainsDao getChainsDao()
```
    Why is this public? Because Spring was freaking out trying to reflect the type.
    
    Returns:
    
    Our kinda private ChainsDao
  - setDbUser
```
public void setDbUser(java.lang.String dbUser)
```
    Description copied from interface: DatabaseFacade
    
    Set the user who is accessing the database.
    
    Specified by:
    
    setDbUser in interface DatabaseFacade
    
    Parameters:
    
    dbUser - The database user
  - getDbUser
```
public java.lang.String getDbUser()
```
    Description copied from interface: DatabaseFacade
    
    Get the user who is accessing the database. This is realy a status field, as nothing outside of here accesses the database.
    
    Specified by:
    
    getDbUser in interface DatabaseFacade
    
    Returns:
    
    Usually "picman" or "picman_dev"
  - setDbUrl
```
public void setDbUrl(java.lang.String dbUrl)
```
    Description copied from interface: DatabaseFacade
    
    Set the database url.
    
    Specified by:
    
    setDbUrl in interface DatabaseFacade
    
    Parameters:
    
    dbUrl - The dbUrl to set.
  - getDbUrl
```
public java.lang.String getDbUrl()
```
    Description copied from interface: DatabaseFacade
    
    Get the url that is accessing the database. This is realy a status field, as nothing outside of here accesses the database.
    
    Specified by:
    
    getDbUrl in interface DatabaseFacade
    
    Returns:
    
    jdbc:mysql://localhost:3306/{something}
  - getSystem
```
public System getSystem()
```
    System Management
    
    Specified by:
    
    getSystem in interface DatabaseFacade
    
    Returns:
    
    The cached System.
  - saveSystem
```
public void saveSystem(System sys)
```
    Description copied from interface: DatabaseFacade
    
    Flush the System configuration back to the database.
    
    Specified by:
    
    saveSystem in interface DatabaseFacade
    
    Parameters:
    
    sys - The System to write.
  - getPicExtensions
```
public java.util.List<java.lang.String> getPicExtensions()
```
    Description copied from interface: DatabaseFacade
    
    Return a list of file name extensions that denote pics that we are interested in.
    Originally, i expected to use .png in here, but basically i've settled on .jpg.
    This is actually convienent, because if there is a pic i want to ignore, i rename it to .jpeg.
    
    Specified by:
    
    getPicExtensions in interface DatabaseFacade
    
    Returns:
    
    A List of Extensions, typically just "jpg".
  - getThumbHeight
```
public int getThumbHeight()
```
    Description copied from interface: DatabaseFacade
    
    Get the user's preferred Thumbnail height used when running the editors.
    
    Specified by:
    
    getThumbHeight in interface DatabaseFacade
    
    Returns:
    
    The height of the Thumnails (I like 140 pixels).
  - getRoots
```
public java.util.List<Root> getRoots()
```
    Description copied from interface: DatabaseFacade
    
    Get a List of all of the Roots
    
    Specified by:
    
    getRoots in interface DatabaseFacade
    
    Returns:
    
    A List of all of the Roots in the database
  - getRootCount
```
public int getRootCount()
```
    Description copied from interface: DatabaseFacade
    
    Get the number of Roots in the database
    
    Specified by:
    
    getRootCount in interface DatabaseFacade
    
    Returns:
    
    The number of Roots
  - getRoot
```
public Root getRoot(int rid)
```
    Description copied from interface: DatabaseFacade
    
    Fetch a Root
    
    Specified by:
    
    getRoot in interface DatabaseFacade
    
    Parameters:
    
    rid - The rootId to match
    
    Returns:
    
    The Root
  - getRoot
```
public Root getRoot(java.lang.String name)
```
    Description copied from interface: DatabaseFacade
    
    Fetch a Root
    
    Specified by:
    
    getRoot in interface DatabaseFacade
    
    Parameters:
    
    name - The Name of the Root to fetch
    
    Returns:
    
    The Root
  - setRoots
```
public void setRoots(java.util.List<Root> roots)
```
    Description copied from interface: DatabaseFacade
    
    Set the Roots in the Database to be this List. I'm not sure why you'd want to do this, and it is unused, but here it is.
    
    Specified by:
    
    setRoots in interface DatabaseFacade
    
    Parameters:
    
    roots - A List of Roots
  - addRoot
```
public void addRoot(Root r)
```
    Description copied from interface: DatabaseFacade
    
    Add this Root to the Database. the Root ID must be 0.
    
    Specified by:
    
    addRoot in interface DatabaseFacade
    
    Parameters:
    
    r - The Root to add.
  - storeRoot
```
public void storeRoot(Root root)
```
    Description copied from interface: DatabaseFacade
    
    Store this existing Root in the database. The Root ID must NOT be 0.
    
    Specified by:
    
    storeRoot in interface DatabaseFacade
    
    Parameters:
    
    root - The existing Root to update.
  - deleteRoot
```
public void deleteRoot(Root root)
```
    Description copied from interface: DatabaseFacade
    
    Delete this Root from the database.
    
    Specified by:
    
    deleteRoot in interface DatabaseFacade
    
    Parameters:
    
    root - The Root to delete.
  - getInactiveRoots
```
public java.util.List<Root> getInactiveRoots()
```
    Description copied from interface: DatabaseFacade
    
    Get a List of Inactive Roots. Inactive Roots will not be scanned for new pics, or included in Sets queries.
    
    Specified by:
    
    getInactiveRoots in interface DatabaseFacade
    
    Returns:
    
    A List of Roots that the User has disabled.
  - getActiveRoots
```
public java.util.List<Root> getActiveRoots()
```
    Description copied from interface: DatabaseFacade
    
    Get a List of active Roots.
    
    Specified by:
    
    getActiveRoots in interface DatabaseFacade
    
    Returns:
    
    A List of Roots
  - getSets
```
public java.util.List<Set> getSets()
```
    Description copied from interface: DatabaseFacade
    
    Get a List of all of the Sets in the database. Note: The Sets are cached in memory. An external app writing to the database will not be reflected in this running instance.
    
    Specified by:
    
    getSets in interface DatabaseFacade
    
    Returns:
    
    The List of Sets
  - getSetsClone
```
public java.util.List<Set> getSetsClone()
```
    Description copied from interface: DatabaseFacade
    
    Get a cloned List of all of the Sets in the database. This is useful for when you want to prune the list without altering the sets cache.
    
    Specified by:
    
    getSetsClone in interface DatabaseFacade
    
    Returns:
    
    The List of Sets
  - getSetCount
```
public int getSetCount()
```
    Description copied from interface: DatabaseFacade
    
    Return the number of Sets in the Database.
    
    Specified by:
    
    getSetCount in interface DatabaseFacade
    
    Returns:
    
    The Number of Sets
  - getSet
```
public Set getSet(int sid)
```
    Description copied from interface: DatabaseFacade
    
    Get the Set that matches this Set ID
    
    Specified by:
    
    getSet in interface DatabaseFacade
    
    Parameters:
    
    sid - The SetID to query
    
    Returns:
    
    The Set that was found or null if no match was made.
  - getSet
```
public Set getSet(java.lang.String setName)
```
    Description copied from interface: DatabaseFacade
    
    Get the Set that matches this Set ID
    
    Specified by:
    
    getSet in interface DatabaseFacade
    
    Parameters:
    
    setName - The name of the Set to query
    
    Returns:
    
    The Set that was found or null if no match was made.
  - setSets
```
public void setSets(java.util.List<Set> sets)
```
    Description copied from interface: DatabaseFacade
    
    Set the Sets in the Database to be this List. I'm not sure why you'd want to do this, and it is unused, but here it is.
    
    Specified by:
    
    setSets in interface DatabaseFacade
    
    Parameters:
    
    sets - A List of Sets
  - addSet
```
public void addSet(Set s)
```
    Add a new set to the database.
    
    Specified by:
    
    addSet in interface DatabaseFacade
    
    Parameters:
    
    s - The Set to add. The sid should be 0.
  - storeSet
```
public void storeSet(Set set)
```
    Store an existing set to the database.
    
    Specified by:
    
    storeSet in interface DatabaseFacade
    
    Parameters:
    
    set - The set to store. The sid should NOT be 0.
  - deleteSet
```
public void deleteSet(Set s)
```
    Delete this set from the database.
    
    Specified by:
    
    deleteSet in interface DatabaseFacade
    
    Parameters:
    
    s - The set to delete.
  - renameSet
```
public void renameSet(java.lang.String oldName,
                      java.lang.String newName)
```
    Description copied from interface: DatabaseFacade
    
    Rename this Set. Includes changing references from the old setname to the new one.
    
    Specified by:
    
    renameSet in interface DatabaseFacade
    
    Parameters:
    
    oldName - What is this set called?
    
    newName - What do we want it to be called?
  - getInactiveSets
```
public java.util.List<Set> getInactiveSets()
```
    Build a list of inactive sets
    
    Specified by:
    
    getInactiveSets in interface DatabaseFacade
    
    Returns:
    
    A List of Sets
  - getActiveSets
```
public java.util.List<Set> getActiveSets()
```
    Build a list of active sets
    
    Specified by:
    
    getActiveSets in interface DatabaseFacade
    
    Returns:
    
    A List of Sets
  - getMetaSet
```
public MetaSet getMetaSet(int sid)
```
    MetaSet Management
    
    Specified by:
    
    getMetaSet in interface DatabaseFacade
    
    Parameters:
    
    sid - The SetID to query.
    
    Returns:
    
    The MetaSet
  - storeMetaSet
```
public void storeMetaSet(MetaSet mset)
```
    Description copied from interface: DatabaseFacade
    
    Store this MetaSet to the database.
    
    Specified by:
    
    storeMetaSet in interface DatabaseFacade
    
    Parameters:
    
    mset - The MetaSet to write.
  - getMetaSetColumns
```
public java.util.List<java.lang.String> getMetaSetColumns()
```
    Get a List of Column names for the MetaSets.
    
    Specified by:
    
    getMetaSetColumns in interface DatabaseFacade
    
    Returns:
    
    a List of "columns" for the known metasets
  - getMetaSetFilter
```
public MetaSetFilter getMetaSetFilter()
```
    Description copied from interface: DatabaseFacade
    
    Fetch a reference to the MetaSet filter processor.
    
    Specified by:
    
    getMetaSetFilter in interface DatabaseFacade
    
    Returns:
    
    A reference to the database's MetaSet filter processor.
  - getMosaic
```
public Mosaic getMosaic(int mid)
```
    Description copied from interface: DatabaseFacade
    
    Get a Mosaic from the database based on this Mosaic ID.
    
    Specified by:
    
    getMosaic in interface DatabaseFacade
    
    Parameters:
    
    mid - The Mosaic ID to query.
    
    Returns:
    
    The Mosaic that matches this mid, or null if not found.
  - getMosaic
```
public Mosaic getMosaic(java.lang.String masterPic,
                        java.lang.String engine,
                        int sid,
                        int tileHeight)
```
    Description copied from interface: DatabaseFacade
    
    Find the Mosaic in the database that matches these parameters.
    
    Specified by:
    
    getMosaic in interface DatabaseFacade
    
    Returns:
    
    The mosaic that matches these parameters, or null if not found.
  - getMosaicTileCount
```
public int getMosaicTileCount(int mid)
```
    Description copied from interface: DatabaseFacade
    
    Return the number of tiles we have stored for this Mosaic
    
    Specified by:
    
    getMosaicTileCount in interface DatabaseFacade
    
    Parameters:
    
    mid - The mosaicId
    
    Returns:
    
    The count
  - getMosaics
```
public java.util.List<Mosaic> getMosaics()
```
    Description copied from interface: DatabaseFacade
    
    Get a List of all of the Mosaics in the database.
    
    Specified by:
    
    getMosaics in interface DatabaseFacade
    
    Returns:
    
    The List of Mosaics
  - storeMosaic
```
public void storeMosaic(Mosaic mosaic)
```
    Description copied from interface: DatabaseFacade
    
    Store this Mosaic in the database.
    
    Specified by:
    
    storeMosaic in interface DatabaseFacade
    
    Parameters:
    
    mosaic - The Mosaic to store.
  - deleteMosaic
```
public void deleteMosaic(int mid)
```
    Description copied from interface: DatabaseFacade
    
    Delete the Mosaic from the database that has this Mosaic ID.
    
    Specified by:
    
    deleteMosaic in interface DatabaseFacade
    
    Parameters:
    
    mid - The Mosaic ID to delete.
  - getMosaicBatch
```
public MosaicBatch getMosaicBatch(int mbid)
```
    Description copied from interface: DatabaseFacade
    
    Get the MosaicBatch that matches this mbid
    
    Specified by:
    
    getMosaicBatch in interface DatabaseFacade
    
    Parameters:
    
    mbid - The MosaicBatch id to query.
    
    Returns:
    
    The MosaicBatch that matches or null if not found.
  - getMosaicBatches
```
public java.util.List<MosaicBatch> getMosaicBatches()
```
    Description copied from interface: DatabaseFacade
    
    Get a List of MosaicBatches in the database.
    
    Specified by:
    
    getMosaicBatches in interface DatabaseFacade
    
    Returns:
    
    The List of MosaicBatches
  - storeMosaicBatch
```
public void storeMosaicBatch(MosaicBatch mbatch)
```
    Description copied from interface: DatabaseFacade
    
    Store this MosaicBatches in the database.
    
    Specified by:
    
    storeMosaicBatch in interface DatabaseFacade
    
    Parameters:
    
    mbatch - The MosaicBatch to store
  - deleteMosaicTiles
```
public void deleteMosaicTiles(int mid)
```
    Description copied from interface: DatabaseFacade
    
    Delete the MosaicTiles for the Mosaic specified by this Mosaic ID.
    
    Specified by:
    
    deleteMosaicTiles in interface DatabaseFacade
    
    Parameters:
    
    mid - The Mosaic ID to delete.
  - getMosaicTiles
```
public java.util.List<MosaicTile> getMosaicTiles(int mid)
```
    Description copied from interface: DatabaseFacade
    
    Fetch the already built MosaicTiles for this Mosaic
    
    Specified by:
    
    getMosaicTiles in interface DatabaseFacade
    
    Parameters:
    
    mid - The MosaicID to fetch
    
    Returns:
    
    A List of MosaicTiles
  - storeMosaicTile
```
public void storeMosaicTile(MosaicTile tile)
```
    Description copied from interface: DatabaseFacade
    
    Store this MosaicTile in the database.
    
    Specified by:
    
    storeMosaicTile in interface DatabaseFacade
    
    Parameters:
    
    tile - The MosaicTile to store.
  - updateMosaicVectors
```
public void updateMosaicVectors(MosaicVector mv)
```
    Description copied from interface: DatabaseFacade
    
    Store this MosaicVector in the database.
    
    Specified by:
    
    updateMosaicVectors in interface DatabaseFacade
    
    Parameters:
    
    mv - The MosaicVector to store.
  - getMosaicVectors
```
public java.util.List<MosaicVector> getMosaicVectors(java.util.List<Pic> picList)
```
    Description copied from interface: DatabaseFacade
    
    Get the List of MosaicVectors that matches this picList, which probably came from a mosaic Set.
    
    Specified by:
    
    getMosaicVectors in interface DatabaseFacade
    
    Parameters:
    
    picList - The List of Pics to query
    
    Returns:
    
    The matching List of MosaicVectors. The List may be empty, but not null.
  - getPoster
```
public Poster getPoster(int pid)
```
    Description copied from interface: DatabaseFacade
    
    Get a Poster from the database based on this Poster ID.
    
    Specified by:
    
    getPoster in interface DatabaseFacade
    
    Parameters:
    
    pid - The Poster ID to query.
    
    Returns:
    
    The Poster that matches this pid, or null if not found.
  - getPosters
```
public java.util.List<Poster> getPosters()
```
    Description copied from interface: DatabaseFacade
    
    Get a List of all of the Mosaics in the database.
    
    Specified by:
    
    getPosters in interface DatabaseFacade
    
    Returns:
    
    The List of Mosaics
  - storePoster
```
public void storePoster(Poster poster)
```
    Description copied from interface: DatabaseFacade
    
    Store this Poster in the database.
    
    Specified by:
    
    storePoster in interface DatabaseFacade
    
    Parameters:
    
    poster - The Poster to store.
  - deletePoster
```
public void deletePoster(int pid)
```
    Description copied from interface: DatabaseFacade
    
    Delete the Poster from the database that has this Poster ID.
    
    Specified by:
    
    deletePoster in interface DatabaseFacade
    
    Parameters:
    
    pid - The Poster ID to delete.
  - getSizes
```
public java.util.List<java.lang.Integer> getSizes()
```
    Description copied from interface: DatabaseFacade
    
    Get the array of Thumbnail Sizes as a List of Integers. The Filters are keyed to the sizes. A Thumbnail that looks OK as a 75, might not be worthy of a 300.
    
    Specified by:
    
    getSizes in interface DatabaseFacade
    
    Returns:
    
    A List of Integers
    
    See Also:
    
    DatabaseFacade.getSizeArray()
  - getSizeArray
```
public int[] getSizeArray()
```
    Description copied from interface: DatabaseFacade
    
    Get an array of the number of thumbnail sizes. Through the years, i have settled on 75,100,150,200,300 as the sizes that i play with and these numbers are hardcoded in here.
    
    Specified by:
    
    getSizeArray in interface DatabaseFacade
    
    Returns:
    
    An array of the sizes
  - getSizeCount
```
public int getSizeCount()
```
    Description copied from interface: DatabaseFacade
    
    Return the number of sizes that we deal with.
    
    Specified by:
    
    getSizeCount in interface DatabaseFacade
    
    Returns:
    
    That would be the number 5.
  - getChains
```
public java.util.List<Chain> getChains()
```
    Description copied from interface: DatabaseFacade
    
    Get a List of all of the Chains in the database.
    
    Specified by:
    
    getChains in interface DatabaseFacade
    
    Returns:
    
    The List
  - getChainCount
```
public int getChainCount()
```
    Description copied from interface: DatabaseFacade
    
    Return the number of Chains in the Database.
    
    Specified by:
    
    getChainCount in interface DatabaseFacade
    
    Returns:
    
    The Count
  - getChain
```
public Chain getChain(java.lang.String chainName)
```
    Description copied from interface: DatabaseFacade
    
    Fetch a Chain based on its name.
    
    Specified by:
    
    getChain in interface DatabaseFacade
    
    Parameters:
    
    chainName - The name to query.
    
    Returns:
    
    The chain or null if not found.
  - getChain
```
public Chain getChain(int cid)
```
    Description copied from interface: DatabaseFacade
    
    Fetch a Chain based on its Chain ID.
    
    Specified by:
    
    getChain in interface DatabaseFacade
    
    Parameters:
    
    cid - The Chain ID to query.
    
    Returns:
    
    The chain or null if not found.
  - storeChain
```
public void storeChain(Chain chain)
```
    Description copied from interface: DatabaseFacade
    
    Store this Chain in the Database.
    
    Specified by:
    
    storeChain in interface DatabaseFacade
    
    Parameters:
    
    chain - The Chain to write.
  - deleteChain
```
public void deleteChain(Chain chain)
```
    Description copied from interface: DatabaseFacade
    
    Delete this Chain from the Database.
    
    Specified by:
    
    deleteChain in interface DatabaseFacade
    
    Parameters:
    
    chain - The Chain to delete.
  - getSetsInChain
```
public java.util.List<Set> getSetsInChain(int cid)
```
    Description copied from interface: DatabaseFacade
    
    Return a list of Sets in a Chain
    
    Specified by:
    
    getSetsInChain in interface DatabaseFacade
    
    Parameters:
    
    cid - The Chain to query
    
    Returns:
    
    A List of Set
  - getSetSizesInChain
```
public java.util.List<SetSize> getSetSizesInChain(int cid,
                                                  int sid)
```
    Description copied from interface: DatabaseFacade
    
    Return a list of SetSize for this set that are in this Chain
    
    Specified by:
    
    getSetSizesInChain in interface DatabaseFacade
    
    Parameters:
    
    cid - The chain id
    
    sid - The Set id
    
    Returns:
    
    A list of SetSizes
  - getContact
```
public Contact getContact(int cid,
                          java.lang.String name)
```
    Description copied from interface: DatabaseFacade
    
    Fetch the Contact that was built with these parameters. This does not return an image, just all of the parameters needed to recreate the image. Such as which Thumbnail appeared at each coordinates.
    
    Specified by:
    
    getContact in interface DatabaseFacade
    
    Parameters:
    
    cid - The Chain ID
    
    name - The qualified name of this contact. i.e. "Gail-100-02"
    
    Returns:
    
    The Contact
  - getContact
```
public Contact getContact(int cid,
                          java.lang.String setName,
                          int size,
                          int item)
```
    Description copied from interface: DatabaseFacade
    
    Fetch the Contact that was built with these parameters. This does not return an image, just all of the parameters needed to recreate the image. Such as which Thumbnail appeared at each coordinates.
    
    Specified by:
    
    getContact in interface DatabaseFacade
    
    Parameters:
    
    cid - The Chain ID
    
    setName - The name of the Set that was used
    
    size - The Thumbnail size
    
    item - Which of this series of contacts
    
    Returns:
    
    The Contact
  - addContact
```
public void addContact(Contact c)
```
    Description copied from interface: DatabaseFacade
    
    Add this Contact to the database.
    
    Specified by:
    
    addContact in interface DatabaseFacade
    
    Parameters:
    
    c - The Contact
  - getNewestContact
```
public Contact getNewestContact()
```
    Description copied from interface: DatabaseFacade
    
    Fetch the newest Contact made. Basically this tells us the last time Contacts were made.
    
    Specified by:
    
    getNewestContact in interface DatabaseFacade
    
    Returns:
    
    The newest Contact in the database.
  - getContactOldestMap
```
public java.util.HashMap<java.lang.String,java.util.Date> getContactOldestMap(Chain chain)
```
    Description copied from interface: DatabaseFacade
    
    Return the oldest contact in each set/size in a map k = SetName i.e. "G-100" / v = Date
    
    Specified by:
    
    getContactOldestMap in interface DatabaseFacade
    
    Parameters:
    
    chain - Which Chain to process
    
    Returns:
    
    the map
  - getFilterCount
```
public int getFilterCount()
```
    Description copied from interface: DatabaseFacade
    
    Get the number of Filters in the database.
    
    Specified by:
    
    getFilterCount in interface DatabaseFacade
    
    Returns:
    
    the count.
  - getFilterColumns
```
public java.util.List<java.lang.String> getFilterColumns()
```
    Description copied from interface: DatabaseFacade
    
    Get a list of the Filter column names from the database.
    
    Specified by:
    
    getFilterColumns in interface DatabaseFacade
    
    Returns:
    
    The List.
  - getFilters
```
public java.util.List<Filter> getFilters()
```
    Description copied from interface: DatabaseFacade
    
    Get a list of all of the Filters in the database.
    
    Specified by:
    
    getFilters in interface DatabaseFacade
    
    Returns:
    
    The List.
  - getFiltersBySet
```
public java.util.List<Filter> getFiltersBySet(java.lang.String set,
                                              int size)
```
    Description copied from interface: DatabaseFacade
    
    Get a list of all of the Filters for this set/size.
    
    Specified by:
    
    getFiltersBySet in interface DatabaseFacade
    
    Parameters:
    
    set - The name of the Set to query.
    
    size - The thumbnail size to query.
    
    Returns:
    
    A List of the Filters that match this query
  - getPicNamesBySet
```
public java.util.List<java.lang.String> getPicNamesBySet(java.lang.String setName,
                                                         int size)
```
    Description copied from interface: DatabaseFacade
    
    Get a List of the Pic Names of the Filters that match this query.
    
    Specified by:
    
    getPicNamesBySet in interface DatabaseFacade
    
    Parameters:
    
    setName - The name of the Set to query
    
    size - The thumbnail size to query
    
    Returns:
    
    A List of the Pic Names that match this query
  - getPicNamesBySet
```
public java.util.List<java.lang.String> getPicNamesBySet(Set set,
                                                         int size)
```
    Description copied from interface: DatabaseFacade
    
    Get a List of the Pic Names of the Filters that match this query.
    
    Specified by:
    
    getPicNamesBySet in interface DatabaseFacade
    
    Parameters:
    
    set - The Set to query
    
    size - The thumbnail size to query
    
    Returns:
    
    A List of the Pic Names that match this query
  - getPicNamesBySet
```
public java.util.List<java.lang.String> getPicNamesBySet(MetaSet set,
                                                         int size,
                                                         int rateOp,
                                                         int rateVal)
```
    Description copied from interface: DatabaseFacade
    
    Get a List of the Pic Names of the Filters that match this query.
    
    Specified by:
    
    getPicNamesBySet in interface DatabaseFacade
    
    Parameters:
    
    set - The MetaSet to query
    
    size - The thumbnail size to query
    
    rateOp - An index into the MetaSet rateOps table. i.e. NONE, =, !=, <, >.
    
    rateVal - The value to apply with the rateOp against this set
    
    Returns:
    
    A List of the Pic Names that match this query
  - getPicNamesBySet
```
public java.util.List<java.lang.String> getPicNamesBySet(java.lang.String setName,
                                                         int size,
                                                         int rateOp,
                                                         int rateVal)
```
    Description copied from interface: DatabaseFacade
    
    Get a List of the Pic Names of the Filters that match this valued query. This allows to say "mlb < 5".
    
    Specified by:
    
    getPicNamesBySet in interface DatabaseFacade
    
    Parameters:
    
    setName - The name of the Set to query.
    
    size - The thumbnail size to query.
    
    Returns:
    
    A List of the Pic Names that match this query.
  - getPicNamesBySet
```
public java.util.List<java.lang.String> getPicNamesBySet(Set set,
                                                         int size,
                                                         int rateOp,
                                                         int rateVal)
```
    Description copied from interface: DatabaseFacade
    
    Get a List of the Pic Names of the Filters that match this valued query. This allows to say "mlb < 5".
    
    Specified by:
    
    getPicNamesBySet in interface DatabaseFacade
    
    Parameters:
    
    set - The Set to query.
    
    size - The thumbnail size to query.
    
    rateOp - An index into the MetaSet rateOps table. i.e. NONE, =, !=, <, >.
    
    rateVal - The value to apply with the rateOp against this set
    
    Returns:
    
    A List of the Pic Names that match this query.
  - getPicNamesByFunc
```
public java.util.List<java.lang.String> getPicNamesByFunc(int func,
                                                          int size,
                                                          int rateOp,
                                                          java.lang.String operand)
```
    Description copied from interface: DatabaseFacade
    
    Get a List of the Pic Names that pass this function filter. See Set for the list of valid function numbers.
    
    Specified by:
    
    getPicNamesByFunc in interface DatabaseFacade
    
    Parameters:
    
    func - The Function number to run.
    
    size - The thumb size to run this filter on.
    
    rateOp - An index into the MetaSet rateOps table. i.e. NONE, =, !=, <, >.
    
    operand - A generic operand for the func. i.e. date (-2) takes a date here "2009-07-25"
    
    Returns:
    
    A List of the Pic Names that match this query.
  - getSetTimestamps
```
public java.util.HashMap<java.lang.String,java.util.Date> getSetTimestamps()
```
    Description copied from interface: DatabaseFacade
    
    Return a hash of the newest filter for each set/size. k = Set i.e. "G_100" / v = Date
    
    Specified by:
    
    getSetTimestamps in interface DatabaseFacade
    
    Returns:
    
    The Hash
  - addFilter
```
public void addFilter(Filter filter)
```
    Description copied from interface: DatabaseFacade
    
    Add a Filter to the database, overwriting any existing filter for this pic.
    
    Specified by:
    
    addFilter in interface DatabaseFacade
    
    Parameters:
    
    filter - The new (or used) Filter.
  - getFilter
```
public Filter getFilter(java.lang.String picName)
```
    Description copied from interface: DatabaseFacade
    
    Get the Filter for the pic named.
    
    Specified by:
    
    getFilter in interface DatabaseFacade
    
    Parameters:
    
    picName - The name of the Pic.
    
    Returns:
    
    the Filter
  - getPicFromFilterMicroSet
```
public FilterMicroSet getPicFromFilterMicroSet(int pid,
                                               int sid)
```
    Description copied from interface: DatabaseFacade
    
    Get the FilterMicroSet for this pic in this set.
    
    Specified by:
    
    getPicFromFilterMicroSet in interface DatabaseFacade
    
    Parameters:
    
    pid - The pid the Pic.
    
    sid - The sid of the set to query.
    
    Returns:
    
    The FilterMicroSet or null if not found.
  - getUser
```
public User getUser(int userid)
             throws DataAccessException
```
    Description copied from interface: DatabaseFacade
    
    Get the User who has this userid.
    
    Specified by:
    
    getUser in interface DatabaseFacade
    
    Parameters:
    
    userid - The userid to query.
    
    Returns:
    
    A PicMan User.
    
    Throws:
    
    DataAccessException
  - storeUser
```
public void storeUser(User user)
```
    Description copied from interface: DatabaseFacade
    
    Store this User in the database. Does not affect the BSAccount settings of this User.
    
    Specified by:
    
    storeUser in interface DatabaseFacade
    
    Parameters:
    
    user - The User to save.
  - getVirgins
```
public java.util.List<Virgin> getVirgins()
```
    Description copied from interface: DatabaseFacade
    
    Get a List of all of the Virgins in the database.
    
    Specified by:
    
    getVirgins in interface DatabaseFacade
    
    Returns:
    
    The List
  - getVirgins
```
public java.util.List<Virgin> getVirgins(int max)
```
    Description copied from interface: DatabaseFacade
    
    Get a List of all of the Virgins in the database up to max number.
    This is useful for the "process up to 5 virgins" page.
    
    Specified by:
    
    getVirgins in interface DatabaseFacade
    
    Parameters:
    
    max - The Maximum number of Virgins to put in the List
    
    Returns:
    
    The List.
  - isVirgin
```
public boolean isVirgin(java.lang.String pic)
```
    Description copied from interface: DatabaseFacade
    
    Is this picName a Virgin?
    
    Specified by:
    
    isVirgin in interface DatabaseFacade
    
    Parameters:
    
    pic - The name of the Pic to query
    
    Returns:
    
    true if this picName is in the Virgins table.
  - addVirgin
```
public void addVirgin(java.lang.String pic)
```
    Description copied from interface: DatabaseFacade
    
    Add this Pic name as a Virgin in the database.
    
    Specified by:
    
    addVirgin in interface DatabaseFacade
    
    Parameters:
    
    pic - The name of the Pic to add.
  - deleteVirgin
```
public void deleteVirgin(java.lang.String pic)
```
    Description copied from interface: DatabaseFacade
    
    Delete this Pic name from the Virgins table. This Pic is no longer a Virgin.
    
    Specified by:
    
    deleteVirgin in interface DatabaseFacade
    
    Parameters:
    
    pic - The name of the Pic to remove.
  - getVirginCount
```
public int getVirginCount()
```
    Description copied from interface: DatabaseFacade
    
    Return the number of Virgins in the database.
    
    Specified by:
    
    getVirginCount in interface DatabaseFacade
    
    Returns:
    
    The count.
  - addPic
```
public void addPic(Pic pic)
```
    Description copied from interface: DatabaseFacade
    
    Add this Pic to the database.
    
    Specified by:
    
    addPic in interface DatabaseFacade
    
    Parameters:
    
    pic - The Pic to add. pid is assumed to be 0.
  - updatePic
```
public void updatePic(Pic pic)
```
    Description copied from interface: DatabaseFacade
    
    Update this Pic in the database. Pic is assumed to exist and pid must not be 0.
    
    Specified by:
    
    updatePic in interface DatabaseFacade
    
    Parameters:
    
    pic - The Pic to update.
  - getPic
```
public Pic getPic(java.lang.String picName)
```
    Description copied from interface: DatabaseFacade
    
    Get a Pic who's name matches this picName.
    
    Specified by:
    
    getPic in interface DatabaseFacade
    
    Parameters:
    
    picName - The name of the Pic to query.
    
    Returns:
    
    The Pic that matches this picName or null.
  - getPic
```
public Pic getPic(int pid)
```
    Description copied from interface: DatabaseFacade
    
    Get a Pic who's pid matches this one.
    
    Specified by:
    
    getPic in interface DatabaseFacade
    
    Parameters:
    
    pid - The pid to query
    
    Returns:
    
    The Pic that matches this pid, or null if not found.
  - getNewestPic
```
public Pic getNewestPic()
```
    Description copied from interface: DatabaseFacade
    
    Get the newest pic in the database.
    
    Specified by:
    
    getNewestPic in interface DatabaseFacade
    
    Returns:
    
    The Pic with the newest Timestamp
  - getRandomPic
```
public Pic getRandomPic()
```
    Description copied from interface: DatabaseFacade
    
    Return a random pic from the database
    
    Specified by:
    
    getRandomPic in interface DatabaseFacade
    
    Returns:
    
    Any pic from the database
  - getPicsByMD5Sum
```
public java.util.List<Pic> getPicsByMD5Sum(long md5sum)
```
    Description copied from interface: DatabaseFacade
    
    Return a list of Pics that have this md5Sum
    
    Specified by:
    
    getPicsByMD5Sum in interface DatabaseFacade
    
    Returns:
    
    The list, may be empty
  - getRandomHomePagePicName
```
public java.lang.String getRandomHomePagePicName(User user)
```
    Description copied from interface: DatabaseFacade
    
    Return a random pic from the database destined to be a thumbnail on the home page
    
    Specified by:
    
    getRandomHomePagePicName in interface DatabaseFacade
    
    Parameters:
    
    user - The User who is requesting the Pic
    
    Returns:
    
    The name of any pic from the database that matches the User's preference
  - onSetChanged
```
public void onSetChanged(SetSize setSize)
```
    Description copied from interface: SetChangedListener
    
    This set/size has changed. Perhaps you care.
    
    Specified by:
    
    onSetChanged in interface SetChangedListener
    
    Parameters:
    
    setSize - The Set/Size that changed.
  - getPicsMap
```
public java.util.HashMap<java.lang.String,java.util.Date> getPicsMap()
```
    Description copied from interface: DatabaseFacade
    
    Get a HashMap of all of the Pic names in the database.
    
    Specified by:
    
    getPicsMap in interface DatabaseFacade
    
    Returns:
    
    The map
  - getPics
```
public java.util.List<Pic> getPics()
```
    Description copied from interface: DatabaseFacade
    
    Get a List of all of the Pics.
    
    Specified by:
    
    getPics in interface DatabaseFacade
    
    Returns:
    
    A List of Pic
  - getPics
```
public java.util.List<Pic> getPics(java.lang.String picName)
```
    Description copied from interface: DatabaseFacade
    
    Get a List of all of the Pics in the database that match this name. Wildcards are supported.
    
    Specified by:
    
    getPics in interface DatabaseFacade
    
    Parameters:
    
    picName - The name (or partial name) of the pics to fetch.
    
    Returns:
    
    A List of Pics.
  - getPics
```
public java.util.List<Pic> getPics(Set set,
                                   int size)
```
    Description copied from interface: DatabaseFacade
    
    Get a list of Pics for this set at this size.
    
    Specified by:
    
    getPics in interface DatabaseFacade
    
    Parameters:
    
    set - The set to use as a filter
    
    size - The size to use as a filter
    
    Returns:
    
    A List of Pic
  - getPicsInDir
```
public java.util.List<Pic> getPicsInDir(int rid,
                                        java.lang.String dirName)
```
    Description copied from interface: DatabaseFacade
    
    Get a list of Pics that are in this subdirectory.
    
    Specified by:
    
    getPicsInDir in interface DatabaseFacade
    
    Parameters:
    
    rid - Root id to search under
    
    dirName - The directory, i.e. "2002/20021225"
    
    Returns:
    
    A List of Pic
  - getPicsNewerThan
```
public java.util.List<Pic> getPicsNewerThan(java.util.Calendar calendar)
```
    Description copied from interface: DatabaseFacade
    
    Get a list of Pics that are newer than this date
    
    Specified by:
    
    getPicsNewerThan in interface DatabaseFacade
    
    Parameters:
    
    calendar - The timestamp to compare against
    
    Returns:
    
    The List of Pics
  - getPicRate
```
public double getPicRate(java.lang.String picName,
                         Set set,
                         int size)
```
    Description copied from interface: DatabaseFacade
    
    Get the rating for this pic intersected by this set at this size
    
    Specified by:
    
    getPicRate in interface DatabaseFacade
    
    Parameters:
    
    picName - The name of the Pic whose rating we want
    
    set - The set to do the rating check against. If a pic is Audrey-7 and we want Carl, then this is probably not one we want.
    
    size - The size of the pic we care about
    
    Returns:
    
    The rate of the pic. This is a double because we could get (6+7)/2 for a rate.
  - getPicRate
```
public double getPicRate(java.lang.String picName,
                         MetaSet metaSet,
                         int size)
```
    Description copied from interface: DatabaseFacade
    
    Get the rating for this pic intersected by this MetaSet at this size
    
    Specified by:
    
    getPicRate in interface DatabaseFacade
    
    Parameters:
    
    picName - The Pic whose rating we want
    
    metaSet - The metaSet to do the rating check against.
    
    size - The size of the pic we care about
    
    Returns:
    
    The rate of the pic. This is a double because we could get (6+7)/2 for a rate.
  - getPicMaxThumbCacheDirUsed
```
public int getPicMaxThumbCacheDirUsed()
```
    Description copied from interface: DatabaseFacade
    
    Determine the highest numbered thumb cache subdirectory used.
    
    Specified by:
    
    getPicMaxThumbCacheDirUsed in interface DatabaseFacade
    
    Returns:
    
    the highest number, or 0 if no thumbs are cached.
  - getPicThumbCacheFillCount
```
public int getPicThumbCacheFillCount(int cacheDir)
```
    Description copied from interface: DatabaseFacade
    
    Determine the number of cached thumbs in this cache directory.
    Note that this doesn't actually check if the thumbs exist, only if they have a database entry.
    
    Specified by:
    
    getPicThumbCacheFillCount in interface DatabaseFacade
    
    Parameters:
    
    cacheDir - The directory to check
    
    Returns:
    
    The Count
  - getUuid
```
public java.lang.String getUuid(java.lang.String setName,
                                int size)
```
    Description copied from interface: DatabaseFacade
    
    Make a uuid String based on a setName and a size
    
    Specified by:
    
    getUuid in interface DatabaseFacade
    
    Parameters:
    
    setName - The name of the Set
    
    size - The size
    
    Returns:
    
    The uuid String. i.e. "G_075"
  - normalizeSize
```
public int normalizeSize(int size)
```
    Given an arbitrary tile height, return a height that we actually know about.
    
    Parameters:
    
    size - The size to normalize
    
    Returns:
    
    One of the sizes from our size array of filters
  - getClientSyncTimestamp
```
public java.util.Date getClientSyncTimestamp(java.lang.String host)
```
    Description copied from interface: DatabaseFacade
    
    Get the last time this client sync'd.
    
    Specified by:
    
    getClientSyncTimestamp in interface DatabaseFacade
    
    Parameters:
    
    host - The host to fetch
    
    Returns:
    
    The date/time of sync or null if never synced.
  - setClientSyncTimestamp
```
public void setClientSyncTimestamp(java.lang.String host)
```
    Description copied from interface: DatabaseFacade
    
    Set the last time this client sync'd to now.
    
    Specified by:
    
    setClientSyncTimestamp in interface DatabaseFacade
    
    Parameters:
    
    host - The host to fetch
  - updateSetTimestamp
```
public void updateSetTimestamp(java.lang.String setSize)
```
    Specified by:
    
    updateSetTimestamp in interface DatabaseFacade
  - storeSyncClient
```
public void storeSyncClient(SyncClient syncClient)
```
    Specified by:
    
    storeSyncClient in interface DatabaseFacade
  - getSyncClients
```
public java.util.List<SyncClient> getSyncClients()
```
    Specified by:
    
    getSyncClients in interface DatabaseFacade
  - storeSyncServer
```
public void storeSyncServer(SyncServer syncServer)
```
    Specified by:
    
    storeSyncServer in interface DatabaseFacade
  - getSyncServers
```
public java.util.List<SyncServer> getSyncServers()
```
    Specified by:
    
    getSyncServers in interface DatabaseFacade

Class DatabaseImpl

Field Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

logger

Method Detail

setPicManCommonFacade

setDEBUG

setChainsDao

setContactsDao

setFiltersDao

setFiltersMicroSetsDao

setMetaSetsDao

setMosaicTilesDao

setMosaicsDao

setMosaicBatchesDao

setMosaicVectorsDao

setPicsDao

setPostersDao

setRootsDao

setServer_SyncDao

setSystemDao

setSetsDao

setSetTimestampsDao

setUsersDao

setVirginsDao

getChainsDao

setDbUser

getDbUser

setDbUrl

getDbUrl

getSystem

saveSystem

getPicExtensions

getThumbHeight

getRoots

getRootCount

getRoot

getRoot

setRoots

addRoot

storeRoot

deleteRoot

getInactiveRoots

getActiveRoots

getSets

getSetsClone

getSetCount

getSet

getSet

setSets

addSet

storeSet

deleteSet

renameSet

getInactiveSets

getActiveSets

getMetaSet

storeMetaSet

getMetaSetColumns

getMetaSetFilter

getMosaic

getMosaic

getMosaicTileCount

getMosaics

storeMosaic

deleteMosaic

getMosaicBatch

getMosaicBatches

storeMosaicBatch

deleteMosaicTiles

getMosaicTiles

storeMosaicTile

updateMosaicVectors

getMosaicVectors

getPoster

getPosters

storePoster

deletePoster