database.h

#ifndef Database_H
#define Database_H

#include <QtSql/QSql>
#include <QtSql/QSqlQuery>
#include <QtSql/QSqlError>
#include <QtSql/QSqlRecord>

#include <QStandardItemModel>
#include <QSettings>
#include <QStandardItem>
#include <QDate>
#include <QCoreApplication>
#include <QFile>

#include <exception>

#include "exceptions/dbexception.h"
#include "utils/log.h"
#include "parameters.h"
#include "database/accessdatabase.h"

using namespace Exceptions;
using namespace Utils;

namespace Databases {
class Database {
public:
    static Database* instance(bool tests=false) throw(DbException*);

    QString  lastError(const QSqlQuery& q) const;

    void testCases();

    void executeFile(QString pName);

    void openTransaction();

    void closeTransaction();

    void close();

    void open();

    ~Database();

    void setDatabase(QSqlDatabase sql);

    void updateBillingNumber();

    void cleanDatabase();

    void changeDatabase(Databases::DbType dbType);
protected:
    Database(bool tests=false)throw(DbException*);

    static Database* _instance; 
    static bool _dbInstance; 

    QSettings* _settings; 

    QSqlDatabase mDatabase; 
    QList<Database*> _instances; 

    static bool isOpen; 

    QVariant value(const QSqlQuery& q, const QString& champ) const;

    static bool _isMysql;

};

}
#endif // Database_H