GncDbiSqlResult::IteratorImpl Class Reference

Inheritance diagram for GncDbiSqlResult::IteratorImpl:

Public Member Functions
	IteratorImpl (GncDbiSqlResult *inst)
virtual GncSqlRow &	operator++ ()
virtual GncSqlRow &	operator++ (int)
virtual GncSqlResult *	operator* ()
virtual std::optional< int64_t >	get_int_at_col (const char *col) const
virtual std::optional< double >	get_float_at_col (const char *col) const
virtual std::optional< double >	get_double_at_col (const char *col) const
virtual std::optional< std::string >	get_string_at_col (const char *col) const
virtual std::optional< time64 >	get_time64_at_col (const char *col) const
virtual bool	is_col_null (const char *col) const noexcept

Detailed Description

Definition at line 51 of file gnc-dbisqlresult.hpp.

Constructor & Destructor Documentation

~IteratorImpl()

GncDbiSqlResult::IteratorImpl::~IteratorImpl ( )

virtualdefault

Reimplemented from GncSqlResult::IteratorImpl.

IteratorImpl()

GncDbiSqlResult::IteratorImpl::IteratorImpl ( GncDbiSqlResult *  inst )

inline

Definition at line 55 of file gnc-dbisqlresult.hpp.

: m_inst{inst} {}

Member Function Documentation

get_double_at_col()

std::optional< double > GncDbiSqlResult::IteratorImpl::get_double_at_col ( const char *  col ) const

virtual

Implements GncSqlResult::IteratorImpl.

Definition at line 127 of file gnc-dbisqlresult.cpp.

{
    auto type = dbi_result_get_field_type (m_inst->m_dbi_result, col);
    auto attrs = dbi_result_get_field_attribs (m_inst->m_dbi_result, col);
    if(type != DBI_TYPE_DECIMAL ||
       (attrs & DBI_DECIMAL_SIZEMASK) != DBI_DECIMAL_SIZE8)
        return std::nullopt;
    auto locale = gnc_push_locale (LC_NUMERIC, "C");
    auto retval =  dbi_result_get_double(m_inst->m_dbi_result, col);
    gnc_pop_locale (LC_NUMERIC, locale);
    return std::optional<double>{retval};
}

get_float_at_col()

std::optional< double > GncDbiSqlResult::IteratorImpl::get_float_at_col ( const char *  col ) const

virtual

Implements GncSqlResult::IteratorImpl.

Definition at line 111 of file gnc-dbisqlresult.cpp.

{
    constexpr double float_precision = 1000000.0;
    auto type = dbi_result_get_field_type (m_inst->m_dbi_result, col);
    auto attrs = dbi_result_get_field_attribs (m_inst->m_dbi_result, col);
    if(type != DBI_TYPE_DECIMAL ||
       (attrs & DBI_DECIMAL_SIZEMASK) != DBI_DECIMAL_SIZE4)
        return std::nullopt;
    auto locale = gnc_push_locale (LC_NUMERIC, "C");
    auto interim =  dbi_result_get_float(m_inst->m_dbi_result, col);
    gnc_pop_locale (LC_NUMERIC, locale);
    double retval = static_cast<double>(round(interim * float_precision)) / float_precision;
    return std::optional<double>{retval};
}

get_int_at_col()

std::optional< int64_t > GncDbiSqlResult::IteratorImpl::get_int_at_col ( const char *  col ) const

virtual

Implements GncSqlResult::IteratorImpl.

Definition at line 102 of file gnc-dbisqlresult.cpp.

{
    auto type = dbi_result_get_field_type (m_inst->m_dbi_result, col);
    if(type != DBI_TYPE_INTEGER)
        return std::nullopt;
    return std::optional<int64_t>{dbi_result_get_longlong (m_inst->m_dbi_result, col)};
}

get_string_at_col()

std::optional< std::string > GncDbiSqlResult::IteratorImpl::get_string_at_col ( const char *  col ) const

virtual

Implements GncSqlResult::IteratorImpl.

Definition at line 141 of file gnc-dbisqlresult.cpp.

{
    auto type = dbi_result_get_field_type (m_inst->m_dbi_result, col);
    dbi_result_get_field_attribs (m_inst->m_dbi_result, col);
    if(type != DBI_TYPE_STRING)
        return std::nullopt;
    auto strval = dbi_result_get_string(m_inst->m_dbi_result, col);
    return std::optional<std::string>{strval ? strval : ""};
}

get_time64_at_col()

std::optional< time64 > GncDbiSqlResult::IteratorImpl::get_time64_at_col ( const char *  col ) const

virtual

Implements GncSqlResult::IteratorImpl.

Definition at line 152 of file gnc-dbisqlresult.cpp.

{
    auto result = (dbi_result_t*) (m_inst->m_dbi_result);
    auto type = dbi_result_get_field_type (result, col);
    dbi_result_get_field_attribs (result, col);
    if (type != DBI_TYPE_DATETIME)
        return std::nullopt;
#if HAVE_LIBDBI_TO_LONGLONG
    /* A less evil hack than the one required by libdbi-0.8, but
     * still necessary to work around the same bug.
     */
    auto timeval = dbi_result_get_as_longlong(result, col);
#else
    /* A seriously evil hack to work around libdbi bug #15
     * https://sourceforge.net/p/libdbi/bugs/15/. When libdbi
     * v0.9 is widely available this can be replaced with
     * dbi_result_get_as_longlong.
     * Note: 0.9 is available in Debian Jessie and Fedora 21.
     */
    auto row = dbi_result_get_currow (result);
    auto idx = dbi_result_get_field_idx (result, col) - 1;
    time64 timeval = result->rows[row]->field_values[idx].d_datetime;
#endif //HAVE_LIBDBI_TO_LONGLONG
    if (timeval < MINTIME || timeval > MAXTIME)
        timeval = 0;
    return std::optional<time64>(timeval);
}

is_col_null()

virtual bool GncDbiSqlResult::IteratorImpl::is_col_null ( const char *  col ) const

inlinevirtualnoexcept

Implements GncSqlResult::IteratorImpl.

Definition at line 64 of file gnc-dbisqlresult.hpp.

        {
            return dbi_result_field_is_null(m_inst->m_dbi_result, col);
        }

operator*()

virtual GncSqlResult * GncDbiSqlResult::IteratorImpl::operator* ( )

inlinevirtual

Implements GncSqlResult::IteratorImpl.

Definition at line 58 of file gnc-dbisqlresult.hpp.

{ return m_inst; }

operator++() [1/2]

GncSqlRow & GncDbiSqlResult::IteratorImpl::operator++ ( )

virtual

Implements GncSqlResult::IteratorImpl.

Definition at line 88 of file gnc-dbisqlresult.cpp.

{
    int status = dbi_result_next_row (m_inst->m_dbi_result);
    if (status)
        return m_inst->m_row;
    int error = m_inst->dberror();
    if (error == DBI_ERROR_BADIDX || error == 0) //ran off the end of the results
        return m_inst->m_sentinel;
    PERR("Error %d incrementing results iterator.", error);
    qof_backend_set_error (m_inst->m_conn->qbe(), ERR_BACKEND_SERVER_ERR);
    return m_inst->m_sentinel;
}

operator++() [2/2]

virtual GncSqlRow & GncDbiSqlResult::IteratorImpl::operator++ ( int  )

inlinevirtual

Definition at line 57 of file gnc-dbisqlresult.hpp.

{ return ++(*this); };

---

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

• gnc-dbisqlresult.hpp
• gnc-dbisqlresult.cpp