postgresinterface.h

#ifndef POSTGRESINTERFACE_H
#define POSTGRESINTERFACE_H
 
#include <QObject>
#include <QDateTime>
#include <QHash>
#include <QList>
#include <QMap>
 
 
#include <QPair>
#include <QSqlDatabase>
#include <QSqlError>
#include <QSqlQuery>
#include <QSqlRecord>
#include <QSqlTableModel>
#include <QSqlTableModel>
#include <QString>
#include <QVariant>
#include <QVariantList>
#include <QtCore>
#include "platformu_global.h"
#include <publication.h>
#include <subscription.h>
#include "sqlbase.h"
 
 
class PLATFORMUSHARED_EXPORT  PostgresInterface  : public SQLBase
{
    Q_OBJECT
 
protected :
     virtual void ReloadTables(void) ;
 
public:
 
    PostgresInterface(QObject *parent = nullptr);
 
    PostgresInterface(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 postgres; }
};
 
#endif // POSTGRESINTERFACE_H