From 8bfd4cc90f25f1800eb5e61d50d4fa74854e0f2a Mon Sep 17 00:00:00 2001
From: pansen <pansen626@sina.com>
Date: 星期一, 28 一月 2019 16:41:30 +0800
Subject: [PATCH] 布控上传修改
---
QiaoJiaSystem/LocalDBTool/SqliteToolkit.hpp | 12 +++++++-----
1 files changed, 7 insertions(+), 5 deletions(-)
diff --git a/QiaoJiaSystem/LocalDBTool/SqliteToolkit.hpp b/QiaoJiaSystem/LocalDBTool/SqliteToolkit.hpp
index 2461bfd..6e2ed40 100644
--- a/QiaoJiaSystem/LocalDBTool/SqliteToolkit.hpp
+++ b/QiaoJiaSystem/LocalDBTool/SqliteToolkit.hpp
@@ -65,6 +65,7 @@
std::string uuid;
std::string faceurl;
FaceFeature faceFeature;
+ std::string enable;
};
typedef std::map<std::string, FaceFeatureWithUrl> FeatureDBWithUrlCache;
@@ -86,7 +87,7 @@
//
std::string getFacesFromTableSql(std::string tableName) {
std::string sql =
- "select uuid,feature,create_time,faceUrl,del_flag from '" + tableName +
+ "select uuid,feature,create_time,faceUrl,del_flag,enabled from '" + tableName +
"_fea' where feature is not null ";
return sql;
}
@@ -100,7 +101,7 @@
}
std::string getTableInfosSql(std::string tableName) {
- std::string sql = "select * from '" + tableName+"';";// + " where del_flag = 0";
+ std::string sql = "select * from '" + tableName + "';";// + " where del_flag = 0";
return sql;
}
@@ -108,8 +109,8 @@
std::string getTableInfosSql() {
//uuid,tableName,tableDesc,tableType,bwType,startTime,endTime
std::string sql =
- "select uuid,tableName,tableType,bwType,startTime,endTime,uploadFlag,cmpThreshold,enabled from '" +
- g_tableName + "' where del_flag = 0";
+ "select uuid,tableName,tableType,bwType,startTime,endTime,uploadFlag,cmpThreshold,enabled,create_by from " +
+ g_tableName + " where del_flag = 0";
return sql;
}
@@ -241,7 +242,8 @@
sql.append("create_time BLOB DEFAULT (datetime('now', 'localtime')),");
sql.append("update_time DATETIME DEFAULT NULL,");
sql.append("create_by varchar(255) DEFAULT NULL,");
- sql.append("del_flag INTEGER DEFAULT 0");
+ sql.append("del_flag INTEGER DEFAULT 0,");
+ sql.append(" enabled varchar(255) DEFAULT 1");
sql.append(");");
// 浜鸿劯鐗瑰緛琛�
sql.append("CREATE TABLE " + g_dbName + ".'");
--
Gitblit v1.8.0