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