mysqlinterface.h

#ifndef MYSQLINTERFACE_H
#define MYSQLINTERFACE_H
 
#include <QDateTime>
#include <QHash>
#include <QList>
#include <QMap>
#include <QObject>
#include <QObject>
#include <QPair>
#include <QSqlDatabase>
#include <QSqlError>
#include <QSqlQuery>
#include <QSqlRecord>
#include <QSqlTableModel>
#include <QSqlTableModel>
#include <QString>
#include <QVariant>
#include <QVariantList>
#include <QtCore>
#include <platform_global.h>
#include <publication.h>
#include <subscription.h>
#include <sqlbase.h>
 
class PLATFORMUSHARED_EXPORT MySqlInterface : public SQLBase
{
    Q_OBJECT
 
protected :
     virtual void ReloadTables(void) ;
 
public:
    MySqlInterface(QObject *parent = nullptr);
    MySqlInterface(QString DatabaseIP, QString DatabasePort, QString DatabaseName, QString DatabaseUser,
      QString DatabasePasswd,  QObject *parent = 0);
 
     virtual  bool ClearAllData( QString dataTable);
 
     virtual QString OpenDatabase(void) ;
 
     virtual void ScratchSql(void);
     virtual void ScratchSubscriber(QString subscriber);
 
     virtual QString TrendThis(QString subscription);
 
     virtual QString getSubFromTable( QString table);
     virtual QString getTableFromSub( QString sub);
     virtual QDataLoggerRecord GetDataRecordsFromTrendTable(QString table, QDateTime fromLocalTime, QDateTime toLocalTime);
     virtual VremMYSqlRecord GetLastDataRecordsFromTrendTable(QString table, QDateTime fromLocalTime, QDateTime toLocalTime);
     virtual VremMYSqlRecord GetLastDataRecordsFromTrendTable(QString table, QDateTime toLocalTime);
     virtual VremMYSqlRecord GetLastDataRecordsFromTrendTable(QString table);
     virtual bool DeleteDataRecordsFromTrendTable(QString table, QDateTime beforeLocalTime);
     virtual bool AddData( QString dataTable, const VremVArray &instance1);
 
     virtual bool ChangeProperties(QString subscriber, VremVArray propertys);
     virtual VremVArray GetProperties( QString subscription);
 
        virtual DBType  getDBType()  { return mysql; }
 
signals:
 
};
 
#endif // MYSQLINTERFACE_H