The SQL Schema is laid out in https://wiki.gnucash.org/wiki/SQL. There's an attached ERD, but note that it shows secondary keys and auxiliary tables that indicate how GnuCash treats the data once it's loaded. The actual schema defines only a few secondary keys and the data represented in the auxiliary tables is actually stored in the slots table. Also keep in mind that we're still using the both backends as an object store.
What enriched metadata are you looking for? How will having it benefit GnuCash? It seems rather presumptuous of you to unilaterally declare your intended derivative project a sibling. Regards, John Ralls IOn Aug 17, 2022, at 9:06 AM, Scott Morgan <sc...@adligo.com> wrote: > > 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 _______________________________________________ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
