2009/8/8 Marcus Wolschon <[email protected]>: > Hello, > > I had a closer look at the data Gnucash 2.3.3 was writing into it`s > MySQL-tables and I noticed > that the entry for the root-account on the "accounts"-table is missing. > > All the accounts directly below root have the same parent_guid but there is no > entry for that guid in the "accounts"-table. > This is a serious architectural difference to the XML -datastructures where > the > root-account can have a currency and slots. It also means that > referential integrity > is never given. (Even when Gnucash is done and no longer connected. This is... > not exactly acceptable behavior for a financial application.) > > 1) > Is this a bug in the gnucash-version I used? > 2) > How is one to find the root-account without doing such expensive queries > as "select parent_guid from accounts there parent_guid not in (select > guid from accounts)" > 3) > Where are the properties of the root-account stored when importing an > existing XML-file or exporting it again? For a financial application I would > expect it to guarantee 100% semantically identical content in that roundtrip. >
The root account guid is in the books table (column root_account_guid). This is causing me some pain as the type of the object referenced by parent_guid is not consistent. Colin L _______________________________________________ gnucash-devel mailing list [email protected] https://lists.gnucash.org/mailman/listinfo/gnucash-devel
