simple_test.py

Go to the documentation of this file.

#!/usr/bin/env python3
 
 
from gnucash import (
        Session, Account, Transaction, Split, GncNumeric, SessionOpenMode)
 
FILE_1 = "/tmp/example.gnucash"
 
with Session("xml://%s" % FILE_1, SessionOpenMode.SESSION_NEW_STORE) as session:
 
    book = session.book
    root_acct = Account(book)
    expenses_acct = Account(book)
    savings_acct = Account(book)
    opening_acct = Account(book)
    trans1 = Transaction(book)
    trans1.BeginEdit()
    trans2 = Transaction(book)
    trans2.BeginEdit()
 
    split1 = Split(book)
    split3 = Split(book)
    comm_table = book.get_table()
    cad = comm_table.lookup("CURRENCY", "CAD")
 
    num1 = GncNumeric(4, 1)
    num2 = GncNumeric(100, 1)
 
    #Set new root account
    book.set_root_account(root_acct)
 
    #Set up root account and add sub-accounts
    root_acct.SetName("Root")
    root_acct.SetType(13) #ACCT_TYPE_ROOT = 13
    root_acct.append_child(expenses_acct)
    root_acct.append_child(savings_acct)
    root_acct.append_child(opening_acct)
 
    #Set up Expenses account
    expenses_acct.SetCommodity(cad)
    expenses_acct.SetName("Expenses")
    expenses_acct.SetType(9) #ACCT_TYPE_EXPENSE = 9
 
    #Set up Savings account
    savings_acct.SetCommodity(cad)
    savings_acct.SetName("Savings")
    savings_acct.SetType(0) #ACCT_TYPE_BANK = 0
 
    #Set up Opening Balance account
    opening_acct.SetCommodity(cad)
    opening_acct.SetName("Opening Balance")
    opening_acct.SetType(10) #ACCT_TYPE_EQUITY = 10
 
    split1.SetValue(num1)
    split1.SetAccount(expenses_acct)
    split1.SetParent(trans1)
 
    split3.SetValue(num2)
    split3.SetAccount(savings_acct)
    split3.SetParent(trans2)
 
    trans1.SetCurrency(cad)
    trans1.SetDate(14, 3, 2006)
    trans1.SetDescription("Groceries")
 
    trans2.SetCurrency(cad)
    trans2.SetDate(7, 11, 1995)
    trans2.SetDescription("Opening Savings Balance")
 
    split2 = Split(book)
    split2.SetAccount(savings_acct)
    split2.SetParent(trans1)
    split2.SetValue(num1.neg())
 
    split4 = Split(book)
    split4.SetAccount(opening_acct)
    split4.SetParent(trans2)
    split4.SetValue(num2.neg())
 
 
    trans1.CommitEdit()
    trans2.CommitEdit()