nl.gx.webmanager.services.seo.dao.impl
Class PageFriendlyURLEntityDAOImpl

java.lang.Object
  nl.gx.webmanager.services.seo.dao.impl.FriendlyURLEntityDAOImpl
      nl.gx.webmanager.services.seo.dao.impl.PageFriendlyURLEntityDAOImpl

All Implemented Interfaces:

FriendlyURLEntityDAO, PageFriendlyURLEntityDAO

public final class PageFriendlyURLEntityDAOImpl
extends FriendlyURLEntityDAOImpl
implements PageFriendlyURLEntityDAO

Data access methods specific for friendly URLs of pages.

Author:

Sander Dahlberg

Constructor Summary

PageFriendlyURLEntityDAOImpl(SEODatabaseUtil seoDatabaseUtil)
Constructor.

Method Summary

java.util.List<FriendlyURLEntity>	getAlternativeEntities(FriendlyURLEntity entity) Returns entities with an alternative path that conflicts with the given entity's URL title.
protected java.util.List<java.lang.Object>	getAvailabilityArguments(FriendlyURLEntity entity) Returns the SQL arguments for checking the availability of a friendly URL.
protected java.lang.String	getAvailabilityQuery() Returns SQL query that confirms a given friendly URL is unique.
protected java.lang.String	getDeleteQuery() Returns SQL delete query used for deleting friendly URLs.
java.util.List<FriendlyURLEntity>	getDescendantEntities(FriendlyURLEntity entity) Returns descendant entities for the given entity.
FriendlyURLEntity	getEntity(int versionId) Returns a friendly URL entity given its version ID.
protected java.util.List<java.lang.Object>	getInsertArguments(FriendlyURLEntity entity) Returns the SQL arguments for the insertion of the given friendly URL entity.
protected java.lang.String	getInsertQuery() Returns SQL insert query used for creating friendly URLs.
protected java.lang.String	getMatchQuery() Returns SQL query that returns a matching friendly URL.
protected java.lang.String	getMatchQueryNullSequence() Returns SQL query that returns a matching friendly URL.
protected java.lang.String	getReferringQuery() Returns SQL select query used for returning referring friendly URLs.
protected java.lang.String	getSelectByIdQuery() Returns SQL select query for retrieving friendly URL by id.
protected boolean	identifierConflictsWithInMemEntities(FriendlyURLEntity sourceEntity, java.util.List<FriendlyURLEntity> targetEntities) Checks whether the source entity is in conflict with one of the target entities.
protected java.util.List<FriendlyURLEntity>	selectFriendlyURLs(java.lang.String query, java.util.List<java.lang.Object> arguments) Selects friendly URL entities.

Methods inherited from class nl.gx.webmanager.services.seo.dao.impl.FriendlyURLEntityDAOImpl

activate, create, delete, deleteAll, deleteById, determineSequenceNumber, genericIdentifierConflicts, getCreateFields, getEntityById, getGenericInsertArguments, getReferencedEntity, getSelectFields, getSEODatabaseUtil, getSequenceNumber, getURLTitle, identifierConflicts, insertFriendlyURL, lastCurrent, makeIdentifierUnique, refer, refer, updateIdentifiers

Methods inherited from class java.lang.Object

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

Methods inherited from interface nl.gx.webmanager.services.seo.dao.FriendlyURLEntityDAO

activate, create, delete, deleteAll, deleteById, getEntityById, getURLTitle, lastCurrent, makeIdentifierUnique, refer, refer, updateIdentifiers

Constructor Detail

PageFriendlyURLEntityDAOImpl

public PageFriendlyURLEntityDAOImpl(SEODatabaseUtil seoDatabaseUtil)

Constructor.

Parameters:

seoDatabaseUtil - Reference to the SEO database util class.

Method Detail

getEntity

public FriendlyURLEntity getEntity(int versionId)
                            throws FriendlyURLException

Returns a friendly URL entity given its version ID.

Specified by:

getEntity in interface FriendlyURLEntityDAO

Specified by:

getEntity in class FriendlyURLEntityDAOImpl

Parameters:

versionId - The version identifier of the page or media item version for which its friendly URL entity is returned.

Returns:

Friendly URL entity object.

Throws:

FriendlyURLException - If any database access fails.

getAlternativeEntities

public java.util.List<FriendlyURLEntity> getAlternativeEntities(FriendlyURLEntity entity)
                                                         throws FriendlyURLException

Returns entities with an alternative path that conflicts with the given entity's URL title. If entity is null then returns all entities with an alternative path.

Specified by:

getAlternativeEntities in interface PageFriendlyURLEntityDAO

Parameters:

entity - Get alternative entities potentially conflicting with a child of this entity.

Returns:

Alternative friendly URL entities.

Throws:

FriendlyURLException - If any access to the persistent layer failed.

getDescendantEntities

public java.util.List<FriendlyURLEntity> getDescendantEntities(FriendlyURLEntity entity)
                                                        throws FriendlyURLException

Returns descendant entities for the given entity. This method does not retrieve the descendant entities if an entity is planned and all it's parents up to the given entity are planned.

Specified by:

getDescendantEntities in interface PageFriendlyURLEntityDAO

Parameters:

entity - Get descendants for this current entity.

Returns:

Descendant friendly URL entities.

Throws:

FriendlyURLException - If any access to the persistent layer failed.

getSelectByIdQuery

protected java.lang.String getSelectByIdQuery()

Returns SQL select query for retrieving friendly URL by id.

Specified by:

getSelectByIdQuery in class FriendlyURLEntityDAOImpl

Returns:

SQL select query.

getInsertQuery

protected java.lang.String getInsertQuery()

Returns SQL insert query used for creating friendly URLs.

Specified by:

getInsertQuery in class FriendlyURLEntityDAOImpl

Returns:

SQL insert query.

getDeleteQuery

protected java.lang.String getDeleteQuery()

Returns SQL delete query used for deleting friendly URLs.

Specified by:

getDeleteQuery in class FriendlyURLEntityDAOImpl

Returns:

SQL delete query.

getReferringQuery

protected java.lang.String getReferringQuery()

Returns SQL select query used for returning referring friendly URLs.

Specified by:

getReferringQuery in class FriendlyURLEntityDAOImpl

Returns:

SQL select query.

getAvailabilityArguments

protected java.util.List<java.lang.Object> getAvailabilityArguments(FriendlyURLEntity entity)

Returns the SQL arguments for checking the availability of a friendly URL.

Specified by:

getAvailabilityArguments in class FriendlyURLEntityDAOImpl

Parameters:

entity - Friendly URL entity to return its arguments for.

Returns:

Array of arguments for the availability query.

getAvailabilityQuery

protected java.lang.String getAvailabilityQuery()

Returns SQL query that confirms a given friendly URL is unique.

Specified by:

getAvailabilityQuery in class FriendlyURLEntityDAOImpl

Returns:

SQL query for confirming uniqueness.

getInsertArguments

protected java.util.List<java.lang.Object> getInsertArguments(FriendlyURLEntity entity)

Returns the SQL arguments for the insertion of the given friendly URL entity.

Specified by:

getInsertArguments in class FriendlyURLEntityDAOImpl

Parameters:

entity - Friendly URL entity to return its arguments for.

Returns:

Array of arguments for the insert query.

getMatchQuery

protected java.lang.String getMatchQuery()

Returns SQL query that returns a matching friendly URL. Used by FriendlyURLEntityDAOImpl.findMatchFromHistory(FriendlyURLEntity).

Specified by:

getMatchQuery in class FriendlyURLEntityDAOImpl

Returns:

SQL query for finding a matching friendly URL.

getMatchQueryNullSequence

protected java.lang.String getMatchQueryNullSequence()

Returns SQL query that returns a matching friendly URL. Used by FriendlyURLEntityDAOImpl.findMatchFromHistory(FriendlyURLEntity). Difference with FriendlyURLEntityDAOImpl.getMatchQuery() is that the sequence is checked for being null.

Specified by:

getMatchQueryNullSequence in class FriendlyURLEntityDAOImpl

Returns:

SQL query for finding a matching friendly URL.

identifierConflictsWithInMemEntities

protected boolean identifierConflictsWithInMemEntities(FriendlyURLEntity sourceEntity,
                                                       java.util.List<FriendlyURLEntity> targetEntities)

Checks whether the source entity is in conflict with one of the target entities.

Specified by:

identifierConflictsWithInMemEntities in class FriendlyURLEntityDAOImpl

Parameters:

sourceEntity - Source friendly URL entity.

targetEntities - Target friendly URL entities.

Returns:

true if URL identifier is not unique, false otherwise.

selectFriendlyURLs

protected java.util.List<FriendlyURLEntity> selectFriendlyURLs(java.lang.String query,
                                                               java.util.List<java.lang.Object> arguments)
                                                        throws java.sql.SQLException

Selects friendly URL entities. The type of entities in the returned list reflects the type of the implementing class.

Specified by:

selectFriendlyURLs in class FriendlyURLEntityDAOImpl

Parameters:

query - Execute this select query, which must retrieve all friendly URL select fields.

arguments - The arguments for the given query.

Returns:

Array of friendly URL entities.

Throws:

java.sql.SQLException - If a database access error occurs.