[Saute-develop] dbsetup.pl update

[Olivier.Roch-Vilato <Oli...@wa...>]

----- 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
>
>
>
>