Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance. Project price only 1 $
You can buy this project and download/modify it how often you want.
package org.umlg.sqlg.sql.dialect;
import com.fasterxml.jackson.databind.JsonNode;
import org.apache.tinkerpop.gremlin.structure.Property;
import org.hsqldb.jdbc.JDBCArrayBasic;
import org.hsqldb.types.Type;
import org.umlg.sqlg.structure.PropertyType;
import org.umlg.sqlg.structure.SchemaTable;
import org.umlg.sqlg.structure.SqlgGraph;
import org.umlg.sqlg.util.SqlgUtil;
import java.sql.*;
import java.time.*;
import java.util.*;
/**
* Date: 2014/07/16
* Time: 3:09 PM
*/
public class HsqldbDialect extends BaseSqlDialect {
public HsqldbDialect() {
super();
}
@Override
public String dialectName() {
return "HsqldbDialect";
}
@Override
public Set getDefaultSchemas() {
return new HashSet<>(Arrays.asList("PUBLIC", "INFORMATION_SCHEMA", "SYSTEM_LOBS"));
}
@Override
public String getPublicSchema() {
return "PUBLIC";
}
@Override
public String existIndexQuery(SchemaTable schemaTable, String prefix, String indexName) {
StringBuilder sb = new StringBuilder("SELECT * FROM INFORMATION_SCHEMA.SYSTEM_INDEXINFO WHERE TABLE_SCHEM = '");
sb.append(schemaTable.getSchema());
sb.append("' AND TABLE_NAME = '");
sb.append(prefix);
sb.append(schemaTable.getTable());
sb.append("' AND INDEX_NAME = '");
sb.append(indexName);
sb.append("'");
return sb.toString();
}
@Override
public boolean supportsTransactionalSchema() {
return false;
}
@Override
public void validateProperty(Object key, Object value) {
if (value instanceof String) {
return;
}
if (value instanceof Character) {
return;
}
if (value instanceof Boolean) {
return;
}
if (value instanceof Byte) {
return;
}
if (value instanceof Short) {
return;
}
if (value instanceof Integer) {
return;
}
if (value instanceof Long) {
return;
}
if (value instanceof Double) {
return;
}
if (value instanceof LocalDate) {
return;
}
if (value instanceof LocalDateTime) {
return;
}
if (value instanceof ZonedDateTime) {
return;
}
if (value instanceof LocalTime) {
return;
}
if (value instanceof Period) {
return;
}
if (value instanceof Duration) {
return;
}
if (value instanceof byte[]) {
return;
}
if (value instanceof boolean[]) {
return;
}
if (value instanceof char[]) {
return;
}
if (value instanceof short[]) {
return;
}
if (value instanceof int[]) {
return;
}
if (value instanceof long[]) {
return;
}
if (value instanceof double[]) {
return;
}
if (value instanceof String[]) {
return;
}
if (value instanceof Character[]) {
return;
}
if (value instanceof Boolean[]) {
return;
}
if (value instanceof Byte[]) {
return;
}
if (value instanceof Short[]) {
return;
}
if (value instanceof Integer[]) {
return;
}
if (value instanceof Long[]) {
return;
}
if (value instanceof Double[]) {
return;
}
if (value instanceof LocalDateTime[]) {
return;
}
if (value instanceof LocalDate[]) {
return;
}
if (value instanceof LocalTime[]) {
return;
}
if (value instanceof ZonedDateTime[]) {
return;
}
if (value instanceof Duration[]) {
return;
}
if (value instanceof Period[]) {
return;
}
throw Property.Exceptions.dataTypeOfPropertyValueNotSupported(value);
}
@Override
public String getColumnEscapeKey() {
return "\"";
}
@Override
public String getPrimaryKeyType() {
return "BIGINT NOT NULL PRIMARY KEY";
}
@Override
public String getAutoIncrementPrimaryKeyConstruct() {
return "BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY";
}
@Override
public String[] propertyTypeToSqlDefinition(PropertyType propertyType) {
switch (propertyType) {
case BOOLEAN:
return new String[]{"BOOLEAN"};
case BYTE:
return new String[]{"TINYINT"};
case SHORT:
return new String[]{"SMALLINT"};
case INTEGER:
return new String[]{"INTEGER"};
case LONG:
return new String[]{"BIGINT"};
case FLOAT:
return new String[]{"REAL"};
case DOUBLE:
return new String[]{"DOUBLE"};
case LOCALDATE:
return new String[]{"DATE"};
case LOCALDATETIME:
return new String[]{"TIMESTAMP WITH TIME ZONE"};
case ZONEDDATETIME:
return new String[]{"TIMESTAMP WITH TIME ZONE", "LONGVARCHAR"};
case LOCALTIME:
return new String[]{"TIME WITH TIME ZONE"};
case PERIOD:
return new String[]{"INTEGER", "INTEGER", "INTEGER"};
case DURATION:
return new String[]{"BIGINT", "INTEGER"};
case STRING:
return new String[]{"LONGVARCHAR"};
case JSON:
throw new IllegalStateException("HSQLDB does not support json types, use good ol string instead!");
case POINT:
throw new IllegalStateException("HSQLDB does not support gis types!");
case POLYGON:
throw new IllegalStateException("HSQLDB does not support gis types!");
case GEOGRAPHY_POINT:
throw new IllegalStateException("HSQLDB does not support gis types!");
case GEOGRAPHY_POLYGON:
throw new IllegalStateException("HSQLDB does not support gis types!");
case BYTE_ARRAY:
return new String[]{"LONGVARBINARY"};
case byte_ARRAY:
return new String[]{"LONGVARBINARY"};
case boolean_ARRAY:
return new String[]{"BOOLEAN ARRAY DEFAULT ARRAY[]"};
case BOOLEAN_ARRAY:
return new String[]{"BOOLEAN ARRAY DEFAULT ARRAY[]"};
case SHORT_ARRAY:
return new String[]{"SMALLINT ARRAY DEFAULT ARRAY[]"};
case short_ARRAY:
return new String[]{"SMALLINT ARRAY DEFAULT ARRAY[]"};
case int_ARRAY:
return new String[]{"INTEGER ARRAY DEFAULT ARRAY[]"};
case INTEGER_ARRAY:
return new String[]{"INTEGER ARRAY DEFAULT ARRAY[]"};
case LONG_ARRAY:
return new String[]{"BIGINT ARRAY DEFAULT ARRAY[]"};
case long_ARRAY:
return new String[]{"BIGINT ARRAY DEFAULT ARRAY[]"};
case float_ARRAY:
return new String[]{"REAL ARRAY DEFAULT ARRAY[]"};
case DOUBLE_ARRAY:
return new String[]{"DOUBLE ARRAY DEFAULT ARRAY[]"};
case double_ARRAY:
return new String[]{"DOUBLE ARRAY DEFAULT ARRAY[]"};
case STRING_ARRAY:
return new String[]{"LONGVARCHAR ARRAY DEFAULT ARRAY[]"};
case LOCALDATETIME_ARRAY:
return new String[]{"TIMESTAMP WITH TIME ZONE ARRAY DEFAULT ARRAY[]"};
case LOCALDATE_ARRAY:
return new String[]{"DATE ARRAY DEFAULT ARRAY[]"};
case LOCALTIME_ARRAY:
return new String[]{"TIME WITH TIME ZONE ARRAY DEFAULT ARRAY[]"};
case ZONEDDATETIME_ARRAY:
return new String[]{"TIMESTAMP WITH TIME ZONE ARRAY DEFAULT ARRAY[]", "LONGVARCHAR ARRAY DEFAULT ARRAY[]"};
case DURATION_ARRAY:
return new String[]{"BIGINT ARRAY DEFAULT ARRAY[]", "INTEGER ARRAY DEFAULT ARRAY[]"};
case PERIOD_ARRAY:
return new String[]{"INTEGER ARRAY DEFAULT ARRAY[]", "INTEGER ARRAY DEFAULT ARRAY[]", "INTEGER ARRAY DEFAULT ARRAY[]"};
default:
throw new IllegalStateException("Unknown propertyType " + propertyType.name());
}
}
@Override
public int propertyTypeToJavaSqlType(PropertyType propertyType) {
switch (propertyType) {
case BOOLEAN:
return Types.BOOLEAN;
case BYTE:
return Types.TINYINT;
case SHORT:
return Types.SMALLINT;
case INTEGER:
return Types.INTEGER;
case LONG:
return Types.BIGINT;
case FLOAT:
return Types.REAL;
case DOUBLE:
return Types.DOUBLE;
case STRING:
return Types.CLOB;
case LOCALDATETIME:
return Types.TIMESTAMP;
case LOCALDATE:
return Types.DATE;
case LOCALTIME:
return Types.TIME;
case JSON:
//TODO support other others like Geometry...
return Types.OTHER;
case byte_ARRAY:
return Types.ARRAY;
case boolean_ARRAY:
return Types.ARRAY;
case short_ARRAY:
return Types.ARRAY;
case int_ARRAY:
return Types.ARRAY;
case long_ARRAY:
return Types.ARRAY;
case float_ARRAY:
return Types.ARRAY;
case double_ARRAY:
return Types.ARRAY;
case STRING_ARRAY:
return Types.ARRAY;
default:
throw new IllegalStateException("Unknown propertyType " + propertyType.name());
}
}
@Override
public PropertyType sqlTypeToPropertyType(SqlgGraph sqlgGraph, String schema, String table, String column, int sqlType, String typeName) {
switch (sqlType) {
case Types.BOOLEAN:
return PropertyType.BOOLEAN;
case Types.SMALLINT:
return PropertyType.SHORT;
case Types.INTEGER:
return PropertyType.INTEGER;
case Types.BIGINT:
return PropertyType.LONG;
case Types.REAL:
return PropertyType.FLOAT;
case Types.DOUBLE:
return PropertyType.DOUBLE;
case Types.VARCHAR:
return PropertyType.STRING;
case Types.TIMESTAMP:
return PropertyType.LOCALDATETIME;
case Types.DATE:
return PropertyType.LOCALDATE;
case Types.TIME:
return PropertyType.LOCALTIME;
case Types.VARBINARY:
return PropertyType.byte_ARRAY;
case Types.ARRAY:
switch (typeName) {
case "BOOLEAN ARRAY":
return PropertyType.boolean_ARRAY;
case "SMALLINT ARRAY":
return PropertyType.short_ARRAY;
case "INTEGER ARRAY":
return PropertyType.int_ARRAY;
case "BIGINT ARRAY":
return PropertyType.long_ARRAY;
case "DOUBLE ARRAY":
return PropertyType.double_ARRAY;
default:
if (typeName.contains("VARCHAR") && typeName.contains("ARRAY")) {
return PropertyType.STRING_ARRAY;
} else {
throw new RuntimeException(String.format("Array type not supported sqlType = %s and typeName = %s", new String[]{String.valueOf(sqlType), typeName}));
}
}
default:
throw new IllegalStateException("Unknown sqlType " + sqlType);
}
}
@Override
public String getForeignKeyTypeDefinition() {
return "BIGINT";
}
@Override
public boolean supportsFloatValues() {
return false;
}
@Override
public boolean supportsByteValues() {
return true;
}
@Override
public boolean supportsFloatArrayValues() {
return false;
}
@Override
public String getArrayDriverType(PropertyType propertyType) {
switch (propertyType) {
case boolean_ARRAY:
return "BOOLEAN";
case BOOLEAN_ARRAY:
return "BOOLEAN";
case SHORT_ARRAY:
return "SMALLINT";
case short_ARRAY:
return "SMALLINT";
case INTEGER_ARRAY:
return "INTEGER";
case int_ARRAY:
return "INTEGER";
case LONG_ARRAY:
return "BIGINT";
case long_ARRAY:
return "BIGINT";
case DOUBLE_ARRAY:
return "DOUBLE";
case double_ARRAY:
return "DOUBLE";
case STRING_ARRAY:
return "VARCHAR";
case LOCALDATETIME_ARRAY:
return "TIMESTAMP";
case LOCALDATE_ARRAY:
return "DATE";
case LOCALTIME_ARRAY:
return "TIME";
default:
throw new IllegalStateException("propertyType " + propertyType.name() + " unknown!");
}
}
@Override
public String createTableStatement() {
return "CREATE TABLE ";
}
@Override
public void prepareDB(Connection conn) {
StringBuilder sql = new StringBuilder("SET DATABASE TRANSACTION CONTROL MVCC;");
try (PreparedStatement preparedStatement = conn.prepareStatement(sql.toString())) {
preparedStatement.executeUpdate();
} catch (SQLException e) {
throw new RuntimeException(e);
}
sql = new StringBuilder("SET DATABASE DEFAULT TABLE TYPE CACHED;");
try (PreparedStatement preparedStatement = conn.prepareStatement(sql.toString())) {
preparedStatement.executeUpdate();
} catch (SQLException e) {
throw new RuntimeException(e);
}
}
@Override
public void validateColumnName(String column) {
super.validateColumnName(column);
}
@Override
public Set getSpacialRefTable() {
return Collections.emptySet();
}
@Override
public List getGisSchemas() {
return Collections.emptyList();
}
@Override
public void setJson(PreparedStatement preparedStatement, int parameterStartIndex, JsonNode right) {
throw new IllegalStateException("Hsqldb does not support json types, this should not have happened!");
}
@Override
public void setPoint(PreparedStatement preparedStatement, int parameterStartIndex, Object point) {
throw new IllegalStateException("Hsqldb does not support gis types, this should not have happened!");
}
@Override
public void setLineString(PreparedStatement preparedStatement, int parameterStartIndex, Object lineString) {
throw new IllegalStateException("Hsqldb does not support gis types, this should not have happened!");
}
@Override
public void setPolygon(PreparedStatement preparedStatement, int parameterStartIndex, Object point) {
throw new IllegalStateException("Hsqldb does not support gis types, this should not have happened!");
}
@Override
public void setGeographyPoint(PreparedStatement preparedStatement, int parameterStartIndex, Object point) {
throw new IllegalStateException("Hsqldb does not support gis types, this should not have happened!");
}
@Override
public void handleOther(Map properties, String columnName, Object o, PropertyType propertyType) {
throw new IllegalStateException("Hsqldb does not support other types, this should not have happened!");
}
@Override
public T getGis(SqlgGraph sqlgGraph) {
throw new IllegalStateException("Hsqldb does not support other types, this should not have happened!");
}
@Override
public void lockTable(SqlgGraph sqlgGraph, SchemaTable schemaTable, String prefix) {
throw new UnsupportedOperationException("Hsqldb does not support table locking!");
}
@Override
public void alterSequenceCacheSize(SqlgGraph sqlgGraph, SchemaTable schemaTable, String sequence, int batchSize) {
throw new UnsupportedOperationException("Hsqldb does not support alterSequenceCacheSize!");
}
@Override
public long nextSequenceVal(SqlgGraph sqlgGraph, SchemaTable schemaTable, String prefix) {
throw new UnsupportedOperationException("Hsqldb does not support nextSequenceVal!");
}
@Override
public long currSequenceVal(SqlgGraph sqlgGraph, SchemaTable schemaTable, String prefix) {
throw new UnsupportedOperationException("Hsqldb does not support currSequenceVal!");
}
@Override
public String sequenceName(SqlgGraph sqlgGraph, SchemaTable outSchemaTable, String prefix) {
throw new UnsupportedOperationException("Hsqldb does not support sequenceName!");
}
@Override
public boolean supportsBulkWithinOut() {
return false;
}
@Override
public String createTemporaryTableStatement() {
return "DECLARE LOCAL TEMPORARY TABLE ";
}
@Override
public String afterCreateTemporaryTableStatement() {
return "";
}
@Override
public List sqlgTopologyCreationScripts() {
List result = new ArrayList<>();
result.add("CREATE SCHEMA \"sqlg_schema\";");
result.add("CREATE TABLE \"sqlg_schema\".\"V_schema\" (\"ID\" BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, \"createdOn\" TIMESTAMP WITH TIME ZONE, \"name\" LONGVARCHAR);");
result.add("CREATE TABLE \"sqlg_schema\".\"V_vertex\" (\"ID\" BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, \"createdOn\" TIMESTAMP WITH TIME ZONE, \"name\" LONGVARCHAR, \"schemaVertex\" LONGVARCHAR);");
result.add("CREATE TABLE \"sqlg_schema\".\"V_edge\" (\"ID\" BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, \"createdOn\" TIMESTAMP WITH TIME ZONE, \"name\" LONGVARCHAR);");
result.add("CREATE TABLE \"sqlg_schema\".\"V_property\" (\"ID\" BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, \"createdOn\" TIMESTAMP WITH TIME ZONE, \"name\" LONGVARCHAR, \"type\" LONGVARCHAR);");
result.add("CREATE TABLE \"sqlg_schema\".\"E_schema_vertex\"(\"ID\" BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, \"sqlg_schema.vertex__I\" BIGINT, \"sqlg_schema.schema__O\" BIGINT, FOREIGN KEY (\"sqlg_schema.vertex__I\") REFERENCES \"sqlg_schema\".\"V_vertex\" (\"ID\"), FOREIGN KEY (\"sqlg_schema.schema__O\") REFERENCES \"sqlg_schema\".\"V_schema\" (\"ID\"));");
result.add("CREATE TABLE \"sqlg_schema\".\"E_in_edges\"(\"ID\" BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, \"sqlg_schema.edge__I\" BIGINT, \"sqlg_schema.vertex__O\" BIGINT, FOREIGN KEY (\"sqlg_schema.edge__I\") REFERENCES \"sqlg_schema\".\"V_edge\" (\"ID\"), FOREIGN KEY (\"sqlg_schema.vertex__O\") REFERENCES \"sqlg_schema\".\"V_vertex\" (\"ID\"));");
result.add("CREATE TABLE \"sqlg_schema\".\"E_out_edges\"(\"ID\" BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, \"sqlg_schema.edge__I\" BIGINT, \"sqlg_schema.vertex__O\" BIGINT, FOREIGN KEY (\"sqlg_schema.edge__I\") REFERENCES \"sqlg_schema\".\"V_edge\" (\"ID\"), FOREIGN KEY (\"sqlg_schema.vertex__O\") REFERENCES \"sqlg_schema\".\"V_vertex\" (\"ID\"));");
result.add("CREATE TABLE \"sqlg_schema\".\"E_vertex_property\"(\"ID\" BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, \"sqlg_schema.property__I\" BIGINT, \"sqlg_schema.vertex__O\" BIGINT, FOREIGN KEY (\"sqlg_schema.property__I\") REFERENCES \"sqlg_schema\".\"V_property\" (\"ID\"), FOREIGN KEY (\"sqlg_schema.vertex__O\") REFERENCES \"sqlg_schema\".\"V_vertex\" (\"ID\"));");
result.add("CREATE TABLE \"sqlg_schema\".\"E_edge_property\"(\"ID\" BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, \"sqlg_schema.property__I\" BIGINT, \"sqlg_schema.edge__O\" BIGINT, FOREIGN KEY (\"sqlg_schema.property__I\") REFERENCES \"sqlg_schema\".\"V_property\" (\"ID\"), FOREIGN KEY (\"sqlg_schema.edge__O\") REFERENCES \"sqlg_schema\".\"V_edge\" (\"ID\"));");
return result;
}
@Override
public Long getPrimaryKeyStartValue() {
return 0L;
}
private Array createArrayOf(Connection conn, PropertyType propertyType, Object[] data) {
org.hsqldb.types.Type type;
switch (propertyType) {
case STRING_ARRAY:
type = Type.SQL_VARCHAR;
break;
case long_ARRAY:
type = Type.SQL_BIGINT;
break;
case LONG_ARRAY:
type = Type.SQL_BIGINT;
break;
case int_ARRAY:
type = Type.SQL_INTEGER;
break;
case INTEGER_ARRAY:
type = Type.SQL_INTEGER;
break;
case SHORT_ARRAY:
type = Type.SQL_SMALLINT;
break;
case short_ARRAY:
type = Type.SQL_SMALLINT;
break;
case FLOAT_ARRAY:
type = Type.SQL_DOUBLE;
break;
case float_ARRAY:
type = Type.SQL_DOUBLE;
break;
case DOUBLE_ARRAY:
type = Type.SQL_DOUBLE;
break;
case double_ARRAY:
type = Type.SQL_DOUBLE;
break;
case BOOLEAN_ARRAY:
type = Type.SQL_BIT;
break;
case boolean_ARRAY:
type = Type.SQL_BIT;
break;
case LOCALDATETIME_ARRAY:
type = Type.SQL_TIMESTAMP_WITH_TIME_ZONE;
break;
case LOCALDATE_ARRAY:
type = Type.SQL_DATE;
break;
case LOCALTIME_ARRAY:
type = Type.SQL_TIME;
break;
case ZONEDDATETIME_ARRAY:
type = Type.SQL_TIMESTAMP_WITH_TIME_ZONE;
break;
default:
throw new IllegalStateException("Unhandled array type " + propertyType.name());
}
return new JDBCArrayBasic(data, type);
}
@Override
public Object convertArray(PropertyType propertyType, java.sql.Array array) throws SQLException {
switch (propertyType) {
case BOOLEAN_ARRAY:
return SqlgUtil.convertObjectArrayToBooleanArray((Object[]) array.getArray());
case boolean_ARRAY:
return SqlgUtil.convertObjectArrayToBooleanPrimitiveArray((Object[]) array.getArray());
case SHORT_ARRAY:
return SqlgUtil.convertObjectOfIntegersArrayToShortArray((Object[]) array.getArray());
case short_ARRAY:
return SqlgUtil.convertObjectOfIntegersArrayToShortPrimitiveArray((Object[]) array.getArray());
case INTEGER_ARRAY:
return SqlgUtil.convertObjectOfIntegersArrayToIntegerArray((Object[]) array.getArray());
case int_ARRAY:
return SqlgUtil.convertObjectOfIntegersArrayToIntegerPrimitiveArray((Object[]) array.getArray());
case LONG_ARRAY:
return SqlgUtil.convertObjectOfLongsArrayToLongArray((Object[]) array.getArray());
case long_ARRAY:
return SqlgUtil.convertObjectOfLongsArrayToLongPrimitiveArray((Object[]) array.getArray());
case DOUBLE_ARRAY:
return SqlgUtil.convertObjectOfDoublesArrayToDoubleArray((Object[]) array.getArray());
case double_ARRAY:
return SqlgUtil.convertObjectOfDoublesArrayToDoublePrimitiveArray((Object[]) array.getArray());
case FLOAT_ARRAY:
return SqlgUtil.convertObjectOfFloatsArrayToFloatArray((Object[]) array.getArray());
case float_ARRAY:
return SqlgUtil.convertObjectOfFloatsArrayToFloatPrimitiveArray((Object[]) array.getArray());
case STRING_ARRAY:
return SqlgUtil.convertObjectOfStringsArrayToStringArray((Object[]) array.getArray());
case LOCALDATETIME_ARRAY:
Object[] timestamps = (Object[]) array.getArray();
return SqlgUtil.copyObjectArrayOfTimestampToLocalDateTime(timestamps, new LocalDateTime[(timestamps).length]);
case LOCALDATE_ARRAY:
Object[] dates = (Object[]) array.getArray();
return SqlgUtil.copyObjectArrayOfDateToLocalDate(dates, new LocalDate[dates.length]);
case LOCALTIME_ARRAY:
Object[] times = (Object[]) array.getArray();
return SqlgUtil.copyObjectArrayOfTimeToLocalTime(times, new LocalTime[times.length]);
default:
throw new IllegalStateException("Unhandled property type " + propertyType.name());
}
}
@Override
public void setArray(PreparedStatement statement, int index, PropertyType type,
Object[] values) throws SQLException {
statement.setArray(index, createArrayOf(statement.getConnection(), type, values));
}
}
