SqlRecord.cpp

Go to the documentation of this file.

#include <cctype>
#include <string>
#include <vector>
#include <iostream>

#include "IString.h"
#include "SqlRecord.h"
#include "SqlQuery.h"

#include <QSqlField>
#include <QVariant>

using namespace std;

namespace Isis {

  SqlRecord::SqlRecord() : QSqlRecord() { }

  SqlRecord::SqlRecord(const SqlQuery &query) : QSqlRecord(query.record()) { }

  bool SqlRecord::hasField(const QString &name) const {
    return (contains(name));
  }

  QString SqlRecord::getFieldName(int index) const {
    return (fieldName(index));
  }

  int SqlRecord::getFieldIndex(const QString &name) const {
    return(indexOf(name));
  }

  QString SqlRecord::getType(const QString &name) const {
    QVariant ftype(field(name).type());
    return (QtTypeField(ftype.typeName()));
  }

  QString SqlRecord::getType(int index) const {
    QVariant ftype(field(index).type());
    return (QtTypeField(ftype.typeName()));
  }

  bool SqlRecord::isNull(const QString &name) const {
    return (field(name).isNull());
  }

  QString SqlRecord::getValue(int index) const {
    return (QString(field(index).value().toString()));
  }

  QString SqlRecord::getValue(const QString &name) const {
    return (QString(field(name).value().toString()));
  }

  QString SqlRecord::QtTypeField(const char *ctype) const {
    QString retType("");
    if(ctype == 0) {
      return (retType);
    }
    else {
      retType = QString((tolower(ctype[0]) == 'q') ? &ctype[1] : ctype).toLower();
    }
    return(retType);
  }

}