Re: python GnuCash interface to SQL backend

2014-11-18 Thread Derek Atkins
Sébastien de Menten sdemen...@gmail.com writes: On Monday, November 17, 2014, Derek Atkins warl...@mit.edu wrote: I think most of our beef against your project is that you're making it read-write.  If it was read-only then nobody here would care. Yes indeed. Me first needs are a) to

Re: python GnuCash interface to SQL backend

2014-11-17 Thread Derek Atkins
Sébastien de Menten sdemen...@gmail.com writes: On Fri, Nov 14, 2014 at 3:33 AM, Derek Atkins warl...@mit.edu wrote: John Ralls jra...@ceridwen.us writes: What’s your goal here? I don’t think that reimplementing GnuCash in Python with GnuCash’s SQL schema is a particularly

Re: python GnuCash interface to SQL backend

2014-11-17 Thread Sébastien de Menten
On Monday, November 17, 2014, Derek Atkins warl...@mit.edu wrote: I think most of our beef against your project is that you're making it read-write. If it was read-only then nobody here would care. Yes indeed. Me first needs are a) to read a GnuCash boom from python and b) to create some

Re: python GnuCash interface to SQL backend

2014-11-16 Thread Sébastien de Menten
On Saturday, November 15, 2014, Christian Stimming christ...@cstimming.de wrote: Dear Sébastien, I really try not to be rude, but a little bit it seems to me as if you don't accept no as an answer here. You asked whether the gnucash developers support an alternative SQL access layer written

Re: python GnuCash interface to SQL backend

2014-11-15 Thread Sébastien de Menten
Hello John, I have put at this address https://github.com/sdementen/piecash/blob/master/docs/source/object_model.rst what I understood from the object model of GnuCash (schema/fields/invariants). I have also added some questions regarding the objects for which you may have the answer... (or these

Re: python GnuCash interface to SQL backend

2014-11-15 Thread John Ralls
On Nov 15, 2014, at 7:08 AM, Sébastien de Menten sdemen...@gmail.com wrote: Hello John, I have put at this address https://github.com/sdementen/piecash/blob/master/docs/source/object_model.rst https://github.com/sdementen/piecash/blob/master/docs/source/object_model.rst what I

Re: python GnuCash interface to SQL backend

2014-11-15 Thread Christian Stimming
Dear Sébastien, I really try not to be rude, but a little bit it seems to me as if you don't accept no as an answer here. You asked whether the gnucash developers support an alternative SQL access layer written in python from scratch, and John's and other answers clearly said no. What else are

Re: python GnuCash interface to SQL backend

2014-11-14 Thread Sébastien de Menten
First of all, thank you John for taking the time to answer to this thread ! If you see GnuCash from the (limited) perspective of an editor for a Book document (as LibreOffice Writer is an editor for a ODT document), object persistence is central. And luckily we have both a very clean and

Re: python GnuCash interface to SQL backend

2014-11-14 Thread Sébastien de Menten
On Fri, Nov 14, 2014 at 3:33 AM, Derek Atkins warl...@mit.edu wrote: John Ralls jra...@ceridwen.us writes: What’s your goal here? I don’t think that reimplementing GnuCash in Python with GnuCash’s SQL schema is a particularly good approach: It’s not exactly the most efficient design.

Re: python GnuCash interface to SQL backend

2014-11-14 Thread Sébastien de Menten
On Fri, Nov 14, 2014 at 3:31 AM, Derek Atkins warl...@mit.edu wrote: Sébastien de Menten sdemen...@gmail.com writes: Where could I find detailed documentation on the GnuCash engine (and the constrains/invariants GnuCash enforces) ? Or would there be some code/program to check a GnuCash

Re: python GnuCash interface to SQL backend

2014-11-14 Thread John Ralls
On Nov 14, 2014, at 4:28 AM, Sébastien de Menten sdemen...@gmail.com wrote: First of all, thank you John for taking the time to answer to this thread ! If you see GnuCash from the (limited) perspective of an editor for a Book document (as LibreOffice Writer is an editor for a ODT

Re: python GnuCash interface to SQL backend

2014-11-14 Thread Sébastien de Menten
On Friday, November 14, 2014, John Ralls jra...@ceridwen.us wrote: On Nov 14, 2014, at 4:28 AM, Sébastien de Menten sdemen...@gmail.com javascript:_e(%7B%7D,'cvml','sdemen...@gmail.com'); wrote: In terms of the implementation itself of the object model, the main things I see not that clean

Re: python GnuCash interface to SQL backend

2014-11-13 Thread Sébastien de Menten
On Wednesday, November 12, 2014, John Ralls jra...@ceridwen.us wrote: On Nov 11, 2014, at 1:10 PM, Sébastien de Menten sdemen...@gmail.com javascript:; wrote: I would be genuinely interested to have more specific documentation on the risks of going the SQL way. There's nothing

Re: python GnuCash interface to SQL backend

2014-11-13 Thread Sébastien de Menten
On Thursday, November 13, 2014, John Ralls jra...@ceridwen.us wrote: On Nov 12, 2014, at 12:08 PM, Sébastien de Menten sdemen...@gmail.com javascript:_e(%7B%7D,'cvml','sdemen...@gmail.com'); wrote: On Wednesday, November 12, 2014, John Ralls jra...@ceridwen.us

Re: python GnuCash interface to SQL backend

2014-11-13 Thread John Ralls
On Nov 12, 2014, at 10:12 PM, Sébastien de Menten sdemen...@gmail.com wrote: On Thursday, November 13, 2014, John Ralls jra...@ceridwen.us mailto:jra...@ceridwen.us wrote: On Nov 12, 2014, at 12:08 PM, Sébastien de Menten sdemen...@gmail.com wrote: On Wednesday, November 12, 2014,

Re: python GnuCash interface to SQL backend

2014-11-13 Thread John Ralls
On Nov 13, 2014, at 9:31 AM, Sébastien de Menten sdemen...@gmail.com wrote: Indeed, it may be worth to explain what are the goals (and the limits). I have tried to use the official python bindings and had the following issues: - need swig + compilations to make them work = pyscash is pure

Re: python GnuCash interface to SQL backend

2014-11-13 Thread Sébastien de Menten
On 2014-11-13 19:25, John Ralls wrote: On Nov 13, 2014, at 9:31 AM, Sébastien de Menten sdemen...@gmail.com wrote: Indeed, it may be worth to explain what are the goals (and the limits). I have tried to use the official python bindings and had the following issues: - need swig + compilations

Re: python GnuCash interface to SQL backend

2014-11-13 Thread John Ralls
On Nov 13, 2014, at 12:44 PM, Sébastien de Menten sdemen...@gmail.com wrote: On 2014-11-13 19:25, John Ralls wrote: On Nov 13, 2014, at 9:31 AM, Sébastien de Menten sdemen...@gmail.com wrote: Indeed, it may be worth to explain what are the goals (and the limits). I have tried to use

Re: python GnuCash interface to SQL backend

2014-11-13 Thread Derek Atkins
Sébastien de Menten sdemen...@gmail.com writes: Where could I find detailed documentation on the GnuCash engine (and the constrains/invariants GnuCash enforces) ? Or would there be some code/program to check a GnuCash file is sane/consistent ? Only in the implementation. There is no

python GnuCash interface to SQL backend

2014-11-12 Thread Sébastien de Menten
Hello, After trying multiple times to work with GnuCash from python (via xml, via the python bindings, via sql), I finally had a try to use SQLAlchemy to handle the GnuCash Books saved through the SQL backend (sqlite3 and postgres). I have a release on PyPI the package pyscash installable

Re: python GnuCash interface to SQL backend

2014-11-12 Thread John Ralls
On Nov 11, 2014, at 1:10 PM, Sébastien de Menten sdemen...@gmail.com wrote: Hello, After trying multiple times to work with GnuCash from python (via xml, via the python bindings, via sql), I finally had a try to use SQLAlchemy to handle the GnuCash Books saved through the SQL backend

Re: python GnuCash interface to SQL backend

2014-11-12 Thread John Ralls
On Nov 12, 2014, at 12:08 PM, Sébastien de Menten sdemen...@gmail.com wrote: On Wednesday, November 12, 2014, John Ralls jra...@ceridwen.us mailto:jra...@ceridwen.us wrote: On Nov 11, 2014, at 1:10 PM, Sébastien de Menten sdemen...@gmail.com javascript:; wrote: I would be