Class ShowCommandExecutor

java.lang.Object
dev.frostlake.executor.ShowCommandExecutor

public class ShowCommandExecutor extends Object
Executes SHOW / DESCRIBE catalog-introspection commands. Extracted from QueryExecutor (which keeps thin forwarders) so that class can stay focused on statement dispatch and query execution. Depends only on the catalog plus a few session/security collaborators — no SELECT-engine or expression-evaluator machinery.

This class is now a thin facade: each command is delegated to one of the per-object-family sub-executors (ShowRelationalExecutor, ShowPipelineExecutor, ShowRoutineExecutor, ShowSecurityExecutor, ShowInfraExecutor, ShowSessionExecutor). The securityManager is installed after construction via setSecurityManager(dev.frostlake.security.SecurityManager), so the security and session sub-executors read it back live through getSecurityManager() rather than caching it.

  • Constructor Details

  • Method Details

    • setSecurityManager

      public void setSecurityManager(SecurityManager securityManager)
    • showDatabases

      public ResultSet showDatabases()
    • showSchemas

      public ResultSet showSchemas(String databaseName)
    • showTables

      public ResultSet showTables(String schemaName)
    • showTablesInAccount

      public ResultSet showTablesInAccount()
    • showSchemasInAccount

      public ResultSet showSchemasInAccount()
    • showObjectsInAccount

      public ResultSet showObjectsInAccount()
    • showViews

      public ResultSet showViews(String schemaName)
    • showTablesInDatabase

      public ResultSet showTablesInDatabase(String databaseName)
    • showHybridTables

      public ResultSet showHybridTables(String schemaName)
    • showHybridTablesInDatabase

      public ResultSet showHybridTablesInDatabase(String databaseName)
    • showViewsInDatabase

      public ResultSet showViewsInDatabase(String databaseName)
    • showMaterializedViews

      public ResultSet showMaterializedViews(String schemaName)
    • showMaterializedViewsInDatabase

      public ResultSet showMaterializedViewsInDatabase(String databaseName)
    • showMaterializedViewsInAccount

      public ResultSet showMaterializedViewsInAccount()
    • showColumns

      public ResultSet showColumns(String tableName)
    • showStreamsInDatabase

      public ResultSet showStreamsInDatabase(String databaseName)
    • showStreamsInAccount

      public ResultSet showStreamsInAccount()
    • showStreams

      public ResultSet showStreams(String schemaName)
    • showStreams

      public ResultSet showStreams(String databaseNameOverride, String schemaName)
    • showTasks

      public ResultSet showTasks(String schemaName)
    • showTasks

      public ResultSet showTasks(String databaseNameOverride, String schemaName)
    • showTasksInDatabase

      public ResultSet showTasksInDatabase(String databaseName)
    • showTasksInAccount

      public ResultSet showTasksInAccount()
    • showPipes

      public ResultSet showPipes(String schemaName, String like)
    • showPipesInDatabase

      public ResultSet showPipesInDatabase(String databaseName, String like)
    • showPipesInAccount

      public ResultSet showPipesInAccount(String like)
    • showWarehouses

      public ResultSet showWarehouses()
    • showStages

      public ResultSet showStages(String schemaName)
    • showStagesInDatabase

      public ResultSet showStagesInDatabase(String databaseName)
    • showStagesInAccount

      public ResultSet showStagesInAccount()
    • showProcedures

      public ResultSet showProcedures(String schemaName, boolean userOnly)
    • showFunctions

      public ResultSet showFunctions(String schemaName, boolean userOnly)
    • showBuiltinFunctions

      public ResultSet showBuiltinFunctions()
    • showBuiltinProcedures

      public ResultSet showBuiltinProcedures()
    • showProceduresInDatabase

      public ResultSet showProceduresInDatabase(String databaseName)
    • showFunctionsInDatabase

      public ResultSet showFunctionsInDatabase(String databaseName)
    • showUserFunctionsInDatabase

      public ResultSet showUserFunctionsInDatabase(String databaseName)
    • showUserProceduresInDatabase

      public ResultSet showUserProceduresInDatabase(String databaseName)
    • showFunctionsInAccount

      public ResultSet showFunctionsInAccount(boolean userOnly)
    • showProceduresInAccount

      public ResultSet showProceduresInAccount(boolean userOnly)
    • describeTable

      public ResultSet describeTable(String tableName)
    • describeView

      public ResultSet describeView(String viewName)
    • describeRelation

      public ResultSet describeRelation(String name, String reportedKind)
    • describeStream

      public ResultSet describeStream(String streamName)
    • describeTask

      public ResultSet describeTask(String taskName)
    • describePipe

      public ResultSet describePipe(String pipeName)
    • showSequences

      public ResultSet showSequences(String schemaName)
    • showSequencesInDatabase

      public ResultSet showSequencesInDatabase(String databaseName)
    • describeSequence

      public ResultSet describeSequence(String sequenceName)
    • showComputePools

      public ResultSet showComputePools()
    • showComputePoolInstanceFamilies

      public ResultSet showComputePoolInstanceFamilies()
    • describeComputePool

      public ResultSet describeComputePool(String poolName)
    • describeWarehouse

      public ResultSet describeWarehouse(String warehouseName)
    • describeStage

      public ResultSet describeStage(String stageName)
    • showTags

      public ResultSet showTags(String schemaName)
    • showTagsInDatabase

      public ResultSet showTagsInDatabase(String databaseName)
    • showTagsInAccount

      public ResultSet showTagsInAccount()
    • describeTag

      public ResultSet describeTag(String tagName)
    • describeFunction

      public ResultSet describeFunction(String name)
    • describeProcedure

      public ResultSet describeProcedure(String name)
    • describeUser

      public ResultSet describeUser(String name)
    • describeMaskingPolicy

      public ResultSet describeMaskingPolicy(String name)
    • describeRowAccessPolicy

      public ResultSet describeRowAccessPolicy(String name)
    • describeFileFormat

      public ResultSet describeFileFormat(String name)
    • showFileFormats

      public ResultSet showFileFormats(String schemaName)
    • showFileFormatsInDatabase

      public ResultSet showFileFormatsInDatabase(String databaseName)
    • showFileFormatsInAccount

      public ResultSet showFileFormatsInAccount()
    • describeSearchOptimization

      public ResultSet describeSearchOptimization(String tableName)
    • showJoinPolicies

      public ResultSet showJoinPolicies(String schemaName)
    • showJoinPoliciesInDatabase

      public ResultSet showJoinPoliciesInDatabase(String databaseName)
    • showJoinPoliciesInAccount

      public ResultSet showJoinPoliciesInAccount()
    • describeJoinPolicy

      public ResultSet describeJoinPolicy(String policyName)
    • showAggregationPolicies

      public ResultSet showAggregationPolicies(String schemaName)
    • showAggregationPoliciesInDatabase

      public ResultSet showAggregationPoliciesInDatabase(String databaseName)
    • showAggregationPoliciesInAccount

      public ResultSet showAggregationPoliciesInAccount()
    • describeAggregationPolicy

      public ResultSet describeAggregationPolicy(String policyName)
    • showProjectionPolicies

      public ResultSet showProjectionPolicies(String schemaName)
    • showProjectionPoliciesInDatabase

      public ResultSet showProjectionPoliciesInDatabase(String databaseName)
    • showProjectionPoliciesInAccount

      public ResultSet showProjectionPoliciesInAccount()
    • describeProjectionPolicy

      public ResultSet describeProjectionPolicy(String policyName)
    • showContacts

      public ResultSet showContacts(String schemaName)
    • showContactsInDatabase

      public ResultSet showContactsInDatabase(String databaseName)
    • showContactsInAccount

      public ResultSet showContactsInAccount()
    • showMaskingPolicies

      public ResultSet showMaskingPolicies(String schemaName)
    • showMaskingPoliciesInDatabase

      public ResultSet showMaskingPoliciesInDatabase(String databaseName)
    • showMaskingPoliciesInAccount

      public ResultSet showMaskingPoliciesInAccount()
    • showRowAccessPolicies

      public ResultSet showRowAccessPolicies(String schemaName)
    • showRowAccessPoliciesInDatabase

      public ResultSet showRowAccessPoliciesInDatabase(String databaseName)
    • showRowAccessPoliciesInAccount

      public ResultSet showRowAccessPoliciesInAccount()
    • showKeysScoped

      public ResultSet showKeysScoped(boolean primary, String scopeKind, String scopeName)
    • showImportedKeys

      public ResultSet showImportedKeys(String scopeKind, String scopeName)
    • showColumnsScoped

      public ResultSet showColumnsScoped(String name, boolean view)
    • showColumnsInSchema

      public ResultSet showColumnsInSchema(String name)
    • showColumnsInDatabase

      public ResultSet showColumnsInDatabase(String databaseName)
    • showColumnsInAccount

      public ResultSet showColumnsInAccount()
    • showViewsInAccount

      public ResultSet showViewsInAccount()
    • showSequencesInAccount

      public ResultSet showSequencesInAccount()
    • showPrimaryKeys

      public ResultSet showPrimaryKeys(String tableName)
    • showUniqueKeys

      public ResultSet showUniqueKeys(String tableName)
    • showUsers

      public ResultSet showUsers()
    • showGrantsOfRole

      public ResultSet showGrantsOfRole(String roleName)
    • showGrantsForCurrentUser

      public ResultSet showGrantsForCurrentUser()
    • showRoles

      public ResultSet showRoles()
    • showCortexSearchServices

      public ResultSet showCortexSearchServices(String schemaName, String like)
    • showCortexSearchServicesInDatabase

      public ResultSet showCortexSearchServicesInDatabase(String databaseName, String like)
    • showCortexSearchServicesInAccount

      public ResultSet showCortexSearchServicesInAccount(String like)
    • describeCortexSearchService

      public ResultSet describeCortexSearchService(String serviceName)
    • showDynamicTables

      public ResultSet showDynamicTables(String schemaName)
    • showDynamicTablesInDatabase

      public ResultSet showDynamicTablesInDatabase(String databaseName)
    • showDynamicTablesInAccount

      public ResultSet showDynamicTablesInAccount()
    • describeDynamicTable

      public ResultSet describeDynamicTable(String tableName, ResultSetProvider projection)
    • showParameters

      public ResultSet showParameters(String likePattern)
    • showParametersInTask

      public ResultSet showParametersInTask(String taskName, String likePattern)
    • showParametersInWarehouse

      public ResultSet showParametersInWarehouse(String warehouseName, String likePattern)
    • showObjects

      public ResultSet showObjects(String schemaName)
    • showObjectsInDatabase

      public ResultSet showObjectsInDatabase(String databaseName)
    • showOrganizationAccounts

      public ResultSet showOrganizationAccounts()
    • showAccounts

      public ResultSet showAccounts()
    • showLocks

      public ResultSet showLocks(boolean inAccount)
    • showTransactions

      public ResultSet showTransactions(String likePattern)
    • showVariables

      public ResultSet showVariables()
    • showQueryHistory

      public ResultSet showQueryHistory(Integer limit)
    • showGrantsOnObject

      public ResultSet showGrantsOnObject(String objectType, String objectName)
    • showGrantsTo

      public ResultSet showGrantsTo(String targetType, String targetName)