GncSqlBookBackend Class Reference

Inheritance diagram for GncSqlBookBackend:

Public Member Functions
void	load_all (GncSqlBackend *) override
	Load all objects of m_type in the database into memory.
Public Member Functions inherited from GncSqlObjectBackend
	GncSqlObjectBackend (int version, const std::string &type, const std::string &table, const EntryVec &vec)
virtual void	create_tables (GncSqlBackend *sql_be)
	Conditionally create or update a database table from m_col_table.
virtual bool	commit (GncSqlBackend *sql_be, QofInstance *inst)
	UPDATE/INSERT a single instance of m_type_name into the database.
virtual bool	write (GncSqlBackend *sql_be)
	Write all objects of m_type_name to the database.
const char *	type () const noexcept
	Return the m_type_name for the class.
const bool	is_version (int version) const noexcept
	Compare a version with the compiled version (m_version).
bool	instance_in_db (const GncSqlBackend *sql_be, QofInstance *inst) const noexcept
	Check the presence of an object in the backend's database.

Additional Inherited Members
Protected Attributes inherited from GncSqlObjectBackend
const std::string	m_table_name
const int	m_version
const std::string	m_type_name
const EntryVec &	m_col_table
	The front-end QofIdType.

Detailed Description

Definition at line 34 of file gnc-book-sql.h.

Constructor & Destructor Documentation

GncSqlBookBackend()

GncSqlBookBackend::GncSqlBookBackend

(

)

Definition at line 72 of file gnc-book-sql.cpp.

                                     :
    GncSqlObjectBackend(TABLE_VERSION, GNC_ID_BOOK,
                        BOOK_TABLE, col_table) {}

Member Function Documentation

load_all()

void GncSqlBookBackend::load_all ( GncSqlBackend *  sql_be )

overridevirtual

Load all objects of m_type in the database into memory.

Parameters

sql_be

The GncSqlBackend containing the database connection.

Implements GncSqlObjectBackend.

Definition at line 166 of file gnc-book-sql.cpp.

{
    g_return_if_fail (sql_be != NULL);
 
    std::stringstream sql;
    sql << "SELECT * FROM " << BOOK_TABLE;
    auto stmt = sql_be->create_statement_from_sql(sql.str());
    if (stmt != nullptr)
    {
        auto result = sql_be->execute_select_statement(stmt);
        auto row = result->begin();
 
        /* If there are no rows, try committing the book; unset
         * loading so that it will actually get saved.
         */
        if (row == result->end())
        {
            sql_be->set_loading(false);
            commit (sql_be, QOF_INSTANCE (sql_be->book()));
            sql_be->set_loading(true);
        }
        else
        {
            // Otherwise, load the 1st book.
            load_single_book (sql_be, *row);
        }
    }
}

---

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

• gnc-book-sql.h
• gnc-book-sql.cpp