Table of Contents

Class TObjectName

Namespace
gudusoft.gsqlparser.nodes
Assembly
gudusoft.gsqlparser.dll

An objectname specifies a database object or a variable. The rules for forming the name of an object depend on the object type. Database object names may be made up of a single identifier or more than one identifier. Each identifier was represented by a TSourceToken.

schemaToken, databaseToken, serverToken is quite straightforward. Meanings of objectToken is depends on objectType. 

public class TObjectName : TParseTreeNode, Visitable
Inheritance
TObjectName
Implements
Inherited Members

Constructors

TObjectName() 

public TObjectName()

TObjectName(EDbObjectType, TSourceToken) 

public TObjectName(EDbObjectType dbOjectType, TSourceToken st)

Parameters

dbOjectType EDbObjectType
st TSourceToken

TObjectName(EDbObjectType, TSourceToken, TSourceToken) 

public TObjectName(EDbObjectType dbOjectType, TSourceToken stPart, TSourceToken stObject)

Parameters

dbOjectType EDbObjectType
stPart TSourceToken
stObject TSourceToken

TObjectName(TSourceToken, EDbObjectType) 

public TObjectName(TSourceToken st, EDbObjectType dbOjectType)

Parameters

st TSourceToken
dbOjectType EDbObjectType

TObjectName(TSourceToken, TSourceToken, EDbObjectType) 

public TObjectName(TSourceToken stObject, TSourceToken stPart, EDbObjectType dbOjectType)

Parameters

stObject TSourceToken
stPart TSourceToken
dbOjectType EDbObjectType

Fields

searchLevel 

public int searchLevel

Field Value

int

ttObjLibrary 

public const int ttObjLibrary = 72

Field Value

int

ttObjOracleHint 

public const int ttObjOracleHint = 70

Field Value

int

ttObjTableAlias

table alias in objectToken

public const int ttObjTableAlias = 4

Field Value

int

ttobjAliasName

alias name in gudusoft.gsqlparser.nodes.TObjectName._objectToken

public const int ttobjAliasName = 25

Field Value

int

ttobjAttribute

attribute name is in gudusoft.gsqlparser.nodes.TObjectName._partToken

public const int ttobjAttribute = 26

Field Value

int

ttobjColumn

column in table, objectToken is table if specified, and partToken is column name.

public const int ttobjColumn = 1

Field Value

int

ttobjColumnAlias

column alias in objectToken.

public const int ttobjColumnAlias = 2

Field Value

int

ttobjColumnMethod

column method like SetXY below, column method in gudusoft.gsqlparser.nodes.TObjectName.methodToken, and colomn name in gudusoft.gsqlparser.nodes.TObjectName._partToken.

UPDATE Cities

SET Location.SetXY(23.5, 23.5) 

public const int ttobjColumnMethod = 11

Field Value

int

ttobjConstraintName

constraint name in gudusoft.gsqlparser.nodes.TObjectName._objectToken

public const int ttobjConstraintName = 19

Field Value

int

ttobjCursorName

cursor name in gudusoft.gsqlparser.nodes.TObjectName._objectToken

public const int ttobjCursorName = 17

Field Value

int

ttobjDatabaseName

Database name in gudusoft.gsqlparser.nodes.TObjectName._objectToken

public const int ttobjDatabaseName = 22

Field Value

int

ttobjDatatype

datatype was not represented by a TObjectName object, this constant was used in source tokens that consist of TTypeName.

public const int ttobjDatatype = 30

Field Value

int

ttobjFieldName

check FieldName for more

public const int ttobjFieldName = 51

Field Value

int

ttobjFunctionName

function name in gudusoft.gsqlparser.nodes.TObjectName._objectToken

public const int ttobjFunctionName = 13

Field Value

int

ttobjIndexName

index name in gudusoft.gsqlparser.nodes.TObjectName._objectToken

public const int ttobjIndexName = 15

Field Value

int

ttobjIndexType 

public const int ttobjIndexType = 42

Field Value

int

ttobjLabelName

label name in gudusoft.gsqlparser.nodes.TObjectName._objectToken

public const int ttobjLabelName = 14

Field Value

int

ttobjMaterializedView 

public const int ttobjMaterializedView = 44

Field Value

int

ttobjMaterializedViewName

materialized view name in gudusoft.gsqlparser.nodes.TObjectName._objectToken

public const int ttobjMaterializedViewName = 16

Field Value

int

ttobjMiningModel 

public const int ttobjMiningModel = 46

Field Value

int

ttobjMixed

this type is used in TObjectNameList, when objects in TObjectNameList includes more than one type, objtype of that TObjectNameList was set to ttobjMixed.

public const int ttobjMixed = 100

Field Value

int

ttobjNotAObject

this is not an object, like sysdate function in oracle database

public const int ttobjNotAObject = -1

Field Value

int

ttobjOperator 

public const int ttobjOperator = 40

Field Value

int

ttobjPackage

package name in gudusoft.gsqlparser.nodes.TObjectName._objectToken

public const int ttobjPackage = 28

Field Value

int

ttobjParameter

parameter name in objectToken.

public const int ttobjParameter = 9

Field Value

int

ttobjPositionalParameters

postgresql Positional Parameters, $1, $1[1], $1[1,10] parameter name is in gudusoft.gsqlparser.nodes.TObjectName._partToken of $1, and parameter name is in gudusoft.gsqlparser.nodes.TObjectName._objectToken of $1.columnName, and column name is in gudusoft.gsqlparser.nodes.TObjectName._partToken

public const int ttobjPositionalParameters = 61

Field Value

int

ttobjProcedureName

procedure name in gudusoft.gsqlparser.nodes.TObjectName._objectToken

public const int ttobjProcedureName = 12

Field Value

int

ttobjPropertyName

property name in gudusoft.gsqlparser.nodes.TObjectName.propertyToken

public const int ttobjPropertyName = 20

Field Value

int

ttobjSchemaName

schema name in gudusoft.gsqlparser.nodes.TObjectName._schemaToken

public const int ttobjSchemaName = 31

Field Value

int

ttobjSequence

Sequence name in gudusoft.gsqlparser.nodes.TObjectName._objectToken

public const int ttobjSequence = 29

Field Value

int

ttobjServerName

server name in gudusoft.gsqlparser.nodes.TObjectName.serverToken

public const int ttobjServerName = 32

Field Value

int

ttobjStringConstant

string constant in gudusoft.gsqlparser.nodes.TObjectName._objectToken

public const int ttobjStringConstant = 23

Field Value

int

ttobjTable

table name in objectToken.

public const int ttobjTable = 3

Field Value

int

ttobjTableCTE

table name in objectToken.

public const int ttobjTableCTE = 5

Field Value

int

ttobjTablePivot

Not used..

public const int ttobjTablePivot = 7

Field Value

int

ttobjTableTemp

table name in objectToken.

public const int ttobjTableTemp = 6

Field Value

int

ttobjTableVar

table variable in objectToken.

public const int ttobjTableVar = 8

Field Value

int

ttobjTransactionName

Transaction name in gudusoft.gsqlparser.nodes.TObjectName._objectToken

public const int ttobjTransactionName = 21

Field Value

int

ttobjTrigger

Trigger name in gudusoft.gsqlparser.nodes.TObjectName._objectToken

public const int ttobjTrigger = 24

Field Value

int

ttobjTypeName

type name in gudusoft.gsqlparser.nodes.TObjectName._objectToken

public const int ttobjTypeName = 27

Field Value

int

ttobjUnknown

object type can't be determined.

public const int ttobjUnknown = 0

Field Value

int

ttobjVariable

variable name in objectToken.

public const int ttobjVariable = 10

Field Value

int

ttobjViewName

view name in gudusoft.gsqlparser.nodes.TObjectName._objectToken

public const int ttobjViewName = 18

Field Value

int

Properties

Atsign 

public virtual TSourceToken Atsign { get; set; }

Property Value

TSourceToken

Attributes 

public virtual TObjectNameList Attributes { get; set; }

Property Value

TObjectNameList

ColumnNameOnly 

public virtual string ColumnNameOnly { get; }

Property Value

string

ColumnNo 

public override long ColumnNo { get; }

Property Value

long

ColumnToken 

public virtual TSourceToken ColumnToken { get; }

Property Value

TSourceToken

source token that represents column only when getObjectType() = ttobjColumn, otherwise, null will be returned.

CommentString 

public virtual TSourceToken CommentString { get; set; }

Property Value

TSourceToken

DatabaseString 

public virtual string DatabaseString { get; }

Property Value

string

DatabaseToken 

public virtual TSourceToken DatabaseToken { get; }

Property Value

TSourceToken

DbObjectType 

public virtual EDbObjectType DbObjectType { get; set; }

Property Value

EDbObjectType


Oralce: scott.emp@remoreserver
informix: hr_db@remoteoffice:hrmanager.employees

public virtual TObjectName Dblink { get; set; }

Property Value

TObjectName

dblink in Oracle, and it aslo menas database server in informix

Exclamationmark 

public virtual TSourceToken Exclamationmark { get; set; }

Property Value

TSourceToken

Indirection 

public virtual TIndirection Indirection { get; set; }

Property Value

TIndirection

LineNo 

public override long LineNo { get; }

Property Value

long

Location 

public virtual ESqlClause Location { get; set; }

Property Value

ESqlClause

MethodToken 

public virtual TSourceToken MethodToken { get; }

Property Value

TSourceToken

ObjectString 

public virtual string ObjectString { get; }

Property Value

string

ObjectToken 

public virtual TSourceToken ObjectToken { get; set; }

Property Value

TSourceToken

ObjectType 

public virtual int ObjectType { get; set; }

Property Value

int

PartString 

public virtual string PartString { get; }

Property Value

string

PartToken 

public virtual TSourceToken PartToken { get; set; }

Property Value

TSourceToken

Prefixed 

public virtual bool Prefixed { get; }

Property Value

bool

PropertyToken 

public virtual TSourceToken PropertyToken { get; set; }

Property Value

TSourceToken

QuoteType 

public virtual EQuoteType QuoteType { get; set; }

Property Value

EQuoteType

ReferencedObjects 

public virtual TObjectNameList ReferencedObjects { get; }

Property Value

TObjectNameList

SchemaString 

public virtual string SchemaString { get; }

Property Value

string

SchemaToken 

public virtual TSourceToken SchemaToken { get; set; }

Property Value

TSourceToken

ServerString 

public virtual string ServerString { get; }

Property Value

string

ServerToken 

public virtual TSourceToken ServerToken { get; }

Property Value

TSourceToken

SortType 

public virtual TSourceToken SortType { get; set; }

Property Value

TSourceToken

SourceColumn 

public virtual TResultColumn SourceColumn { get; set; }

Property Value

TResultColumn

SourceTable 

public virtual TTable SourceTable { get; set; }

Property Value

TTable

Subscripts 

public virtual bool Subscripts { get; }

Property Value

bool

TableDetermined 

public virtual bool TableDetermined { get; set; }

Property Value

bool

TableString 

public virtual string TableString { get; }

Property Value

string

TableToken 

public virtual TSourceToken TableToken { get; }

Property Value

TSourceToken

linkedColumnDefinition 

public TColumnDefinition linkedColumnDefinition { get; set; }

Property Value

TColumnDefinition

Methods

TObjectName_Renamed() 

public virtual void TObjectName_Renamed()

ToString()

String representation of parse tree node including sub parse tree node. This string was generated by collecting text from the start token of this node to the end token of this node. If this node was modified later, then use toScript() to return string representation instead.

public override string ToString()

Returns

string

string representation of parse tree node including sub parse tree node.

accept(TParseTreeVisitor) 

public override void accept(TParseTreeVisitor v)

Parameters

v TParseTreeVisitor

acceptChildren(TParseTreeVisitor) 

public override void acceptChildren(TParseTreeVisitor v)

Parameters

v TParseTreeVisitor

appendObjectName(TObjectName) 

public virtual void appendObjectName(TObjectName objectName)

Parameters

objectName TObjectName

attributesToPropertyToken(TObjectNameList)

used in Oracle and teradata SQL syntax

teradata:

column.attribute()

column.attribute().attribute() 

public virtual void attributesToPropertyToken(TObjectNameList attributes)

Parameters

attributes TObjectNameList

coordinate() 

public string coordinate()

Returns

string

init(object)

Initialize a query tree node.

public override void init(object arg1)

Parameters

arg1 object

init(object, object) 

public override void init(object arg1, object arg2)

Parameters

arg1 object
arg2 object

init(object, object, object) 

public override void init(object arg1, object arg2, object arg3)

Parameters

arg1 object
arg2 object
arg3 object

init(object, object, object, object) 

public override void init(object arg1, object arg2, object arg3, object arg4)

Parameters

arg1 object
arg2 object
arg3 object
arg4 object

init(object, object, object, object, object) 

public override void init(object arg1, object arg2, object arg3, object arg4, object arg5)

Parameters

arg1 object
arg2 object
arg3 object
arg4 object
arg5 object

init(object, object, object, object, object, object) 

public override void init(object arg1, object arg2, object arg3, object arg4, object arg5, object arg6)

Parameters

arg1 object
arg2 object
arg3 object
arg4 object
arg5 object
arg6 object

isAttributeNameInObjectName(TSourceToken, TSourceToken) 

public virtual bool isAttributeNameInObjectName(TSourceToken leftparen, TSourceToken rightparen)

Parameters

leftparen TSourceToken
rightparen TSourceToken

Returns

bool

isPrefixedThisTable(TTable) 

public virtual bool isPrefixedThisTable(TTable pTable)

Parameters

pTable TTable

Returns

bool

isValidColumnName(EDbVendor) 

public virtual bool isValidColumnName(EDbVendor pDBVendor)

Parameters

pDBVendor EDbVendor

Returns

bool

mergeObjectName(TObjectName) 

public virtual void mergeObjectName(TObjectName objectName)

Parameters

objectName TObjectName

mergeObjectName(TObjectName, TObjectName) 

public virtual void mergeObjectName(TObjectName objectName, TObjectName objectName2)

Parameters

objectName TObjectName
objectName2 TObjectName

setIndirection(TIndirection) 

public void setIndirection(TIndirection i)

Parameters

i TIndirection

setObjectType(int) 

public void setObjectType(int i)

Parameters

i int
Edit this page