queries on mysql
John Ralls
jralls at ceridwen.us
Sat Nov 27 11:23:39 EST 2010
On Nov 27, 2010, at 4:40 AM, Donald Allen wrote:
> On Sat, Nov 27, 2010 at 5:23 AM, Fred Verschueren <fvsc at fremar.be> wrote:
>> Don,
>>
>> thanks for your advice and explanation.
>> I've done it the way you described and it took me 50 sec per year for one
>> account, so in total 25 minutes.
>
> Good.
>
>>
>> Nevertheless I think having the layout of the database can help making own
>> reports easy.
>
> Absolutely. I've already done my own report-writing outside gnucash,
> processing the xml file (with a python program; python has good xml
> parsing facilities in its library), which I reverse-engineered. Having
> the data in a database and the data-model documented will makes this
> sort of thing much easier and the code less messy.
>
You do know that there are python bindings to Gnucash's internals in 2.3? No need to reverse-engineer (well, maybe a bit -- the developer documentation isn't that great).
Regards,
John Ralls
More information about the gnucash-devel
mailing list