SqliteRecord Class Reference

SqliteRecord is one record in the SqliteRecordset object. More...

#include <SqliteRecord.h>

Inheritance diagram for SqliteRecord:

Collaboration diagram for SqliteRecord:

Public Member Functions
	SqliteRecord (SqliteInpDef_ptr def)
	SqliteRecord ()=delete
	SqliteRecord (const SqliteRecord &)=delete
SqliteRecord &	operator= (const SqliteRecord &)=delete
	~SqliteRecord () override
	Destructor.
bool	isFieldNull (std::string_view field) const override
	Check if the field value is NULL.
int	getInt (std::string_view field) const override
	Get int field value.
long	getLong (std::string_view field) const override
	Get long field value.
double	getDouble (std::string_view field) const override
	Get double field value.
float	getFloat (std::string_view field) const override
	Get float field value.
virtual const std::string &	getString (std::string_view field) const override
	Get string field value.
int	getInt (std::string_view field, unsigned int index) const override
	Get array int field value.
long	getLong (std::string_view field, unsigned int index) const override
	Get array long field value.
double	getDouble (std::string_view field, unsigned int index) const override
	Get array double field value.
float	getFloat (std::string_view field, unsigned int index) const override
	Get array float field value.
virtual const std::string &	getString (std::string_view field, unsigned int index) const override
	Get array string field value.
void	dump () const
	Dump to cout.
void	addValue (std::string_view field, SqliteInp value)

Private Types
enum	FieldCheckCode { FIELD_CHECK_OK , FIELD_CHECK_BAD_NAME , FIELD_CHECK_BAD_TYPE , FIELD_CHECK_NULL_VAL }
typedef std::map< std::string, SqliteInp, std::less<> >	Record
typedef Record::const_iterator	RecordCIterator
typedef std::tuple< RecordCIterator, FieldCheckCode >	FieldCheckResult

Private Member Functions
FieldCheckResult	checkField (std::string_view field, SqliteInpType fieldType) const
void	handleError (std::string_view field, FieldCheckCode checkCode) const

Private Attributes
SqliteInpDef_ptr	m_def
Record	m_record

Detailed Description

SqliteRecord is one record in the SqliteRecordset object.

Definition at line 48 of file SqliteRecord.h.

Member Typedef Documentation

FieldCheckResult

typedef std::tuple<RecordCIterator,FieldCheckCode> SqliteRecord::FieldCheckResult

private

Definition at line 137 of file SqliteRecord.h.

Record

typedef std::map<std::string,SqliteInp, std::less<> > SqliteRecord::Record

private

Definition at line 128 of file SqliteRecord.h.

RecordCIterator

typedef Record::const_iterator SqliteRecord::RecordCIterator

private

Definition at line 129 of file SqliteRecord.h.

Member Enumeration Documentation

FieldCheckCode

enum SqliteRecord::FieldCheckCode

private

Enumerator
FIELD_CHECK_OK
FIELD_CHECK_BAD_NAME
FIELD_CHECK_BAD_TYPE
FIELD_CHECK_NULL_VAL

Definition at line 130 of file SqliteRecord.h.

  {
    FIELD_CHECK_OK
    , FIELD_CHECK_BAD_NAME
    , FIELD_CHECK_BAD_TYPE
    , FIELD_CHECK_NULL_VAL
  };

Constructor & Destructor Documentation

SqliteRecord() [1/3]

SqliteRecord::SqliteRecord

(

SqliteInpDef_ptr

def

)

Definition at line 21 of file SqliteRecord.cxx.

  : m_def(std::move(def))
{
}

SqliteRecord() [2/3]

SqliteRecord::SqliteRecord ( )

delete

SqliteRecord() [3/3]

SqliteRecord::SqliteRecord ( const SqliteRecord & )

delete

~SqliteRecord()

SqliteRecord::~SqliteRecord ( )

override

Destructor.

Definition at line 26 of file SqliteRecord.cxx.

{
}

Member Function Documentation

addValue()

void SqliteRecord::addValue	(	std::string_view	field,
		SqliteInp	value )

Definition at line 104 of file SqliteRecord.cxx.

{
  auto [it,result] = m_record.emplace(std::string{field}, std::move(value));
  if(!result) throw std::runtime_error(std::format("Unexpected error when adding new value for the field {}. Duplicate field name?", field)); 
}

checkField()

SqliteRecord::FieldCheckResult SqliteRecord::checkField ( std::string_view field, SqliteInpType fieldType ) const

inlineprivate

Definition at line 146 of file SqliteRecord.h.

{
  FieldCheckCode checkCode{FIELD_CHECK_OK};
  RecordCIterator checkIt{m_record.end()};
 
  auto defIt = m_def->find(field);
  if(defIt==m_def->end()) checkCode = FIELD_CHECK_BAD_NAME;
  else if(defIt->second!=fieldType) checkCode = FIELD_CHECK_BAD_TYPE;
 
  if(checkCode==FIELD_CHECK_OK) {
    checkIt = m_record.find(field);
    if(checkIt==m_record.end()) {
      checkCode = FIELD_CHECK_NULL_VAL;
    }
  }
  return std::make_tuple(checkIt,checkCode);
}

dump()

void SqliteRecord::dump

(

)

const

Dump to cout.

Definition at line 110 of file SqliteRecord.cxx.

{
  boost::io::ios_all_saver saver (std::cout);
  bool first{true};
  for(const auto& [colName,colType] : *m_def) {
    if(first) {
      first = false;
    }
    else {
      std::cout << ", ";
    }
    auto recIt = m_record.find(colName);
    bool fieldNull = (recIt==m_record.end());
    std::cout << "[" << colName << " (";
    switch(colType) {
    case SQLITEINP_INT:
      std::cout << "int) : " << (fieldNull? "NULL" : std::to_string(std::get<int>(recIt->second))) << "]";
      break;
    case SQLITEINP_LONG:
      std::cout << "long) : " << (fieldNull? "NULL" : std::to_string(std::get<long>(recIt->second))) << "]";
      break;
    case SQLITEINP_FLOAT:
      std::cout << "float) : ";
      if (fieldNull) {
          std::cout << "NULL";
      }
      else {
          std::cout << std::setprecision(10) << std::get<float>(recIt->second) << "]";
      }
      break;
    case SQLITEINP_DOUBLE:
      std::cout << "double) : ";
      if (fieldNull) {
          std::cout << "NULL";
      }
      else {
          std::cout << std::setprecision(10) << std::get<double>(recIt->second) << "]";
      }
      break;
    case SQLITEINP_STRING:
      std::cout << "string) : " << (fieldNull? "NULL" : ("\"" + std::get<std::string>(recIt->second)) + "\"") << "]";
      break;
    default:
      std::cout << "ERROR) : ]";
    }
  }
  std::cout << std::endl;
}

getDouble() [1/2]

double SqliteRecord::getDouble ( std::string_view field ) const

overridevirtual

Get double field value.

Parameters

field

[IN] field name

Returns

field value

Implements IRDBRecord.

Definition at line 53 of file SqliteRecord.cxx.

{
  auto [recIt,checkCode] = checkField(field,SQLITEINP_DOUBLE);
  if(checkCode==FIELD_CHECK_OK) {
    return std::get<double>(recIt->second);
  }
  handleError(field,checkCode);
  return 0.;
}

getDouble() [2/2]

double SqliteRecord::getDouble ( std::string_view field, unsigned int index ) const

overridevirtual

Get array double field value.

Parameters

field	[IN] field name
index	[IN] index in the array

Returns

field value

Implements IRDBRecord.

Definition at line 89 of file SqliteRecord.cxx.

{
  return getDouble(std::format("{}_{}", field, index));
}

getFloat() [1/2]

float SqliteRecord::getFloat ( std::string_view field ) const

overridevirtual

Get float field value.

Parameters

field

[IN] field name

Returns

field value

Implements IRDBRecord.

Definition at line 63 of file SqliteRecord.cxx.

{
  // SQLite stores REAL as double
  return (float)getDouble(field);
}

getFloat() [2/2]

float SqliteRecord::getFloat ( std::string_view field, unsigned int index ) const

overridevirtual

Get array float field value.

Parameters

field	[IN] field name
index	[IN] index in the array

Returns

field value

Implements IRDBRecord.

Definition at line 94 of file SqliteRecord.cxx.

{
  return getFloat(std::format("{}_{}", field, index));
}

getInt() [1/2]

int SqliteRecord::getInt ( std::string_view field ) const

overridevirtual

Get int field value.

Parameters

field

[IN] field name

Returns

field value

Implements IRDBRecord.

Definition at line 37 of file SqliteRecord.cxx.

{
  auto [recIt,checkCode] = checkField(field,SQLITEINP_INT);
  if(checkCode==FIELD_CHECK_OK) {
    return std::get<int>(recIt->second);
  }
  handleError(field,checkCode);
  return 0;
}

getInt() [2/2]

int SqliteRecord::getInt ( std::string_view field, unsigned int index ) const

overridevirtual

Get array int field value.

Parameters

field	[IN] field name
index	[IN] index in the array

Returns

field value

Implements IRDBRecord.

Definition at line 79 of file SqliteRecord.cxx.

{
  return getInt(std::format("{}_{}", field, index));
}

getLong() [1/2]

long SqliteRecord::getLong ( std::string_view field ) const

overridevirtual

Get long field value.

Parameters

field

[IN] field name

Returns

field value

Implements IRDBRecord.

Definition at line 47 of file SqliteRecord.cxx.

{
  // Our database does not support LONG data types at this moment
  return (long)getInt(field);
}

getLong() [2/2]

long SqliteRecord::getLong ( std::string_view field, unsigned int index ) const

overridevirtual

Get array long field value.

Parameters

field	[IN] field name
index	[IN] index in the array

Returns

field value

Implements IRDBRecord.

Definition at line 84 of file SqliteRecord.cxx.

{
  return getLong(std::format("{}_{}", field, index));
}

getString() [1/2]

const std::string & SqliteRecord::getString ( std::string_view field ) const

overridevirtual

Get string field value.

Parameters

field

[IN] field name

Returns

field value

Implements IRDBRecord.

Definition at line 69 of file SqliteRecord.cxx.

{
  auto [recIt,checkCode] = checkField(field,SQLITEINP_STRING);
  if(checkCode==FIELD_CHECK_OK) {
    return std::get<std::string>(recIt->second);
  }
  handleError(field,checkCode);
  throw std::runtime_error("Unexpected error in SqliteRecord::getString()");
}

getString() [2/2]

const std::string & SqliteRecord::getString ( std::string_view field, unsigned int index ) const

overridevirtual

Get array string field value.

Parameters

field	[IN] field name
index	[IN] index in the array

Returns

field value

Implements IRDBRecord.

Definition at line 99 of file SqliteRecord.cxx.

{
  return getString(std::format("{}_{}", field, index));
}

handleError()

void SqliteRecord::handleError ( std::string_view field, FieldCheckCode checkCode ) const

private

Definition at line 160 of file SqliteRecord.cxx.

{
  switch(checkCode) {
  case FIELD_CHECK_BAD_NAME:
    throw std::runtime_error( std::format("handleError: Wrong name for the field {}",field));
  case FIELD_CHECK_BAD_TYPE:
    throw std::runtime_error( std::format("handleError: Wrong data type requested for the field {}",field));
  case FIELD_CHECK_NULL_VAL:
    throw std::runtime_error( std::format("handleError: {} is NULL", field));
  default:
    break;
  }
  return;
}

isFieldNull()

bool SqliteRecord::isFieldNull ( std::string_view field ) const

overridevirtual

Check if the field value is NULL.

Parameters

field

[IN] field name @retun TRUE if the field is NULL, FALSE otherwise

Implements IRDBRecord.

Definition at line 30 of file SqliteRecord.cxx.

{
  if(m_record.find(field)!=m_record.end()) return false;
  if(m_def->find(field)==m_def->end()) throw std::runtime_error( std::format("Wrong name for the field {}",field));
  return true;
}

operator=()

SqliteRecord & SqliteRecord::operator= ( const SqliteRecord & )

delete

Member Data Documentation

m_def

SqliteInpDef_ptr SqliteRecord::m_def

private

Definition at line 139 of file SqliteRecord.h.

m_record

Record SqliteRecord::m_record

private

Definition at line 140 of file SqliteRecord.h.

---

The documentation for this class was generated from the following files:

• SqliteRecord.h
• SqliteRecord.cxx