I am trying to execute the following filtered transaction report from the piecash project:
from __future__ import print_function
import datetime
import re
import os.path
from piecash import open_book
if __name__=='__main__':
this_folder = os.path.dirname(os.path.realpath(__file__))
s = open_book(os.path.join(this_folder, "teste.gnucash"), open_if_lock=True)
else:
s = open_book(os.path.join("teste.gnucash"), open_if_lock=True)
# get default currency
print(s.default_currency)
regex_filter = re.compile(u"^/Ativos/Dinheiro/Carteira")
# retrieve relevant transactions
transactions = [tr for tr in s.transactions # query all transactions in the book/session and filter them on
if (regex_filter.search(tr.description) # description field matching regex
or any(regex_filter.search(spl.memo) for spl in tr.splits)) # or memo field of any split of transaction
and tr.post_date.date() >= datetime.date(2016, 03, 1)] # and with post_date no later than begin nov.
try:
import jinja2
except ImportError:
print("\n\t*** Install jinja2 ('pip install jinja2') to test the jinja2 template version ***\n")
jinja2 = None
if jinja2:
env = jinja2.Environment(trim_blocks=True, lstrip_blocks=True)
print(env.from_string("""
Here are the transactions for the search criteria '{{regex.pattern}}':
{% for tr in transactions %}
- {{ tr.post_date.strftime("%Y/%m/%d") }} : {{ tr.description }}
{% for spl in tr.splits %}
{{ spl.value.__abs__() }} {% if spl.value < 0 %} --> {% else %} <-- {% endif %} {{ spl.account.fullname() }} : {{ spl.memo }}
{% endfor %}
{% endfor %}
""").render(transactions=transactions,regex=regex_filter))
However I get the following error on the last line of the code, when trying to render the jinja2 template:
AttributeError: 'unicode' object has no attribute 'call'
I found that the last answer (by @brianz) from this question shed some light into the problem. transactions
is a list of unicode strings, while regex_filter
is a compiled regex regular expression object, from which the pattern was extracted by the template in regex.pattern
.
I tried to pass the regex.pattern
directly without any success, trying to follow the jinja2 api render example.
Any ideas on what exactly am I missing?
the last line of .format()
does a lot of stuff to go wrong, specifically I noticed:
{{ spl.account.fullname() }}
which seems like the kind of name that could be an attribute or method so I asked and it seems it is in fact unicode that you tried to call. Mystery solved ;)