package com.highdatas.mdm.util;
|
|
public interface Constant {
|
public static final String dbName = "dbName";
|
public static final String USER = "user";
|
public static final String ID = "id";
|
public static final String HID = "h.id";
|
public static final String STD_ID = "std_id";
|
public static final String COMMA = " , ";
|
public static final String COMMA_TRIM = ",";
|
public static final String WHERE_DEFAULT = " 1 = 1 ";
|
public static final String WHERE_DEFAULTUN = " 1 <> 1 ";
|
public static final String SEGMENT_COMMON = "value = {0}";
|
public static final String SEGMENT_STRING = "value = '{0}'";
|
public static final String EQUAL = " = ";
|
public static final String LIKE = " like ";
|
public static final String EMPTY = " ";
|
public static final String EMPTY_Str = "";
|
public static final String SEMICOLON = ";";
|
public static final String colon = ":";
|
public static final String UnderLine = "_";
|
public static final String WHERE_SEGMENT = "whereSegment";
|
public static final String VERSION = "version";
|
public static final String VERSION_Default = "V1.0";
|
public static final String UPDATE_SEGMENT = "updateSegment";
|
public static final String TOTAL = "total";
|
public static final String FIELDS = "fields";
|
public static final String DEAL = "deal";
|
public static final String PARENT_ID = "parent_id";
|
|
public static final String RECORD = "_record";
|
public static final String MAX = "max";
|
|
String Dot = "\\.";
|
String Default_Patter = "(?<=@\\{)(.+?)(?=\\})";
|
String addDataType = "addDataType";
|
String addAll = "addAll";
|
|
String UnMatched = "未生效";
|
String Current = "当前版本";
|
String History = "历史版本";
|
String afterDate = "afterData";
|
String currentData = "currentData";
|
String beforeData = "beforeData";
|
|
String StructureMenu = "StructureMenu";
|
String tableName = "tableName";
|
String Alias = "{0}.{1}";
|
String extent = "{0}~{1}";
|
String FieldAsAlias = "{0} AS {1}";
|
String caseWhen = " case when a2.{0} != null then a2.{0} else a1.{0} end as {0}";
|
String H = "h";
|
String A1 = "a1";
|
String A2 = "a2";
|
String All = "all";
|
String All_UPCASE = "All";
|
String DataMenu = "DataMenu";
|
String AND = " and ";
|
String MD = "md_";
|
|
|
String CNT = "cnt";
|
String checkFieldSqlTemplate = "select count(1) as cnt from (select {0} from {1}) a1";
|
String selectRecordFieldSqlTemplate = "select {0}, 0 as deal from {1}";
|
String selectFieldSqlTemplate = "select {0} from ({1}) a where {2}";
|
String selectFieldTableTemplate = "select {0} from {1} where {2}";
|
String selectFieldSqlMysqlTemplate = "select * from {0} limit 1";
|
String STEP_READ_FROM_TABLE = "Read data from table";
|
String STEP_INSERT_UPDATE = "Insert or update";
|
String STEP_DUMMY = "Dummy";
|
String MYSQL_UUID = "replace(UUID(),'-', '')";
|
String TYPE = "type";
|
String Active = "active";
|
String AssembleTempTable = "hj_table_";
|
String AssembleTempSql = "hj_sql_";
|
String CreateFieldMysql = "`{0}` VARCHAR(255) NULL";
|
String CreateTableMysql = "CREATE TABLE IF NOT EXISTS `{0}` ({1}) ENGINE=InnoDB DEFAULT CHARSET=utf8;";
|
String checkTableByNameBySchema = "select table_name from information_schema.tables where table_schema={0} and table_name = {1};";
|
String Temp = "temp_";
|
String Temp2RecordMySQLTemplate = "INSERT INTO {0} ({1}) SELECT {2}, replace(uuid(),''-'', '''') as std_id, replace(uuid(),''-'', '''') as id, 0 as deal from {3}";
|
String MYSQLJoinUpdateSql = "INSERT INTO {0} ({1}) SELECT {2} , replace(uuid(),''-'', '''') as id, s1.id as std_id, 0 as deal FROM {3} t1 inner join {4} s1 on {5};";
|
String MYSQLJoinAddSql = "INSERT INTO {0} ({1}) SELECT {2} , replace(uuid(),''-'', '''') as std_id, replace(uuid(),''-'', '''') as id, 0 as deal FROM {3} t1 WHERE NOT EXISTS(SELECT * FROM {4} s1 WHERE {5});";
|
String Temp2RecordHbaseTemplate = "INSERT INTO {0} ({1}) SELECT ({2}, ) from {3}";
|
String ParamsShell = "@\\{{0}\\}";
|
String Cron = "cron";
|
String TABLE_NAME = "TABLE_NAME";
|
String Success = "success";
|
String Data = "data";
|
String Mysql_UUID = "replace(uuid(),''-'', '''')";
|
String MainData = "MainData";
|
String MYSQLJoinParse = " t1.{0} = s1.{0} ";
|
String T1 = "t1";
|
String S1 = "s1";
|
String Code = "code";
|
String truncateTableMysql = "truncate table {0};";
|
String DropTableMysql = "DROP TABLE IF EXISTS {0};";
|
String DeleteDealMysqlTemplate = "delete from {0} where deal = 0";
|
String QUESTION = "?";
|
|
String MysqlAddField = "alter table {0} add {1} {2} null;"; //alter table table1 add transactor varchar(10) not Null;
|
String ResultList = "resultList";
|
String fieldName = "fieldName";
|
String sucPercent = "sucPercent";
|
String varchar = "varchar";
|
String varcharSize = " (255) ";
|
String Text = " text ";
|
String Default = "default";
|
String USERID = "user_id";
|
String FIELD = "field";
|
String DISTINCT = "distinct {0}";
|
String InSql = "{0} in ( {1} )";
|
String z_AllVal = "z_AllVal";
|
|
|
int queueSize = 20;
|
int cntCoefficient = 50;
|
}
|
