import java.sql.Types;

import org.hibernate.boot.model.TypeContributions;
import org.hibernate.dialect.PostgreSQLDialect;
import org.hibernate.service.ServiceRegistry;

import lombok.extern.slf4j.Slf4j;

@Slf4j
public class PgDialect extends PostgreSQLDialect {

	public PgDialect() {
		super();
	}

	/**
	 * 这里的方法注释会导致java代码查询的逻辑删除值是true/false
	 * 但取消注释会导致java代码的逻辑删除列定义由原本的smallint改为integer,但逻辑删除时的where deleted=1 是对的
	 * 结论：@SoftDelete注解不遵守CustomerBooleanJdbcType给出的建议，或者说它有自己独立的逻辑
	 */
	@Override
	public int getPreferredSqlTypeCodeForBoolean() {
		return Types.SMALLINT;
	}

	@Override
	protected void registerColumnTypes(TypeContributions typeContributions, ServiceRegistry serviceRegistry) {
		super.registerColumnTypes(typeContributions, serviceRegistry);
		typeContributions.contributeJdbcType(CustomerBooleanJdbcType.INSTANCE);
	}
}

import java.sql.CallableStatement;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Types;
import java.util.Objects;

import org.hibernate.dialect.Dialect;
import org.hibernate.sql.ast.spi.SqlAppender;
import org.hibernate.type.SqlTypes;
import org.hibernate.type.descriptor.ValueBinder;
import org.hibernate.type.descriptor.ValueExtractor;
import org.hibernate.type.descriptor.WrapperOptions;
import org.hibernate.type.descriptor.converter.spi.BasicValueConverter;
import org.hibernate.type.descriptor.java.JavaType;
import org.hibernate.type.descriptor.jdbc.BasicBinder;
import org.hibernate.type.descriptor.jdbc.BasicExtractor;
import org.hibernate.type.descriptor.jdbc.BooleanJdbcType;
import org.hibernate.type.descriptor.jdbc.JdbcLiteralFormatter;
import org.hibernate.type.descriptor.jdbc.JdbcType;
import org.hibernate.type.descriptor.jdbc.JdbcTypeIndicators;

import lombok.extern.slf4j.Slf4j;

@Slf4j
public class CustomerBooleanJdbcType extends BooleanJdbcType {

	private CustomerBooleanJdbcType() {
	}

	public static final CustomerBooleanJdbcType INSTANCE = new CustomerBooleanJdbcType();
	private static final long serialVersionUID = 1L;

	@Override
	public <X> ValueBinder<X> getBinder(JavaType<X> javaType) {
		return new BasicBinder<>(javaType, this) {
			@Override
			protected void doBindNull(PreparedStatement st, int index, WrapperOptions options) throws SQLException {
				st.setNull(index, options.getPreferredSqlTypeCodeForBoolean());
			}

			@Override
			protected void doBindNull(CallableStatement st, String name, WrapperOptions options) throws SQLException {
				st.setNull(name, options.getPreferredSqlTypeCodeForBoolean());
			}

			@Override
			protected void doBind(PreparedStatement st, X value, int index, WrapperOptions options)
					throws SQLException {
				st.setInt(index, Objects.equals(true, value) ? 1 : 0);
			}

			@Override
			protected void doBind(CallableStatement st, X value, String name, WrapperOptions options)
					throws SQLException {
				st.setInt(name, Objects.equals(true, value) ? 1 : 0);
			}
		};
	}

	@Override
	public <T> JdbcLiteralFormatter<T> getJdbcLiteralFormatter(JavaType<T> javaType) {
		return (SqlAppender appender, T value, Dialect dialect, WrapperOptions wrapperOptions) -> appender
				.append(Objects.equals(value, true) || Objects.equals(value, 1) ? "1" : "0");

	}

	@Override
	public JdbcType resolveIndicatedType(JdbcTypeIndicators indicators, JavaType<?> domainJtd) {
		return this;
	}

	@Override
	public <X> ValueExtractor<X> getExtractor(JavaType<X> javaType) {
		return new BasicExtractor<>(javaType, this) {
			@Override
			protected X doExtract(ResultSet rs, int paramIndex, WrapperOptions options) throws SQLException {
				String label = rs.getMetaData().getColumnName(paramIndex);
				Object o = rs.getObject(paramIndex);
				int result = rs.getInt(paramIndex);
				log.debug("label:{} ,result: {} , o: {}", label, result, o);
				return javaType.wrap(Objects.equals(result, 1), options);
			}

			@Override
			protected X doExtract(CallableStatement statement, int index, WrapperOptions options) throws SQLException {
				return javaType.wrap(Objects.equals(statement.getInt(index), 1), options);
			}

			@Override
			protected X doExtract(CallableStatement statement, String name, WrapperOptions options)
					throws SQLException {
				int result = statement.getInt(name);
				return javaType.wrap(Objects.equals(result, 1), options);
			}
		};
	}

	@Override
	public int getDdlTypeCode() {
		return SqlTypes.SMALLINT;
	}

	@Override
	public int getJdbcTypeCode() {
		return Types.BOOLEAN;
	}

	@Override
	public int getDefaultSqlTypeCode() {
		return Types.BOOLEAN;
	}

	@Override
	public String getCheckCondition(String columnName, JavaType<?> javaType, BasicValueConverter<?, ?> converter,
			Dialect dialect) {
		return columnName + " in (0,1)";
	}

	@Override
	public boolean isBoolean() {
		return false;
	}

	@Override
	public boolean isSmallInteger() {
		return true;
	}

}