Inheritance diagram for GncSqlJobBackend:

Public Member Functions
void	load_all (GncSqlBackend *) override
	Load all objects of m_type in the database into memory.

bool	write (GncSqlBackend *) override
	Write all objects of m_type_name to the database.

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.

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 35 of file gnc-job-sql.h.

Constructor & Destructor Documentation

◆ GncSqlJobBackend()

GncSqlJobBackend::GncSqlJobBackend ( )

Definition at line 73 of file gnc-job-sql.cpp.

                                   :
    GncSqlObjectBackend(TABLE_VERSION, GNC_ID_JOB,
                        TABLE_NAME, col_table) {}

Member Function Documentation

◆ load_all()

void GncSqlJobBackend::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 105 of file gnc-job-sql.cpp.

{
    g_return_if_fail (sql_be != NULL);
 
    std::string sql("SELECT * FROM " TABLE_NAME);
    auto stmt = sql_be->create_statement_from_sql(sql);
    auto result = sql_be->execute_select_statement(stmt);
 
    for (auto row : *result)
        load_single_job (sql_be, row);
 
    std::string pkey(col_table[0]->name());
    sql = "SELECT DISTINCT ";
    sql += pkey + " FROM " TABLE_NAME;
    gnc_sql_slots_load_for_sql_subquery (sql_be, sql,
                     (BookLookupFn)gnc_job_lookup);
}

◆ write()

bool GncSqlJobBackend::write ( GncSqlBackend * sql_be )

overridevirtual

Write all objects of m_type_name to the database.

Parameters

sql_be The GncSqlBackend containing the database.

Returns: true if the objects were successfully written, false otherwise.

Reimplemented from GncSqlObjectBackend.

Definition at line 157 of file gnc-job-sql.cpp.

{
    g_return_val_if_fail (sql_be != NULL, FALSE);
    write_objects_t data{sql_be, true, this};
 
    qof_object_foreach (GNC_ID_JOB, sql_be->book(), write_single_job, &data);
 
    return data.is_ok;
}

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