Configuration: libgda 3.1.2 gnucash-gda SVN16943 PostgreSQL 8.2.6 MySql 5.0.51 Sqlite 3.3.7
Today, I deleted all the gnucash databases (Well, I just started a new file for SQLite:-). I made three copies of my current gnucash XML data, and loaded them into three instances of gnucash SVN (running concurrently). In one, I select File -> Save As and saved to a file with .db extension to get a SQLite file. In another, I selected File -> Database Connection and saved to a MySql connection. In the last, I selected File -> Database Connection and saved to a PostgreSQL connection. (Then I walked away from the computer for about 5 hours, which is why I wanted them running concurrently.) Here are excerpts from connecting to the various DBs with their respective clients: sqlite> select count(*) from transactions; 3354 sqlite> select count(*) from splits; 11469 sqlite> select count(*) from accounts; 515 mysql> select count(*) from transactions; +----------+ | count(*) | +----------+ | 3662 | +----------+ 1 row in set (0.02 sec) mysql> select count(*) from splits; +----------+ | count(*) | +----------+ | 11487 | +----------+ 1 row in set (0.00 sec) mysql> select count(*) from accounts; +----------+ | count(*) | +----------+ | 522 | +----------+ 1 row in set (0.00 sec) And PostgreSQL: gnucash_db=# select count(*) from transactions; count ------- 3662 (1 row) gnucash_db=# select count(*) from splits; count ------- 11484 (1 row) gnucash_db=# select count(*) from accounts; count ------- 522 (1 row) None of the instances of gnucash-gda informed me that they were creating scheduled transactions (and if one did, they all should have, anyway). Therefore, the number of splits, transactions, and accounts MUST be identical in all cases. Anybody know of a quick and easy way to count these in my XML file so that I know what these numbers should actually be? Next, I'm going to track down which are missing. I'll be checking log files (not for SQLite of course) and comparing the DB contents to each other, but it would be ideal to be able to compare them to the "gold standard" XML source file. This appears to be separate from the SERIAL problem of libgda's PostgreSQL provider as PostgreSQL has the highest number of splits. (Most complete? Are there duplicates?) Mark _______________________________________________ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
