You are here: Symbol Reference > Classes
ContentsIndexHome
PreviousUpNext
Classes

The following table lists classes in this documentation.

Classes
Class 
Description 
Class represents for Parameters Declaration 

SQL Parser class. 

SQL Parser class. 

Represent alias of table of field. 

Class represent analytic function. 

TLz_Attr represents a dot separated name, or just a single name.
Usually, it represents a database object like table, field, function name, etc...

relname is the first source token of identifier.
Take identifier: server.database.schema_name.object_name for example, relname points to "server".

attrs stores source tokens in identifier except first one. Take identifier: server.database.schema_name.object_name for example, attrs includes "database",
"schema_name", and "object_name".

If identifier is a single name like this: object_name, then relname stores source token of object_name, and attrs is empty.

If attr is a dot separated name like this: schema_name.object_name, then relname -> schema_name , and attrs[0] -> object_name.... more 

Argument of cast function used in TLz_FuncCall

TLz_Const represents a parse tree node of const value including integer, float and single quote string. 

Dummy node to store information of various parse tree node. 

Class represents function call. 

Identifier in sql was represented by TLz_Attr, so this class is not used. 

Raw parse tree node of insert statement. 

Raw parse tree of join table. All information in this node will be parsed into TlzJoin. 

Raw parse tree node of join condition. 

List of objects which is type of TLz_Node, or class descends from TLz_Node

Base class of all parse tree nodes. 

Raw parse tree node of select list item. 

Raw parse tree node of order by clause. 

Raw parse tree node of data source, usually, it's a table. 

Represent various data type used in sql. 

Raw parse tree node of update statement. 

Value clause of DB2. 

Raw parse tree node of column in create/alter table. 

Constraint of column and table level. 

List of constraint. 

Reference clause of foreign key. 

Represents common table expression. 

Expression is widely used in the sql, such as in the where clause,having clause. It's represented by the class TLzCustomExpression, and organized in a binary tree mode.

Usually, expression is created after parsing a sql.
You can also create expression manually in two ways:
1. Create an empty TLzCustomExpression instance, and
than add lexpr, rexpr and set oper yourself.

2. Create a TLzCustomExpression instance with an expression string as paramter, than a binary expression
tree will be created automatically with lexpr, rexpr,
oper and other properties set correctly if input expression string is a valid expression.

You... more 

Database object tokens in TCustomSqlStatement such as ServerTokens,DatabaseTokens,SchemaTokens,TableTokens store full original information, it's grouped by each sql statement, and not sorted, same object may occurs serval time. Sometimes, we want to access these database objects in a script level, group by server,database,schema,with sourted information.

So, we prepare all these raw information in TCustomSqlStatement into a new class: TLzDBObject, along with TLzDBObjectList,
you have a more convenience way to access database object in sql scripts.
 

List of database object found in sql. 

Field/Column in all sql statements. 

List of TlzField. 

Class used to setup format options. 

Elements in from clause were represented by one or more TLzJoin objects.



Theta joins, which use the WHERE clause to establish the filtering criteria, are the "old" way to do join operations.
In such type of join, each table in from clause have a corresponding TlzJoin object with JoinTableType = jttNone

 
In from clause, one table can connect to previous table.
Join item contains all information about this connection such as table(JoinItemTable, JoinItemJoin), join type(JoinType), join condition(JoinQualType, JoinQual).

 

List of join item in join. 

List of Joins in from clause. 

Placeholder of TLz_Node

List of sql statement, all descends from TCustomSqlStatement

Represents table object in sql. 

List of tables. 

Top clause of ms sql server. 

Class used to store bind variable(:bindvar) and sql variable (@var).

When a bind variable was found, TCustomGSqlParser.OnBindVar is fired.

When a sql variable was found, TCustomGSqlParser.OnSqlVar is fired.

Bind variable can be found in TCustomSqlStatement.Params.

Sql variable can be found in TCustomSqlStatement.SqlVars

List of value list. 

Source token created after reading from input sql.

If this token represents a database object, check following properties for more detail information.

TSourceToken.DBObjType
TSourceToken.ParentToken
TSourceToken.ChildToken
TSourceToken.RelatedToken
TSourceToken.RelatedTokens
TSourceToken.RelatedSubquery 

List of source tokens. 
Modules
Gudu software http://www.sqlparser.com
Send comments about this topic.