gudusoft.gsqlparser.sqlenv

Class TSQLSchema

Object

gudusoft.gsqlparser.sqlenv.TSQLObject

gudusoft.gsqlparser.sqlenv.TSQLSchema

public class TSQLSchema
extends TSQLObject

SQL schema, contains a list of schema objects.

Field Summary

Fields inherited from class gudusoft.gsqlparser.sqlenv.TSQLObject

dataObjectType, name, nameKeepCase, sqlEnv

Constructor Summary

Constructors

Constructor and Description
TSQLSchema(TSQLCatalog sqlCatalog, String schemaName) Create a new instance of the schema, added to the catalog.

Method Summary

Modifier and Type	Method and Description
protected void	addSchemaObject(TSQLSchemaObject schemaObject) add database object
boolean	containsTable(String tableName)
TSQLFunction	createFunction(String functionName) create a function belong to this schema
TSQLOraclePackage	createOraclePackage(String oraclePackageName) create a oracle package belong to this schema
TSQLProcedure	createProcedure(String procedureName) create a procedure belong to this schema
TSQLProcedure	createProcedure(String procedureName, ESQLDataObjectType type)
TSQLSchemaObject	createSchemaObject(String schemaObjectName, ESQLDataObjectType dataObjectType)
protected TSQLSchemaObject	createSchemaObject(String schemaObjectName, ESQLDataObjectType dataObjectType, int priority)
TSQLSynonyms	createSynonyms(String synonymsName) create a synonyms belong to this schema
TSQLTable	createTable(String tableName) create a table belong to this schema.
TSQLTable	createTable(String tableName, int priority)
TSQLTrigger	createTrigger(String triggerName) create a trigger belong to this schema
TSQLTable	findTable(String tableName)
TSQLCatalog	getCatalog()
List<TSQLSchemaObject>	getPackageObjectList(TSQLOraclePackage oraclePackage)
String	getQualifiedName() qualified name for database object such as: databaseName.schemaName.tableName
List<TSQLSchemaObject>	getSchemaObjectList()

Methods inherited from class gudusoft.gsqlparser.sqlenv.TSQLObject

compareTo, compareTo, compareTo, compareTo, getDataObjectType, getName, getNameKeepCase, getSqlEnv, isDelimitedIdentifier, isDelimitedIdentifier, normalizeIdentifier, normalizeIdentifier, normalizeIdentifier, setDataObjectType

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

TSQLSchema

public TSQLSchema(TSQLCatalog sqlCatalog,
                  String schemaName)

Create a new instance of the schema, added to the catalog.

Parameters:

sqlCatalog - catalog contains this schema

schemaName - name of the schema

Method Detail

getQualifiedName

public String getQualifiedName()

Description copied from class: TSQLObject

qualified name for database object such as: databaseName.schemaName.tableName

Overrides:

getQualifiedName in class TSQLObject

Returns:

qualified name

getCatalog

public TSQLCatalog getCatalog()

getSchemaObjectList

public List<TSQLSchemaObject> getSchemaObjectList()

getPackageObjectList

public List<TSQLSchemaObject> getPackageObjectList(TSQLOraclePackage oraclePackage)

addSchemaObject

protected void addSchemaObject(TSQLSchemaObject schemaObject)

add database object

Parameters:

schemaObject -

createOraclePackage

public TSQLOraclePackage createOraclePackage(String oraclePackageName)

create a oracle package belong to this schema

Parameters:

oraclePackageName - oracle package name

Returns:

an instance of the oracle package

createProcedure

public TSQLProcedure createProcedure(String procedureName)

create a procedure belong to this schema

Parameters:

procedureName - procedure name

Returns:

an instance of the SQL procedure

createProcedure

public TSQLProcedure createProcedure(String procedureName,
                                     ESQLDataObjectType type)

createFunction

public TSQLFunction createFunction(String functionName)

create a function belong to this schema

Parameters:

functionName - function name

Returns:

an instance of the SQL function.

createTrigger

public TSQLTrigger createTrigger(String triggerName)

create a trigger belong to this schema

Parameters:

triggerName - trigger name

Returns:

an instance of the SQL trigger.

createSynonyms

public TSQLSynonyms createSynonyms(String synonymsName)

create a synonyms belong to this schema

Parameters:

synonymsName - synonyms name

Returns:

an instance of the SQL synonyms

createTable

public TSQLTable createTable(String tableName)

create a table belong to this schema. If table with the same name already exists in the schema return the existing table.

Parameters:

tableName - table name

Returns:

an instance of the SQL table

createTable

public TSQLTable createTable(String tableName,
                             int priority)

containsTable

public boolean containsTable(String tableName)

findTable

public TSQLTable findTable(String tableName)

createSchemaObject

public TSQLSchemaObject createSchemaObject(String schemaObjectName,
                                           ESQLDataObjectType dataObjectType)

Parameters:

schemaObjectName - 该名称不带 catalog, schema 前缀

dataObjectType -

Returns:

createSchemaObject

protected TSQLSchemaObject createSchemaObject(String schemaObjectName,
                                              ESQLDataObjectType dataObjectType,
                                              int priority)

Parameters:

schemaObjectName - 该名称不带 catalog, schema 前缀

dataObjectType -

priority -

Returns: