Another problem with scheme query and SQL backend (Phil Longstaff)

Erwin Rieger erwin.rieger at ibrieger.de
Tue Jun 23 07:39:27 EDT 2009


Am Samstag, den 20.06.2009, 12:00 -0400 schrieb
gnucash-devel-request at gnucash.org:


> Message: 1
> Date: Fri, 19 Jun 2009 12:52:37 -0400
> From: Phil Longstaff <plongstaff at rogers.com>
> Subject: Re: Another problem with scheme query and SQL backend
> To: gnucash-devel at gnucash.org
> Message-ID: <200906191252.37634.plongstaff at rogers.com>
> Content-Type: text/plain;  charset="iso-8859-1"
> 
> On May 31, 2009 12:41:13 pm Phil Longstaff wrote:
> > On May 31, 2009 06:53:23 am Erwin Rieger wrote:
> > > Hi,
> > >
> > > i have another funny problem with querying data from scheme with the
> > > (my)sql backend.
> > >
> > > The query from my previous posts do only return transactions that
> > > are/were shown in the gui (ledger)!
> > >
> > > Steps to reproduce:
> > >       * install config.user from my previous post in ~/.gnucash
> > >       * open a nonempty sql-book with gnucash (with --extra command line
> > >         option), all accounts closed, only account-tree visible
> > >       * run scheme query from the "Extensions - AQueryTest1" menu
> > >       * watch output on console: "got 0 transactions..."
> > >       * open a account with transactions in it
> > >       * run scheme query from the "Extensions - AQueryTest1" menu a
> > >         second time
> > >       * watch output on console, now it reports a number of returned
> > >         transactions
> > >       * close ledger view of account
> > >       * re-run query, console still reports a number of returned
> > >         transactions
> >
> > Yes, there definitely isn't support for general queries, yet.  I *do* have
> > something in there which is commented out, so maybe I need to get it
> > working. I wasn't aware of the extensions menu, so didn't have a way of
> > creating a general query.  All I had was the ones built into gnucash.  The
> > main one is a split query for a single account, used to populate a
> > register, and at this point, the assumption is that that is the only query
> > used.  This explains why your BQueryTest fails (isn't split query for a
> > single account) and why this test here fails (it might load a single
> > account, but not all accounts). However, any accounts which have a ledger
> > open would have had those splits/transactions already loaded.
> 
> Fixed (basically) in r18136 - still not support for complete queries, but 
> these queries work.
> 
> Phil
> 
I took a first look at the new revision - and it seems to be good. Now i
am able to continue the work on my gnucash extensions.

Thank you very much!

-- 
Mit freundlichen Gruessen Erwin Rieger

--------------------------------------------------------------------
| Ingenieurbuero Rieger, Software Entwicklung
| EMail: erwin.rieger at ibrieger.de
--------------------------------------------------------------------




More information about the gnucash-devel mailing list