#ifndef SQLITEDB_H
#define SQLITEDB_H
#include <QSqlDatabase>
#include <qdebug.h>
#include <QFileDialog>
#include <QSqlError>
#include <QSqlQuery>
#include <QPluginLoader>
#include <QApplication>
#include <qlibraryinfo.h>
#include "global.h"

typedef QVector<QString>           vec_t;
typedef QVector<vec_t>            array_t;

class SqliteDB
{
public:
    SqliteDB();
    QSqlDatabase database;
    int OpenDataBase();
    int CloseDataBase();
    int CreateDataBase();
    int InsertData(QString& tablename,QString& sql);
    int UpdataData(QString& tablename, QString& columnName, QString& columnValue, QString whereColName = "", QString whereColValue = "");
    int UpdataDataCol(QString& tablename, QString& updateColumn, QString& whereCond);
    int UpdateDataSql(QString& tablename,QString& UpdataSql);
    int QueryData(QString& tablename, QString& column, QString& whereCon);
    QVector<ChannelSetting> GetDataMultiLine(QString tablename, QString column = "", QString whereCon = "");
    QVector<WorkConditionChannels_t> GetWorkConditionChannels(QString tablename);
    QVector<WorkCondition_t> GetWorkCondition(QString tablename,QString whereCon = "");
    QVector<WorkConditionInfo_t> GetWorkConditionInfo(QString tablename,QString whereCon = "");
    QVector<TriggerConfig_t> GetTriggerConfig(QString tablename,QString whereCon = "");
    QVector<TriggerEvent_t> GetTriggerEvent(QString tablename,QString whereCon = "");
    QVector<TriggerAlarmStatusInfo_t> GetTriggerAlarmStatusInfo(QString tablename,QString whereCon = "");
    QVector<UnitConfiguration_t> GetUnitConfigurationInfo(QString tablename,QString whereCon = "");
    QString GetSingelLine(QString& tablename, QString& column, QString whereCon = "");
    int DeleteData(QString& tablename, QString condColumnName = "", QVariant condColumnValue = "");
    int DeleteDataW(QString& tablename, QString whereCon = "");
    int ExeSqlData(QString& strSql);
    int initTable();

};
extern SqliteDB* g_SqliteDB;
#endif // SQLITEDB_H