Bdd.h

Aller à la documentation de ce fichier.

#ifndef BDD_H
#define BDD_H

#include <QtSql/QtSql>
#include <QtSql/QSqlDatabase>

#define DEBUG_BDD
#define DEBUG_BASEDEDONNEES

#define HOSTNAME       "localhost"
#define USERNAME       "estock"
#define PASSWORD       "password"
#define DATABASENAME   "e-stock"

class Bdd
{
public:    
    static Bdd* getInstance();
    static void detruireInstance();

    bool connecter();
    bool estConnecte();

    /* uniquement pour : UPDATE, INSERT et DELETE */
    bool executer(QString requete);

    /* uniquement pour : SELECT */
    bool recuperer(QString requete, QString &donnees); // 1 -> 1
    bool recuperer(QString requete, QStringList &donnees); // 1 -> 1..*
    bool recuperer(QString requete, QVector<QString> &donnees); // 1..* -> 1
    bool recuperer(QString requete, QVector<QStringList> &donnees); // 1..* -> 1..*

private:
    Bdd();
    ~Bdd();
    QSqlDatabase db; 
    static Bdd* bdd; 
    static int nbAcces; 
};

#endif // BDD_H