beanquery

beanquery copied to clipboard

``` beanquery> SELECT account, SUM(CONVERT(position, 'USD', date)), balance WHERE account ~ "Expenses:" AND '2025-08-31-bangkok-thailand' in links GROUP BY 1 ORDER BY 1 error: Traceback (most recent call last): File "/home/tbm/.local/lib/python3.11/site-packages/beanquery/shell.py",...

tbm

dnicolodi

Better error messages when `beancount` format does not apply

5

It's late and maybe I'm doing something wrong but I get a Python syntax error with `.format beancount``: ``` beanquery> .format beancount beanquery> SELECT date, META("receipt") WHERE account ~ "^Expenses:"...

tbm

REST API server

2

Since I'm converting the Cashier Sync Server to use Beoncount data, the thought naturally comes to me. Would it make sense to have the same thing directly in bean-query? It...

alensiljak

Add support for parameters in query directives

1

Currently query directives defined in a ledger can only be run as written, but it would allow for more powerful queries if they could take parameters. As a trivial example:...

hhmitchell