A C E F G I M N O R S T U V Z

A

addColumns(Vector) - Method in class org.gibello.zql.ZInsert

Specify which columns to insert

addColumnUpdate(String, ZExp) - Method in class org.gibello.zql.ZUpdate

Add one column=value pair to the SET... clause This method also keeps track of the column order

addCustomFunction(String, int) - Method in class org.gibello.zql.ZqlParser

addCustomFunction(String, int) - Static method in class org.gibello.zql.ZUtils

addFrom(Vector) - Method in class org.gibello.zql.ZQuery

Insert the FROM part of the statement

addGroupBy(ZGroupBy) - Method in class org.gibello.zql.ZQuery

Insert a GROUP BY...HAVING clause

addOperand(ZExp) - Method in class org.gibello.zql.ZExpression

Add an operand to the current expression.

addOrderBy(Vector) - Method in class org.gibello.zql.ZQuery

Insert an ORDER BY clause

addSelect(Vector) - Method in class org.gibello.zql.ZQuery

Insert the SELECT part of the statement

addSet(ZExpression) - Method in class org.gibello.zql.ZQuery

Insert a SET clause (generally UNION, INTERSECT or MINUS)

addSet(Hashtable) - Method in class org.gibello.zql.ZUpdate

Insert a SET... clause in the UPDATE statement

addTables(Vector) - Method in class org.gibello.zql.ZLockTable

addValueSpec(ZExp) - Method in class org.gibello.zql.ZInsert

Specify the VALUES part or SQL sub-query of the INSERT statement

addWhere(ZExp) - Method in class org.gibello.zql.ZDelete

Add a WHERE clause to the DELETE statement

addWhere(ZExp) - Method in class org.gibello.zql.ZQuery

Insert a WHERE clause

addWhere(ZExp) - Method in class org.gibello.zql.ZUpdate

Insert a WHERE... clause in the UPDATE statement

C

COLUMNNAME - Static variable in class org.gibello.zql.ZConstant

E

eval(ZTuple, ZExp) - Method in class org.gibello.zql.data.ZEval

Evaluate a boolean expression to true or false (for example, SQL WHERE clauses are boolean expressions)

evalExpValue(ZTuple, ZExp) - Method in class org.gibello.zql.data.ZEval

Evaluate a numeric or string expression (example: a+1)

F

FORM_COLUMN - Static variable in class org.gibello.zql.ZAliasedName

FORM_TABLE - Static variable in class org.gibello.zql.ZAliasedName

G

getAggregate() - Method in class org.gibello.zql.ZSelectItem

If this item is an aggregate function, return the function name.

getAggregateCall(String) - Static method in class org.gibello.zql.ZUtils

getAlias() - Method in class org.gibello.zql.ZAliasedName

getAlias() - Method in class org.gibello.zql.ZUpdate

getAscOrder() - Method in class org.gibello.zql.ZOrderBy

Get the order (ascending or descending)

getAttIndex(String) - Method in class org.gibello.zql.data.ZTuple

Return the index of the attribute corresponding to the name

getAttName(int) - Method in class org.gibello.zql.data.ZTuple

Return the name of the attribute corresponding to the index

getAttValue(int) - Method in class org.gibello.zql.data.ZTuple

Return the value of the attribute corresponding to the index

getAttValue(String) - Method in class org.gibello.zql.data.ZTuple

Return the value of the attribute whith the given name

getColumn() - Method in class org.gibello.zql.ZAliasedName

getColumns() - Method in class org.gibello.zql.ZInsert

Get the columns involved in the INSERT statement.

getColumnUpdate(String) - Method in class org.gibello.zql.ZUpdate

Get the SQL expression that specifies a given column's update value.

getColumnUpdate(int) - Method in class org.gibello.zql.ZUpdate

Get the SQL expression that specifies a given column's update value.

getColumnUpdateCount() - Method in class org.gibello.zql.ZUpdate

Returns the number of column/value pairs in the SET... clause.

getColumnUpdateName(int) - Method in class org.gibello.zql.ZUpdate

Get the column name that corresponds to a given index.

getComment() - Method in class org.gibello.zql.ZTransactStmt

getExpression() - Method in class org.gibello.zql.ZOrderBy

Get the ORDER BY expression.

getExpression() - Method in class org.gibello.zql.ZSelectItem

getFrom() - Method in class org.gibello.zql.ZQuery

Get the FROM part of the statement

getGroupBy() - Method in class org.gibello.zql.ZGroupBy

Get the GROUP BY expressions

getGroupBy() - Method in class org.gibello.zql.ZQuery

Get the GROUP BY...HAVING part of the statement

getHaving() - Method in class org.gibello.zql.ZGroupBy

Get the HAVING clause

getLockMode() - Method in class org.gibello.zql.ZLockTable

getNumAtt() - Method in class org.gibello.zql.data.ZTuple

Return the number of attributes in the tupple

getOperand(int) - Method in class org.gibello.zql.ZExpression

Get an operand according to its index (position).

getOperands() - Method in class org.gibello.zql.ZExpression

Get this expression's operands.

getOperator() - Method in class org.gibello.zql.ZExpression

Get this expression's operator.

getOrderBy() - Method in class org.gibello.zql.ZQuery

Get the ORDER BY clause

getQuery() - Method in class org.gibello.zql.ZInsert

Get the sub-query (ex. in INSERT INTO table1 SELECT * FROM table2;, the sub-query is SELECT * FROM table2;)

getSchema() - Method in class org.gibello.zql.ZAliasedName

getSelect() - Method in class org.gibello.zql.ZQuery

Get the SELECT part of the statement

getSet() - Method in class org.gibello.zql.ZQuery

Get the SET clause (generally UNION, INTERSECT or MINUS)

getSet() - Method in class org.gibello.zql.ZUpdate

Get the whole SET... clause

getTable() - Method in class org.gibello.zql.ZAliasedName

getTable() - Method in class org.gibello.zql.ZDelete

getTable() - Method in class org.gibello.zql.ZInsert

Get the name of the table involved in the INSERT statement.

getTable() - Method in class org.gibello.zql.ZUpdate

getTables() - Method in class org.gibello.zql.ZLockTable

getType() - Method in class org.gibello.zql.ZConstant

getValue() - Method in class org.gibello.zql.ZConstant

getValues() - Method in class org.gibello.zql.ZInsert

Get the VALUES part of the INSERT statement

getWhere() - Method in class org.gibello.zql.ZDelete

getWhere() - Method in class org.gibello.zql.ZQuery

Get the WHERE part of the statement

getWhere() - Method in class org.gibello.zql.ZUpdate

Get the WHERE clause of this UPDATE statement.

I

initParser(InputStream) - Method in class org.gibello.zql.ZqlParser

Initialize (or re-initialize) the input stream for the parser.

isAggregate(String) - Static method in class org.gibello.zql.ZUtils

isAttribute(String) - Method in class org.gibello.zql.data.ZTuple

To know if an attributes is already defined

isCustomFunction(String) - Static method in class org.gibello.zql.ZUtils

isDistinct() - Method in class org.gibello.zql.ZQuery

isExpression() - Method in class org.gibello.zql.ZSelectItem

isForUpdate() - Method in class org.gibello.zql.ZQuery

isNowait() - Method in class org.gibello.zql.ZLockTable

isReadOnly() - Method in class org.gibello.zql.ZTransactStmt

isWildcard() - Method in class org.gibello.zql.ZAliasedName

M

main(String[]) - Static method in class org.gibello.zql.data.ZEval

main(String[]) - Static method in class org.gibello.zql.ZqlParser

Test program: Parses SQL statements from stdin or from a text file.

N

nbOperands() - Method in class org.gibello.zql.ZExpression

Get the number of operands

NULL - Static variable in class org.gibello.zql.ZConstant

NUMBER - Static variable in class org.gibello.zql.ZConstant

O

org.gibello.zql - package org.gibello.zql

org.gibello.zql.data - package org.gibello.zql.data

R

readExpression() - Method in class org.gibello.zql.ZqlParser

Parse an SQL Expression (like the WHERE clause of an SQL query).

readStatement() - Method in class org.gibello.zql.ZqlParser

Parse an SQL Statement from the parser's input stream.

readStatements() - Method in class org.gibello.zql.ZqlParser

Parse a set of SQL Statements from the parser's input stream (all the available statements are parsed and returned).

S

setAggregate(String) - Method in class org.gibello.zql.ZSelectItem

Initialize an aggregate function on this item (generally SUM, AVG, MAX, MIN) Example: SELECT AVG(age) FROM people; -> The aggregate function is AVG.

setAlias(String) - Method in class org.gibello.zql.ZAliasedName

Associate an alias with the current name.

setAlias(String) - Method in class org.gibello.zql.ZUpdate

setAscOrder(boolean) - Method in class org.gibello.zql.ZOrderBy

Set the order to ascending or descending (defailt is ascending order).

setAtt(String, Object) - Method in class org.gibello.zql.data.ZTuple

Set the value of the given attribute name

setComment(String) - Method in class org.gibello.zql.ZTransactStmt

setExpression(ZExp) - Method in class org.gibello.zql.ZSelectItem

Initialize this SELECT item as an SQL expression (not a column name nor wildcard) Example: SELECT a+b FROM table1; (a+b is an expression)

setHaving(ZExp) - Method in class org.gibello.zql.ZGroupBy

Initiallize the HAVING part of the GROUP BY

setLockMode(String) - Method in class org.gibello.zql.ZLockTable

setOperands(Vector) - Method in class org.gibello.zql.ZExpression

Set the operands list

setRow(String) - Method in class org.gibello.zql.data.ZTuple

Set the current tuple's column values.

setRow(Vector) - Method in class org.gibello.zql.data.ZTuple

Set the current tuple's column values.

STRING - Static variable in class org.gibello.zql.ZConstant

T

toReversePolish() - Method in class org.gibello.zql.ZExpression

String form of the current expression (reverse polish notation).

toString() - Method in class org.gibello.zql.data.ZTuple

Returns a string representation of the object

toString() - Method in class org.gibello.zql.ZAliasedName

toString() - Method in class org.gibello.zql.ZConstant

toString() - Method in class org.gibello.zql.ZDelete

toString() - Method in class org.gibello.zql.ZExpression

toString() - Method in class org.gibello.zql.ZGroupBy

toString() - Method in class org.gibello.zql.ZInsert

toString() - Method in class org.gibello.zql.ZOrderBy

toString() - Method in class org.gibello.zql.ZQuery

toString() - Method in class org.gibello.zql.ZUpdate

U

UNKNOWN - Static variable in class org.gibello.zql.ZConstant

ZConstant types

V

VARIABLE_PLIST - Static variable in class org.gibello.zql.ZUtils

Z

ZAliasedName - Class in org.gibello.zql

A name/alias association
Names can have two forms: FORM_TABLE for table names ([schema.]table) FORM_COLUMN for column names ([[schema.]table.]column)

ZAliasedName() - Constructor for class org.gibello.zql.ZAliasedName

ZAliasedName(String, int) - Constructor for class org.gibello.zql.ZAliasedName

Create a new ZAliasedName given it's full name.

ZConstant - Class in org.gibello.zql

ZConstant: a representation of SQL constants

ZConstant(String, int) - Constructor for class org.gibello.zql.ZConstant

Create a new constant, given its name and type.

ZDelete - Class in org.gibello.zql

ZDelete: an SQL DELETE statement.

ZDelete(String) - Constructor for class org.gibello.zql.ZDelete

Create a DELETE statement on a given table

ZEval - Class in org.gibello.zql.data

Evaluate SQL expressions

ZEval() - Constructor for class org.gibello.zql.data.ZEval

ZExp - Interface in org.gibello.zql

A common interface for all SQL Expressions (ZQueries, ZExpressions and ZConstants are ZExps).

ZExpression - Class in org.gibello.zql

ZExpression: an SQL Expression An SQL expression is an operator and one or more operands Example: a AND b AND c -> operator = AND, operands = (a, b, c)

ZExpression(String) - Constructor for class org.gibello.zql.ZExpression

Create an SQL Expression given the operator

ZExpression(String, ZExp) - Constructor for class org.gibello.zql.ZExpression

Create an SQL Expression given the operator and 1st operand

ZExpression(String, ZExp, ZExp) - Constructor for class org.gibello.zql.ZExpression

Create an SQL Expression given the operator, 1st and 2nd operands

ZFromItem - Class in org.gibello.zql

ZFromItem: an SQL FROM clause (example: the FROM part of a SELECT...FROM).

ZFromItem() - Constructor for class org.gibello.zql.ZFromItem

Create a new FROM clause.

ZFromItem(String) - Constructor for class org.gibello.zql.ZFromItem

Create a new FROM clause on a given table.

ZGroupBy - Class in org.gibello.zql

ZGroupBy: an SQL GROUP BY...HAVING clause

ZGroupBy(Vector) - Constructor for class org.gibello.zql.ZGroupBy

Create a GROUP BY given a set of Expressions

ZInsert - Class in org.gibello.zql

ZInsert: an SQL INSERT statement

ZInsert(String) - Constructor for class org.gibello.zql.ZInsert

Create an INSERT statement on a given table

ZLockTable - Class in org.gibello.zql

ZLockTable: an SQL LOCK TABLE statement

ZLockTable() - Constructor for class org.gibello.zql.ZLockTable

ZOrderBy - Class in org.gibello.zql

An SQL query ORDER BY clause.

ZOrderBy(ZExp) - Constructor for class org.gibello.zql.ZOrderBy

ZqlParser - Class in org.gibello.zql

ZqlParser: an SQL parser

ZqlParser(InputStream) - Constructor for class org.gibello.zql.ZqlParser

Create a new parser to parse SQL statements from a given input stream.

ZqlParser() - Constructor for class org.gibello.zql.ZqlParser

Create a new parser: before use, call initParser(InputStream) to specify an input stream for the parsing.

ZQuery - Class in org.gibello.zql

ZQuery: an SQL SELECT statement

ZQuery() - Constructor for class org.gibello.zql.ZQuery

Create a new SELECT statement

ZSelectItem - Class in org.gibello.zql

ZSelectItem: an item in the SELECT part of an SQL query.

ZSelectItem() - Constructor for class org.gibello.zql.ZSelectItem

Create a new SELECT item

ZSelectItem(String) - Constructor for class org.gibello.zql.ZSelectItem

Create a new SELECT item, given its name (for column names and wildcards).

ZStatement - Interface in org.gibello.zql

ZStatement: a common interface for all SQL statements.

ZTransactStmt - Class in org.gibello.zql

ZTransactStmt: an SQL statement that concerns database transactions (example: COMMIT, ROLLBACK, SET TRANSACTION)

ZTransactStmt(String) - Constructor for class org.gibello.zql.ZTransactStmt

ZTuple - Class in org.gibello.zql.data

ZTuple() - Constructor for class org.gibello.zql.data.ZTuple

The simplest constructor

ZTuple(String) - Constructor for class org.gibello.zql.data.ZTuple

Create a new tuple, given it's column names

ZUpdate - Class in org.gibello.zql

ZUpdate: an SQL UPDATE statement.

ZUpdate(String) - Constructor for class org.gibello.zql.ZUpdate

Create an UPDATE statement on a given table.

ZUtils - Class in org.gibello.zql

ZUtils() - Constructor for class org.gibello.zql.ZUtils

A C E F G I M N O R S T U V Z