stec-platform
Public Member Functions | Protected Member Functions | List of all members
MySqlInterface Class Reference
Inheritance diagram for MySqlInterface:
Collaboration diagram for MySqlInterface:

Public Member Functions

 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)
 starts a new database
 
virtual void ScratchSubscriber (QString subscriber)
 
virtual QString TrendThis (QString subscription)
 returns the table name for this trend, creates the trend if not there
 
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 ()
 
- Public Member Functions inherited from SQLBase
 SQLBase (QObject *parent=0)
 
 SQLBase (QString DatabaseIP, QString DatabasePort, QString DatabaseName, QString DatabaseUser, QString DatabasePasswd, QObject *parent=0)
 
bool open ()
 
QString OpenDatabase (QString DatabaseIP, QString DatabasePort, QString DatabaseName, QString DatabaseUser, QString DatabasePasswd)
 
void ScratchDataTable (QString DataTable)
 
bool isOpen (void)
 returns true if database is open
 
QSqlDatabase & getDB (void)
 
QList< SqlRow > getAllRows (void)
 
qint64 GetCurrentGMT (void)
 
qint64 GetGMTFromLocal (QDateTime time)
 
bool AddData (Subscription *sub)
 
bool AddData (Subscription *sub, QString dataTable)
 
bool AddDataBySub (QString subName, VremVArray va)
 
QSqlTableModel * getSubMap (void)
 
void AddDataBySubscriptionName (QString &name, VremVArray &data)
 
QHash< QString, QString > getAllTracking (void)
 

Protected Member Functions

virtual void ReloadTables (void)
 
- Protected Member Functions inherited from SQLBase
QSqlTableModel * newDbTable (QString tableName)
 

Additional Inherited Members

- Public Types inherited from SQLBase
enum  dbtype { postgres = 0 , mysql = 1 , sqlite = 2 }
 
typedef enum SQLBase::dbtype DBType
 
typedef QList< SqlRow > QSqlRowList
 
typedef QList< VremMYSqlRecord > QDataLoggerRecord
 
- Public Slots inherited from SQLBase
void SlotAddDataBySubscriptionName (QString name, VremVArray data)
 
- Signals inherited from SQLBase
void SignalValuesAdded (QString Table, QDateTime time)
 
- Static Public Member Functions inherited from SQLBase
static QDateTime EarliestPossibleDate (void)
 return the earliest possible date this could ever record. Product did not exist prior to 2013
 
- Protected Attributes inherited from SQLBase
PublicationRegistration * cloud
 
QString databaseIP
 
QString databasePort
 
QString databaseName
 
QString databaseUser
 
QString databasePasswd
 
QSqlDatabase db
 
QSqlTableModel * sub_model
 
QSqlTableModel * key_model
 
DRWLock< short > retry
 
QMutex classLock
 

Member Function Documentation

◆ ClearAllData()

bool MySqlInterface::ClearAllData ( QString  dataTable)
virtual

required functions for inhering this class

Implements SQLBase.

◆ OpenDatabase()

QString MySqlInterface::OpenDatabase ( void  )
virtual

Allow try to re-open database "MAX_RETRY_OPENDB" times every 10 mins

Implements SQLBase.

The documentation for this class was generated from the following files: