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 (const std::string &field) const override
	Check if the field value is NULL.
int	getInt (const std::string &field) const override
	Get int field value.
long	getLong (const std::string &field) const override
	Get long field value.
double	getDouble (const std::string &field) const override
	Get double field value.
float	getFloat (const std::string &field) const override
	Get float field value.
virtual const std::string &	getString (const std::string &field) const override
	Get string field value.
int	getInt (const std::string &field, unsigned int index) const override
	Get array int field value.
long	getLong (const std::string &field, unsigned int index) const override
	Get array long field value.
double	getDouble (const std::string &field, unsigned int index) const override
	Get array double field value.
float	getFloat (const std::string &field, unsigned int index) const override
	Get array float field value.
virtual const std::string &	getString (const std::string &field, unsigned int index) const override
	Get array string field value.
void	dump () const
	Dump to cout.
void	addValue (const std::string &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 >	Record
typedef Record::const_iterator	RecordCIterator
typedef std::tuple< RecordCIterator, FieldCheckCode >	FieldCheckResult

Private Member Functions
FieldCheckResult	checkField (const std::string &field, SqliteInpType fieldType) const
void	handleError (const std::string &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 138 of file SqliteRecord.h.

◆ Record

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

private

Definition at line 129 of file SqliteRecord.h.

◆ RecordCIterator

typedef Record::const_iterator SqliteRecord::RecordCIterator

private

Definition at line 130 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 131 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 20 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 25 of file SqliteRecord.cxx.

26{

27}

Member Function Documentation

◆ addValue()

void SqliteRecord::addValue	(	const std::string &	field,
		SqliteInp	value )

Definition at line 103 of file SqliteRecord.cxx.

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

◆ checkField()

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

inlineprivate

Definition at line 149 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 111 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 ( const std::string & field ) const

overridevirtual

Get double field value.

Parameters

field [IN] field name

Returns: field value

Implements IRDBRecord.

Definition at line 52 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	(	const std::string &	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 88 of file SqliteRecord.cxx.

{
  return getDouble(field + "_" + std::to_string(index));
}

◆ getFloat() [1/2]

float SqliteRecord::getFloat ( const std::string & field ) const

overridevirtual

Get float field value.

Parameters

field [IN] field name

Returns: field value

Implements IRDBRecord.

Definition at line 62 of file SqliteRecord.cxx.

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

◆ getFloat() [2/2]

float SqliteRecord::getFloat	(	const std::string &	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 93 of file SqliteRecord.cxx.

{
  return getFloat(field + "_" + std::to_string(index));
}

◆ getInt() [1/2]

int SqliteRecord::getInt ( const std::string & field ) const

overridevirtual

Get int field value.

Parameters

field [IN] field name

Returns: field value

Implements IRDBRecord.

Definition at line 36 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	(	const std::string &	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 78 of file SqliteRecord.cxx.

{
  return getInt(field + "_" + std::to_string(index));
}

◆ getLong() [1/2]

long SqliteRecord::getLong ( const std::string & field ) const

overridevirtual

Get long field value.

Parameters

field [IN] field name

Returns: field value

Implements IRDBRecord.

Definition at line 46 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	(	const std::string &	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 83 of file SqliteRecord.cxx.

{
  return getLong(field + "_" + std::to_string(index));
}

◆ getString() [1/2]

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

overridevirtual

Get string field value.

Parameters

field [IN] field name

Returns: field value

Implements IRDBRecord.

Definition at line 68 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	(	const std::string &	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 98 of file SqliteRecord.cxx.

{
  return getString(field + "_" + std::to_string(index));
}

◆ handleError()

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

inlineprivate

Definition at line 168 of file SqliteRecord.h.

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

◆ isFieldNull()

bool SqliteRecord::isFieldNull ( const std::string & 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 29 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( "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 140 of file SqliteRecord.h.

◆ m_record

Record SqliteRecord::m_record

private

Definition at line 141 of file SqliteRecord.h.

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

Public Member Functions

Private Types

Private Member Functions

Private Attributes

Detailed Description

Member Typedef Documentation

◆ FieldCheckResult

◆ Record

◆ RecordCIterator

Member Enumeration Documentation

◆ FieldCheckCode

Constructor & Destructor Documentation

◆ SqliteRecord() [1/3]

◆ SqliteRecord() [2/3]

◆ SqliteRecord() [3/3]

◆ ~SqliteRecord()

Member Function Documentation

◆ addValue()

◆ checkField()

◆ dump()

◆ getDouble() [1/2]

◆ getDouble() [2/2]

◆ getFloat() [1/2]

◆ getFloat() [2/2]

◆ getInt() [1/2]

◆ getInt() [2/2]

◆ getLong() [1/2]

◆ getLong() [2/2]

◆ getString() [1/2]

◆ getString() [2/2]

◆ handleError()

◆ isFieldNull()

◆ operator=()

Member Data Documentation

◆ m_def

◆ m_record