Package 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	Description
TSQLSchema(TSQLCatalog sqlCatalog, String schemaName)	Create a new instance of the schema, added to the catalog.

Method Summary

Modifier and Type	Method	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
TSQLSchemaObject	findSchemaObject(String schemaObjectName)
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()
boolean	isSealed()	Check if this schema is sealed (Phase 6).
void	seal()	Seal this schema to prevent further modifications (Phase 6).

Methods inherited from class gudusoft.gsqlparser.sqlenv.TSQLObject

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

Methods inherited from class java.lang.Object

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

Constructor Details

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 Details

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()

seal

public void seal()

Seal this schema to prevent further modifications (Phase 6).

See TSQLEnv#seal() for detailed documentation.

isSealed

public boolean isSealed()

Check if this schema is sealed (Phase 6).

Returns:

true if sealed, false otherwise

getSchemaObjectList

public List<TSQLSchemaObject> getSchemaObjectList()

getPackageObjectList

public List<TSQLSchemaObject> getPackageObjectList(TSQLOraclePackage oraclePackage)

addSchemaObject

protected void addSchemaObject(TSQLSchemaObject schemaObject)

add database object

Dual-write strategy: Updates both legacy schemaObjectMap and new type-specific maps for backward compatibility and performance optimization.

Parameters:

schemaObject - schema object to add

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)

findSchemaObject

public TSQLSchemaObject findSchemaObject(String schemaObjectName)

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: