Class CommandConstants
- java.lang.Object
-
- com.databricks.jdbc.dbclient.impl.common.CommandConstants
-
public class CommandConstants extends Object
-
-
Field Summary
Fields Modifier and Type Field Description static StringGET_CATALOGS_STATEMENT_IDstatic StringGET_FUNCTIONS_STATEMENT_IDstatic StringGET_PROCEDURE_COLUMNS_STATEMENT_IDstatic StringGET_PROCEDURES_STATEMENT_IDstatic StringGET_TABLE_TYPE_STATEMENT_IDstatic StringGET_TABLES_STATEMENT_IDstatic StringIN_ABSOLUTE_SCHEMA_SQLstatic StringIN_ABSOLUTE_TABLE_SQLstatic StringIN_ALL_CATALOGS_SQLstatic StringIN_CATALOG_SQLstatic StringLIKE_SQLstatic StringMETADATA_STATEMENT_IDstatic StringSCHEMA_LIKE_SQLstatic StringSHOW_CATALOGS_SQLstatic StringSHOW_COLUMNS_SQLstatic StringSHOW_FOREIGN_KEYS_SQLstatic StringSHOW_FUNCTIONS_SQLstatic StringSHOW_PRIMARY_KEYS_SQLstatic StringSHOW_SCHEMAS_IN_ALL_CATALOGS_SQLstatic StringSHOW_SCHEMAS_IN_CATALOG_SQLstatic StringSHOW_TABLE_TYPES_SQLstatic StringSHOW_TABLES_IN_ALL_CATALOGS_SQLstatic StringSHOW_TABLES_SQLstatic StringTABLE_LIKE_SQL
-
Constructor Summary
Constructors Constructor Description CommandConstants()
-
Method Summary
All Methods Static Methods Concrete Methods Modifier and Type Method Description static StringbuildProcedureColumnsSQL(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern, Map<Integer,ImmutableSqlParameter> params)Builds a parameterized SQL query to fetch procedure columns from information_schema.parameters.static StringbuildProceduresSQL(String catalog, String schemaPattern, String procedureNamePattern, Map<Integer,ImmutableSqlParameter> params)Builds a parameterized SQL query to fetch procedures from information_schema.routines.static StringescapeSqlIdentifier(String identifier)
-
-
-
Field Detail
-
METADATA_STATEMENT_ID
public static final String METADATA_STATEMENT_ID
- See Also:
- Constant Field Values
-
GET_TABLES_STATEMENT_ID
public static final String GET_TABLES_STATEMENT_ID
- See Also:
- Constant Field Values
-
GET_CATALOGS_STATEMENT_ID
public static final String GET_CATALOGS_STATEMENT_ID
- See Also:
- Constant Field Values
-
GET_TABLE_TYPE_STATEMENT_ID
public static final String GET_TABLE_TYPE_STATEMENT_ID
- See Also:
- Constant Field Values
-
GET_FUNCTIONS_STATEMENT_ID
public static final String GET_FUNCTIONS_STATEMENT_ID
- See Also:
- Constant Field Values
-
GET_PROCEDURES_STATEMENT_ID
public static final String GET_PROCEDURES_STATEMENT_ID
- See Also:
- Constant Field Values
-
GET_PROCEDURE_COLUMNS_STATEMENT_ID
public static final String GET_PROCEDURE_COLUMNS_STATEMENT_ID
- See Also:
- Constant Field Values
-
SHOW_CATALOGS_SQL
public static final String SHOW_CATALOGS_SQL
- See Also:
- Constant Field Values
-
SHOW_TABLE_TYPES_SQL
public static final String SHOW_TABLE_TYPES_SQL
- See Also:
- Constant Field Values
-
IN_CATALOG_SQL
public static final String IN_CATALOG_SQL
- See Also:
- Constant Field Values
-
IN_ABSOLUTE_SCHEMA_SQL
public static final String IN_ABSOLUTE_SCHEMA_SQL
- See Also:
- Constant Field Values
-
IN_ABSOLUTE_TABLE_SQL
public static final String IN_ABSOLUTE_TABLE_SQL
- See Also:
- Constant Field Values
-
IN_ALL_CATALOGS_SQL
public static final String IN_ALL_CATALOGS_SQL
- See Also:
- Constant Field Values
-
SHOW_SCHEMAS_IN_CATALOG_SQL
public static final String SHOW_SCHEMAS_IN_CATALOG_SQL
- See Also:
- Constant Field Values
-
LIKE_SQL
public static final String LIKE_SQL
- See Also:
- Constant Field Values
-
SCHEMA_LIKE_SQL
public static final String SCHEMA_LIKE_SQL
- See Also:
- Constant Field Values
-
TABLE_LIKE_SQL
public static final String TABLE_LIKE_SQL
- See Also:
- Constant Field Values
-
SHOW_TABLES_SQL
public static final String SHOW_TABLES_SQL
- See Also:
- Constant Field Values
-
SHOW_TABLES_IN_ALL_CATALOGS_SQL
public static final String SHOW_TABLES_IN_ALL_CATALOGS_SQL
- See Also:
- Constant Field Values
-
SHOW_COLUMNS_SQL
public static final String SHOW_COLUMNS_SQL
- See Also:
- Constant Field Values
-
SHOW_FUNCTIONS_SQL
public static final String SHOW_FUNCTIONS_SQL
- See Also:
- Constant Field Values
-
SHOW_SCHEMAS_IN_ALL_CATALOGS_SQL
public static final String SHOW_SCHEMAS_IN_ALL_CATALOGS_SQL
- See Also:
- Constant Field Values
-
SHOW_PRIMARY_KEYS_SQL
public static final String SHOW_PRIMARY_KEYS_SQL
- See Also:
- Constant Field Values
-
SHOW_FOREIGN_KEYS_SQL
public static final String SHOW_FOREIGN_KEYS_SQL
- See Also:
- Constant Field Values
-
-
Method Detail
-
buildProceduresSQL
public static String buildProceduresSQL(String catalog, String schemaPattern, String procedureNamePattern, Map<Integer,ImmutableSqlParameter> params)
Builds a parameterized SQL query to fetch procedures from information_schema.routines. LIKE clause values use ? placeholders with parameters populated in the provided map for server-side binding.
-
buildProcedureColumnsSQL
public static String buildProcedureColumnsSQL(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern, Map<Integer,ImmutableSqlParameter> params)
Builds a parameterized SQL query to fetch procedure columns from information_schema.parameters. LIKE clause values use ? placeholders with parameters populated in the provided map for server-side binding.
-
-