|
static
ApplicationDefines::ResultValue | CreateDBTablesIfNotExist () |
| |
static
ApplicationDefines::ResultValue | AddAndFillColumnsInvAndDeviceSNRIfNeeded (const int inv, const QString &qadraSNR) |
| | AddAndFillColumnsInvAndDeviceSNRIfNeeded - method checks and adds columns that were added later some time after initial database release. More...
|
| |
static
ApplicationDefines::ResultValue | InsertQadraMessages (const QList< QadraMessageDataRequest > &qadraMessageDataList) |
| |
static
ApplicationDefines::ResultValue | GetQadraMessagesByStatus (QList< QadraMessageDataRequest > &qadraMessageDataList, const QString &status=QADRA_MESSAGE_STATUS_UNPROCESSED) |
| |
static
ApplicationDefines::ResultValue | UpdateQadraMessagesStatus (const QadraMessageDataResponse &qadraMessageData, const QString &status=QADRA_MESSAGE_STATUS_SENT) |
| |
static
ApplicationDefines::ResultValue | DeleteSentQadraMessagesByStatus (const QString &status=QADRA_MESSAGE_STATUS_SENT) |
| |
static
ApplicationDefines::ResultValue | RemoveOldestRecords (const uint32_t maxRecordCount) |
| |
| static bool | Vacuum () |
| | Vacuum - rebuilds the entire database file, reclaiming unused space and defragmenting data What Actually Happens: More...
|
| |
| static bool | BeginTransaction () |
| |
| static bool | CommitTransaction () |
| |
| static bool | RollbackTransaction () |
| |
static
ApplicationDefines::ResultValue | Insert (Model &model, QVariant &id) |
| |
static
ApplicationDefines::ResultValue | GetID (const Model &model, QVariant &id) |
| |
| static bool | PrepareQuery (QSqlQuery &query, const QString &queryContent) |
| |
| static bool | ExecQuery (QSqlQuery &query) |
| |
static
ApplicationDefines::ResultValue | PrepareAndExecQuery (QSqlQuery &query, const QString &queryContent, const bool doRollbackTransactionOnError) |
| |
static
ApplicationDefines::ResultValue | CheckIfTableContainsColumn (const QString &tableName, const QString &columnName, bool &wantedColumnExists) |
| |