com.bretth.osmosis.core.pgsql.v0_6.impl
Class WayNodeBuilder

java.lang.Object
  extended by com.bretth.osmosis.core.pgsql.v0_6.impl.EntityFeatureBuilder<DbOrderedFeature<WayNode>>
      extended by com.bretth.osmosis.core.pgsql.v0_6.impl.WayNodeBuilder

public class WayNodeBuilder
extends EntityFeatureBuilder<DbOrderedFeature<WayNode>>

Reads and writes way nodes to jdbc classes.

Author:
Brett Henderson

Constructor Summary
WayNodeBuilder()
           
 
Method Summary
 DbOrderedFeature<WayNode> buildEntity(java.sql.ResultSet resultSet)
          Creates a new entity based upon the current row in the result set.
 java.lang.String getEntityName()
          Returns the name of the entity feature.
 java.lang.String getParentEntityName()
          Returns the name of the entity features entity type.
 java.lang.String getSqlDefaultOrderBy()
          Provides a default SQL ORDER BY clause suitable for this entity feature.
 java.lang.String getSqlDelete(boolean filterByEntityId)
          The SQL DELETE statement for deleting entity features.
 java.lang.String getSqlInsert(int rowCount)
          The SQL INSERT statement for adding features.
 java.lang.String getSqlSelect(boolean filterByEntityId, boolean orderBy)
          The SQL SELECT statement for retrieving entity feature details.
 int populateEntityParameters(java.sql.PreparedStatement statement, int initialIndex, DbOrderedFeature<WayNode> entityFeature)
          Sets entity values as bind variable parameters to an entity insert query.
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

WayNodeBuilder

public WayNodeBuilder()
Method Detail

getParentEntityName

public java.lang.String getParentEntityName()
Returns the name of the entity features entity type.

Specified by:
getParentEntityName in class EntityFeatureBuilder<DbOrderedFeature<WayNode>>
Returns:
The parent entity name.

getEntityName

public java.lang.String getEntityName()
Returns the name of the entity feature. This is used for error messages.

Specified by:
getEntityName in class EntityFeatureBuilder<DbOrderedFeature<WayNode>>
Returns:
The entity name.

getSqlSelect

public java.lang.String getSqlSelect(boolean filterByEntityId,
                                     boolean orderBy)
The SQL SELECT statement for retrieving entity feature details.

Specified by:
getSqlSelect in class EntityFeatureBuilder<DbOrderedFeature<WayNode>>
Parameters:
filterByEntityId - If true, a WHERE clause will be added filtering by the entity id column.
orderBy - If true, a default ORDER BY clause will be added ordering by the entity id column at a minimum and possibly other fields depending on implementation.
Returns:
The SQL string.

getSqlDefaultOrderBy

public java.lang.String getSqlDefaultOrderBy()
Provides a default SQL ORDER BY clause suitable for this entity feature.

Overrides:
getSqlDefaultOrderBy in class EntityFeatureBuilder<DbOrderedFeature<WayNode>>
Returns:
The ORDER BY clause.

getSqlInsert

public java.lang.String getSqlInsert(int rowCount)
The SQL INSERT statement for adding features.

Specified by:
getSqlInsert in class EntityFeatureBuilder<DbOrderedFeature<WayNode>>
Parameters:
rowCount - The number of rows to insert in a single statement.
Returns:
The SQL string.

getSqlDelete

public java.lang.String getSqlDelete(boolean filterByEntityId)
The SQL DELETE statement for deleting entity features.

Specified by:
getSqlDelete in class EntityFeatureBuilder<DbOrderedFeature<WayNode>>
Parameters:
filterByEntityId - If true, a WHERE clause will be added filtering by the entity id column.
Returns:
The SQL String.

buildEntity

public DbOrderedFeature<WayNode> buildEntity(java.sql.ResultSet resultSet)
Creates a new entity based upon the current row in the result set.

Specified by:
buildEntity in class EntityFeatureBuilder<DbOrderedFeature<WayNode>>
Parameters:
resultSet - The result set to read from.
Returns:
The newly built entity object.

populateEntityParameters

public int populateEntityParameters(java.sql.PreparedStatement statement,
                                    int initialIndex,
                                    DbOrderedFeature<WayNode> entityFeature)
Sets entity values as bind variable parameters to an entity insert query.

Specified by:
populateEntityParameters in class EntityFeatureBuilder<DbOrderedFeature<WayNode>>
Parameters:
statement - The prepared statement to add the values to.
initialIndex - The offset index of the first variable to set.
entityFeature - The entity containing the data to be inserted.
Returns:
The current parameter offset.