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 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 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 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";
}