The following table lists classes in this documentation.
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. | |
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. |
Gudu software http://www.sqlparser.com
|
Send comments about this topic.
|