gudusoft.gsqlparser.sqlenv

Class TDDLSQLEnv

Object

gudusoft.gsqlparser.sqlenv.TSQLEnv

gudusoft.gsqlparser.sqlenv.TDDLSQLEnv

public class TDDLSQLEnv
extends TSQLEnv

Nested Class Summary

Nested classes/interfaces inherited from class gudusoft.gsqlparser.sqlenv.TSQLEnv

TSQLEnv.InvalidNameFormException

Field Summary

Fields inherited from class gudusoft.gsqlparser.sqlenv.TSQLEnv

catalogCollationCaseSensitive, columnCollationCaseSensitive, DEFAULT_DB_NAME, DEFAULT_SCHEMA_NAME, DEFAULT_SERVER_NAME, defaultCollationCaseSensitive, functionCollationCaseSensitive, isAliasReferenceForbidden, SNOWFLAKE_SCHEMA_AFTER_DATABASE_SWITCH, tableCollationCaseSensitive

Constructor Summary

Constructors

Constructor and Description
TDDLSQLEnv(String defaultServer, String defaultDatabase, String defaultSchema, EDbVendor dbVendor, String sql)
TDDLSQLEnv(String defaultServer, String defaultDatabase, String defaultSchema, EDbVendor dbVendor, String sql, IdentifierProfile identifierProfile) Same input, analyzed under an explicit identifier configuration.
TDDLSQLEnv(String defaultServer, String defaultDatabase, String defaultSchema, TSQLEnv metadataSQLEnv, EDbVendor dbVendor, String sql)
TDDLSQLEnv(String defaultServer, String defaultDatabase, String defaultSchema, TSQLEnv metadataSQLEnv, EDbVendor dbVendor, String sql, IdentifierProfile identifierProfile) Same input, analyzed under an explicit identifier configuration.

Method Summary

Modifier and Type	Method and Description
void	initSQLEnv() This method must be override in the subclass to build a SQL environment with real metadata.
boolean	isInit()
static void	main(String[] args)
void	setIncludeLocalTemporaryTables(boolean include) Disable for whole-script catalog preloading; call-frame temporary DDL needs positional scope.

Methods inherited from class gudusoft.gsqlparser.sqlenv.TSQLEnv

addFunction, addFunction, addOraclePackage, addProcedure, addSQLRoutine, addTable, addTrigger, addView, columnInTable, compareColumn, compareColumn, compareIdentifier, compareIdentifier, compareIdentifier, compareQualifiedColumn, compareQualifiedTable, compareTable, compareTable, copy, createSQLCatalog, createSQLSchema, delimitedChar, doAddCatalog, doAddSchemaObject, doAddSchemaObject, doSearchSchemaObject, endsWithDelimitedIdentifier, findSchemaAfterDatabaseSwitch, getAFullQualifiedSchemaObjectName, getCatalogList, getCatalogProvider, getCatalogStore, getColumnInTable, getColumnsInTable, getDatabaseName, getDatabaseName, getDBVendor, getDefaultCatalogName, getDefaultSchemaName, getDefaultServerName, getIdentifierProfile, getIdentifierService, getNumberOfTables, getObjectName, getObjectName, getProcedureParameterPresets, getProcedureParameterValue, getProcedureParameterValue, getSchemaName, getSchemaName, getSQLCatalog, getSQLSchema, getStmtSeparatorChar, getVariableValue, hasCatalogMetadata, hasParameterPresets, isAliasOccludingColumn, isAliasVisibleInHaving, isDelimitedIdentifier, isDelimitedIdentifier, isEnableGetMetadataFromDDL, isHavingAliasOutrankingUngroupedColumn, matchSubObjectNameToWhole, normalizeIdentifier, normalizeIdentifier, parseNameForm, putSchemaObject, qualifyForPresets, requireSqlLexicalNameForm, searchCatalog, searchFunction, searchFunction, searchSchemaObject, searchSchemaObject, searchTable, searchTable, setCatalogProviderForCompatibility, setDefaultCatalogName, setDefaultSchemaName, setDefaultServerName, setEnableGetMetadataFromDDL, setProcedureParameterValue, setProcedureParameterValue, supportCatalog, supportSchema, toLexical, toLexical, toString

Methods inherited from class Object

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

Constructor Detail

TDDLSQLEnv

public TDDLSQLEnv(String defaultServer,
                  String defaultDatabase,
                  String defaultSchema,
                  EDbVendor dbVendor,
                  String sql)

TDDLSQLEnv

public TDDLSQLEnv(String defaultServer,
                  String defaultDatabase,
                  String defaultSchema,
                  EDbVendor dbVendor,
                  String sql,
                  IdentifierProfile identifierProfile)

Same input, analyzed under an explicit identifier configuration.

DDL in the script registers objects in this environment, so the rules used to key them must be the run's rules — otherwise a later reference is compared by a relation the registration never used. A profile belonging to another vendor is not applied (IdentifierProfile.forVendorOr(gudusoft.gsqlparser.sqlenv.IdentifierProfile, gudusoft.gsqlparser.EDbVendor)); null means the vendor default.

TDDLSQLEnv

public TDDLSQLEnv(String defaultServer,
                  String defaultDatabase,
                  String defaultSchema,
                  TSQLEnv metadataSQLEnv,
                  EDbVendor dbVendor,
                  String sql)

TDDLSQLEnv

public TDDLSQLEnv(String defaultServer,
                  String defaultDatabase,
                  String defaultSchema,
                  TSQLEnv metadataSQLEnv,
                  EDbVendor dbVendor,
                  String sql,
                  IdentifierProfile identifierProfile)

Same input, analyzed under an explicit identifier configuration.

DDL in the script registers objects in this environment, so the rules used to key them must be the run's rules — otherwise a later reference is compared by a relation the registration never used. A profile belonging to another vendor is not applied (IdentifierProfile.forVendorOr(gudusoft.gsqlparser.sqlenv.IdentifierProfile, gudusoft.gsqlparser.EDbVendor)); null means the vendor default.

Method Detail

setIncludeLocalTemporaryTables

public void setIncludeLocalTemporaryTables(boolean include)

Disable for whole-script catalog preloading; call-frame temporary DDL needs positional scope.

isInit

public boolean isInit()

initSQLEnv

public void initSQLEnv()

Description copied from class: TSQLEnv

This method must be override in the subclass to build a SQL environment with real metadata.
this usually done by querying the INFORMATION_SCHEMA

Specified by:

initSQLEnv in class TSQLEnv

main

public static void main(String[] args)