From 93fcc2eb2db5038ca1944acde9f4c8b751aca930 Mon Sep 17 00:00:00 2001
From: xuxiuxi <554325746@qq.com>
Date: 星期一, 04 三月 2019 16:27:14 +0800
Subject: [PATCH] add models, daos and controllers for tables.
---
QiaoJiaSystem/VideoServer/QiaoJia/DB/LDBTool.h | 33 +++++++++++++++++++++------------
1 files changed, 21 insertions(+), 12 deletions(-)
diff --git a/QiaoJiaSystem/VideoServer/QiaoJia/DB/LDBTool.h b/QiaoJiaSystem/VideoServer/QiaoJia/DB/LDBTool.h
index 2c73a77..d4c26bd 100644
--- a/QiaoJiaSystem/VideoServer/QiaoJia/DB/LDBTool.h
+++ b/QiaoJiaSystem/VideoServer/QiaoJia/DB/LDBTool.h
@@ -51,6 +51,8 @@
bool updateCamDevTable(Record_Cam_Dev camRec);
std::list<Record_Cam_Dev> searchCamDevTableAll(void);
int searchCamDevNumber(void);
+ bool searchCamDevByCamId(QString strCamId);
+ bool updateCamDevSnapshot(const QString& strIp ,const QString& imgUrl);
//load_file_info
bool insertLoadFileTable(Record_Load_File_info loadfileRec);
@@ -111,9 +113,8 @@
//config
bool updateConfigTableByServerInfo(Record_Config configRec);
- bool updateConfigTableByCutDuration(int n_cut_max_duration);
+ bool updateConfigTableByCutDuration(int n_cut_max_duration,int n_cut_min_duration);
Record_Config searchConfigTableWithinServerInfo(void);
- int searchConfigTableWithinCutDuration(void);
bool updateConfigTableByDevType(int devType);
int searchDevTypeFromConfigTable(void);
//Record_Config searchDevIdFromConfigTable(void);
@@ -121,22 +122,30 @@
//name_key_match
bool insertRecordVedioPath(QString pathKey,QString filePath);
QString searchRecordVedioPathByKey(QString pathKey);
- //perimeter_rule
- bool insertPerimeterRule(ActRule actRule);
- bool updatePerimeterRuleByCamId(ActRule actRule);
- ActRule searchPerimeterRuleByCamId(int camId);
+
//rule_week
- bool insertCameraWeekRule(LActRuleWeekRecord weekRule);
- QVector<LActRuleWeekRecord> searchCameraWeekRuleByCamId(int camId);
- //rule_act
- ActRule searchActRuleByCamId(int camId);
- //crowd_rule
- ActRule searchCrowdRuleByCamId(int camId);
+ bool updateCameraWeekRule(const LActRuleWeekRecord& weekRule);
+ std::vector<LActRuleWeekRecord> searchCameraWeekRuleByCamId(const QString& camId,const int& sdkType);
+
+ //sdk_rule
+ bool updateSdkRule(const SdkRule& sdkRule);
+ SdkRuleMap searchSdkRuleByCamId(const QString& camId);
private:
QSqlDatabase m_db;
QSqlTableModel *m_pModel;
QMutex m_mutexVisit;
+public:
+ QSqlDatabase* get_m_db() {
+ return &m_db;
+ }
+ QSqlTableModel* get_m_pModel() {
+ return m_pModel;
+ }
+ QMutex* get_m_mutexVisit() {
+ return &m_mutexVisit;
+ }
+
};
#endif // LDBTOOL_H
--
Gitblit v1.8.0