SqlRecord.cpp

 
/* SPDX-License-Identifier: CC0-1.0 */
 
#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);
  }
 
}