SQL Databases from before 2.3.16

[Phil Longstaff]

Support for this already exists.  There's a "versions" table which has 
table-name/table-version pairs.  This is loaded automatically when the file is 
opened.  The backend code for each object type contains a "create tables" 
routine which is called to create and/or update tables for that object type.  At 
this time, if the table version is not current, it can be updated.  There is 
already some code for various object types which have handled some upgrades 
through the 2.3.X series.

 Phil
---------
I used to be a hypochondriac AND a kleptomaniac. So I took something for it.




________________________________
From: Derek Atkins <warlord at MIT.EDU>
To: John Ralls <jralls at ceridwen.us>
Cc: devel gnucash <gnucash-devel at gnucash.org>
Sent: Wed, December 8, 2010 8:23:46 AM
Subject: Re: SQL Databases from before 2.3.16

John,

John Ralls <jralls at ceridwen.us> writes:

> Everyone using a SQL backend who started with data saved from XML with a 
>Gnucash version before 2.3.16 should re-save from XML with 2.3.17 and re-enter 
>any intervening transactions.
>
> I just fixed 635967 [1], which complained that scheduled transactions didn't 
>work in 2.3.17 from a database created with 2.3.15.
>
> That's true, and r19911 fixes it. It was caused by a change in the way that KVP 
>data are saved and retrieved by the SQL backend in r19729 which fixed 627831 
>[2], a much worse data loss: All online banking and some transaction data for 
>transactions that have more than one KVP slot; perhaps other data as well.

Do you think there may have been some SQL you could have used to clean
this up?  Going forward (after 2.4.0) we will NOT be able to ask people
to save to XML and reload the Database.  *ANY* Schema changes or data
corrections we need to make will need to be done in-place within the
SQL.

C.f. MythTV for a reference on how to do this.

> Regards,
> John Ralls

-derek

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
      warlord at MIT.EDU                        PGP key available
_______________________________________________
gnucash-devel mailing list
gnucash-devel at gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel