[GNC] future of custom reports in 3.x

Matthew Pounsett matt at conundrum.com
Tue Apr 10 12:12:31 EDT 2018


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.


More information about the gnucash-user mailing list