Database.h++

Go to the documentation of this file.

#ifndef __libquark_util_Database_hxx
#define __libquark_util_Database_hxx

#include <QSqlDatabase>
#include <QSqlQuery>

#include <quark/Quark.h++>
#include <quark/QuarkTypes.h++>

namespace quark {
namespace util {

class LIBQUARK_API Database
{
  public:

  virtual ~Database();

  virtual bool open();

  virtual void close();

  inline QString file() const
  { return(_file); }

  RowID lastInsertRowID(const QSqlQuery &query);

  protected:

  Database(const QString &schemaFile, const QString &file);

  QSqlQuery *buildQuery(const QString &sql);

  QSqlQuery *buildQueryFromFile(const QString &schemaFile);

  inline bool transaction()
  { return(_db.transaction()); }

  inline bool rollback()
  { return(_db.rollback()); }

  inline bool commit()
  { return(_db.commit()); }

  virtual bool check();

  virtual bool prepareStatements();

  virtual void teardownStatements();

  virtual bool populateTables();

  virtual bool cacheData();

  int executeSQL(const QString &sql);

  int executeSQLFromFile(const QString &sqlFile);

  QString generateGUID();

  private:

  bool init();
  bool buildSchema();

  QString _schemaFile;
  QString _file;
  bool _new;
  QSqlDatabase _db;
  static QAtomicInt _connectionID;
};

} // namespace util
} // namespace quark

#endif // __libquark_util_Database_hxx