RE: [Rainbowportal-devel] New update code and v1 final

[Daniel E. <del...@ed...>]

Any problems with CVS checkout can't seem to get latest, this has worked
fine for me in the past

 

-----Original Message-----
From: manu [mailto:ma...@du...] 
Sent: Thursday, October 09, 2003 1:08 PM
To: rai...@li...
Subject: [Rainbowportal-devel] New update code and v1 final

 

Ok, this makes v1 really close.

I need a couple of volunteers that can test the new code creating a new
installation from scratch and reporting any problem.

 

Roadmap:

-        Test new code (this week)

-        Ensure all modules have its own code in install procedure. (next
week)
all code must run without problems even if it is run an unlimited number of
times
updates and fixed should be included (Ozan is doing this. If one wants help
please contact me for coordinating efforts)

-        Create a new script for core only tables and procedures.

Timetable mainly depends on how many people will work on it.

All script will be then wrapped up and tested well before releasing.

 

Description follows.

 

1.2.8.1743 - 09/10/2003

by Manu

Setup/Update.asp script UPDATED

- New features in update code:

- Version in script is now optional. Update runs a script against db for
include the

  current version entry. You need manually insert version only if you skip
install.

- Script version is checked against code before each run. 

  This means that you can update many versions with the same script. 

  Very useful if you want update the initial script that creates the db.

  Scenario: 

  You want provide a convenient way for your users for apply updates and you
want

  provide a fresh installation script that just do all with few
instructions.

  You do two scripts.

  One, named eg: 1.1.7.0000.sql that creates db structure updated to 1734. 

  The last row must contain something like:

  INSERT INTO [rb_Versions] ([Release],[Version],[ReleaseDate])
VALUES('1734','1.2.8.1734', CONVERT(datetime, '09/11/2003', 101))

  GO

  

  One or more scripts as usual for updating existing versions.

  At runtime on clean machine present the list of ALL scripts.

  Then the 1.1.7.0000.sql runs and updates the version. At this point the
row updates tha version.

  When setup go to next script it see that this does not need any update and
skips it.

  On more recent systems (eg: 1730) all updates are run.  

  

- You can now include modules in a single installation. This is great
because

  we can easily move the code for modules on the module itself. No more need
for

  refreshing db settings as in 1.2.8.1742.

  Please note in the sample below that in version 1.2.8.1743 we can even
omit the script

  and install only modules. 

  

  New syntax:

      <Release>

            <Id>1742</Id>

            <Version>1.2.8.1742</Version>

            <Script>1.2.8.1742.sql</Script>

            <Date>2003-10-08T00:00:00.0000000+01:00</Date>

      </Release>

      <Release>

            <Id>1743</Id>

            <Version>1.2.8.1743</Version>

            <Date>2003-10-08T00:00:00.0000000+01:00</Date>

            <Modules>

 
<Installer>DesktopModules/XmlModule/installer.xml</Installer>

 
<Installer>DesktopModules/Pictures/installer.xml</Installer>

            </Modules>

      </Release>

 

  If present sql script is always run BEFORE installing modules.

  You can make however 2 entries for the same version.

  Sample:

  

      <!-- This section is run before -->

      <Release>

            <Id>1555</Id>

            <Version>1.2.8.1555</Version>

            <Date>2003-10-08T00:00:00.0000000+01:00</Date>

            <Script>1.2.8.1555_before.sql</Script>

            <Modules>

 
<Installer>DesktopModules/XmlModule/installer.xml</Installer>

 
<Installer>DesktopModules/Pictures/installer.xml</Installer>

            </Modules>

      </Release>

      <!-- This script will be run AFTER MODULE installation -->

      <Release>

            <Id>1555</Id>

            <Version>1.2.8.1555</Version>

            <Script>1.2.8.1555_after.sql</Script>

            <Date>2003-10-08T00:00:00.0000000+01:00</Date>

      </Release>

  

  Other changes:

  - Added EmptyModule template on Desktopmodules (not on project)

  Use it as base for you own modules-

  - Minor bug fix in Install Module code.  

 

 

------------------------------------
Emmanuele De Andreis
Technical Manager
DUEMETRI
Internet Solutions Provider

RAINBOW PORTAL
Main portal - http://www.rainbowportal.net <http://www.rainbowportal.net/> 
Sourceforge CVS - http://sourceforge.net/projects/rainbowportal/
<http://sourceforge.net/projects/rainbowportal/> 
Support Forums - http://www.rainbowportal.net/ASPNetForums
<http://www.rainbowportal.net/ASPNetForums> 

Bug Tracker - http://sourceforge.net/tracker/?group_id=66837
<http://sourceforge.net/tracker/?group_id=66837&atid=515929> &atid=515929