@ProviderType
public interface DB
| Modifier and Type | Field and Description |
|---|---|
static int |
SQL_SIZE_NONE |
static int |
SQL_VARCHAR_MAX_SIZE |
static int |
SQL_VARCHAR_MAX_SIZE_THRESHOLD |
| Modifier and Type | Method and Description |
|---|---|
void |
addIndexes(Connection connection,
String indexesSQL,
Set<String> validIndexNames) |
String |
buildSQL(String template) |
DBType |
getDBType() |
List<Index> |
getIndexes(Connection connection) |
ResultSet |
getIndexResultSet(Connection connection,
String tableName) |
int |
getMajorVersion() |
int |
getMinorVersion() |
default String |
getNewUuidFunctionName() |
String |
getPopulateSQL(String databaseName,
String sqlContent) |
ResultSet |
getPrimaryKeysResultSet(Connection connection,
String tableName) |
String |
getRecreateSQL(String databaseName) |
Integer |
getSQLType(String templateType) |
Integer |
getSQLVarcharSize(String templateType) |
String |
getTemplateBlob() |
String |
getTemplateFalse() |
String |
getTemplateTrue() |
String |
getVersionString() |
boolean |
isSupportsAlterColumnName() |
boolean |
isSupportsAlterColumnType() |
boolean |
isSupportsInlineDistinct() |
default boolean |
isSupportsNewUuidFunction() |
boolean |
isSupportsQueryingAfterException() |
boolean |
isSupportsScrollableResults() |
boolean |
isSupportsStringCaseSensitiveQuery() |
boolean |
isSupportsUpdateWithInnerJoin() |
void |
process(com.liferay.petra.function.UnsafeConsumer<Long,Exception> unsafeConsumer) |
default void |
runSQL(Connection connection,
DBTypeToSQLMap dbTypeToSQLMap) |
void |
runSQL(Connection connection,
String sql) |
void |
runSQL(Connection connection,
String[] sqls) |
default void |
runSQL(DBTypeToSQLMap dbTypeToSQLMap) |
void |
runSQL(String sql) |
void |
runSQL(String[] sqls) |
void |
runSQLTemplateString(Connection connection,
String template,
boolean failOnError) |
void |
runSQLTemplateString(String template,
boolean failOnError) |
void |
setSupportsStringCaseSensitiveQuery(boolean supportsStringCaseSensitiveQuery) |
void |
updateIndexes(Connection connection,
String tablesSQL,
String indexesSQL,
boolean dropStaleIndexes) |
static final int SQL_SIZE_NONE
static final int SQL_VARCHAR_MAX_SIZE
static final int SQL_VARCHAR_MAX_SIZE_THRESHOLD
void addIndexes(Connection connection,
String indexesSQL,
Set<String> validIndexNames)
throws IOException
IOExceptionString buildSQL(String template)
throws IOException,
SQLException
IOExceptionSQLExceptionDBType getDBType()
List<Index> getIndexes(Connection connection) throws SQLException
SQLExceptionResultSet getIndexResultSet(Connection connection,
String tableName)
throws SQLException
SQLExceptionint getMajorVersion()
int getMinorVersion()
default String getNewUuidFunctionName()
String getPopulateSQL(String databaseName,
String sqlContent)
ResultSet getPrimaryKeysResultSet(Connection connection,
String tableName)
throws SQLException
SQLExceptionString getRecreateSQL(String databaseName)
Integer getSQLType(String templateType)
Integer getSQLVarcharSize(String templateType)
String getTemplateBlob()
String getTemplateFalse()
String getTemplateTrue()
String getVersionString()
boolean isSupportsAlterColumnName()
boolean isSupportsAlterColumnType()
boolean isSupportsInlineDistinct()
default boolean isSupportsNewUuidFunction()
boolean isSupportsQueryingAfterException()
boolean isSupportsScrollableResults()
boolean isSupportsStringCaseSensitiveQuery()
boolean isSupportsUpdateWithInnerJoin()
void process(com.liferay.petra.function.UnsafeConsumer<Long,Exception> unsafeConsumer)
throws Exception
Exceptiondefault void runSQL(Connection connection,
DBTypeToSQLMap dbTypeToSQLMap)
throws IOException,
SQLException
IOExceptionSQLExceptionvoid runSQL(Connection connection,
String sql)
throws IOException,
SQLException
IOExceptionSQLExceptionvoid runSQL(Connection connection,
String[] sqls)
throws IOException,
SQLException
IOExceptionSQLExceptiondefault void runSQL(DBTypeToSQLMap dbTypeToSQLMap) throws IOException, SQLException
IOExceptionSQLExceptionvoid runSQL(String sql)
throws IOException,
SQLException
IOExceptionSQLExceptionvoid runSQL(String[] sqls)
throws IOException,
SQLException
IOExceptionSQLExceptionvoid runSQLTemplateString(Connection connection,
String template,
boolean failOnError)
throws IOException,
javax.naming.NamingException,
SQLException
IOExceptionjavax.naming.NamingExceptionSQLExceptionvoid runSQLTemplateString(String template,
boolean failOnError)
throws IOException,
javax.naming.NamingException,
SQLException
IOExceptionjavax.naming.NamingExceptionSQLExceptionvoid setSupportsStringCaseSensitiveQuery(boolean supportsStringCaseSensitiveQuery)
void updateIndexes(Connection connection,
String tablesSQL,
String indexesSQL,
boolean dropStaleIndexes)
throws Exception
Exception