SqlQuery.h

Go to the documentation of this file.

#ifndef SqlQuery_h
#define SqlQuery_h

#include <string>
#include <vector>
#include <iostream>
#include "IException.h"
#include "Database.h"
#include <QSqlQuery>
#include <QSqlError>

namespace Isis {

  class SqlRecord;

  class SqlQuery : public QSqlQuery {
    public:
      SqlQuery();
      SqlQuery(Database &db);
      SqlQuery(const std::string &query,
               Database db = Database(Database::Connect));
      SqlQuery(const SqlQuery &other);
      virtual ~SqlQuery()  { }

      bool isThrowing() const {
        return (_throwIfFailed);
      }

      void setThrowOnFailure() {
        _throwIfFailed = true;
      }
      void setNoThrowOnFailure() {
        _throwIfFailed = false;
      }

      bool exec(const std::string &query);
      bool exec() {
        return(QSqlQuery::exec());
      }
      std::string getQuery() const;

      int nFields() const;
      std::string fieldName(int index) const;
      int fieldIndex(const std::string &name) const;
      std::vector<std::string> fieldNameList() const;
      std::vector<std::string> fieldTypeList() const;

      int nRows() const;
      SqlRecord getRecord() const;

    private:
      bool _throwIfFailed;        

      void tossQueryError(const std::string &message, const char *f, int l) const;
  };
}
#endif