#ifndef DATABASETHREAD_H
#define DATABASETHREAD_H

#include <QThread>
#include <QDateTime>
#include <QSqlDatabase>
#include <QSqlQuery>
#include <QSqlError>
#include <QVariant>
#include <QStringList>
#include <QList>
#include <QJsonDocument>
#include <QJsonObject>
#include <QJsonArray>
#include <QJsonValue>
#include <QVariant>
#include <QJsonParseError>


class AlarmRep {
public:
    AlarmRep(QString deviceId="",QString sql="",QString atype="", QString t=""){
        DeviceId = deviceId;
        Sql = sql;
        AlarmType = atype;
        AlarmTime=t;
    }

    QString DeviceId;
    QString Sql;
    QString AlarmType;
    QString AlarmTime;
};

class DatabaseThread : public QThread
{
    Q_OBJECT
public:
    explicit DatabaseThread(QObject *parent = nullptr);
    void appendSql(QString sql);
    void appendAlarm(AlarmRep rep);
    void run();
    void check_devicelist();
signals:
    void AlarmReport(QString addr, quint64 insertid, QString type, QString time, QString companycode, QString phonelist);
public slots:
    
private:
    int hour;
    QSqlDatabase db;
    QStringList sqlList;
    QList<AlarmRep> alarmRepList;
};

#endif // DATABASETHREAD_H