#ifndef LDBTOOL_H
|
#define LDBTOOL_H
|
|
//#include <QObject>
|
#include <QSqlDatabase>
|
#include <QSqlTableModel>
|
#include <QSqlQuery>
|
#include <QSqlRecord>
|
#include <QSqlError>
|
#include "DBStruct.h"
|
#include <QJsonDocument>
|
#include <QJsonObject>
|
#include <QDateTime>
|
#include <QMutexLocker>
|
|
class LDBTool
|
{
|
public:
|
// explicit LDBTool(QObject *parent = nullptr);
|
LDBTool();
|
~LDBTool();
|
|
void connectDB();
|
|
//DeviceTable
|
bool insertDeviceTable(Record_Storage_Dev deviceRec);
|
bool deleteDeviceTable(QString strDeviceId);
|
bool deleteDeviceTableAndChnAndSdk(QString str_storage_dev_id);
|
bool updateDeviceTable(Record_Storage_Dev deviceRec);
|
std::list<Record_Storage_Dev> searchDeviceTableAll(void);
|
int searchDeviceNumber(void);
|
Record_Storage_Dev searchDeviceTableByDeviceId(QString strDeviceId);
|
int searchDurationByDeviceId(QString strDeviceId);
|
|
//ChannelTable
|
bool insertChannelTable(Record_Cam_Chn channelRec);
|
bool deleteChannelTable(QString strDeviceId, int nChannelId);
|
bool deleteChannelTableByCamID(QString strCamId);
|
bool updateChannelTable(Record_Cam_Chn channelRec);
|
std::list<Record_Cam_Chn> searchChannelTableAll(void);
|
std::list<Record_Cam_Chn> searchChannelTableByDevlId(QString strDeviceId);
|
Record_Cam_Chn searchOldestRecordfromChnTableByUpdateTime(void);
|
Record_Cam_Chn searchChannelTableByChannelId(QString strDeviceId, int nChannelId);
|
Record_Cam_Chn searchNewestRecordfromChnTableByChannelId(QString strDeviceId, int nChannelId);
|
Record_Cam_Chn searchOldestRecordfromChnTableByChannelId(QString strDeviceId, int nChannelId);
|
std::list<Record_Cam_Chn> searchChannelTableCamType(void);
|
|
//cam_dev
|
bool insertCamDevTable(Record_Cam_Dev channelRec);
|
bool deleteCamDevandSdkByCamID(QString strCamId);
|
bool updateCamDevTable(Record_Cam_Dev camRec);
|
std::list<Record_Cam_Dev> searchCamDevTableAll(void);
|
int searchCamDevNumber(void);
|
bool searchCamDevByCamId(QString strCamId);
|
|
//load_file_info
|
bool insertLoadFileTable(Record_Load_File_info loadfileRec);
|
bool deleteLoadFileTable(QString strDeviceId, int nChannelId, QDateTime tim_startTime);
|
bool deleteLoadFileTablebyDevID(QString strDeviceId);
|
bool updateLoadFileTable(Record_Load_File_info loadfileRec);
|
std::list<Record_Load_File_info> searchLoadFileTableAll(void);
|
Record_Load_File_info searchOldestRecordfromLoadTableByUpdateTime(void);
|
|
//insert rec to loadfile_info && update cam_chn
|
bool insertLoadFileTableAndUpdateChannelTable(Record_Load_File_info loadfileRec,
|
Record_Cam_Chn channelRec);
|
|
//cut_video_info
|
bool insertCutVideoTable(Record_Cut_Video_info cutVideoRec);
|
bool deleteCutVideoTable(QString strDeviceId, int nChannelId, QString strSrcPath);
|
bool deleteCutVideoTablebyDevID(QString strDeviceId);
|
bool updateCutVideoTable(Record_Cut_Video_info cutVideoRec);
|
bool updateCutVideoTable(std::string src_path, std::string dst_path, int total);
|
std::list<Record_Cut_Video_info> searchCutVideoTableAll(void);
|
Record_Cut_Video_info searchOldestRecordfromCutTableByUpdateTime(void);
|
|
//insert rec to cut_video_info && delete load_file_info
|
bool insertCutVideoTableAndDeleteLoadFileTable(Record_Cut_Video_info cutVideoRec,
|
QString strDeviceId, int nChannelId,
|
QDateTime tim_loadStartTime);
|
|
//sdk_hdl_info
|
bool insertSdkHdlTable(Record_Sdk_Hdl_info sdkHdlRec);
|
bool deleteSdkHdlTable(QString strSrcPath);
|
bool updateSdkHdlTable(Record_Sdk_Hdl_info sdkHdlRec);
|
bool updateSdkHdlTablePos(QString str_src_path,int pos);
|
std::list<Record_Sdk_Hdl_info> searchSdkHdlTableAll(void);
|
bool deleteSdkHdlTablebyDevID(QString strDevId);
|
|
//insert rec to sdk_hdl_info && delete cut_video_info
|
bool insertSdkHdlTableAndDeleteCutVideoTable(Record_Sdk_Hdl_info sdkHdlRec,\
|
QString strDeviceId, \
|
int nChannelId, \
|
QString strCutSrcPath);
|
|
//chn_sdk
|
bool insertChnSdkTable(Record_Chn_Sdk chnSdkRec);
|
bool deleteChnSdkTable(QString strDeviceId, int nChannelId);
|
bool updateChnSdkTable(Record_Chn_Sdk chnSdkRec);
|
std::list<Record_Chn_Sdk> searchChnSdkTableAll(void);
|
Record_Chn_Sdk searchChnSdkTableByChannelId(QString strDeviceId, int nChannelId);
|
// Record_Chn_Sdk searchChnSdkTableByCam(QString strCamId);
|
|
bool updateDevChnAndSdk(Record_Cam_Chn channelRec, Record_Chn_Sdk chnSdkRec);
|
// bool updateCamAndSdk(Record_Cam_Chn channelRec, Record_Chn_Sdk chnSdkRec);
|
|
bool insertCamSdkTable(Record_Cam_Sdk camSdkRec);
|
bool deleteCamSdkTable(QString strCamDevId);
|
bool updateCamSdkTable(Record_Cam_Sdk camSdkRec);
|
Record_Cam_Sdk searchCamSdkTableByCamId(QString strCamId);
|
bool updateCamAndSdkTable(Record_Cam_Dev camRec, Record_Cam_Sdk camSdkRec);
|
|
//config
|
bool updateConfigTableByServerInfo(Record_Config configRec);
|
bool updateConfigTableByCutDuration(int n_cut_max_duration,int n_cut_min_duration);
|
Record_Config searchConfigTableWithinServerInfo(void);
|
bool updateConfigTableByDevType(int devType);
|
int searchDevTypeFromConfigTable(void);
|
//Record_Config searchDevIdFromConfigTable(void);
|
bool updateDevNameConfigTable(QString dev_name);
|
//name_key_match
|
bool insertRecordVedioPath(QString pathKey,QString filePath);
|
QString searchRecordVedioPathByKey(QString pathKey);
|
|
//rule_week
|
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;
|
};
|
|
#endif // LDBTOOL_H
|
