Package tilda.db

Class SelectQueryParsedAndValidated

java.lang.Object

tilda.db.QueryHelper

tilda.db.SelectQuery

tilda.db.SelectQueryParsedAndValidated

public class SelectQueryParsedAndValidated
extends SelectQuery

LDH-NOTE This class allwos to pass in a full string-based where-clause that will be validated against the TildaSQL parser

Author:

ldh

Nested Class Summary

Nested classes/interfaces inherited from class tilda.db.QueryHelper

QueryHelper.CaseClause, QueryHelper.CaseWhen, QueryHelper.Op, QueryHelper.S

Field Summary

Fields

Modifier and Type	Field	Description
protected TildaObjectMetaData	_OMD
protected static org.apache.logging.log4j.Logger	LOG

Fields inherited from class tilda.db.QueryHelper

_C, _Cardinality, _FullSelect, _NoWhereClause, _QueryStr, _SchemaName, _Section, _ST, _SubSelectCount, _TableName, _Where, _WherePos

Constructor Summary

Constructors

Constructor	Description
SelectQueryParsedAndValidated(TildaObjectMetaData OMD, java.lang.String WhereClause)

Method Summary

Modifier and Type	Method	Description
<T> java.util.List<T>	execute(Connection C, int Start, int Size)
<T> void	execute(Connection C, ObjectProcessor<T> OP, int Start, int Size)

Methods inherited from class tilda.db.SelectQuery

execute

Methods inherited from class tilda.db.QueryHelper

addSuperQueryContext, ageBetween, ageEquals, ageEquals, ageGreaterThan, ageGreaterThan, ageGreaterThanOrEqual, ageGreaterThanOrEqual, ageLessThan, ageLessThan, ageLessThanOrEqual, ageLessThanOrEqual, and, any, any, any, any, any, any, any, array, clear, closePar, colOpBase, compareBase, divide, divide, divide, divide, divide, divide, divide, divide, equals, equals, equals, equals, equals, equals, equals, equals, equals, equals, equals, equals, equals, equals, equals, equals, equals, equals, equals, equals, equals, equals, equals, equals, equals, equals, equals, equals, equals, equals, equals, equals, equals, equals, equals, equals, equals, equals, equals, equals, equals, equals, exists, from, from, from, fromSubSelect, fromTable, getCardinality, getColumns, getWhereClause, getWhereClause, groupBy, groupBy, gt, gt, gt, gt, gt, gt, gt, gt, gt, gt, gt, gt, gt, gt, gt, gt, gt, gt, gt, gt, gt, gt, gt, gt, gt, gt, gt, gt, gt, gt, gt, gt, gte, gte, gte, gte, gte, gte, gte, gte, gte, gte, gte, gte, gte, gte, gte, gte, gte, gte, gte, gte, gte, gte, gte, gte, gte, gte, gte, gte, gte, gte, gte, gte, in, in, in, in, in, in, in, in, in, in, in, in, in, in, in, in, in, in, in, in, in, in, in, in, in, in, in, in, in, in, in, in, in, in, in, in, in, in, in, in, in, in, isFullSelectQuery, isNotNull, isNull, isWhereClause, isWhereClauseEmpty, like, like, like, like, like, like, like, like, like, like, like, like, like, like, like, like, like, lt, lt, lt, lt, lt, lt, lt, lt, lt, lt, lt, lt, lt, lt, lt, lt, lt, lt, lt, lt, lt, lt, lt, lt, lt, lt, lt, lt, lt, lt, lt, lt, lt, lt, lte, lte, lte, lte, lte, lte, lte, lte, lte, lte, lte, lte, lte, lte, lte, lte, lte, lte, lte, lte, lte, lte, lte, lte, lte, lte, lte, lte, lte, lte, lte, lte, minus, minus, minus, minus, minus, minus, minus, minus, minus, minus, multiply, multiply, multiply, multiply, multiply, multiply, multiply, multiply, newLine, newLine, not, notEquals, notEquals, notEquals, notEquals, notEquals, notEquals, notEquals, notEquals, notEquals, notEquals, notEquals, notEquals, notEquals, notEquals, notEquals, notEquals, notEquals, notEquals, notEquals, notEquals, notEquals, notEquals, notEquals, notEquals, notEquals, notEquals, notEquals, notEquals, notEquals, notEquals, notExists, opCol, openPar, opOK, opVal, opVal, opVal, opVal, opVal, opVal, opVal, opVal, opVal, opVal, opValBase, or, orderBy, orderBy, orderByBase, orderByCountStar, padding, plus, plus, plus, plus, plus, plus, plus, plus, plus, plus, selectCase, selectColumn, selectColumn, selectColumn, selectColumnBase, selectCountDistinct, selectCountStar, selectDistinctColumn, set, set, set, set, set, set, set, set, set, set, set, set, set, set, set, set, set, set, set, set, set, setColumn, setNow, subWhere, subWhere, subWhere, tableSample, toString, values, valuesBase, where, within

Methods inherited from class java.lang.Object

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

Field Detail

LOG

protected static final org.apache.logging.log4j.Logger LOG

_OMD

protected final TildaObjectMetaData _OMD

Constructor Detail

SelectQueryParsedAndValidated

public SelectQueryParsedAndValidated(TildaObjectMetaData OMD,
                                     java.lang.String WhereClause)
                              throws java.lang.Exception

Throws:

java.lang.Exception

Method Detail

execute

public <T> java.util.List<T> execute(Connection C,
                                     int Start,
                                     int Size)
                              throws java.lang.Exception

Throws:

java.lang.Exception

execute

public <T> void execute(Connection C,
                        ObjectProcessor<T> OP,
                        int Start,
                        int Size)
                 throws java.lang.Exception

Throws:

java.lang.Exception