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 <gnucash-devel-requ...@gnucash.org> wrote: > Send gnucash-devel mailing list submissions to > gnucash-devel@gnucash.org > > 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 > gnucash-devel-requ...@gnucash.org > > You can reach the person managing the list at > gnucash-devel-ow...@gnucash.org > > 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 <jra...@ceridwen.us> > To: Thomas <tduellmann+gnucashde...@gmail.com> > Cc: gnucash-devel@gnucash.org > Subject: Re: [GNC-dev] Database abstraction > Message-ID: <b25cdeda-378c-42bf-a33b-cc8a8d160...@ceridwen.us> > Content-Type: text/plain; charset=us-ascii > > > > > On Aug 16, 2022, at 4:54 AM, Thomas <tduellmann+gnucashde...@gmail.com> > 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 > gnucash-devel@gnucash.org > 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 sc...@adligo.com 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 _______________________________________________ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
