限定符和类型 | 常量字段 | 值 |
---|---|---|
public static final java.lang.String |
CACHE_CAFFEINE |
"caffeine" |
public static final java.lang.String |
CACHE_CAFFEINE_LONG |
"caffeine_long" |
public static final java.lang.String |
CACHE_DICT |
"dict" |
public static final java.lang.String |
CACHE_MEMORY |
"memory" |
public static final java.lang.String |
DEFAULT_DB_NAME |
"default" |
限定符和类型 | 常量字段 | 值 |
---|---|---|
public static final java.lang.String |
ClickHouse |
"clickhouse" |
public static final java.lang.String |
Highgo |
"highgo" |
public static final java.lang.String |
Mssql |
"sqlserver" |
public static final java.lang.String |
Mysql |
"mysql" |
public static final java.lang.String |
Oracle |
"oracle" |
public static final java.lang.String |
PG |
"postgresql" |
public static final java.lang.String |
Sqlite |
"sqlite" |
限定符和类型 | 常量字段 | 值 |
---|---|---|
protected final java.lang.String |
PrefixIndexKey |
"@" |
限定符和类型 | 常量字段 | 值 |
---|---|---|
public static final java.lang.String |
C_GMT_CREATE |
"gmt_create" |
public static final java.lang.String |
C_GMT_MODIFIED |
"gmt_modified" |
public static final java.lang.String |
C_ID |
"id" |
public static final java.lang.String |
DEFAULT_VALUE_NOW |
"@NOW" |
public static final java.lang.String |
DEFAULT_VALUE_UPDATE |
"@UPDATE" |
public static final java.lang.String |
REF_COL_SUF |
"$" |
public static final java.lang.String |
REF_SEPARATOR |
"-" |
限定符和类型 | 常量字段 | 值 |
---|---|---|
public static final java.lang.String |
COLUMN_SUFFIX |
"$" |
限定符和类型 | 常量字段 | 值 |
---|---|---|
protected final java.lang.String |
DictObj |
"dict_obj" |
protected final java.lang.String |
DictObjColumn |
"dict_obj_column" |
protected final java.lang.String |
DictObjTable |
"dict_obj_table" |
限定符和类型 | 常量字段 | 值 |
---|---|---|
public static final java.lang.String |
AND_OPERATION |
" AND " |
public static final java.lang.String |
DbValueKey |
"DbValue" |
public static final java.lang.String |
INDEX_KEY |
"INDEX" |
public static final java.lang.String |
OR_OPERATION |
" OR " |
public static final java.lang.String |
PrefixOld |
"old_" |
限定符和类型 | 常量字段 | 值 |
---|---|---|
public static final java.lang.String |
And |
"AND" |
public static final java.lang.String |
As |
"AS" |
public static final java.lang.String |
Asc |
"ASC" |
public static final java.lang.String |
Blank |
" " |
public static final java.lang.String |
Comma |
"," |
public static final java.lang.String |
ConstColumn |
"1" |
public static final java.lang.String |
Desc |
"DESC" |
public static final java.lang.String |
Dot |
"." |
public static final java.lang.String |
Exists |
"EXISTS" |
public static final java.lang.String |
From |
"FROM" |
public static final java.lang.String |
In |
"IN" |
public static final java.lang.String |
InnerJoin |
"INNER JOIN" |
public static final java.lang.String |
Insert |
"INSERT INTO" |
public static final java.lang.String |
IsNotNull |
"IS NOT NULL" |
public static final java.lang.String |
IsNull |
"IS NULL" |
public static final java.lang.String |
LeftJoin |
"LEFT OUTER JOIN" |
public static final java.lang.String |
LeftParen |
"(" |
public static final java.lang.String |
Like |
"LIKE" |
public static final java.lang.String |
Not |
"NOT" |
public static final java.lang.String |
Null |
"NULL" |
public static final java.lang.String |
On |
"ON" |
public static final java.lang.String |
Or |
"OR" |
public static final java.lang.String |
OrderBy |
"ORDER BY" |
public static final java.lang.String |
RightJoin |
"RIGHT OUTER JOIN" |
public static final java.lang.String |
RightParen |
")" |
public static final java.lang.String |
Select |
"SELECT" |
public static final java.lang.String |
Update |
"UPDATE" |
public static final java.lang.String |
Where |
"WHERE" |
限定符和类型 | 常量字段 | 值 |
---|---|---|
protected final java.lang.String |
RowEndParameterName |
"end" |
protected final java.lang.String |
RowStartParameterName |
"start" |
限定符和类型 | 常量字段 | 值 |
---|---|---|
public static final java.lang.String |
DEFAULT |
"default" |
限定符和类型 | 常量字段 | 值 |
---|---|---|
public static final java.lang.String |
DB_LEVEL_ADMIN |
"Admin" |
public static final java.lang.String |
DB_LEVEL_DEV |
"Dev" |
public static final java.lang.String |
DB_LEVEL_READ_WRITE |
"ReadWrite" |
public static final java.lang.String |
PASSWORD_PREFIX |
"!T" |
public static final java.lang.String |
SQL_APP_DB |
"SELECT id, status, gmt_create, gmt_modified, remark, tenant_id, db_access_id, app_id, app_alias, db_name FROM dust_app_config " |
public static final java.lang.String |
SQL_CREATE_Schema |
"Create DataBase if not exists %s" |
public static final java.lang.String |
SQL_DELETE_APP_DB |
"DELETE FROM dust_app_db WHERE tenant_id=:id" |
public static final java.lang.String |
SQL_DELETE_DB |
"DELETE FROM dust_db WHERE id=:id" |
public static final java.lang.String |
SQL_DELETE_TENANT |
"DELETE FROM dust_tenant WHERE id=:id" |
public static final java.lang.String |
SQL_FIND_ADMIN_DB |
"SELECT id, status, gmt_create, gmt_modified, remark,cluster, name, host, access_level, permission, user, password FROM dust_db_access WHERE access_level = \'Admin\' AND cluster=:cluster" |
public static final java.lang.String |
SQL_FIND_APP_DB |
"SELECT id, status, gmt_create, gmt_modified, remark, tenant_id, db_access_id, app_id, app_alias, db_name FROM dust_app_config WHERE tenant_id=:tenantId AND app_id=:appId" |
public static final java.lang.String |
SQL_FIND_DB |
"SELECT id, status, gmt_create, gmt_modified, remark,cluster, name, host, access_level, permission, user, password FROM dust_db_access WHERE id=:id" |
public static final java.lang.String |
SQL_GRANT_SUPER |
"GRANT ALL ON %s .* TO %s@\'%\' IDENTIFIED BY \'%s\'" |
public static final java.lang.String |
SQL_GRANT_TENANT |
"GRANT SELECT,INSERT,UPDATE,DELETE ON %s.* TO %s@\'%%\' IDENTIFIED BY \'%s\'" |
public static final java.lang.String |
SQL_INSERT_APP_DB |
"INSERT INTO dust_app_config(id, status, remark, tenant_id, db_access_id, app_id, app_alias, db_name) VALUES(:id, :status, :remark, :tenantId, :dbAccessId, :appId, :appAlias, :dbName)" |
public static final java.lang.String |
SQL_INSERT_DB |
"INSERT INTO dust_db_access(id, status, remark,cluster, name, host, access_level, permission, user, password) VALUES(:id, :status, :remark, :cluster, :name, :host, :accessLevel, :permission, :user, :password) " |
public static final java.lang.String |
SQL_UPDATE_APP_DB |
"UPDATE dust_app_config SET status=:status WHERE id=:id " |
public static final java.lang.String |
SQL_UPDATE_DB |
"UPDATE dust_db_access SET status=:status WHERE id=:id " |