Package tilda.db

Class DeleteQuery

java.lang.Object

tilda.db.QueryHelper

tilda.db.DeleteQuery

public class DeleteQuery
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
DeleteQuery(Connection C, java.lang.String SchemaName, java.lang.String TableName)

Method Summary

Modifier and Type	Method	Description
int	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

Constructor Detail

DeleteQuery

public DeleteQuery(Connection C,
                   java.lang.String SchemaName,
                   java.lang.String TableName)
            throws java.lang.Exception

Throws:

java.lang.Exception

Method Detail

execute

public int execute()
            throws java.lang.Exception

Throws:

java.lang.Exception