DatabaseService.h

Go to the documentation of this file.

#ifndef DATABASESERVICE_H
#define DATABASESERVICE_H

// QT INCLUDES
#include <QScopedPointer>
#include <QSqlDatabase>
#include <QVariant>

// BASE INCLUDES
#include "core/ApplicationDefines.h"

class Model;

class DatabaseService
{
public:
    DatabaseService();
    virtual ~DatabaseService();

    ApplicationDefines::DatabaseServiceType GetDatabaseServiceType();

    static bool Vacuum();
    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 );

private:
    class DataClass;
    QScopedPointer<DataClass> d;
};

#endif // DATABASESERVICE_H