org.hibernate.dialect.SpannerDialect Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of beangle-hibernate-core Show documentation
Show all versions of beangle-hibernate-core Show documentation
Hibernate Orm Core Shade,Support Scala Collection
/*
* Hibernate, Relational Persistence for Idiomatic Java
*
* License: GNU Lesser General Public License (LGPL), version 2.1 or later.
* See the lgpl.txt file in the root directory or .
*/
package org.hibernate.dialect;
import java.util.Date;
import java.util.Map;
import org.hibernate.LockMode;
import org.hibernate.LockOptions;
import org.hibernate.StaleObjectStateException;
import org.hibernate.boot.Metadata;
import org.hibernate.boot.model.FunctionContributions;
import org.hibernate.boot.model.relational.Exportable;
import org.hibernate.boot.model.relational.Sequence;
import org.hibernate.boot.model.relational.SqlStringGenerationContext;
import org.hibernate.dialect.function.CommonFunctionFactory;
import org.hibernate.dialect.function.FormatFunction;
import org.hibernate.dialect.lock.LockingStrategy;
import org.hibernate.dialect.lock.LockingStrategyException;
import org.hibernate.dialect.pagination.LimitHandler;
import org.hibernate.dialect.pagination.LimitOffsetLimitHandler;
import org.hibernate.dialect.unique.UniqueDelegate;
import org.hibernate.engine.jdbc.dialect.spi.DialectResolutionInfo;
import org.hibernate.engine.jdbc.env.spi.SchemaNameResolver;
import org.hibernate.engine.spi.SessionFactoryImplementor;
import org.hibernate.event.spi.EventSource;
import org.hibernate.internal.util.collections.ArrayHelper;
import org.hibernate.mapping.Column;
import org.hibernate.mapping.Constraint;
import org.hibernate.mapping.ForeignKey;
import org.hibernate.mapping.Table;
import org.hibernate.mapping.UniqueKey;
import org.hibernate.persister.entity.Lockable;
import org.hibernate.query.SemanticException;
import org.hibernate.query.sqm.IntervalType;
import org.hibernate.query.sqm.TemporalUnit;
import org.hibernate.sql.ast.SqlAstTranslator;
import org.hibernate.sql.ast.SqlAstTranslatorFactory;
import org.hibernate.sql.ast.spi.SqlAppender;
import org.hibernate.sql.ast.spi.StandardSqlAstTranslatorFactory;
import org.hibernate.sql.ast.tree.Statement;
import org.hibernate.sql.exec.spi.JdbcOperation;
import org.hibernate.tool.schema.spi.Exporter;
import org.hibernate.type.BasicType;
import org.hibernate.type.BasicTypeRegistry;
import org.hibernate.type.StandardBasicTypes;
import jakarta.persistence.TemporalType;
import static org.hibernate.dialect.SimpleDatabaseVersion.ZERO_VERSION;
import static org.hibernate.query.sqm.produce.function.StandardFunctionReturnTypeResolvers.useArgType;
import static org.hibernate.type.SqlTypes.BIGINT;
import static org.hibernate.type.SqlTypes.BINARY;
import static org.hibernate.type.SqlTypes.BLOB;
import static org.hibernate.type.SqlTypes.BOOLEAN;
import static org.hibernate.type.SqlTypes.CHAR;
import static org.hibernate.type.SqlTypes.CLOB;
import static org.hibernate.type.SqlTypes.DECIMAL;
import static org.hibernate.type.SqlTypes.DOUBLE;
import static org.hibernate.type.SqlTypes.FLOAT;
import static org.hibernate.type.SqlTypes.INTEGER;
import static org.hibernate.type.SqlTypes.LONG32NVARCHAR;
import static org.hibernate.type.SqlTypes.LONG32VARBINARY;
import static org.hibernate.type.SqlTypes.LONG32VARCHAR;
import static org.hibernate.type.SqlTypes.NCHAR;
import static org.hibernate.type.SqlTypes.NCLOB;
import static org.hibernate.type.SqlTypes.NUMERIC;
import static org.hibernate.type.SqlTypes.NVARCHAR;
import static org.hibernate.type.SqlTypes.REAL;
import static org.hibernate.type.SqlTypes.SMALLINT;
import static org.hibernate.type.SqlTypes.TIME;
import static org.hibernate.type.SqlTypes.TIMESTAMP;
import static org.hibernate.type.SqlTypes.TIMESTAMP_WITH_TIMEZONE;
import static org.hibernate.type.SqlTypes.TINYINT;
import static org.hibernate.type.SqlTypes.VARBINARY;
import static org.hibernate.type.SqlTypes.VARCHAR;
/**
* A {@linkplain Dialect SQL dialect} for Cloud Spanner.
*
* @author Mike Eltsufin
* @author Chengyuan Zhao
* @author Daniel Zou
* @author Dmitry Solomakha
*/
public class SpannerDialect extends Dialect {
private final Exporter spannerTableExporter = new SpannerDialectTableExporter( this );
private static final LockingStrategy LOCKING_STRATEGY = new DoNothingLockingStrategy();
private static final EmptyExporter NOOP_EXPORTER = new EmptyExporter();
private static final UniqueDelegate NOOP_UNIQUE_DELEGATE = new DoNothingUniqueDelegate();
public SpannerDialect() {
super( ZERO_VERSION );
}
public SpannerDialect(DialectResolutionInfo info) {
super(info);
}
@Override
protected String columnType(int sqlTypeCode) {
switch ( sqlTypeCode ) {
case BOOLEAN:
return "bool";
case TINYINT:
case SMALLINT:
case INTEGER:
case BIGINT:
return "int64";
case REAL:
case FLOAT:
case DOUBLE:
case DECIMAL:
case NUMERIC:
return "float64";
//there is no time type of any kind
case TIME:
//timestamp does not accept precision
case TIMESTAMP:
case TIMESTAMP_WITH_TIMEZONE:
return "timestamp";
case CHAR:
case NCHAR:
case VARCHAR:
case NVARCHAR:
return "string($l)";
case BINARY:
case VARBINARY:
return "bytes($l)";
case CLOB:
case NCLOB:
return "string(max)";
case BLOB:
return "bytes(max)";
default:
return super.columnType( sqlTypeCode );
}
}
@Override
protected String castType(int sqlTypeCode) {
switch ( sqlTypeCode ) {
case CHAR:
case NCHAR:
case VARCHAR:
case NVARCHAR:
case LONG32VARCHAR:
case LONG32NVARCHAR:
return "string";
case BINARY:
case VARBINARY:
case LONG32VARBINARY:
return "bytes";
}
return super.castType( sqlTypeCode );
}
@Override
public int getMaxVarcharLength() {
//max is equivalent to 2_621_440
return 2_621_440;
}
@Override
public int getMaxVarbinaryLength() {
//max is equivalent to 10_485_760
return 10_485_760;
}
@Override
public boolean supportsStandardArrays() {
return true;
}
@Override
public String getArrayTypeName(String javaElementTypeName, String elementTypeName, Integer maxLength) {
return "ARRAY<" + elementTypeName + ">";
}
@Override
public void initializeFunctionRegistry(FunctionContributions functionContributions) {
super.initializeFunctionRegistry(functionContributions);
final BasicTypeRegistry basicTypeRegistry = functionContributions.getTypeConfiguration().getBasicTypeRegistry();
final BasicType byteArrayType = basicTypeRegistry.resolve( StandardBasicTypes.BINARY );
final BasicType longType = basicTypeRegistry.resolve( StandardBasicTypes.LONG );
final BasicType booleanType = basicTypeRegistry.resolve( StandardBasicTypes.BOOLEAN );
final BasicType stringType = basicTypeRegistry.resolve( StandardBasicTypes.STRING );
final BasicType dateType = basicTypeRegistry.resolve( StandardBasicTypes.DATE );
final BasicType timestampType = basicTypeRegistry.resolve( StandardBasicTypes.TIMESTAMP );
// Aggregate Functions
functionContributions.getFunctionRegistry().namedAggregateDescriptorBuilder( "any_value" )
.setExactArgumentCount( 1 )
.register();
functionContributions.getFunctionRegistry().namedAggregateDescriptorBuilder( "array_agg" )
.setExactArgumentCount( 1 )
.register();
functionContributions.getFunctionRegistry().namedAggregateDescriptorBuilder( "countif" )
.setInvariantType( longType )
.setExactArgumentCount( 1 )
.register();
functionContributions.getFunctionRegistry().namedAggregateDescriptorBuilder( "logical_and" )
.setInvariantType( booleanType )
.setExactArgumentCount( 1 )
.register();
functionContributions.getFunctionRegistry().namedAggregateDescriptorBuilder( "logical_or" )
.setInvariantType( booleanType )
.setExactArgumentCount( 1 )
.register();
functionContributions.getFunctionRegistry().namedAggregateDescriptorBuilder( "string_agg" )
.setInvariantType( stringType )
.setArgumentCountBetween( 1, 2 )
.register();
CommonFunctionFactory functionFactory = new CommonFunctionFactory(functionContributions);
// Mathematical Functions
functionFactory.log();
functionFactory.log10();
functionFactory.trunc();
functionFactory.ceiling_ceil();
functionFactory.cosh();
functionFactory.sinh();
functionFactory.tanh();
functionFactory.moreHyperbolic();
functionFactory.bitandorxornot_bitAndOrXorNot();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "is_inf" )
.setInvariantType( booleanType )
.setExactArgumentCount( 1 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "is_nan" )
.setInvariantType( booleanType )
.setExactArgumentCount( 1 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "ieee_divide" )
.setInvariantType( booleanType )
.setExactArgumentCount( 2 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "div" )
.setInvariantType( longType )
.setExactArgumentCount( 2 )
.register();
functionFactory.sha1();
// Hash Functions
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "farm_fingerprint" )
.setInvariantType( longType )
.setExactArgumentCount( 1 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "sha256" )
.setInvariantType( byteArrayType )
.setExactArgumentCount( 1 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "sha512" )
.setInvariantType( byteArrayType )
.setExactArgumentCount( 1 )
.register();
// String Functions
functionFactory.concat_pipeOperator();
functionFactory.trim2();
functionFactory.reverse();
functionFactory.repeat();
functionFactory.substr();
functionFactory.substring_substr();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "byte_length" )
.setInvariantType( longType )
.setExactArgumentCount( 1 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "code_points_to_bytes" )
.setInvariantType( byteArrayType )
.setExactArgumentCount( 1 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "code_points_to_string" )
.setInvariantType( stringType )
.setExactArgumentCount( 1 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "ends_with" )
.setInvariantType( booleanType )
.setExactArgumentCount( 2 )
.register();
// queryEngine.getSqmFunctionRegistry().namedTemplateBuilder( "format" )
// .setInvariantType( StandardBasicTypes.STRING )
// .register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "from_base64" )
.setInvariantType( byteArrayType )
.setExactArgumentCount( 1 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "from_hex" )
.setInvariantType( byteArrayType )
.setExactArgumentCount( 1 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "regexp_contains" )
.setInvariantType( booleanType )
.setExactArgumentCount( 2 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "regexp_extract" )
.setExactArgumentCount( 2 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "regexp_extract_all" )
.setExactArgumentCount( 2 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "regexp_replace" )
.setExactArgumentCount( 3 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "safe_convert_bytes_to_string" )
.setInvariantType( stringType )
.setExactArgumentCount( 1 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "split" )
.setArgumentCountBetween( 1, 2 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "starts_with" )
.setInvariantType( booleanType )
.setExactArgumentCount( 2 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "strpos" )
.setInvariantType( longType )
.setExactArgumentCount( 2 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "to_base64" )
.setInvariantType( stringType )
.setExactArgumentCount( 1 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "to_code_points" )
.setExactArgumentCount( 1 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "to_hex" )
.setInvariantType( stringType )
.setExactArgumentCount( 1 )
.register();
// JSON Functions
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "json_query" )
.setInvariantType( stringType )
.setExactArgumentCount( 2 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "json_value" )
.setInvariantType( stringType )
.setExactArgumentCount( 2 )
.register();
// Array Functions
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "array" )
.setExactArgumentCount( 1 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "array_concat" )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "array_length" )
.setInvariantType( longType )
.setExactArgumentCount( 1 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "array_to_string" )
.setInvariantType( stringType )
.setArgumentCountBetween( 2, 3 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "array_reverse" )
.setExactArgumentCount( 1 )
.register();
// Date functions
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "date" )
.setInvariantType( dateType )
.setArgumentCountBetween( 1, 3 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "date_add" )
.setInvariantType( dateType )
.setExactArgumentCount( 2 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "date_sub" )
.setInvariantType( dateType )
.setExactArgumentCount( 2 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "date_diff" )
.setInvariantType( longType )
.setExactArgumentCount( 3 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "date_trunc" )
.setReturnTypeResolver( useArgType( 1 ) )
.setExactArgumentCount( 2 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "date_from_unix_date" )
.setInvariantType( dateType )
.setExactArgumentCount( 1 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "format_date" )
.setInvariantType( stringType )
.setExactArgumentCount( 2 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "parse_date" )
.setInvariantType( dateType )
.setExactArgumentCount( 2 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "unix_date" )
.setInvariantType( longType )
.setExactArgumentCount( 1 )
.register();
// Timestamp functions
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "string" )
.setInvariantType( stringType )
.setArgumentCountBetween( 1, 2 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "timestamp" )
.setInvariantType( timestampType )
.setArgumentCountBetween( 1, 2 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "timestamp_add" )
.setInvariantType( timestampType )
.setExactArgumentCount( 2 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "timestamp_sub" )
.setInvariantType( timestampType )
.setExactArgumentCount( 2 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "timestamp_diff" )
.setInvariantType( longType )
.setExactArgumentCount( 3 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "timestamp_trunc" )
.setInvariantType( timestampType )
.setArgumentCountBetween( 2, 3 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "format_timestamp" )
.setInvariantType( stringType )
.setArgumentCountBetween( 2, 3 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "parse_timestamp" )
.setInvariantType( timestampType )
.setArgumentCountBetween( 2, 3 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "timestamp_seconds" )
.setInvariantType( timestampType )
.setExactArgumentCount( 1 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "timestamp_millis" )
.setInvariantType( timestampType )
.setExactArgumentCount( 1 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "timestamp_micros" )
.setInvariantType( timestampType )
.setExactArgumentCount( 1 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "unix_seconds" )
.setInvariantType( longType )
.setExactArgumentCount( 1 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "unix_millis" )
.setInvariantType( longType )
.setExactArgumentCount( 1 )
.register();
functionContributions.getFunctionRegistry().namedDescriptorBuilder( "unix_micros" )
.setInvariantType( longType )
.setExactArgumentCount( 1 )
.register();
functionContributions.getFunctionRegistry().register(
"format",
new FormatFunction( "format_timestamp", true, true, functionContributions.getTypeConfiguration() )
);
functionFactory.listagg_stringAgg( "string" );
functionFactory.inverseDistributionOrderedSetAggregates();
functionFactory.hypotheticalOrderedSetAggregates();
functionFactory.array_spanner();
}
@Override
public SqlAstTranslatorFactory getSqlAstTranslatorFactory() {
return new StandardSqlAstTranslatorFactory() {
@Override
protected SqlAstTranslator buildTranslator(
SessionFactoryImplementor sessionFactory, Statement statement) {
return new SpannerSqlAstTranslator<>( sessionFactory, statement );
}
};
}
@Override
public Exporter getTableExporter() {
return this.spannerTableExporter;
}
/* SELECT-related functions */
@Override
public boolean supportsCurrentTimestampSelection() {
return true;
}
@Override
public boolean isCurrentTimestampSelectStringCallable() {
return false;
}
@Override
public String getCurrentTimestampSelectString() {
return "select current_timestamp() as now";
}
@Override
public void appendBooleanValueString(SqlAppender appender, boolean bool) {
appender.appendSql( bool );
}
@Override
public String translateExtractField(TemporalUnit unit) {
switch (unit) {
case WEEK:
return "isoweek";
case DAY_OF_MONTH:
return "day";
case DAY_OF_WEEK:
return "dayofweek";
case DAY_OF_YEAR:
return "dayofyear";
default:
return super.translateExtractField(unit);
}
}
@Override
public String timestampaddPattern(TemporalUnit unit, TemporalType temporalType, IntervalType intervalType) {
if ( temporalType == TemporalType.TIMESTAMP ) {
switch (unit) {
case YEAR:
case QUARTER:
case MONTH:
throw new SemanticException("Illegal unit for timestamp_add(): " + unit);
default:
return "timestamp_add(?3,interval ?2 ?1)";
}
}
else {
switch (unit) {
case NANOSECOND:
case SECOND:
case MINUTE:
case HOUR:
case NATIVE:
throw new SemanticException("Illegal unit for date_add(): " + unit);
default:
return "date_add(?3,interval ?2 ?1)";
}
}
}
@Override
public String timestampdiffPattern(TemporalUnit unit, TemporalType fromTemporalType, TemporalType toTemporalType) {
if ( toTemporalType == TemporalType.TIMESTAMP || fromTemporalType == TemporalType.TIMESTAMP ) {
switch (unit) {
case YEAR:
case QUARTER:
case MONTH:
throw new SemanticException("Illegal unit for timestamp_diff(): " + unit);
default:
return "timestamp_diff(?3,?2,?1)";
}
}
else {
switch (unit) {
case NANOSECOND:
case SECOND:
case MINUTE:
case HOUR:
case NATIVE:
throw new SemanticException("Illegal unit for date_diff(): " + unit);
default:
return "date_diff(?3,?2,?1)";
}
}
}
@Override
public void appendDatetimeFormat(SqlAppender appender, String format) {
appender.appendSql( datetimeFormat( format ).result() );
}
public static Replacer datetimeFormat(String format) {
return MySQLDialect.datetimeFormat(format)
//day of week
.replace("EEEE", "%A")
.replace("EEE", "%a")
//minute
.replace("mm", "%M")
.replace("m", "%M")
//month of year
.replace("MMMM", "%B")
.replace("MMM", "%b")
.replace("MM", "%m")
.replace("M", "%m")
//week of year
.replace("ww", "%V")
.replace("w", "%V")
//year for week
.replace("YYYY", "%G")
.replace("YYY", "%G")
.replace("YY", "%g")
.replace("Y", "%g")
//timezones
.replace("zzz", "%Z")
.replace("zz", "%Z")
.replace("z", "%Z")
.replace("ZZZ", "%z")
.replace("ZZ", "%z")
.replace("Z", "%z")
.replace("xxx", "%Ez")
.replace("xx", "%z"); //note special case
}
/* DDL-related functions */
@Override
public boolean canCreateSchema() {
return false;
}
@Override
public String[] getCreateSchemaCommand(String schemaName) {
throw new UnsupportedOperationException(
"No create schema syntax supported by " + getClass().getName() );
}
@Override
public String[] getDropSchemaCommand(String schemaName) {
throw new UnsupportedOperationException(
"No drop schema syntax supported by " + getClass().getName() );
}
@Override
public String getCurrentSchemaCommand() {
throw new UnsupportedOperationException(
"No current schema syntax supported by " + getClass().getName() );
}
@Override
public SchemaNameResolver getSchemaNameResolver() {
// Spanner does not have a notion of database name schemas, so return "".
return (connection, dialect) -> "";
}
@Override
public boolean dropConstraints() {
return false;
}
@Override
public boolean qualifyIndexName() {
return false;
}
@Override
public String getDropForeignKeyString() {
throw new UnsupportedOperationException(
"Cannot drop foreign-key constraint because Cloud Spanner does not support foreign keys." );
}
@Override
public String getAddForeignKeyConstraintString(
String constraintName,
String[] foreignKey,
String referencedTable,
String[] primaryKey,
boolean referencesPrimaryKey) {
throw new UnsupportedOperationException(
"Cannot add foreign-key constraint because Cloud Spanner does not support foreign keys." );
}
@Override
public String getAddForeignKeyConstraintString(
String constraintName,
String foreignKeyDefinition) {
throw new UnsupportedOperationException(
"Cannot add foreign-key constraint because Cloud Spanner does not support foreign keys." );
}
@Override
public String getAddPrimaryKeyConstraintString(String constraintName) {
throw new UnsupportedOperationException( "Cannot add primary key constraint in Cloud Spanner." );
}
/* Lock acquisition functions */
@Override
public boolean supportsLockTimeouts() {
return false;
}
@Override
public LockingStrategy getLockingStrategy(Lockable lockable, LockMode lockMode) {
return LOCKING_STRATEGY;
}
@Override
public String getForUpdateString(LockOptions lockOptions) {
return "";
}
@Override
public String getForUpdateString() {
return "";
}
@Override
public String getForUpdateString(String aliases) {
throw new UnsupportedOperationException(
"Cloud Spanner does not support selecting for lock acquisition." );
}
@Override
public String getForUpdateString(String aliases, LockOptions lockOptions) {
throw new UnsupportedOperationException(
"Cloud Spanner does not support selecting for lock acquisition." );
}
@Override
public String getWriteLockString(int timeout) {
throw new UnsupportedOperationException(
"Cloud Spanner does not support selecting for lock acquisition." );
}
@Override
public String getWriteLockString(String aliases, int timeout) {
throw new UnsupportedOperationException(
"Cloud Spanner does not support selecting for lock acquisition." );
}
@Override
public String getReadLockString(int timeout) {
throw new UnsupportedOperationException(
"Cloud Spanner does not support selecting for lock acquisition." );
}
@Override
public String getReadLockString(String aliases, int timeout) {
throw new UnsupportedOperationException(
"Cloud Spanner does not support selecting for lock acquisition." );
}
@Override
public boolean supportsOuterJoinForUpdate() {
return false;
}
@Override
public String getForUpdateNowaitString() {
throw new UnsupportedOperationException(
"Cloud Spanner does not support selecting for lock acquisition." );
}
@Override
public String getForUpdateNowaitString(String aliases) {
throw new UnsupportedOperationException(
"Cloud Spanner does not support selecting for lock acquisition." );
}
@Override
public String getForUpdateSkipLockedString() {
throw new UnsupportedOperationException(
"Cloud Spanner does not support selecting for lock acquisition." );
}
@Override
public String getForUpdateSkipLockedString(String aliases) {
throw new UnsupportedOperationException(
"Cloud Spanner does not support selecting for lock acquisition." );
}
/* Unsupported Hibernate Exporters */
@Override
public Exporter getSequenceExporter() {
return NOOP_EXPORTER;
}
@Override
public Exporter getForeignKeyExporter() {
return NOOP_EXPORTER;
}
@Override
public Exporter getUniqueKeyExporter() {
return NOOP_EXPORTER;
}
@Override
public String applyLocksToSql(
String sql,
LockOptions aliasedLockOptions,
Map keyColumnNames) {
return sql;
}
@Override
public UniqueDelegate getUniqueDelegate() {
return NOOP_UNIQUE_DELEGATE;
}
@Override
public boolean supportsCircularCascadeDeleteConstraints() {
return false;
}
@Override
public boolean supportsCascadeDelete() {
return false;
}
@Override
public boolean supportsOffsetInSubquery() {
return true;
}
@Override
public char openQuote() {
return '`';
}
@Override
public char closeQuote() {
return '`';
}
@Override
public LimitHandler getLimitHandler() {
return LimitOffsetLimitHandler.INSTANCE;
}
/* Type conversion and casting */
/**
* A no-op {@link Exporter} which is responsible for returning empty Create and Drop SQL strings.
*
* @author Daniel Zou
*/
static class EmptyExporter implements Exporter {
@Override
public String[] getSqlCreateStrings(T exportable, Metadata metadata, SqlStringGenerationContext context) {
return ArrayHelper.EMPTY_STRING_ARRAY;
}
@Override
public String[] getSqlDropStrings(T exportable, Metadata metadata, SqlStringGenerationContext context) {
return ArrayHelper.EMPTY_STRING_ARRAY;
}
}
/**
* A locking strategy for the Cloud Spanner dialect that does nothing. Cloud Spanner does not
* support locking.
*
* @author Chengyuan Zhao
*/
static class DoNothingLockingStrategy implements LockingStrategy {
@Override
public void lock(
Object id, Object version, Object object, int timeout, EventSource session)
throws StaleObjectStateException, LockingStrategyException {
// Do nothing. Cloud Spanner doesn't have have locking strategies.
}
}
/**
* A no-op delegate for generating Unique-Constraints. Cloud Spanner offers unique-restrictions
* via interleaved indexes with the "UNIQUE" option. This is not currently supported.
*
* @author Chengyuan Zhao
*/
static class DoNothingUniqueDelegate implements UniqueDelegate {
@Override
public String getColumnDefinitionUniquenessFragment(Column column, SqlStringGenerationContext context) {
return "";
}
@Override
public String getTableCreationUniqueConstraintsFragment(Table table, SqlStringGenerationContext context) {
return "";
}
@Override
public String getAlterTableToAddUniqueKeyCommand(UniqueKey uniqueKey, Metadata metadata, SqlStringGenerationContext context) {
return "";
}
@Override
public String getAlterTableToDropUniqueKeyCommand(UniqueKey uniqueKey, Metadata metadata, SqlStringGenerationContext context) {
return "";
}
}
}
© 2015 - 2024 Weber Informatics LLC | Privacy Policy