| | |
| | | * @return sql |
| | | */ |
| | | std::string getInitDBSql() { |
| | | // %% ALTER TABLE sys_o_tables ADD COLUMN uploadFlag varchar(255) DEFAULT 0; |
| | | // %% ALTER TABLE sys_o_tables ADD COLUMN cmpThreshold varchar(255) DEFAULT 60; |
| | | // %% ALTER TABLE sys_o_tables ADD COLUMN enabled varchar(255) DEFAULT 1; |
| | | std::string sql = "CREATE TABLE \"main\".\"sys_o_tables\" ("; |
| | | sql.append(" uuid varchar(255) PRIMARY KEY, "); |
| | | // sql.append(" ClusterName varchar(255) DEFAULT NULL,");//本地库不需要 |
| | |
| | | std::string sql = "update '"; |
| | | sql.append(tableName + "' set "); |
| | | for (auto &item :fieldValues) { |
| | | if (item.second.size() == 0) { |
| | | continue; |
| | | } |
| | | sql.append(item.first + " = '" + item.second + "',"); |
| | | } |
| | | sql.append(" update_time ='" + AppUtil::getTimeSecString() + "'"); |