The PostgresInterface class Database engine for Postgres. More...

#include <postgresinterface.h>

Inheritance diagram for PostgresInterface:

Collaboration diagram for PostgresInterface:

Public Member Functions
	PostgresInterface (QObject *parent=nullptr)
	PostgresInterface. More...

	PostgresInterface (QString DatabaseIP, QString DatabasePort, QString DatabaseName, QString DatabaseUser, QString DatabasePasswd, QObject *parent=0)
	PostgresInterface. More...

virtual bool	ClearAllData (QString dataTable)
	ClearAllData. More...

virtual QString	OpenDatabase (void)
	OpenDatabase. More...

virtual void	ScratchSql (void)
	starts a new database More...

virtual void	ScratchSubscriber (QString subscriber)
	scratch a subsciption

virtual QString	TrendThis (QString subscription)
	returns the table name for this trend, creates the trend if not there

virtual QString	getSubFromTable (QString table)
	getSubFromTable More...

virtual QString	getTableFromSub (QString sub)
	getTableFromSub More...

virtual QDataLoggerRecord	GetDataRecordsFromTrendTable (QString table, QDateTime fromLocalTime, QDateTime toLocalTime)
	GetDataRecordsFromTrendTable. More...

virtual VremMYSqlRecord	GetLastDataRecordsFromTrendTable (QString table, QDateTime fromLocalTime, QDateTime toLocalTime)
	GetLastDataRecordsFromTrendTable. More...

virtual VremMYSqlRecord	GetLastDataRecordsFromTrendTable (QString table, QDateTime toLocalTime)
	GetLastDataRecordsFromTrendTable. More...

virtual VremMYSqlRecord	GetLastDataRecordsFromTrendTable (QString table)
	GetLastDataRecordsFromTrendTable. More...

virtual bool	DeleteDataRecordsFromTrendTable (QString table, QDateTime beforeLocalTime)
	DeleteDataRecordsFromTrendTable. More...

virtual bool	AddData (QString dataTable, const VremVArray &instance1)
	AddData. More...

virtual bool	ChangeProperties (QString subscriber, VremVArray propertys)
	ChangeProperties. More...

virtual VremVArray	GetProperties (QString subscription)
	GetProperties. More...

virtual DBType	getDBType ()
	getDBType More...

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

Detailed Description

The PostgresInterface class Database engine for Postgres.

Constructor & Destructor Documentation

◆ PostgresInterface() [1/2]

PostgresInterface::PostgresInterface ( QObject * parent = nullptr )

PostgresInterface.

Parameters

parent

◆ PostgresInterface() [2/2]

PostgresInterface::PostgresInterface	(	QString	DatabaseIP,
		QString	DatabasePort,
		QString	DatabaseName,
		QString	DatabaseUser,
		QString	DatabasePasswd,
		QObject *	parent = `0`
	)

PostgresInterface.

Parameters

DatabaseIP
DatabasePort
DatabaseName
DatabaseUser
DatabasePasswd
parent

Member Function Documentation

◆ AddData()

bool PostgresInterface::AddData	(	QString	dataTable,
		const VremVArray &	instance1
	)

virtual

AddData.

Parameters

dataTable
instance1

Returns

added data to the table defined in dataTable

Implements SQLBase.

◆ ChangeProperties()

bool PostgresInterface::ChangeProperties	(	QString	subscriber,
		VremVArray	propertys
	)

virtual

ChangeProperties.

Parameters

subscriber
propertys

Returns

Changes the property of a subcription

Implements SQLBase.

◆ ClearAllData()

bool PostgresInterface::ClearAllData ( QString dataTable )

virtual

ClearAllData.

Parameters

dataTable

Returns

Implements SQLBase.

◆ DeleteDataRecordsFromTrendTable()

bool PostgresInterface::DeleteDataRecordsFromTrendTable	(	QString	table,
		QDateTime	beforeLocalTime
	)

virtual

DeleteDataRecordsFromTrendTable.

Parameters

table
beforeLocalTime

Returns

Deletes data from a table, before beforeLocalTime

Implements SQLBase.

◆ GetDataRecordsFromTrendTable()

SQLBase::QDataLoggerRecord PostgresInterface::GetDataRecordsFromTrendTable	(	QString	table,
		QDateTime	fromLocalTime,
		QDateTime	toLocalTime
	)

virtual

GetDataRecordsFromTrendTable.

Parameters

table
fromLocalTime
toLocalTime

Returns

Implements SQLBase.

◆ getDBType()

virtual DBType PostgresInterface::getDBType ( )

inlinevirtual

getDBType

Returns

Gets the database handle

Implements SQLBase.

◆ GetLastDataRecordsFromTrendTable() [1/3]

SQLBase::VremMYSqlRecord PostgresInterface::GetLastDataRecordsFromTrendTable ( QString table )

virtual

GetLastDataRecordsFromTrendTable.

Parameters

table

Returns

Implements SQLBase.

◆ GetLastDataRecordsFromTrendTable() [2/3]

SQLBase::VremMYSqlRecord PostgresInterface::GetLastDataRecordsFromTrendTable	(	QString	table,
		QDateTime	fromLocalTime,
		QDateTime	toLocalTime
	)

virtual

GetLastDataRecordsFromTrendTable.

Parameters

table
fromLocalTime
toLocalTime

Returns

Implements SQLBase.

◆ GetLastDataRecordsFromTrendTable() [3/3]

SQLBase::VremMYSqlRecord PostgresInterface::GetLastDataRecordsFromTrendTable	(	QString	table,
		QDateTime	toLocalTime
	)

virtual

GetLastDataRecordsFromTrendTable.

Parameters

table
toLocalTime

Returns

Implements SQLBase.

◆ GetProperties()

VremVArray PostgresInterface::GetProperties ( QString subscription )

virtual

GetProperties.

Parameters

subscription

Returns

returns the properties of a database subscription

Implements SQLBase.

◆ getSubFromTable()

QString PostgresInterface::getSubFromTable ( QString table )

virtual

getSubFromTable

Parameters

table

Returns

Implements SQLBase.

◆ getTableFromSub()

QString PostgresInterface::getTableFromSub ( QString sub )

virtual

getTableFromSub

Parameters

sub

Returns

Implements SQLBase.

◆ OpenDatabase()

QString PostgresInterface::OpenDatabase ( void )

virtual

OpenDatabase.

Returns

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

Implements SQLBase.

◆ ScratchSql()

void PostgresInterface::ScratchSql ( void )

virtual

starts a new database

do not eliminate any gdr tables if gdr is using the same database also mis same

Implements SQLBase.

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

/home/ed/Software/multiverse/stec-platform/libs/platformulib/postgresinterface.h
/home/ed/Software/multiverse/stec-platform/libs/platformulib/postgresinterface.cpp

Public Member Functions

Protected Member Functions

Additional Inherited Members

Detailed Description

Constructor & Destructor Documentation

◆ PostgresInterface() [1/2]

◆ PostgresInterface() [2/2]

Member Function Documentation

◆ AddData()

◆ ChangeProperties()

◆ ClearAllData()

◆ DeleteDataRecordsFromTrendTable()

◆ GetDataRecordsFromTrendTable()

◆ getDBType()

◆ GetLastDataRecordsFromTrendTable() [1/3]

◆ GetLastDataRecordsFromTrendTable() [2/3]

◆ GetLastDataRecordsFromTrendTable() [3/3]

◆ GetProperties()

◆ getSubFromTable()

◆ getTableFromSub()

◆ OpenDatabase()

◆ ScratchSql()