GghBxM3V

1import java.sql.Types;
2
3import org.hibernate.dialect.Dialect;
4import org.hibernate.dialect.function.StandardSQLFunction;
5import org.hibernate.dialect.function.SQLFunctionTemplate;
6import org.hibernate.dialect.function.VarArgsSQLFunction;
7import org.hibernate.Hibernate;
8import org.hibernate.type.StringType;
9
10public class SQLiteDialect extends Dialect {
11    public SQLiteDialect() {
12        registerColumnType(Types.BIT, "integer");
13        registerColumnType(Types.TINYINT, "tinyint");
14        registerColumnType(Types.SMALLINT, "smallint");
15        registerColumnType(Types.INTEGER, "integer");
16        registerColumnType(Types.BIGINT, "bigint");
17        registerColumnType(Types.FLOAT, "float");
18        registerColumnType(Types.REAL, "real");
19        registerColumnType(Types.DOUBLE, "double");
20        registerColumnType(Types.NUMERIC, "numeric");
21        registerColumnType(Types.DECIMAL, "decimal");
22        registerColumnType(Types.CHAR, "char");
23        registerColumnType(Types.VARCHAR, "varchar");
24        registerColumnType(Types.LONGVARCHAR, "longvarchar");
25        registerColumnType(Types.DATE, "date");
26        registerColumnType(Types.TIME, "time");
27        registerColumnType(Types.TIMESTAMP, "timestamp");
28        registerColumnType(Types.BINARY, "blob");
29        registerColumnType(Types.VARBINARY, "blob");
30        registerColumnType(Types.LONGVARBINARY, "blob");
31        // registerColumnType(Types.NULL, "null");
32        registerColumnType(Types.BLOB, "blob");
33        registerColumnType(Types.CLOB, "clob");
34        registerColumnType(Types.BOOLEAN, "integer");
35
36        registerFunction( "concat", new VarArgsSQLFunction(StringType.INSTANCE, "", "||", "") );
37        registerFunction( "mod", new SQLFunctionTemplate( StringType.INSTANCE, "?1 % ?2" ) );
38        registerFunction( "substr", new StandardSQLFunction("substr", StringType.INSTANCE) );
39        registerFunction( "substring", new StandardSQLFunction( "substr", StringType.INSTANCE) );
40    }
41
42    public boolean supportsIdentityColumns() {
43        return true;
44    }
45
46  /*
47  public boolean supportsInsertSelectIdentity() {
48    return true; // As specify in NHibernate dialect
49  }
50  */
51
52    public boolean hasDataTypeInIdentityColumn() {
53        return false; // As specify in NHibernate dialect
54    }
55
56  /*
57  public String appendIdentitySelectToInsert(String insertString) {
58    return new StringBuffer(insertString.length()+30). // As specify in NHibernate dialect
59      append(insertString).
60      append("; ").append(getIdentitySelectString()).
61      toString();
62  }
63  */
64
65    public String getIdentityColumnString() {
66        // return "integer primary key autoincrement";
67        return "integer";
68    }
69
70    public String getIdentitySelectString() {
71        return "select last_insert_rowid()";
72    }
73
74    public boolean supportsLimit() {
75        return true;
76    }
77
78    protected String getLimitString(String query, boolean hasOffset) {
79        return new StringBuffer(query.length()+20).
80                append(query).
81                append(hasOffset ? " limit ? offset ?" : " limit ?").
82                toString();
83    }
84
85    public boolean supportsTemporaryTables() {
86        return true;
87    }
88
89    public String getCreateTemporaryTableString() {
90        return "create temporary table if not exists";
91    }
92
93    public boolean dropTemporaryTableAfterUse() {
94        return false;
95    }
96
97    public boolean supportsCurrentTimestampSelection() {
98        return true;
99    }
100
101    public boolean isCurrentTimestampSelectStringCallable() {
102        return false;
103    }
104
105    public String getCurrentTimestampSelectString() {
106        return "select current_timestamp";
107    }
108
109    public boolean supportsUnionAll() {
110        return true;
111    }
112
113    public boolean hasAlterTable() {
114        return false; // As specify in NHibernate dialect
115    }
116
117    public boolean dropConstraints() {
118        return false;
119    }
120
121    public String getAddColumnString() {
122        return "add column";
123    }
124
125    public String getForUpdateString() {
126        return "";
127    }
128
129    public boolean supportsOuterJoinForUpdate() {
130        return false;
131    }
132
133    public String getDropForeignKeyString() {
134        throw new UnsupportedOperationException("No drop foreign key syntax supported by SQLiteDialect");
135    }
136
137    public String getAddForeignKeyConstraintString(String constraintName,
138                                                   String[] foreignKey, String referencedTable, String[] primaryKey,
139                                                   boolean referencesPrimaryKey) {
140        throw new UnsupportedOperationException("No add foreign key syntax supported by SQLiteDialect");
141    }
142
143    public String getAddPrimaryKeyConstraintString(String constraintName) {
144        throw new UnsupportedOperationException("No add primary key syntax supported by SQLiteDialect");
145    }
146
147    public boolean supportsIfExistsBeforeTableName() {
148        return true;
149    }
150
151    public boolean supportsCascadeDelete() {
152        return false;
153    }
154}