Created
January 14, 2022 19:22
-
-
Save julianoBRL/4483e987bdd9a146dda1238751c73938 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import java.sql.Types; | |
/* | |
<dependency> | |
<groupId>org.xerial</groupId> | |
<artifactId>sqlite-jdbc</artifactId> | |
</dependency> | |
spring.jpa.database-platform=com.shintaro.sqlite.sqliteConfig.SQLiteDialect | |
spring.jpa.hibernate.ddl-auto=update | |
spring.datasource.url = jdbc:sqlite:sqlitesample.db | |
spring.datasource.driver-class-name = org.sqlite.JDBC | |
spring.datasource.username = admin | |
spring.datasource.password = admin | |
spring.jpa.show-sql=true | |
*/ | |
import org.hibernate.dialect.Dialect; | |
import org.hibernate.dialect.function.SQLFunctionTemplate; | |
import org.hibernate.dialect.function.StandardSQLFunction; | |
import org.hibernate.dialect.function.VarArgsSQLFunction; | |
import org.hibernate.type.StringType; | |
public class SQLiteDialect extends Dialect { | |
public SQLiteDialect() { | |
registerColumnType(Types.BIT, "integer"); | |
registerColumnType(Types.TINYINT, "tinyint"); | |
registerColumnType(Types.SMALLINT, "smallint"); | |
registerColumnType(Types.INTEGER, "integer"); | |
registerColumnType(Types.BIGINT, "bigint"); | |
registerColumnType(Types.FLOAT, "float"); | |
registerColumnType(Types.REAL, "real"); | |
registerColumnType(Types.DOUBLE, "double"); | |
registerColumnType(Types.NUMERIC, "numeric"); | |
registerColumnType(Types.DECIMAL, "decimal"); | |
registerColumnType(Types.CHAR, "char"); | |
registerColumnType(Types.VARCHAR, "varchar"); | |
registerColumnType(Types.LONGVARCHAR, "longvarchar"); | |
registerColumnType(Types.DATE, "date"); | |
registerColumnType(Types.TIME, "time"); | |
registerColumnType(Types.TIMESTAMP, "timestamp"); | |
registerColumnType(Types.BINARY, "blob"); | |
registerColumnType(Types.VARBINARY, "blob"); | |
registerColumnType(Types.LONGVARBINARY, "blob"); | |
// registerColumnType(Types.NULL, "null"); | |
registerColumnType(Types.BLOB, "blob"); | |
registerColumnType(Types.CLOB, "clob"); | |
registerColumnType(Types.BOOLEAN, "integer"); | |
registerFunction("concat", new VarArgsSQLFunction(StringType.INSTANCE, "", "||", "")); | |
registerFunction("mod", new SQLFunctionTemplate(StringType.INSTANCE, "?1 % ?2")); | |
registerFunction("substr", new StandardSQLFunction("substr", StringType.INSTANCE)); | |
registerFunction("substring", new StandardSQLFunction("substr", StringType.INSTANCE)); | |
} | |
public boolean supportsIdentityColumns() { | |
return true; | |
} | |
public boolean hasDataTypeInIdentityColumn() { | |
return false; // As specify in NHibernate dialect | |
} | |
public String getIdentityColumnString() { | |
// return "integer primary key autoincrement"; | |
return "integer"; | |
} | |
public String getIdentitySelectString() { | |
return "select last_insert_rowid()"; | |
} | |
public boolean supportsLimit() { | |
return true; | |
} | |
protected String getLimitString(String query, boolean hasOffset) { | |
return new StringBuffer(query.length() + 20).append(query).append(hasOffset ? " limit ? offset ?" : " limit ?") | |
.toString(); | |
} | |
public boolean supportsTemporaryTables() { | |
return true; | |
} | |
public String getCreateTemporaryTableString() { | |
return "create temporary table if not exists"; | |
} | |
public boolean dropTemporaryTableAfterUse() { | |
return false; | |
} | |
public boolean supportsCurrentTimestampSelection() { | |
return true; | |
} | |
public boolean isCurrentTimestampSelectStringCallable() { | |
return false; | |
} | |
public String getCurrentTimestampSelectString() { | |
return "select current_timestamp"; | |
} | |
public boolean supportsUnionAll() { | |
return true; | |
} | |
public boolean hasAlterTable() { | |
return false; // As specify in NHibernate dialect | |
} | |
public boolean dropConstraints() { | |
return false; | |
} | |
public String getAddColumnString() { | |
return "add column"; | |
} | |
public String getForUpdateString() { | |
return ""; | |
} | |
public boolean supportsOuterJoinForUpdate() { | |
return false; | |
} | |
public String getDropForeignKeyString() { | |
throw new UnsupportedOperationException("No drop foreign key syntax supported by SQLiteDialect"); | |
} | |
public String getAddForeignKeyConstraintString(String constraintName, String[] foreignKey, String referencedTable, | |
String[] primaryKey, boolean referencesPrimaryKey) { | |
throw new UnsupportedOperationException("No add foreign key syntax supported by SQLiteDialect"); | |
} | |
public String getAddPrimaryKeyConstraintString(String constraintName) { | |
throw new UnsupportedOperationException("No add primary key syntax supported by SQLiteDialect"); | |
} | |
public boolean supportsIfExistsBeforeTableName() { | |
return true; | |
} | |
public boolean supportsCascadeDelete() { | |
return false; | |
} | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment