[GNC] future of custom reports in 3.x

[Matthew Pounsett]

On 8 April 2018 at 13:13, John Ralls <jralls at ceridwen.us> wrote:

>
> In the meantime there are four alternatives for custom reports:
> 2. Learn SQL and use a SQL backend to extract the data you want. The
> results are generally amenable to import into a spreadsheet for further
> processing; you could also install the appropriate ODBC module for your SQL
> engine of choice and connect to it with Libre/OpenOffice, Microsoft Access,
> or some similar tool with a custom report writer or your favorite
> programming language’s SQL interface (e.g. DBAPI for Python).


Is there some clear documentation of the SQL schema somewhere?  I had a
look through the gnc-*-sql.cpp files, but it's not the most transparent
description of a database that I've ever read. :)   I was considering
putting together a set of Python/SQLAlchemy classes that implement the
object-data mapping, and would be happy to contribute it back to the
project, if people thought that'd be useful.