flowable兼容Gaussdb数据库

本文主要是介绍flowable兼容Gaussdb数据库，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

步骤一、

在项目中创建org.flowable.common.engine.impl.AbstractEngineConfiguration文件（这边路径必须一致，打包时会覆盖源文件,将源码全部复制过来），修改其中getDefaultDatabaseTypeMappings方法，将Gauss数据库标识为mysql（尝试过其他的报错就不试了，就用mysql）

//在AbstractEngineConfiguration类中
//添加静态属性
public static final String DATABASE_TYPE_GAUSS = "mysql";//加入Gauss支持
//在以下方法中添加下面这行代码
public static Properties getDefaultDatabaseTypeMappings() {................databaseTypeMappings.setProperty("Zenith", DATABASE_TYPE_GAUSS);//加入Gauss支持  待添加return databaseTypeMappings;
}

步骤二、

修改liquibase-core-4.3.5.jar中源码

1.创建GaussDatabase，继承AbstractJdbcDatabase，具体的类实现从OracleDatabase类中复制，然后进行如下修改

删除setConnection方法；

修改PRODUCT_NAME常量值为“Zenith”；

修改getDefaultPort方法，返回1888；//具体端口随着上线更改

修改getShortName方法，返回 zenith

修改getDefaultDriver方法，返回Gauss的Driver。//驱动

具体操作:1.在项目中新建如下包名，创建自己的GaussDatabase类，复制如下代码，根据具体情况作相应修改

package liquibase.database.core;import java.lang.reflect.Method;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.HashSet;
import java.util.List;
import java.util.Locale;
import java.util.Map;
import java.util.Properties;
import java.util.Set;
import java.util.regex.Matcher;
import java.util.regex.Pattern;
import liquibase.CatalogAndSchema;
import liquibase.Scope;
import liquibase.database.AbstractJdbcDatabase;
import liquibase.database.DatabaseConnection;
import liquibase.database.OfflineConnection;
import liquibase.database.jvm.JdbcConnection;
import liquibase.exception.DatabaseException;
import liquibase.exception.UnexpectedLiquibaseException;
import liquibase.exception.ValidationErrors;
import liquibase.executor.ExecutorService;
import liquibase.statement.DatabaseFunction;
import liquibase.statement.SequenceCurrentValueFunction;
import liquibase.statement.SequenceNextValueFunction;
import liquibase.statement.UniqueConstraint;
import liquibase.statement.core.RawCallStatement;
import liquibase.statement.core.RawSqlStatement;
import liquibase.structure.DatabaseObject;
import liquibase.structure.core.Catalog;
import liquibase.structure.core.Index;
import liquibase.structure.core.PrimaryKey;
import liquibase.structure.core.Schema;
import liquibase.util.JdbcUtils;
import liquibase.util.StringUtil;/*** @Description:* @Author: gx* @Date: 2023/09/11/ 13:42*/
public class GaussDatabase extends AbstractJdbcDatabase {private static final String PRODUCT_NAME = "Zenith";@Overrideprotected String getDefaultDatabaseProductName() {return PRODUCT_NAME;}/*** Is this AbstractDatabase subclass the correct one to use for the given connection.** @param conn*/@Overridepublic boolean isCorrectDatabaseImplementation(DatabaseConnection conn) throws DatabaseException {return PRODUCT_NAME.equalsIgnoreCase(conn.getDatabaseProductName());}/*** If this database understands the given url, return the default driver class name.  Otherwise return null.** @param url*/@Overridepublic String getDefaultDriver(String url) {if(url.startsWith("jdbc:zenith")) {return "com.huawei.gauss.jdbc.ZenithDriver";}return null;}/*** Returns an all-lower-case short name of the product.  Used for end-user selecting of database type* such as the DBMS precondition.*/@Overridepublic String getShortName() {return "zenith";}@Overridepublic Integer getDefaultPort() {return 1888;}/*** Returns whether this database support initially deferrable columns.*/@Overridepublic boolean supportsInitiallyDeferrableColumns() {return true;}@Overridepublic boolean supportsTablespaces() {return true;}@Overridepublic int getPriority() {return PRIORITY_DEFAULT;}private static final Pattern PROXY_USER = Pattern.compile(".*(?:thin|oci)\\:(.+)/@.*");protected final int SHORT_IDENTIFIERS_LENGTH = 30;protected final int LONG_IDENTIFIERS_LEGNTH = 128;public static final int ORACLE_12C_MAJOR_VERSION = 12;private Set<String> reservedWords = new HashSet<>();private Set<String> userDefinedTypes;private Map<String, String> savedSessionNlsSettings;private Boolean canAccessDbaRecycleBin;private Integer databaseMajorVersion;private Integer databaseMinorVersion;/*** Default constructor for an object that represents the Oracle Database DBMS.*/public GaussDatabase() {super.unquotedObjectsAreUppercased = true;//noinspection HardCodedStringLiteralsuper.setCurrentDateTimeFunction("SYSTIMESTAMP");// Setting list of Oracle's native functions//noinspection HardCodedStringLiteraldateFunctions.add(new DatabaseFunction("SYSDATE"));//noinspection HardCodedStringLiteraldateFunctions.add(new DatabaseFunction("SYSTIMESTAMP"));//noinspection HardCodedStringLiteraldateFunctions.add(new DatabaseFunction("CURRENT_TIMESTAMP"));//noinspection HardCodedStringLiteralsuper.sequenceNextValueFunction = "%s.nextval";//noinspection HardCodedStringLiteralsuper.sequenceCurrentValueFunction = "%s.currval";}private void tryProxySession(final String url, final Connection con) {Matcher m = PROXY_USER.matcher(url);if (m.matches()) {Properties props = new Properties();props.put("PROXY_USER_NAME", m.group(1));try {Method method = con.getClass().getMethod("openProxySession", int.class, Properties.class);method.setAccessible(true);method.invoke(con, 1, props);} catch (Exception e) {Scope.getCurrentScope().getLog(getClass()).info("Could not open proxy session on OracleDatabase: " + e.getCause().getMessage());}}}@Overridepublic int getDatabaseMajorVersion() throws DatabaseException {if (databaseMajorVersion == null) {return super.getDatabaseMajorVersion();} else {return databaseMajorVersion;}}@Overridepublic int getDatabaseMinorVersion() throws DatabaseException {if (databaseMinorVersion == null) {return super.getDatabaseMinorVersion();} else {return databaseMinorVersion;}}@Overridepublic String getJdbcCatalogName(CatalogAndSchema schema) {return null;}@Overridepublic String getJdbcSchemaName(CatalogAndSchema schema) {return correctObjectName((schema.getCatalogName() == null) ? schema.getSchemaName() : schema.getCatalogName(), Schema.class);}@Overrideprotected String getAutoIncrementClause(final String generationType, final Boolean defaultOnNull) {if (StringUtil.isEmpty(generationType)) {return super.getAutoIncrementClause();}String autoIncrementClause = "GENERATED %s AS IDENTITY"; // %s -- [ ALWAYS | BY DEFAULT [ ON NULL ] ]String generationStrategy = generationType;if (Boolean.TRUE.equals(defaultOnNull) && generationType.toUpperCase().equals("BY DEFAULT")) {generationStrategy += " ON NULL";}return String.format(autoIncrementClause, generationStrategy);}@Overridepublic String generatePrimaryKeyName(String tableName) {if (tableName.length() > 27) {//noinspection HardCodedStringLiteralreturn "PK_" + tableName.toUpperCase(Locale.US).substring(0, 27);} else {//noinspection HardCodedStringLiteralreturn "PK_" + tableName.toUpperCase(Locale.US);}}@Overridepublic boolean isReservedWord(String objectName) {return reservedWords.contains(objectName.toUpperCase());}@Overridepublic boolean supportsSequences() {return true;}/*** Oracle supports catalogs in liquibase terms** @return false*/@Overridepublic boolean supportsSchemas() {return false;}@Overrideprotected String getConnectionCatalogName() throws DatabaseException {if (getConnection() instanceof OfflineConnection) {return getConnection().getCatalog();}try {//noinspection HardCodedStringLiteralreturn Scope.getCurrentScope().getSingleton(ExecutorService.class).getExecutor("jdbc", this).queryForObject(new RawCallStatement("select sys_context( 'userenv', 'current_schema' ) from dual"), String.class);} catch (Exception e) {//noinspection HardCodedStringLiteralScope.getCurrentScope().getLog(getClass()).info("Error getting default schema", e);}return null;}@Overridepublic String getDefaultCatalogName() {//NOPMDreturn (super.getDefaultCatalogName() == null) ? null : super.getDefaultCatalogName().toUpperCase(Locale.US);}/*** <p>Returns an Oracle date literal with the same value as a string formatted using ISO 8601.</p>** <p>Convert an ISO8601 date string to one of the following results:* to_date('1995-05-23', 'YYYY-MM-DD')* to_date('1995-05-23 09:23:59', 'YYYY-MM-DD HH24:MI:SS')</p>* <p>* Implementation restriction:<br>* Currently, only the following subsets of ISO8601 are supported:<br>* <ul>* <li>YYYY-MM-DD</li>* <li>YYYY-MM-DDThh:mm:ss</li>* </ul>*/@Overridepublic String getDateLiteral(String isoDate) {String normalLiteral = super.getDateLiteral(isoDate);if (isDateOnly(isoDate)) {return "TO_DATE(" + normalLiteral + ", 'YYYY-MM-DD')";} else if (isTimeOnly(isoDate)) {return "TO_DATE(" + normalLiteral + ", 'HH24:MI:SS')";} else if (isTimestamp(isoDate)) {return "TO_TIMESTAMP(" + normalLiteral + ", 'YYYY-MM-DD HH24:MI:SS.FF')";} else if (isDateTime(isoDate)) {int seppos = normalLiteral.lastIndexOf('.');if (seppos != -1) {normalLiteral = normalLiteral.substring(0, seppos) + "'";}return "TO_DATE(" + normalLiteral + ", 'YYYY-MM-DD HH24:MI:SS')";}return "UNSUPPORTED:" + isoDate;}@Overridepublic boolean isSystemObject(DatabaseObject example) {if (example == null) {return false;}if (this.isLiquibaseObject(example)) {return false;}if (example instanceof Schema) {//noinspection HardCodedStringLiteral,HardCodedStringLiteral,HardCodedStringLiteral,HardCodedStringLiteralif ("SYSTEM".equals(example.getName()) || "SYS".equals(example.getName()) || "CTXSYS".equals(example.getName()) || "XDB".equals(example.getName())) {return true;}//noinspection HardCodedStringLiteral,HardCodedStringLiteral,HardCodedStringLiteral,HardCodedStringLiteralif ("SYSTEM".equals(example.getSchema().getCatalogName()) || "SYS".equals(example.getSchema().getCatalogName()) || "CTXSYS".equals(example.getSchema().getCatalogName()) || "XDB".equals(example.getSchema().getCatalogName())) {return true;}} else if (isSystemObject(example.getSchema())) {return true;}if (example instanceof Catalog) {//noinspection HardCodedStringLiteral,HardCodedStringLiteral,HardCodedStringLiteral,HardCodedStringLiteralif (("SYSTEM".equals(example.getName()) || "SYS".equals(example.getName()) || "CTXSYS".equals(example.getName()) || "XDB".equals(example.getName()))) {return true;}} else if (example.getName() != null) {//noinspection HardCodedStringLiteralif (example.getName().startsWith("BIN$")) { //oracle deleted tableboolean filteredInOriginalQuery = this.canAccessDbaRecycleBin();if (!filteredInOriginalQuery) {filteredInOriginalQuery = StringUtil.trimToEmpty(example.getSchema().getName()).equalsIgnoreCase(this.getConnection().getConnectionUserName());}if (filteredInOriginalQuery) {return !((example instanceof PrimaryKey) || (example instanceof Index) || (example instanceofliquibase.statement.UniqueConstraint));} else {return true;}} else //noinspection HardCodedStringLiteralif (example.getName().startsWith("AQ$")) { //oracle AQ tablesreturn true;} else //noinspection HardCodedStringLiteralif (example.getName().startsWith("DR$")) { //oracle index tablesreturn true;} else //noinspection HardCodedStringLiteralif (example.getName().startsWith("SYS_IOT_OVER")) { //oracle system tablereturn true;} else //noinspection HardCodedStringLiteral,HardCodedStringLiteralif ((example.getName().startsWith("MDRT_") || example.getName().startsWith("MDRS_")) && example.getName().endsWith("$")) {// CORE-1768 - Oracle creates these for spatial indices and will remove them when the index is removed.return true;} else //noinspection HardCodedStringLiteralif (example.getName().startsWith("MLOG$_")) { //Created by materliaized view logs for every table that is part of a materialized view. Not available for DDL operations.return true;} else //noinspection HardCodedStringLiteralif (example.getName().startsWith("RUPD$_")) { //Created by materialized view log tables using primary keys. Not available for DDL operations.return true;} else //noinspection HardCodedStringLiteralif (example.getName().startsWith("WM$_")) { //Workspace Manager backup tables.return true;} else //noinspection HardCodedStringLiteralif ("CREATE$JAVA$LOB$TABLE".equals(example.getName())) { //This table contains the name of the Java object, the date it was loaded, and has a BLOB column to store the Java object.return true;} else //noinspection HardCodedStringLiteralif ("JAVA$CLASS$MD5$TABLE".equals(example.getName())) { //This is a hash table that tracks the loading of Java objects into a schema.return true;} else //noinspection HardCodedStringLiteralif (example.getName().startsWith("ISEQ$$_")) { //System-generated sequencereturn true;} else //noinspection HardCodedStringLiteralif (example.getName().startsWith("USLOG$")) { //for update materialized viewreturn true;} else if (example.getName().startsWith("SYS_FBA")) { //for Flashback tablesreturn true;}}return super.isSystemObject(example);}@Overridepublic boolean supportsAutoIncrement() {// Oracle supports Identity beginning with version 12cboolean isAutoIncrementSupported = false;try {if (getDatabaseMajorVersion() >= 12) {isAutoIncrementSupported = true;}// Returning true will generate create table command with 'IDENTITY' clause, example:// CREATE TABLE AutoIncTest (IDPrimaryKey NUMBER(19) GENERATED BY DEFAULT AS IDENTITY NOT NULL, TypeID NUMBER(3) NOT NULL, Description NVARCHAR2(50), CONSTRAINT PK_AutoIncTest PRIMARY KEY (IDPrimaryKey));// While returning false will continue to generate create table command without 'IDENTITY' clause, example:// CREATE TABLE AutoIncTest (IDPrimaryKey NUMBER(19) NOT NULL, TypeID NUMBER(3) NOT NULL, Description NVARCHAR2(50), CONSTRAINT PK_AutoIncTest PRIMARY KEY (IDPrimaryKey));} catch (DatabaseException ex) {isAutoIncrementSupported = false;}return isAutoIncrementSupported;}@Overridepublic boolean supportsRestrictForeignKeys() {return false;}@Overridepublic int getDataTypeMaxParameters(String dataTypeName) {//noinspection HardCodedStringLiteralif ("BINARY_FLOAT".equals(dataTypeName.toUpperCase())) {return 0;}//noinspection HardCodedStringLiteralif ("BINARY_DOUBLE".equals(dataTypeName.toUpperCase())) {return 0;}return super.getDataTypeMaxParameters(dataTypeName);}public String getSystemTableWhereClause(String tableNameColumn) {List<String> clauses = new ArrayList<String>(Arrays.asList("BIN$","AQ$","DR$","SYS_IOT_OVER","MLOG$_","RUPD$_","WM$_","ISEQ$$_","USLOG$","SYS_FBA"));for (int i = 0;i<clauses.size(); i++) {clauses.set(i, tableNameColumn+" NOT LIKE '"+clauses.get(i)+"%'");}return "("+ StringUtil.join(clauses, " AND ") + ")";}@Overridepublic boolean jdbcCallsCatalogsSchemas() {return true;}public Set<String> getUserDefinedTypes() {if (userDefinedTypes == null) {userDefinedTypes = new HashSet<>();if ((getConnection() != null) && !(getConnection() instanceof OfflineConnection)) {try {try {//noinspection HardCodedStringLiteraluserDefinedTypes.addAll(Scope.getCurrentScope().getSingleton(ExecutorService.class).getExecutor("jdbc", this).queryForList(new RawSqlStatement("SELECT DISTINCT TYPE_NAME FROM ALL_TYPES"), String.class));} catch (DatabaseException e) { //fall back to USER_TYPES if the user cannot see ALL_TYPES//noinspection HardCodedStringLiteraluserDefinedTypes.addAll(Scope.getCurrentScope().getSingleton(ExecutorService.class).getExecutor("jdbc", this).queryForList(new RawSqlStatement("SELECT TYPE_NAME FROM USER_TYPES"), String.class));}} catch (DatabaseException e) {//ignore error}}}return userDefinedTypes;}@Overridepublic String generateDatabaseFunctionValue(DatabaseFunction databaseFunction) {//noinspection HardCodedStringLiteralif ((databaseFunction != null) && "current_timestamp".equalsIgnoreCase(databaseFunction.toString())) {return databaseFunction.toString();}if ((databaseFunction instanceof SequenceNextValueFunction) || (databaseFunction instanceofSequenceCurrentValueFunction)) {String quotedSeq = super.generateDatabaseFunctionValue(databaseFunction);// replace "myschema.my_seq".nextval with "myschema"."my_seq".nextvalreturn quotedSeq.replaceFirst("\"([^\\.\"]+)\\.([^\\.\"]+)\"", "\"$1\".\"$2\"");}return super.generateDatabaseFunctionValue(databaseFunction);}@Overridepublic ValidationErrors validate() {ValidationErrors errors = super.validate();DatabaseConnection connection = getConnection();if ((connection == null) || (connection instanceof OfflineConnection)) {//noinspection HardCodedStringLiteralScope.getCurrentScope().getLog(getClass()).info("Cannot validate offline database");return errors;}if (!canAccessDbaRecycleBin()) {errors.addWarning(getDbaRecycleBinWarning());}return errors;}public String getDbaRecycleBinWarning() {return "Liquibase needs to access the DBA_RECYCLEBIN table so we can automatically handle the case where " +"constraints are deleted and restored. Since Oracle doesn't properly restore the original table names " +"referenced in the constraint, we use the information from the DBA_RECYCLEBIN to automatically correct this" +" issue.\n" +"\n" +"The user you used to connect to the database (" + getConnection().getConnectionUserName() +") needs to have \"SELECT ON SYS.DBA_RECYCLEBIN\" permissions set before we can perform this operation. " +"Please run the following SQL to set the appropriate permissions, and try running the command again.\n" +"\n" +"     GRANT SELECT ON SYS.DBA_RECYCLEBIN TO " + getConnection().getConnectionUserName() + ";";}public boolean canAccessDbaRecycleBin() {if (canAccessDbaRecycleBin == null) {DatabaseConnection connection = getConnection();if ((connection == null) || (connection instanceof OfflineConnection)) {return false;}Statement statement = null;try {statement = ((JdbcConnection) connection).createStatement();@SuppressWarnings("HardCodedStringLiteral") ResultSet resultSet = statement.executeQuery("select 1 from dba_recyclebin where 0=1");resultSet.close(); //don't need to do anything with the result set, just make sure statement ran.this.canAccessDbaRecycleBin = true;} catch (Exception e) {//noinspection HardCodedStringLiteralif ((e instanceof SQLException) && e.getMessage().startsWith("ORA-00942")) { //ORA-00942: table or view does not existthis.canAccessDbaRecycleBin = false;} else {//noinspection HardCodedStringLiteralScope.getCurrentScope().getLog(getClass()).warning("Cannot check dba_recyclebin access", e);this.canAccessDbaRecycleBin = false;}} finally {JdbcUtils.close(null, statement);}}return canAccessDbaRecycleBin;}@Overridepublic boolean supportsNotNullConstraintNames() {return true;}/*** Tests if the given String would be a valid identifier in Oracle DBMS. In Oracle, a valid identifier has* the following form (case-insensitive comparison):* 1st character: A-Z* 2..n characters: A-Z0-9$_#* The maximum length of an identifier differs by Oracle version and object type.*/public boolean isValidOracleIdentifier(String identifier, Class<? extends DatabaseObject> type) {if ((identifier == null) || (identifier.length() < 1))return false;if (!identifier.matches("^(i?)[A-Z][A-Z0-9\\$\\_\\#]*$"))return false;/** @todo It seems we currently do not have a class for tablespace identifiers, and all other classes* we do know seem to be supported as 12cR2 long identifiers, so:*/return (identifier.length() <= LONG_IDENTIFIERS_LEGNTH);}/*** Returns the maximum number of bytes (NOT: characters) for an identifier. For Oracle <=12c Release 20, this* is 30 bytes, and starting from 12cR2, up to 128 (except for tablespaces, PDB names and some other rather rare* object types).** @return the maximum length of an object identifier, in bytes*/public int getIdentifierMaximumLength() {try {if (getDatabaseMajorVersion() < ORACLE_12C_MAJOR_VERSION) {return SHORT_IDENTIFIERS_LENGTH;} else if ((getDatabaseMajorVersion() == ORACLE_12C_MAJOR_VERSION) && (getDatabaseMinorVersion() <= 1)) {return SHORT_IDENTIFIERS_LENGTH;} else {return LONG_IDENTIFIERS_LEGNTH;}} catch (DatabaseException ex) {throw new UnexpectedLiquibaseException("Cannot determine the Oracle database version number", ex);}}
}

步骤三、

修改 liquibase.datatype.core.BooleanType类，以支持Gauss的bit类型与java的Boolean类型的转换

在toDatabaseDataType方法中添加DmDatabase的支持

在isNumericBoolean方法中添加DmDatabase类型

具体操作如下：1.在当前项目新建包名，修改代码

2.这里转换可能还是会有问题，我们暂时不做考虑，他只是影响自动创建表，我们在application.yml中添加如下配置吗，不让他自己创建表

# flowable相关表

flowable:

# true 会对数据库中所有表进行更新操作。如果表不存在，则自动创建(建议开发时使用)

database-schema-update: false

# 关闭定时任务JOB

async-executor-activate: false

package liquibase.datatype.core;import java.util.Locale;import liquibase.change.core.LoadDataChange;
import liquibase.database.Database;
import liquibase.database.core.*;
import liquibase.datatype.DataTypeInfo;
import liquibase.datatype.DatabaseDataType;
import liquibase.datatype.LiquibaseDataType;
import liquibase.exception.UnexpectedLiquibaseException;
import liquibase.statement.DatabaseFunction;
import liquibase.util.StringUtil;@DataTypeInfo(name = "boolean",aliases = {"java.sql.Types.BOOLEAN", "java.lang.Boolean", "bit", "bool"},minParameters = 0,maxParameters = 0,priority = 1)
public class BooleanType extends LiquibaseDataType {public BooleanType() {}@Overridepublic DatabaseDataType toDatabaseDataType(Database database) {String originalDefinition = StringUtil.trimToEmpty(getRawDefinition());if ((database instanceof Firebird3Database)) {return new DatabaseDataType("BOOLEAN");}if ((database instanceof AbstractDb2Database) || (database instanceof FirebirdDatabase)) {return new DatabaseDataType("SMALLINT");} else if (database instanceof MSSQLDatabase) {return new DatabaseDataType(database.escapeDataTypeName("bit"));} else if (database instanceof MySQLDatabase) {if (originalDefinition.toLowerCase(Locale.US).startsWith("bit")) {return new DatabaseDataType("BIT", getParameters());}return new DatabaseDataType("BIT", 1);} else if (database instanceof OracleDatabase) {return new DatabaseDataType("NUMBER", 1);} else if ((database instanceof SybaseASADatabase) || (database instanceof SybaseDatabase)) {return new DatabaseDataType("BIT");} else if (database instanceof DerbyDatabase) {if (((DerbyDatabase) database).supportsBooleanDataType()) {return new DatabaseDataType("BOOLEAN");} else {return new DatabaseDataType("SMALLINT");}} else if (database.getClass().isAssignableFrom(DB2Database.class)) {if (((DB2Database) database).supportsBooleanDataType()) return new DatabaseDataType("BOOLEAN");else return new DatabaseDataType("SMALLINT");} else if (database instanceof HsqlDatabase) {return new DatabaseDataType("BOOLEAN");} else if (database instanceof PostgresDatabase) {if (originalDefinition.toLowerCase(Locale.US).startsWith("bit")) {return new DatabaseDataType("BIT", getParameters());}} else if (database instanceof GaussDatabase) {return new DatabaseDataType("bit");}return super.toDatabaseDataType(database);}@Overridepublic String objectToSql(Object value, Database database) {if ((value == null) || "null".equals(value.toString().toLowerCase(Locale.US))) {return null;}String returnValue;if (value instanceof String) {value = ((String) value).replaceAll("'", "");if ("true".equals(((String) value).toLowerCase(Locale.US)) || "1".equals(value) || "b'1'".equals(((String) value).toLowerCase(Locale.US)) || "t".equals(((String) value).toLowerCase(Locale.US)) || ((String) value).toLowerCase(Locale.US).equals(this.getTrueBooleanValue(database).toLowerCase(Locale.US))) {returnValue = this.getTrueBooleanValue(database);} else if ("false".equals(((String) value).toLowerCase(Locale.US)) || "0".equals(value) || "b'0'".equals(((String) value).toLowerCase(Locale.US)) || "f".equals(((String) value).toLowerCase(Locale.US)) || ((String) value).toLowerCase(Locale.US).equals(this.getFalseBooleanValue(database).toLowerCase(Locale.US))) {returnValue = this.getFalseBooleanValue(database);} else {throw new UnexpectedLiquibaseException("Unknown boolean value: " + value);}} else if (value instanceof Long) {if (Long.valueOf(1).equals(value)) {returnValue = this.getTrueBooleanValue(database);} else {returnValue = this.getFalseBooleanValue(database);}} else if (value instanceof Number) {if (value.equals(1) || "1".equals(value.toString()) || "1.0".equals(value.toString())) {returnValue = this.getTrueBooleanValue(database);} else {returnValue = this.getFalseBooleanValue(database);}} else if (value instanceof DatabaseFunction) {return value.toString();} else if (value instanceof Boolean) {if (((Boolean) value)) {returnValue = this.getTrueBooleanValue(database);} else {returnValue = this.getFalseBooleanValue(database);}} else {throw new UnexpectedLiquibaseException("Cannot convert type " + value.getClass() + " to a boolean value");}return returnValue;}protected boolean isNumericBoolean(Database database) {if (database instanceof DerbyDatabase) {return !((DerbyDatabase) database).supportsBooleanDataType();} else if (database.getClass().isAssignableFrom(DB2Database.class)) {return !((DB2Database) database).supportsBooleanDataType();}return (database instanceof Db2zDatabase) || (database instanceof DB2Database) || (database instanceof FirebirdDatabase) || (database instanceof MSSQLDatabase) || (database instanceof MySQLDatabase) || (database instanceof OracleDatabase) ||(database instanceof SQLiteDatabase) || (database instanceof SybaseASADatabase) || (database instanceof SybaseDatabase) || (database instanceof GaussDatabase);}/*** The database-specific value to use for "false" "boolean" columns.*/public String getFalseBooleanValue(Database database) {if (isNumericBoolean(database)) {return "0";}if (database instanceof InformixDatabase) {return "'f'";}return "FALSE";}/*** The database-specific value to use for "true" "boolean" columns.*/public String getTrueBooleanValue(Database database) {if (isNumericBoolean(database)) {return "1";}if (database instanceof InformixDatabase) {return "'t'";}return "TRUE";}@Overridepublic LoadDataChange.LOAD_DATA_TYPE getLoadTypeName() {return LoadDataChange.LOAD_DATA_TYPE.BOOLEAN;}
}