[Saute-develop] dbsetup.pl update
Status: Alpha
Brought to you by:
heiseltc
|
From: Olivier.Roch-Vilato <Oli...@wa...> - 2001-09-26 16:05:45
|
----- Original Message ----- From: Olivier.Roch-Vilato <Oli...@wa...> To: Conan Heiselt <hei...@ya...> Sent: Tuesday, September 25, 2001 3:03 PM Subject: Re: [Saute-develop] dbsetup.pl update > > I did have one question. In the "changes" file, it only needs the > > version number sections of the versions with changes to the database, > > right? For example, if we don't implement any changes until 0.5 we > > won't need to put in 0.2, 0.3, and 0.4 version sections. Correct? > > That's right > > > > > As a future posibility, is there a way to have the update script just > > compare what's in the schema file with the database? (i.e. without > > the changes file) This is a lot more in depth and may not be worth > > the effort since we probably won't be doing too many changes. Just a > > thought. > > It was my first idea, but then i realize that the update script has no way > to make difference > between 'remove field f1, add field f2' and 'rename field f1 to f2' or > 'remove table t1, add table t2' > and 'rename table t1 to t2' (in the first case there is data loss, not in > the second). > > Moreover we can do things in the changes file that we can't by just > analyzing the schema file > (for example convert prep time field in minutes), all we have to do is add > new functions in the update script. > > > > > A+ > > Olivier > > > > |