java.lang.Object
org.jdaemon.era.sql.Query
org.jdaemon.era.sql.TableQuery
- All Implemented Interfaces:
- java.lang.Cloneable
- public class TableQuery
- extends Query
Query for extracting data from a simple table
| Fields inherited from class org.jdaemon.era.sql.Query |
|
|
Method Summary |
boolean |
equals(java.lang.Object other)
Equality operator. |
protected java.util.Iterator |
getAggregates(org.jdaemon.util.sql.ConnectionManager connection,
org.jdaemon.era.Grouping grouping)
Abstract method - retrieve attribute values and agregates from a database connection
This method provides should be overridden in order to provide and implementation for
getAggregates(grouping). |
java.lang.String |
getAggregatesQuery(org.jdaemon.era.Grouping grouping)
|
java.lang.String |
getTableName()
|
protected java.util.Iterator |
getValues(org.jdaemon.util.sql.ConnectionManager connection_manager,
java.lang.String[] attributes,
org.jdaemon.era.Sort[] sorts)
Abstract method - retrieve attribute values from a database connection
This method provides should be overridden in order to provide and implementation for
getValues(attributes, sorts). |
java.lang.String |
getValuesQuery(java.lang.String[] attributes,
org.jdaemon.era.Sort[] sorts)
|
private static void |
writeAggregateFunction(org.jdaemon.era.Aggregate aggregate,
java.lang.StringBuffer buffer)
|
private static void |
writeAggregateSelects(org.jdaemon.util.QuickList aggregates,
java.lang.StringBuffer buffer)
|
private static void |
writeAttributeSelects(java.lang.String[] attributes,
java.lang.StringBuffer sql)
|
private static void |
writeConstraint(Query.Constraint constraint,
java.lang.StringBuffer buffer)
|
private static void |
writeConstraints(org.jdaemon.util.QuickList constraints,
java.lang.StringBuffer buffer)
|
private static void |
writeGroups(org.jdaemon.util.QuickList sorts,
java.lang.StringBuffer buffer)
|
private static void |
writeOperand(java.lang.Object operand,
java.lang.StringBuffer buffer)
|
private static void |
writeSort(org.jdaemon.era.Sort sort,
java.lang.StringBuffer sql)
|
private static void |
writeSorts(org.jdaemon.era.Sort[] sorts,
java.lang.StringBuffer sql)
|
table_name
private java.lang.String table_name
QUOTED_FORMAT
private static java.text.Format QUOTED_FORMAT
DATE_FORMAT
private static java.text.Format DATE_FORMAT
TableQuery
public TableQuery(org.jdaemon.util.sql.ConnectionManager connection_manager,
java.lang.String table_name)
- Creates a new instance of TableQuery
getTableName
public java.lang.String getTableName()
equals
public boolean equals(java.lang.Object other)
- Description copied from class:
Query
- Equality operator.
Query objects are deemed to be equal if all of the below conditions apply:
- The connection factory used by this query equals the connection factory used by the other query
- All of the constraints in this query and in the other query are both individually equal and were applied in the same order
- Overrides:
equals in class Query
writeGroups
private static void writeGroups(org.jdaemon.util.QuickList sorts,
java.lang.StringBuffer buffer)
writeAggregateFunction
private static void writeAggregateFunction(org.jdaemon.era.Aggregate aggregate,
java.lang.StringBuffer buffer)
writeAggregateSelects
private static void writeAggregateSelects(org.jdaemon.util.QuickList aggregates,
java.lang.StringBuffer buffer)
writeOperand
private static void writeOperand(java.lang.Object operand,
java.lang.StringBuffer buffer)
writeConstraint
private static void writeConstraint(Query.Constraint constraint,
java.lang.StringBuffer buffer)
writeConstraints
private static void writeConstraints(org.jdaemon.util.QuickList constraints,
java.lang.StringBuffer buffer)
getAggregates
protected java.util.Iterator getAggregates(org.jdaemon.util.sql.ConnectionManager connection,
org.jdaemon.era.Grouping grouping)
throws java.sql.SQLException,
org.jdaemon.util.resource.ResourceManagerException
- Description copied from class:
Query
- Abstract method - retrieve attribute values and agregates from a database connection
This method provides should be overridden in order to provide and implementation for
getAggregates(grouping).
- Specified by:
getAggregates in class Query
writeAttributeSelects
private static void writeAttributeSelects(java.lang.String[] attributes,
java.lang.StringBuffer sql)
writeSort
private static void writeSort(org.jdaemon.era.Sort sort,
java.lang.StringBuffer sql)
writeSorts
private static void writeSorts(org.jdaemon.era.Sort[] sorts,
java.lang.StringBuffer sql)
getValues
protected java.util.Iterator getValues(org.jdaemon.util.sql.ConnectionManager connection_manager,
java.lang.String[] attributes,
org.jdaemon.era.Sort[] sorts)
throws java.sql.SQLException,
org.jdaemon.util.resource.ResourceManagerException
- Description copied from class:
Query
- Abstract method - retrieve attribute values from a database connection
This method provides should be overridden in order to provide and implementation for
getValues(attributes, sorts).
- Specified by:
getValues in class Query
getValuesQuery
public java.lang.String getValuesQuery(java.lang.String[] attributes,
org.jdaemon.era.Sort[] sorts)
getAggregatesQuery
public java.lang.String getAggregatesQuery(org.jdaemon.era.Grouping grouping)