[GNC-dev] Data Model Schema

Hi All,

   Is the Data Model, / DB Schema stored somewhere with enriched metadata?
If not I would like to volunteer to do this work, in part because I'm
probably going to create a sibling Java project at some point to share the
schema / data model.

Cheers,
Scott

On Wed, Aug 17, 2022 at 11:00 AM <[email protected]> wrote:

> Send gnucash-devel mailing list submissions to
>         [email protected]
>
> To subscribe or unsubscribe via the World Wide Web, visit
>         https://lists.gnucash.org/mailman/listinfo/gnucash-devel
> or, via email, send a message with subject or body 'help' to
>         [email protected]
>
> You can reach the person managing the list at
>         [email protected]
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-devel digest..."
>
>
> Today's Topics:
>
>    1. Re:  Database abstraction (john)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Tue, 16 Aug 2022 09:15:46 -0700
> From: john <[email protected]>
> To: Thomas <[email protected]>
> Cc: [email protected]
> Subject: Re: [GNC-dev] Database abstraction
> Message-ID: <[email protected]>
> Content-Type: text/plain;       charset=us-ascii
>
>
>
> > On Aug 16, 2022, at 4:54 AM, Thomas <[email protected]>
> wrote:
> >
> > Hello everybody,
> >
> > for quite some time I am interested in doing some simple queries against
> the data I have in my GnuCash books that I found hard to specify in custom
> reports or the like.
> > As I have some technical background, I was thinking whether there is
> some DB abstraction that allows easier queries than the core database model
> behind GnuCash. At least for me, it would be easier to write some Python
> code or SQL queries rather than writing a custom GnuCash report tbh.
> >
> > So a representation closer to the visual representation in GnuCash where
> it is easier (without countless JOINs for example) to make queries (e.g.,
> get all transactions in a specific account that are higher than a certain
> amount).
> >
> > I'd appreciate any kinds of hints on what you would use for such
> purposes!
> >
> > Thanks a lot in advance!
>
> For that specific example you could use the Python bindings to call
> xaccAccountGetSplitList() and filter the result by amount in a list
> comprehension. The API docs at https://code.gnucash.org/docs/MAINT are a
> good place to discover more functions like that.
>
> Regards,
> John Ralls
>
>
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> gnucash-devel mailing list
> [email protected]
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>
>
> ------------------------------
>
> End of gnucash-devel Digest, Vol 233, Issue 6
> *********************************************
>


-- 
Regards,
Scott Morgan
President & CEO
Adligo Inc
http://www.adligo.com
https://www.linkedin.com/in/scott-morgan-21739415
A+ Better Business Bureau Rating
<https://www.bbb.org/chicago/business-reviews/computer-software-publishers-and-developers/adligo-inc-in-chicago-il-88381256>
https://github.com/adligo

By Appointment Only:
1-866-968-1893 Ex 101
[email protected]
skype:adligo1?call
Send Me Files Securely:
*https://www.sendthisfile.com/f.jsp?id=ewOnyeFQM18IDRf7MMIdolfI
<https://www.sendthisfile.com/f.jsp?id=ewOnyeFQM18IDRf7MMIdolfI>*
https://discord.com/
Adligo#3066