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. More...

bool	isFieldNull (const std::string &field) const override
	Check if the field value is NULL. More...

int	getInt (const std::string &field) const override
	Get int field value. More...

long	getLong (const std::string &field) const override
	Get long field value. More...

double	getDouble (const std::string &field) const override
	Get double field value. More...

float	getFloat (const std::string &field) const override
	Get float field value. More...

virtual const std::string &	getString (const std::string &field) const override
	Get string field value. More...

int	getInt (const std::string &field, unsigned int index) const override
	Get array int field value. More...

long	getLong (const std::string &field, unsigned int index) const override
	Get array long field value. More...

double	getDouble (const std::string &field, unsigned int index) const override
	Get array double field value. More...

float	getFloat (const std::string &field, unsigned int index) const override
	Get array float field value. More...

virtual const std::string &	getString (const std::string &field, unsigned int index) const override
	Get array string field value. More...

void	dump () const
	Dump to cout. More...

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