r16534 - gnucash/branches/gda-dev/src/backend/gda - 1) When loading an account, query splits and set

[Phil Longstaff]

Author: plongstaff
Date: 2007-09-15 21:28:54 -0400 (Sat, 15 Sep 2007)
New Revision: 16534
Trac: http://svn.gnucash.org/trac/changeset/16534

Modified:
   gnucash/branches/gda-dev/src/backend/gda/gnc-account-gda.c
   gnucash/branches/gda-dev/src/backend/gda/gnc-backend-gda.c
   gnucash/branches/gda-dev/src/backend/gda/gnc-backend-util-gda.c
   gnucash/branches/gda-dev/src/backend/gda/gnc-backend-util-gda.h
   gnucash/branches/gda-dev/src/backend/gda/gnc-transaction-gda.c
   gnucash/branches/gda-dev/src/backend/gda/gnc-transaction-gda.h
Log:
1) When loading an account, query splits and set
starting/cleared/reconciled balances.  Because of a Gda bug, I can't
just use SUM(quantity_num) so the backend adds all of the quantities.

2) Expand the set of allowable URLs.  The format is now:
     - gda://@xxxxxxx       where xxxxxxx is a connection configured
                            in the libgda config db
     - gda://sqlite:file    opens file as an sqlite file
     - gda://prov:dsn       where prov is a provider name built into
                            libgda and dsn is a valid connection
                            string for that provider

3) MySQL was hanging on "select * from transactions where guid in
(select tx_guid from splits where ...) so this is now split into 2
separate queries.