From d0451fdd55195901e65e5c4b3b64028a86f9e669 Mon Sep 17 00:00:00 2001
From: kimi42345 <kimi42345@outlook.com>
Date: 星期日, 22 三月 2020 22:10:54 +0800
Subject: [PATCH] no message
---
src/main/java/com/highdatas/mdm/util/Constant.java | 53 +++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 53 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/highdatas/mdm/util/Constant.java b/src/main/java/com/highdatas/mdm/util/Constant.java
index 6364547..0480394 100644
--- a/src/main/java/com/highdatas/mdm/util/Constant.java
+++ b/src/main/java/com/highdatas/mdm/util/Constant.java
@@ -14,7 +14,10 @@
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";
@@ -22,11 +25,13 @@
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";
@@ -40,6 +45,7 @@
String StructureMenu = "StructureMenu";
String tableName = "tableName";
String Alias = "{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";
@@ -48,4 +54,51 @@
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 ";
}
--
Gitblit v1.8.0