- after updates to the books files, beancount must be restarted to reflect updates

 - updates also invalidate the cache meaning restart takes several minutes

 - paper checks are entered in the books when written, but may not be cashed until months later (reconcile errors)

 - balance checks are manually updated in svn/Financial/Ledger/sanity-check-balances.yaml

 - jumping to an individual transaction in a large ledger isn't trivial - Emacs grep mode is the current best option

 - Pam and other staff don't use Emacs

 - auditors would prefer Bradley didn't perform reconciliation, ideally not Rosanne either

 - transactions are entered manually and reconciled after the fact, but importing from statements may be useful in some cases

Q. How are reconciliation reports created currently? How do you read them?

 - by hand from copying and pasting from the helper tool output

TODO/ISSUES:

 - AMEX statement doesn't provide bank balance or running total

"""

import argparse

import csv

import datetime

import decimal

import os

from typing import Dict, List, Tuple

from beancount import loader

begin_date = statement_trans[0]['date']

end_date = statement_trans[-1]['date']

# Do we traverse and filter the in-memory entries list and filter that, or do we

# use Beancount Query Language (BQL) to get a list of transactions? Currently

# using BQL.

#

# beancount.query.query_compile.compile() and

# beancount.query.query_execute.filter_entries() look useful in this respect,

# but I'm not clear on how to use compile(). An example would help.

entries, _, options = loader.load_file(args.beancount_file)

    AND date <= {end_date.isoformat()} AND META('bank-statement') != NULL"""

result_types, result_rows = run_query(

    entries,

    options,

    numberify=True,

)

cleared_total = result_rows[0][0]

# String concatenation looks bad, but there's no SQL injection possible here

# because BQL can't write back to the Beancount files. I hope!

query = f"SELECT filename, META('lineno') AS posting_line, META('bank-statement') AS posting_statement, date, number(cost(position)), payee, narration where account = '{args.account}' and date >= {begin_date} and date <= {end_date}"

result_types, result_rows = run_query(

    entries,

    options,

    query,

)

books_trans = sort_records([standardize_beancount_record(row) for row in result_rows])