DatabaseFacade

All Known Implementing Classes:

DatabaseImpl
```
public interface DatabaseFacade
```
API into the PicMan database

Since:

2006/07/17

Author:

Dick Balaska

See Also:

DatabaseFacade.java,
JOCLPoolingDriver.jocl Configuration file for the database

Method Summary

All Methods Instance Methods Abstract 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 root)` Add this `Root` to the Database.
`void`	`addSet(Set set)` Add this new `Set` to the database.
`void`	`addVirgin(java.lang.String picName)` 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 set)` Delete this `Set` from the database.
`void`	`deleteVirgin(java.lang.String picName)` 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()` Get a List of active `Set`s
`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.
`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 index)` 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 setName, 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()` Get a List of inactive `Set`s
`MetaSet`	`getMetaSet(int sid)` Get the `MetaSet` that matches this Set ID.
`java.util.List<java.lang.String>`	`getMetaSetColumns()` Get a List of Column names for the `MetaSet`s.
`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()` Fetch a reference to the `System` configuration.
`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 picName)` Is this picName a `Virgin`?
`void`	`renameSet(java.lang.String oldName, java.lang.String newName)` Rename this Set.
`void`	`saveSystem(System system)` Flush the `System` configuration back to the database.
`void`	`setClientSyncTimestamp(java.lang.String host)` Set the last time this client sync'd to now.
`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`	`setPicManCommonFacade(PicManCommonFacade picManCommonFacade)` Set the callback to the partial main business facade.
`void`	`setRoots(java.util.List<Root> roots)` Set the `Root`s in the Database to be this List.
`void`	`setSets(java.util.List<Set> sets)` Set the `Set`s in the Database to be this List.
`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)` Update this existing `Set` in 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)`

- Method Detail
  - setDEBUG
```
void setDEBUG(boolean debugFlag)
```
    Enable logger output on the database
    
    Parameters:
    
    debugFlag - true == turn on debugging.
  - setPicManCommonFacade
```
void setPicManCommonFacade(PicManCommonFacade picManCommonFacade)
```
    Set the callback to the partial main business facade. We are interested in the error handler.
    
    Parameters:
    
    picManCommonFacade - Where the error handler lives.
  - getContact
```
Contact getContact(int cid,
                   java.lang.String name)
```
    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.
    
    Parameters:
    
    cid - The Chain ID
    
    name - The qualified name of this contact. i.e. "Gail-100-02"
    
    Returns:
    
    The Contact
  - getContact
```
Contact getContact(int cid,
                   java.lang.String setName,
                   int size,
                   int index)
```
    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.
    
    Parameters:
    
    cid - The Chain ID
    
    setName - The name of the Set that was used
    
    size - The Thumbnail size
    
    index - Which of this series of contacts
    
    Returns:
    
    The Contact
  - addContact
```
void addContact(Contact c)
```
    Add this Contact to the database.
    
    Parameters:
    
    c - The Contact
  - getNewestContact
```
Contact getNewestContact()
```
    Fetch the newest Contact made. Basically this tells us the last time Contacts were made.
    
    Returns:
    
    The newest Contact in the database.
  - getContactOldestMap
```
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. "G-100" / v = Date
    
    Parameters:
    
    chain - Which Chain to process
    
    Returns:
    
    the map
  - getChains
```
java.util.List<Chain> getChains()
```
    Get a List of all of the Chains in the database.
    
    Returns:
    
    The List
  - getChainCount
```
int getChainCount()
```
    Return the number of Chains in the Database.
    
    Returns:
    
    The Count
    
    Throws:
    
    DataAccessException - It broke.
  - getChain
```
Chain getChain(java.lang.String chainName)
```
    Fetch a Chain based on its name.
    
    Parameters:
    
    chainName - The name to query.
    
    Returns:
    
    The chain or null if not found.
  - getChain
```
Chain getChain(int cid)
```
    Fetch a Chain based on its Chain ID.
    
    Parameters:
    
    cid - The Chain ID to query.
    
    Returns:
    
    The chain or null if not found.
  - deleteChain
```
void deleteChain(Chain chain)
```
    Delete this Chain from the Database.
    
    Parameters:
    
    chain - The Chain to delete.
  - storeChain
```
void storeChain(Chain chain)
```
    Store this Chain in the Database.
    
    Parameters:
    
    chain - The Chain to write.
  - getSetsInChain
```
java.util.List<Set> getSetsInChain(int cid)
```
    Return a list of Sets in a Chain
    
    Parameters:
    
    cid - The Chain to query
    
    Returns:
    
    A List of Set
  - getSetSizesInChain
```
java.util.List<SetSize> getSetSizesInChain(int cid,
                                           int sid)
```
    Return a list of SetSize for this set that are in this Chain
    
    Parameters:
    
    cid - The chain id
    
    sid - The Set id
    
    Returns:
    
    A list of SetSizes
  - getFilterCount
```
int getFilterCount()
```
    Get the number of Filters in the database.
    
    Returns:
    
    the count.
  - getFilterColumns
```
java.util.List<java.lang.String> getFilterColumns()
```
    Get a list of the Filter column names from the database.
    
    Returns:
    
    The List.
  - getFilters
```
java.util.List<Filter> getFilters()
```
    Get a list of all of the Filters in the database.
    
    Returns:
    
    The List.
  - getFiltersBySet
```
java.util.List<Filter> getFiltersBySet(java.lang.String setName,
                                       int size)
```
    Get a list of all of the Filters for this set/size.
    
    Parameters:
    
    setName - The name of the Set to query.
    
    size - The thumbnail size to query.
    
    Returns:
    
    A List of the Filters that match this query
  - getPicNamesBySet
```
java.util.List<java.lang.String> getPicNamesBySet(java.lang.String setName,
                                                  int size)
```
    Get a List of the Pic Names of the Filters that match this query.
    
    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
```
java.util.List<java.lang.String> getPicNamesBySet(Set set,
                                                  int size)
```
    Get a List of the Pic Names of the Filters that match this query.
    
    Parameters:
    
    set - The Set to query
    
    size - The thumbnail size to query
    
    Returns:
    
    A List of the Pic Names that match this query
  - getPicNamesBySet
```
java.util.List<java.lang.String> getPicNamesBySet(MetaSet set,
                                                  int size,
                                                  int rateOp,
                                                  int rateVal)
```
    Get a List of the Pic Names of the Filters that match this query.
    
    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
```
java.util.List<java.lang.String> getPicNamesBySet(Set set,
                                                  int size,
                                                  int rateOp,
                                                  int rateVal)
```
    Get a List of the Pic Names of the Filters that match this valued query. This allows to say "mlb < 5".
    
    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.
  - getPicNamesBySet
```
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 Filters that match this valued query. This allows to say "mlb < 5".
    
    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.
  - getPicNamesByFunc
```
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. See Set for the list of valid function numbers.
    
    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
```
java.util.HashMap<java.lang.String,java.util.Date> getSetTimestamps()
```
    Return a hash of the newest filter for each set/size. k = Set i.e. "G_100" / v = Date
    
    Returns:
    
    The Hash
  - addFilter
```
void addFilter(Filter filter)
```
    Add a Filter to the database, overwriting any existing filter for this pic.
    
    Parameters:
    
    filter - The new (or used) Filter.
  - getFilter
```
Filter getFilter(java.lang.String picName)
```
    Get the Filter for the pic named.
    
    Parameters:
    
    picName - The name of the Pic.
    
    Returns:
    
    the Filter
  - getPicFromFilterMicroSet
```
FilterMicroSet getPicFromFilterMicroSet(int pid,
                                        int sid)
```
    Get the FilterMicroSet for this pic in this set.
    
    Parameters:
    
    pid - The pid the Pic.
    
    sid - The sid of the set to query.
    
    Returns:
    
    The FilterMicroSet or null if not found.
  - getMetaSet
```
MetaSet getMetaSet(int sid)
```
    Get the MetaSet that matches this Set ID.
    
    Parameters:
    
    sid - The SetID to query.
    
    Returns:
    
    The MetaSet
  - storeMetaSet
```
void storeMetaSet(MetaSet mset)
```
    Store this MetaSet to the database.
    
    Parameters:
    
    mset - The MetaSet to write.
  - getMetaSetColumns
```
java.util.List<java.lang.String> getMetaSetColumns()
```
    Get a List of Column names for the MetaSets.
    
    Returns:
    
    a List of "columns" for the known metasets
  - getMetaSetFilter
```
MetaSetFilter getMetaSetFilter()
```
    Fetch a reference to the MetaSet filter processor.
    
    Returns:
    
    A reference to the database's MetaSet filter processor.
  - getMosaics
```
java.util.List<Mosaic> getMosaics()
```
    Get a List of all of the Mosaics in the database.
    
    Returns:
    
    The List of Mosaics
  - getMosaic
```
Mosaic getMosaic(int mid)
```
    Get a Mosaic from the database based on this Mosaic ID.
    
    Parameters:
    
    mid - The Mosaic ID to query.
    
    Returns:
    
    The Mosaic that matches this mid, or null if not found.
  - getMosaic
```
Mosaic getMosaic(java.lang.String masterPic,
                 java.lang.String engine,
                 int sid,
                 int tileHeight)
```
    Find the Mosaic in the database that matches these parameters.
    
    Parameters:
    
    masterPic -
    
    engine -
    
    sid -
    
    tileHeight -
    
    Returns:
    
    The mosaic that matches these parameters, or null if not found.
  - getMosaicTileCount
```
int getMosaicTileCount(int mid)
```
    Return the number of tiles we have stored for this Mosaic
    
    Parameters:
    
    mid - The mosaicId
    
    Returns:
    
    The count
  - deleteMosaic
```
void deleteMosaic(int mid)
```
    Delete the Mosaic from the database that has this Mosaic ID.
    
    Parameters:
    
    mid - The Mosaic ID to delete.
  - storeMosaic
```
void storeMosaic(Mosaic mosaic)
```
    Store this Mosaic in the database.
    
    Parameters:
    
    mosaic - The Mosaic to store.
  - getMosaicBatches
```
java.util.List<MosaicBatch> getMosaicBatches()
```
    Get a List of MosaicBatches in the database.
    
    Returns:
    
    The List of MosaicBatches
  - getMosaicBatch
```
MosaicBatch getMosaicBatch(int mbid)
```
    Get the MosaicBatch that matches this mbid
    
    Parameters:
    
    mbid - The MosaicBatch id to query.
    
    Returns:
    
    The MosaicBatch that matches or null if not found.
  - storeMosaicBatch
```
void storeMosaicBatch(MosaicBatch mbatch)
```
    Store this MosaicBatches in the database.
    
    Parameters:
    
    mbatch - The MosaicBatch to store
  - getMosaicTiles
```
java.util.List<MosaicTile> getMosaicTiles(int mid)
```
    Fetch the already built MosaicTiles for this Mosaic
    
    Parameters:
    
    mid - The MosaicID to fetch
    
    Returns:
    
    A List of MosaicTiles
  - deleteMosaicTiles
```
void deleteMosaicTiles(int mid)
```
    Delete the MosaicTiles for the Mosaic specified by this Mosaic ID.
    
    Parameters:
    
    mid - The Mosaic ID to delete.
  - storeMosaicTile
```
void storeMosaicTile(MosaicTile tile)
```
    Store this MosaicTile in the database.
    
    Parameters:
    
    tile - The MosaicTile to store.
  - updateMosaicVectors
```
void updateMosaicVectors(MosaicVector mv)
```
    Store this MosaicVector in the database.
    
    Parameters:
    
    mv - The MosaicVector to store.
  - getMosaicVectors
```
java.util.List<MosaicVector> getMosaicVectors(java.util.List<Pic> picList)
```
    Get the List of MosaicVectors that matches this picList, which probably came from a mosaic Set.
    
    Parameters:
    
    picList - The List of Pics to query
    
    Returns:
    
    The matching List of MosaicVectors. The List may be empty, but not null.
  - getPosters
```
java.util.List<Poster> getPosters()
```
    Get a List of all of the Mosaics in the database.
    
    Returns:
    
    The List of Mosaics
  - getPoster
```
Poster getPoster(int pid)
```
    Get a Poster from the database based on this Poster ID.
    
    Parameters:
    
    pid - The Poster ID to query.
    
    Returns:
    
    The Poster that matches this pid, or null if not found.
  - deletePoster
```
void deletePoster(int pid)
```
    Delete the Poster from the database that has this Poster ID.
    
    Parameters:
    
    pid - The Poster ID to delete.
  - storePoster
```
void storePoster(Poster poster)
```
    Store this Poster in the database.
    
    Parameters:
    
    poster - The Poster to store.
  - addPic
```
void addPic(Pic pic)
```
    Add this Pic to the database.
    
    Parameters:
    
    pic - The Pic to add. pid is assumed to be 0.
  - updatePic
```
void updatePic(Pic pic)
```
    Update this Pic in the database. Pic is assumed to exist and pid must not be 0.
    
    Parameters:
    
    pic - The Pic to update.
  - getPic
```
Pic getPic(java.lang.String picName)
```
    Get a Pic who's name matches this picName.
    
    Parameters:
    
    picName - The name of the Pic to query.
    
    Returns:
    
    The Pic that matches this picName or null.
  - getPic
```
Pic getPic(int pid)
```
    Get a Pic who's pid matches this one.
    
    Parameters:
    
    pid - The pid to query
    
    Returns:
    
    The Pic that matches this pid, or null if not found.
  - getNewestPic
```
Pic getNewestPic()
```
    Get the newest pic in the database.
    
    Returns:
    
    The Pic with the newest Timestamp
  - getRandomPic
```
Pic getRandomPic()
```
    Return a random pic from the database
    
    Returns:
    
    Any pic from the database
  - getPicsByMD5Sum
```
java.util.List<Pic> getPicsByMD5Sum(long md5sum)
```
    Return a list of Pics that have this md5Sum
    
    Parameters:
    
    md5sum -
    
    Returns:
    
    The list, may be empty
  - getRandomHomePagePicName
```
java.lang.String getRandomHomePagePicName(User user)
```
    Return a random pic from the database destined to be a thumbnail on the home page
    
    Parameters:
    
    user - The User who is requesting the Pic
    
    Returns:
    
    The name of any pic from the database that matches the User's preference
  - getPicsMap
```
java.util.HashMap<java.lang.String,java.util.Date> getPicsMap()
```
    Get a HashMap of all of the Pic names in the database.
    
    Returns:
    
    The map
  - getPics
```
java.util.List<Pic> getPics(java.lang.String picName)
```
    Get a List of all of the Pics in the database that match this name. Wildcards are supported.
    
    Parameters:
    
    picName - The name (or partial name) of the pics to fetch.
    
    Returns:
    
    A List of Pics.
  - getPics
```
java.util.List<Pic> getPics()
```
    Get a List of all of the Pics.
    
    Returns:
    
    A List of Pic
  - getPics
```
java.util.List<Pic> getPics(Set set,
                            int size)
```
    Get a list of Pics for this set at this size.
    
    Parameters:
    
    set - The set to use as a filter
    
    size - The size to use as a filter
    
    Returns:
    
    A List of Pic
  - getPicsInDir
```
java.util.List<Pic> getPicsInDir(int rid,
                                 java.lang.String dirName)
```
    Get a list of Pics that are in this subdirectory.
    
    Parameters:
    
    rid - Root id to search under
    
    dirName - The directory, i.e. "2002/20021225"
    
    Returns:
    
    A List of Pic
  - getPicsNewerThan
```
java.util.List<Pic> getPicsNewerThan(java.util.Calendar calendar)
```
    Get a list of Pics that are newer than this date
    
    Parameters:
    
    calendar - The timestamp to compare against
    
    Returns:
    
    The List of Pics
  - getPicMaxThumbCacheDirUsed
```
int getPicMaxThumbCacheDirUsed()
```
    Determine the highest numbered thumb cache subdirectory used.
    
    Returns:
    
    the highest number, or 0 if no thumbs are cached.
  - getPicThumbCacheFillCount
```
int getPicThumbCacheFillCount(int cacheDir)
```
    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.
    
    Parameters:
    
    cacheDir - The directory to check
    
    Returns:
    
    The Count
  - getPicRate
```
double getPicRate(java.lang.String picName,
                  Set set,
                  int size)
```
    Get the rating for this pic intersected by this set at this size
    
    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
```
double getPicRate(java.lang.String picName,
                  MetaSet metaSet,
                  int size)
```
    Get the rating for this pic intersected by this MetaSet at this size
    
    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.
  - getRoots
```
java.util.List<Root> getRoots()
```
    Get a List of all of the Roots
    
    Returns:
    
    A List of all of the Roots in the database
  - getRootCount
```
int getRootCount()
```
    Get the number of Roots in the database
    
    Returns:
    
    The number of Roots
  - getRoot
```
Root getRoot(int rid)
```
    Fetch a Root
    
    Parameters:
    
    rid - The rootId to match
    
    Returns:
    
    The Root
  - getRoot
```
Root getRoot(java.lang.String name)
```
    Fetch a Root
    
    Parameters:
    
    name - The Name of the Root to fetch
    
    Returns:
    
    The Root
  - setRoots
```
void setRoots(java.util.List<Root> roots)
```
    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.
    
    Parameters:
    
    roots - A List of Roots
  - addRoot
```
void addRoot(Root root)
      throws java.lang.Exception
```
    Add this Root to the Database. the Root ID must be 0.
    
    Parameters:
    
    root - The Root to add.
    
    Throws:
    
    java.lang.Exception - Can't do it.
  - deleteRoot
```
void deleteRoot(Root root)
         throws java.lang.Exception
```
    Delete this Root from the database.
    
    Parameters:
    
    root - The Root to delete.
    
    Throws:
    
    java.lang.Exception - Can't do it.
  - storeRoot
```
void storeRoot(Root root)
```
    Store this existing Root in the database. The Root ID must NOT be 0.
    
    Parameters:
    
    root - The existing Root to update.
  - getInactiveRoots
```
java.util.List<Root> getInactiveRoots()
```
    Get a List of Inactive Roots. Inactive Roots will not be scanned for new pics, or included in Sets queries.
    
    Returns:
    
    A List of Roots that the User has disabled.
  - getActiveRoots
```
java.util.List<Root> getActiveRoots()
```
    Get a List of active Roots.
    
    Returns:
    
    A List of Roots
  - getSets
```
java.util.List<Set> getSets()
```
    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.
    
    Returns:
    
    The List of Sets
  - getSetsClone
```
java.util.List<Set> getSetsClone()
```
    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.
    
    Returns:
    
    The List of Sets
  - getSetCount
```
int getSetCount()
```
    Return the number of Sets in the Database.
    
    Returns:
    
    The Number of Sets
  - getSet
```
Set getSet(int sid)
```
    Get the Set that matches this Set ID
    
    Parameters:
    
    sid - The SetID to query
    
    Returns:
    
    The Set that was found or null if no match was made.
  - getSet
```
Set getSet(java.lang.String setName)
```
    Get the Set that matches this Set ID
    
    Parameters:
    
    setName - The name of the Set to query
    
    Returns:
    
    The Set that was found or null if no match was made.
  - setSets
```
void setSets(java.util.List<Set> sets)
```
    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.
    
    Parameters:
    
    sets - A List of Sets
  - addSet
```
void addSet(Set set)
     throws java.lang.Exception
```
    Add this new Set to the database. The Set ID (sid) is assumed to be 0.
    
    Parameters:
    
    set - The Set to add
    
    Throws:
    
    java.lang.Exception - Can't do it
  - deleteSet
```
void deleteSet(Set set)
        throws java.lang.Exception
```
    Delete this Set from the database. This is a very bad thing, as new Set IDs are derived from the number of Sets.
    
    Parameters:
    
    set - The Set to delete.
    
    Throws:
    
    java.lang.Exception - Can't do it.
  - storeSet
```
void storeSet(Set set)
```
    Update this existing Set in the database.
    
    Parameters:
    
    set - The Set to update
  - renameSet
```
void renameSet(java.lang.String oldName,
               java.lang.String newName)
```
    Rename this Set. Includes changing references from the old setname to the new one.
    
    Parameters:
    
    oldName - What is this set called?
    
    newName - What do we want it to be called?
  - getInactiveSets
```
java.util.List<Set> getInactiveSets()
```
    Get a List of inactive Sets
    
    Returns:
    
    The List of Sets that the User has marked as inactive.
  - getActiveSets
```
java.util.List<Set> getActiveSets()
```
    Get a List of active Sets
    
    Returns:
    
    The List of Sets that are NOT marked inactive.
  - getSizeArray
```
int[] getSizeArray()
```
    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.
    
    Returns:
    
    An array of the sizes
  - getSizes
```
java.util.List<java.lang.Integer> getSizes()
```
    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.
    
    Returns:
    
    A List of Integers
    
    See Also:
    
    getSizeArray()
  - getSizeCount
```
int getSizeCount()
```
    Return the number of sizes that we deal with.
    
    Returns:
    
    That would be the number 5.
  - getSystem
```
System getSystem()
```
    Fetch a reference to the System configuration. Note: This is a cached object and changes made outside of this application will not be picked up.
    
    Returns:
    
    The cached System.
  - saveSystem
```
void saveSystem(System system)
```
    Flush the System configuration back to the database.
    
    Parameters:
    
    system - The System to write.
  - getThumbHeight
```
int getThumbHeight()
```
    Get the user's preferred Thumbnail height used when running the editors.
    
    Returns:
    
    The height of the Thumnails (I like 140 pixels).
  - getPicExtensions
```
java.util.List<java.lang.String> getPicExtensions()
```
    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.
    
    Returns:
    
    A List of Extensions, typically just "jpg".
  - getUser
```
User getUser(int userid)
      throws DataAccessException
```
    Get the User who has this userid.
    
    Parameters:
    
    userid - The userid to query.
    
    Returns:
    
    A PicMan User.
    
    Throws:
    
    DataAccessException
  - storeUser
```
void storeUser(User user)
```
    Store this User in the database. Does not affect the BSAccount settings of this User.
    
    Parameters:
    
    user - The User to save.
  - getUuid
```
java.lang.String getUuid(java.lang.String setName,
                         int size)
```
    Make a uuid String based on a setName and a size
    
    Parameters:
    
    setName - The name of the Set
    
    size - The size
    
    Returns:
    
    The uuid String. i.e. "G_075"
  - getVirginCount
```
int getVirginCount()
```
    Return the number of Virgins in the database.
    
    Returns:
    
    The count.
  - getVirgins
```
java.util.List<Virgin> getVirgins()
```
    Get a List of all of the Virgins in the database.
    
    Returns:
    
    The List
  - getVirgins
```
java.util.List<Virgin> getVirgins(int max)
```
    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.
    
    Parameters:
    
    max - The Maximum number of Virgins to put in the List
    
    Returns:
    
    The List.
  - isVirgin
```
boolean isVirgin(java.lang.String picName)
```
    Is this picName a Virgin?
    
    Parameters:
    
    picName - The name of the Pic to query
    
    Returns:
    
    true if this picName is in the Virgins table.
  - addVirgin
```
void addVirgin(java.lang.String picName)
```
    Add this Pic name as a Virgin in the database.
    
    Parameters:
    
    picName - The name of the Pic to add.
  - deleteVirgin
```
void deleteVirgin(java.lang.String picName)
```
    Delete this Pic name from the Virgins table. This Pic is no longer a Virgin.
    
    Parameters:
    
    picName - The name of the Pic to remove.
  - getClientSyncTimestamp
```
java.util.Date getClientSyncTimestamp(java.lang.String host)
```
    Get the last time this client sync'd.
    
    Parameters:
    
    host - The host to fetch
    
    Returns:
    
    The date/time of sync or null if never synced.
  - setClientSyncTimestamp
```
void setClientSyncTimestamp(java.lang.String host)
```
    Set the last time this client sync'd to now.
    
    Parameters:
    
    host - The host to fetch
  - updateSetTimestamp
```
void updateSetTimestamp(java.lang.String setSize)
```
  - storeSyncClient
```
void storeSyncClient(SyncClient syncClient)
```
  - getSyncClients
```
java.util.List<SyncClient> getSyncClients()
```
  - storeSyncServer
```
void storeSyncServer(SyncServer syncServer)
```
  - getSyncServers
```
java.util.List<SyncServer> getSyncServers()
```
  - setDbUser
```
void setDbUser(java.lang.String dbUser)
```
    Set the user who is accessing the database.
    
    Parameters:
    
    dbUser - The database user
  - getDbUser
```
java.lang.String getDbUser()
```
    Get the user who is accessing the database. This is realy a status field, as nothing outside of here accesses the database.
    
    Returns:
    
    Usually "picman" or "picman_dev"
  - setDbUrl
```
void setDbUrl(java.lang.String dbUrl)
```
    Set the database url.
    
    Parameters:
    
    dbUrl - The dbUrl to set.
  - getDbUrl
```
java.lang.String getDbUrl()
```
    Get the url that is accessing the database. This is realy a status field, as nothing outside of here accesses the database.
    
    Returns:
    
    jdbc:mysql://localhost:3306/{something}

Interface DatabaseFacade

Method Summary

Method Detail

setDEBUG

setPicManCommonFacade

getContact

getContact

addContact

getNewestContact

getContactOldestMap

getChains

getChainCount

getChain

getChain

deleteChain

storeChain

getSetsInChain

getSetSizesInChain

getFilterCount

getFilterColumns

getFilters

getFiltersBySet

getPicNamesBySet

getPicNamesBySet

getPicNamesBySet

getPicNamesBySet

getPicNamesBySet

getPicNamesByFunc

getSetTimestamps

addFilter

getFilter

getPicFromFilterMicroSet

getMetaSet

storeMetaSet

getMetaSetColumns

getMetaSetFilter

getMosaics

getMosaic

getMosaic

getMosaicTileCount

deleteMosaic

storeMosaic

getMosaicBatches

getMosaicBatch

storeMosaicBatch

getMosaicTiles

deleteMosaicTiles

storeMosaicTile

updateMosaicVectors

getMosaicVectors

getPosters

getPoster

deletePoster

storePoster

addPic

updatePic

getPic

getPic

getNewestPic

getRandomPic

getPicsByMD5Sum

getRandomHomePagePicName

getPicsMap

getPics

getPics

getPics

getPicsInDir

getPicsNewerThan

getPicMaxThumbCacheDirUsed

getPicThumbCacheFillCount

getPicRate

getPicRate

getRoots

getRootCount

getRoot

getRoot

setRoots

addRoot

deleteRoot

storeRoot