gnc-transaction-sql.h File Reference

load and save data to SQL More...

#include "Transaction.h"
#include "qof.h"
#include "Account.h"

Go to the source code of this file.

Data Structures
class	GncSqlTransBackend
class	GncSqlSplitBackend
struct	acct_balances_t

Functions
void	gnc_sql_transaction_load_tx_for_account (GncSqlBackend *sql_be, Account *account)
	Loads all transactions which have splits for a specific account. More...

Detailed Description

load and save 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-transaction-sql.h.

Function Documentation

gnc_sql_transaction_load_tx_for_account()

void gnc_sql_transaction_load_tx_for_account	(	GncSqlBackend *	sql_be,
		Account *	account
	)

Loads all transactions which have splits for a specific account.

Parameters

sql_be	SQL backend
account	Account

Loads all transactions which have splits for a specific account.

Parameters

sql_be	SQL backend
account	Account

Definition at line 687 of file gnc-transaction-sql.cpp.

{
    const GncGUID* guid;

    g_return_if_fail (sql_be != NULL);
    g_return_if_fail (account != NULL);

    guid = qof_instance_get_guid (QOF_INSTANCE (account));

    const std::string tpkey(tx_col_table[0]->name());    //guid
    const std::string spkey(split_col_table[0]->name()); //guid
    const std::string stkey(split_col_table[1]->name()); //txn_guid
    const std::string sakey(split_col_table[2]->name()); //account_guid
    std::string sql("(SELECT DISTINCT ");
    sql += stkey + " FROM " SPLIT_TABLE " WHERE " + sakey + " = '";
    sql += gnc::GUID(*guid).to_string() + "')";
    query_transactions (sql_be, sql);
}