[GNC] future of custom reports in 3.x

Sébastien de Menten sdementen at gmail.com
Tue Apr 10 13:10:10 EDT 2018


You can also look at
http://piecash.readthedocs.io/en/latest/object_model.html
Piecash is in fact a python ORM (sqlalchemy) on top of the gnucash dql
tables.

On Tue, Apr 10, 2018, 18:14 Matthew Pounsett <matt at conundrum.com> wrote:

> On 10 April 2018 at 11:45, Amish <anon.amish at gmail.com> wrote:
>
> > May be fastest and easiest way would be to first save sample data (say
> > only 1 transaction) to say PostgreSQL database and then use pg_dump to
> dump
> > it to text file.
> >
> > That's an approach, for sure.  However...  there are 24 tables just in my
> personal accounts sqllite db, but 21 gnc-*-sql.cpp files in the SQL
> back-end code, and not all of those are created.  That's an odd mismatch
> that needs to be accounted for.  Also, in the database there are no foreign
> keys defined, which means it's going to be difficult to confirm all of the
> expected relations.  That combination of facts makes for a really difficult
> job reverse-engineering the schema by trial and error.   A pointer to the
> documentation that the developers are using when they do their work would
> make the whole thing a lot easier.
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


More information about the gnucash-user mailing list