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 <m...@conundrum.com> wrote: > On 10 April 2018 at 11:45, Amish <anon.am...@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@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. > _______________________________________________ gnucash-user mailing list gnucash-user@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.
