Package tilda.db

Class SelectQuery

java.lang.Object

tilda.db.QueryHelper

tilda.db.SelectQuery

Direct Known Subclasses:

SelectQueryParsedAndValidated

public class SelectQuery
extends QueryHelper

LDH-NOTE This class helps build queries more safely, but it's not a compile-time tool. Therefore, there is no point in trying to catch syntax errors as the database will do that plenty fine.
It's tempting to add extra features to catch mismatched parentheses, checking there is no duplicate table names in the From clause. The only thing that was interesting is that using operators in the SET part of a select or update causes weird things. For example, select a=3 evaluates as a boolean expression which i find weird, so i check for it. Other than that, nothing except major issues like

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 inherited from class tilda.db.QueryHelper

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

Constructor Summary

Constructors

Constructor	Description
SelectQuery(Connection C, java.lang.String SchemaName, java.lang.String TableName, boolean fullSelect)

Method Summary

Modifier and Type	Method	Description
int	execute(RecordProcessor RP, int Start, int Size)

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

Constructor Detail

SelectQuery

public SelectQuery(Connection C,
                   java.lang.String SchemaName,
                   java.lang.String TableName,
                   boolean fullSelect)
            throws java.lang.Exception

Throws:

java.lang.Exception

Method Detail

execute

public int execute(RecordProcessor RP,
                   int Start,
                   int Size)
            throws java.lang.Exception

Throws:

java.lang.Exception