bean-query and balance assertion

93 views
Skip to first unread message

maucs...@gmail.com

unread,
Mar 20, 2017, 1:16:17 PM3/20/17
to Beancount
Is it possible to query balance assertions from bean-query?

Martin Blais

unread,
Mar 25, 2017, 6:35:15 PM3/25/17
to Beancount
Not in this version of the shell, but in the next version I'll write each of the virtual "tables" will be by type of directive, so that'll work.


On Mon, Mar 20, 2017 at 1:16 PM, <maucs...@gmail.com> wrote:
Is it possible to query balance assertions from bean-query?

--
You received this message because you are subscribed to the Google Groups "Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beancount+unsubscribe@googlegroups.com.
To post to this group, send email to bean...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/aee56f44-bbb4-412a-a9b7-8e6d147a2e58%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

maucs...@gmail.com

unread,
Mar 28, 2017, 9:21:57 AM3/28/17
to Beancount
Understood. Thanks for the response


On Sunday, March 26, 2017 at 6:35:15 AM UTC+8, Martin Blais wrote:
Not in this version of the shell, but in the next version I'll write each of the virtual "tables" will be by type of directive, so that'll work.

On Mon, Mar 20, 2017 at 1:16 PM, <maucs...@gmail.com> wrote:
Is it possible to query balance assertions from bean-query?

--
You received this message because you are subscribed to the Google Groups "Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beancount+...@googlegroups.com.

Martin Blais

unread,
Mar 29, 2017, 8:52:28 AM3/29/17
to Beancount
Also, there's a bean-sql script which can write the processed contents of a ledger into a SQL database.
It also writes a table of balance directives (and all other directives).
That would be a two-step solution, not great, but just wanted to point out it's there.

Or you could also write a Python script. Depends what you're trying to do / how important you need the check.





To unsubscribe from this group and stop receiving emails from it, send an email to beancount+unsubscribe@googlegroups.com.

To post to this group, send email to bean...@googlegroups.com.

Oon-Ee Ng

unread,
May 19, 2018, 7:19:44 PM5/19/18
to Beancount
I'm looking into this as well, has this landed (can't see it mentioned in the docs at https://docs.google.com/document/d/1s0GOZMcrKKCLlP29MD7kHO4L88evrwWdIO0p4EwRBE0/edit )? Otherwise I'll look into python scripting for this.


On Sunday, March 26, 2017 at 6:35:15 AM UTC+8, Martin Blais wrote:
Not in this version of the shell, but in the next version I'll write each of the virtual "tables" will be by type of directive, so that'll work.

On Mon, Mar 20, 2017 at 1:16 PM, <maucs...@gmail.com> wrote:
Is it possible to query balance assertions from bean-query?

--
You received this message because you are subscribed to the Google Groups "Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beancount+...@googlegroups.com.

Martin Blais

unread,
May 19, 2018, 10:09:54 PM5/19/18
to Beancount
I don't think I documented this.

To unsubscribe from this group and stop receiving emails from it, send an email to beancount+unsubscribe@googlegroups.com.

To post to this group, send email to bean...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages