gnc-recurrence-sql.h File Reference

load and save accounts data to SQL More...

#include <glib.h>
#include "Recurrence.h"
#include "guid.h"
#include "gnc-sql-object-backend.hpp"

Go to the source code of this file.

Data Structures
class	GncSqlRecurrenceBackend

Functions
gboolean	gnc_sql_recurrence_save (GncSqlBackend *sql_be, const GncGUID *guid, const Recurrence *pRecurrence)
void	gnc_sql_recurrence_save_list (GncSqlBackend *sql_be, const GncGUID *guid, GList *schedule)
gboolean	gnc_sql_recurrence_delete (GncSqlBackend *sql_be, const GncGUID *guid)
Recurrence *	gnc_sql_recurrence_load (GncSqlBackend *sql_be, const GncGUID *guid)
GList *	gnc_sql_recurrence_load_list (GncSqlBackend *sql_be, const GncGUID *guid)

Detailed Description

load and save accounts data to SQL

Author

Copyright (c) 2006-2008 Phil Longstaff plong.nosp@m.staf.nosp@m.f@rog.nosp@m.ers..nosp@m.com

This file implements the top-level QofBackend API for saving/ restoring data to/from an SQL database

Definition in file gnc-recurrence-sql.h.

Function Documentation

gnc_sql_recurrence_delete()

gboolean gnc_sql_recurrence_delete	(	GncSqlBackend *	sql_be,
		const GncGUID *	guid
	)

Definition at line 277 of file gnc-recurrence-sql.cpp.

{
    recurrence_info_t recurrence_info;
 
    g_return_val_if_fail (sql_be != NULL, FALSE);
    g_return_val_if_fail (guid != NULL, FALSE);
 
    recurrence_info.be = sql_be;
    recurrence_info.guid = guid;
    return sql_be->do_db_operation(OP_DB_DELETE, TABLE_NAME,
                                   TABLE_NAME, &recurrence_info, guid_col_table);
}

gnc_sql_recurrence_load()

Recurrence * gnc_sql_recurrence_load	(	GncSqlBackend *	sql_be,
		const GncGUID *	guid
	)

Definition at line 323 of file gnc-recurrence-sql.cpp.

{
    Recurrence* r = NULL;
 
    g_return_val_if_fail (sql_be != NULL, NULL);
    g_return_val_if_fail (guid != NULL, NULL);
 
    auto result = gnc_sql_set_recurrences_from_db (sql_be, guid);
    auto row = result->begin();
    if (row == nullptr)
    {
        g_warning ("No recurrences found");
        return r;
    }
    r = g_new0 (Recurrence, 1);
    g_assert (r != NULL);
    load_recurrence (sql_be, *(result->begin()), r);
 
    if (++row != nullptr)
        g_warning ("More than 1 recurrence found: first one used");
 
    return r;
}

gnc_sql_recurrence_load_list()

GList * gnc_sql_recurrence_load_list	(	GncSqlBackend *	sql_be,
		const GncGUID *	guid
	)

Definition at line 348 of file gnc-recurrence-sql.cpp.

{
    GList* list = NULL;
 
    g_return_val_if_fail (sql_be != NULL, NULL);
    g_return_val_if_fail (guid != NULL, NULL);
 
    auto result = gnc_sql_set_recurrences_from_db (sql_be, guid);
    for (auto row : *result)
    {
        Recurrence* pRecurrence = g_new0 (Recurrence, 1);
        g_assert (pRecurrence != NULL);
        load_recurrence (sql_be, row, pRecurrence);
        list = g_list_append (list, pRecurrence);
    }
 
    return list;
}

gnc_sql_recurrence_save()

gboolean gnc_sql_recurrence_save	(	GncSqlBackend *	sql_be,
		const GncGUID *	guid,
		const Recurrence *	pRecurrence
	)

Definition at line 236 of file gnc-recurrence-sql.cpp.

{
    recurrence_info_t recurrence_info;
 
    g_return_val_if_fail (sql_be != NULL, FALSE);
    g_return_val_if_fail (guid != NULL, FALSE);
    g_return_val_if_fail (r != NULL, FALSE);
 
    (void)gnc_sql_recurrence_delete (sql_be, guid);
 
    recurrence_info.be = sql_be;
    recurrence_info.guid = guid;
    recurrence_info.pRecurrence = (Recurrence*)r;
    return sql_be->do_db_operation(OP_DB_INSERT, TABLE_NAME,
                                   TABLE_NAME, &recurrence_info, col_table);
}

gnc_sql_recurrence_save_list()

void gnc_sql_recurrence_save_list	(	GncSqlBackend *	sql_be,
		const GncGUID *	guid,
		GList *	schedule
	)

Definition at line 255 of file gnc-recurrence-sql.cpp.

{
    recurrence_info_t recurrence_info;
    GList* l;
 
    g_return_if_fail (sql_be != NULL);
    g_return_if_fail (guid != NULL);
 
    (void)gnc_sql_recurrence_delete (sql_be, guid);
 
    recurrence_info.be = sql_be;
    recurrence_info.guid = guid;
    for (l = schedule; l != NULL; l = g_list_next (l))
    {
        recurrence_info.pRecurrence = (Recurrence*)l->data;
        (void)sql_be->do_db_operation(OP_DB_INSERT, TABLE_NAME,
                                      TABLE_NAME, &recurrence_info, col_table);
    }
}