Difference between revisions of "NewRelease"

From RackTables Wiki
Jump to navigation Jump to search
(→‎rolling out: SQL helper file)
m (→‎updating demo: use "git add -p")
 
(39 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 
== pre-release checklist ==
 
== pre-release checklist ==
First make sure, that all necessary changes are already committed into the repository:
+
=== part 1 ===
 +
Make sure all necessary changes have been committed into the repository:
 
<ul>
 
<ul>
  
<li>Make sure you have the right branch checked out and that no pending changes are in the working copy:
+
<li>Make sure you have the right branch checked out and no pending changes are in the working copy:
 
<pre>
 
<pre>
 
git status
 
git status
 
</pre>
 
</pre>
<li>If the new release has any release notes, make sure these appear both in <tt>wwwroot/inc/upgrade.php</tt> and in <tt>README</tt>.</li>
+
<li>If the new release should have any release notes, make sure these appear both in <tt>wwwroot/inc/upgrade.php</tt> and in <tt>README</tt>.</li>
  
<li>Update <tt>ChangeLog</tt> file to have the current date on the new version line.</li>
+
<li>Update <tt>ChangeLog</tt> file to have the current date on the to-be version line.</li>
  
<li>Make sure, that <tt>upgrade.php</tt> has new version listed in <tt>$versionhistory</tt> and <tt>executeUpgradeBatch()</tt>. It is normal to accumulate updates in <tt>executeUpgradeBatch()</tt> long before the release, this way on the release day you will have nothing to do in <tt>upgrade.php</tt>. But if you had no changes to DB since the last release, you are likely to see there changes missing. Just make sure the new version is in both places anyway.</li>
+
<li>Make sure <tt>upgrade.php</tt> has the to-be version listed in <tt>$versionhistory</tt> and <tt>getUpgradeBatch()</tt>. It is normal to accumulate updates in <tt>getUpgradeBatch()</tt> long before the release, this way on the release day you will have nothing to do in <tt>upgrade.php</tt>. But if you had no changes to DB since the last release, you are likely to see there changes missing. Just make sure the new version is in both places anyway.</li>
  
<li>Bump up CODE_VERSION in <tt>wwwroot/inc/config.php</tt>. DON'T do this unless you really intend to make a release right now.</li>
+
<li>Bump up <tt>CODE_VERSION</tt> in <tt>wwwroot/inc/config.php</tt>. DON'T do this unless you really intend to make a release right now.</li>
  
 
<li>Produce a commit with all changes pending thus far:
 
<li>Produce a commit with all changes pending thus far:
 
<pre>
 
<pre>
git status
+
git add ChangeLog wwwroot/inc/config.php
git add ChangeLog
 
[...]
 
git add wwwroot/inc/config.php
 
 
git commit
 
git commit
 
</pre>
 
</pre>
Line 28: Line 26:
 
<pre>
 
<pre>
 
git clone git@github.com:RackTables/racktables.git
 
git clone git@github.com:RackTables/racktables.git
# cd racktables
+
cd racktables
# git checkout maintenance-0.19.x
+
git checkout master # or maintenance
 
</pre></li>
 
</pre></li>
  
<li>The application must be able to install itself with own installer. Once this is found working, dump the database:
+
<li>The application must be able to install itself using its own installer (only some of the involved code is in the CI script). Once this is found working, dump the database:
 
<pre>
 
<pre>
 
mysqldump --extended-insert=FALSE --order-by-primary racktables_db > ~/tmp/dump-fresh.sql
 
mysqldump --extended-insert=FALSE --order-by-primary racktables_db > ~/tmp/dump-fresh.sql
 
</pre></li>
 
</pre></li>
  
<li>Demo data must be loadable without any errors:
+
<li>Demo data must be loadable without any errors (this is likely to be OK since this check is now in the CI script):
 
<pre>
 
<pre>
 
mysql racktables_db < scripts/init-sample-racks.sql
 
mysql racktables_db < scripts/init-sample-racks.sql
Line 45: Line 43:
 
<pre>
 
<pre>
 
# reload using the previous release
 
# reload using the previous release
/path/to/racktables-contribs/demoreload.sh X.Y.z racktables_db
+
/path/to/racktables-contribs/demo.racktables.org/demoreload.sh X.Y.z racktables_db no
 
# (make through upgrade.php)
 
# (make through upgrade.php)
 
mysqldump --extended-insert=FALSE --order-by-primary racktables_db > ~/tmp/dump-upgraded.sql
 
mysqldump --extended-insert=FALSE --order-by-primary racktables_db > ~/tmp/dump-upgraded.sql
Line 51: Line 49:
 
</pre></li>
 
</pre></li>
  
<li>Test the source as much as you find possible.</li>
+
=== part 2 (unit testing) ===
 +
'''''The commands below need some proofreading because the test data files in the source code tree still use the <tt>racktables</tt> MySQL username, which I had for this reason used for the 0.20.12 release. Whatever is the agreed username, it probably should be consistent with what is in the SQL dumps. -- Denis'''''
 +
 
 +
<li>Setup a fresh database and grant access to the 'racktables_user' user.  This will be used to create a sample data file that unit tests can utilize.</li>
 +
<pre>
 +
DROP DATABASE IF EXISTS racktables_unittest;
 +
CREATE DATABASE racktables_unittest CHARACTER SET utf8 COLLATE utf8_general_ci;
 +
GRANT ALL PRIVILEGES ON racktables_unittest.* TO racktables_user@localhost IDENTIFIED BY 'MY_SECRET_PASSWORD';
 +
</pre>
 +
 
 +
<li>Use the web interface to complete the installation. When prompted to set the admin password, enter 'admin'.</li>
 +
 
 +
<li>Load the sample data.</li>
 +
<pre>mysql -u racktables_user -p racktables_unittest < scripts/init-sample-racks.sql</pre>
 +
 
 +
<li>Export the database to the tests/data dir.</li>
 +
<pre>mysqldump --skip-comments -u racktables_user -p racktables_unittest > tests/data/$CODE_VERSION.sql</pre>
 +
 
 +
<li>Run the unit tests. Fix any failures.</li>
 +
<pre>
 +
cd tests
 +
./express.sh
 +
phpunit --group large
 +
</pre>
 +
 
 +
<li>If all is OK, commit the new SQL dump in the <tt>tests/data</tt> directory.</li>
 +
 
 +
=== part 3 (finalization) ===
 +
<li>Test the source by hand as much as you find possible.</li>
  
 
<li>Look into the error log of the server you used for the tests. There shouldn't be any error/warning messages.</li>
 
<li>Look into the error log of the server you used for the tests. There shouldn't be any error/warning messages.</li>
  
<li>Test and repeat until everything is fixed consistently.</li>
+
<li>Do not proceed further until everything is fixed consistently.</li>
 
</ul>
 
</ul>
  
Line 65: Line 91:
  
 
== rolling out ==
 
== rolling out ==
 +
=== producing and publishing deliverables ===
 
* Make two archives:
 
* Make two archives:
 
<pre>
 
<pre>
export TAG='RackTables-X.Y.z'
+
TAG='RackTables-X.Y.z'
 
git archive --prefix=$TAG/ -o $TAG.tar.gz $TAG
 
git archive --prefix=$TAG/ -o $TAG.tar.gz $TAG
 
git archive --prefix=$TAG/ -o $TAG.zip $TAG
 
git archive --prefix=$TAG/ -o $TAG.zip $TAG
 
</pre>
 
</pre>
* Upload the tarball and zipfile to SF FRS ([https://sourceforge.net/projects/racktables/files/ from browser] or by [https://sourceforge.net/apps/trac/sourceforge/wiki/Release%20files%20for%20download other means]).
+
* Upload the tarball and zipfile to SF FRS ([https://sourceforge.net/projects/racktables/files/ from browser] or by [https://sourceforge.net/p/forge/documentation/Release%20Files%20for%20Download/ other means] if you prefer). Give the uploaded files a couple minutes to make it through the system to the user-visible download area.
* Open [https://sourceforge.net/projects/racktables/files files section] and set the newly uploaded tar.gz as "current".
+
* Open [https://sourceforge.net/projects/racktables/files files section] and set the newly uploaded release files as "current".
** Open properties form (round "i" sign) of the previous release tar.gz.
+
** Open properties form (round "(i)" sign) of the previous release tar.gz.
 
** Unset all "default download for" checkboxes.
 
** Unset all "default download for" checkboxes.
** Unset "download button" text.
 
 
** Save.
 
** Save.
** Open properties form (round "i" sign) of the previous release zip.
+
** Open properties form (round "(i)" sign) of the previous release zip.
 
** Unset Windows "default download for" checkbox.
 
** Unset Windows "default download for" checkbox.
** Unset "download button" text.
 
 
** Save.
 
** Save.
 
** In the latest tarball properties form, set all "default download for" checkboxes except Windows.
 
** In the latest tarball properties form, set all "default download for" checkboxes except Windows.
** Set "download button" text to "latest stable".
 
 
** Save.
 
** Save.
 
** In the latest zipfile properties form, set Windows "default download for" checkbox.
 
** In the latest zipfile properties form, set Windows "default download for" checkbox.
 
** Save.
 
** Save.
 
** Hover the big green "download" button and watch the mouse hint featuring the right version number (sometimes it takes several minutes to see the update).
 
** Hover the big green "download" button and watch the mouse hint featuring the right version number (sometimes it takes several minutes to see the update).
* In MantisBT mark version as released (Manage, Manage Projects, [http://bugs.racktables.org/manage_proj_edit_page.php?project_id=1 RackTables], Versions).
+
** '''Tip:''' to update the banner text below the file list of the SF's "Files" section open a terminal connection to SF shell and edit the file <tt>/home/frs/project/racktables/README.md</tt> (once done, let the SF 5-10 minutes to start using the updated revision).
* Log into SF shell service:
+
 
<pre>
+
=== updating Mantis ===
$ cat ~/.ssh/config
+
* In MantisBT mark the released version as released (Manage, Manage Projects, [https://bugs.racktables.org/manage_proj_edit_page.php?project_id=1 RackTables], Versions). Add the next version with the release date several months into the future.
Host shell.sourceforge.net
+
 
User YOUR_SF_USERNAME,racktables
+
=== updating the main web-site ===
$ ssh -t shell.sourceforge.net create
+
* In racktables-htdocs repository modify and commit <tt>header.php</tt>.
# upon logging in update $lastrelease
+
* On the web-server run <tt>git pull</tt>.
$ vim /home/project-web/racktables/htdocs/header.php
+
* Open https://racktables.org and test the "download" link to work.
# test the "download" link at racktables.org to work
+
 
</pre>
+
=== updating other news feeds ===
* Post a Freecode (ex-Freshmeat) release announce
+
* Send a letter to the racktables-users list (even more so after Freshmeat/Freecode is gone).
** open http://freecode.com/projects/racktables
+
* Update IRC channel topic
** make sure you are logged in (check top bar)
+
 
** use "submit a release" button to the right
+
=== updating demo ===
** fill in version number
 
** update version number in "tar.gz" and "zip" URL fields
 
** compose 1-2 paragraphs worth of text describing the focus of this release
 
** proofread and submit (usually it takes several hours to pass the moderation)
 
* Send a letter to the racktables-users list, if necessary.
 
 
* Produce a helper SQL file for the current release in [https://github.com/RackTables/racktables-contribs racktables-contribs].
 
* Produce a helper SQL file for the current release in [https://github.com/RackTables/racktables-contribs racktables-contribs].
 
** Copy the previous <tt>init-full-X.Y.z.sql</tt> to current <tt>init-full-X.Y.z.sql</tt> and <tt>git add</tt> the new file.
 
** Copy the previous <tt>init-full-X.Y.z.sql</tt> to current <tt>init-full-X.Y.z.sql</tt> and <tt>git add</tt> the new file.
 
** Take a clean RackTables instance of the current release (either use demoreload on the previous release or install manually).
 
** Take a clean RackTables instance of the current release (either use demoreload on the previous release or install manually).
 
** Make an SQL dump of this new installation like this: <tt>mysqldump --extended-insert=FALSE --order-by-primary racktables_db > init-full-X.Y.z.sql</tt>
 
** Make an SQL dump of this new installation like this: <tt>mysqldump --extended-insert=FALSE --order-by-primary racktables_db > init-full-X.Y.z.sql</tt>
** <tt>git add -i</tt> the new file again (note interactive add). Use patch mode to add relevant chunks. Quit.
+
** Edit permissions like [https://github.com/RackTables/racktables-contribs/commit/0354001ce16e937cfc5ae555fe73dc3c351a6556 this].
 +
** <tt>git add -p</tt> the new file again (note the flag). Add relevant chunks only. Quit.
 
** <tt>git commit; git push</tt>
 
** <tt>git commit; git push</tt>
* Update demo.racktables.org to the current release (<tt>$demorelease</tt> will need an update). Below is a sample CLI session of updating the demo to 0.19.14:
+
* Update demo.racktables.org to the current release (<tt>$demorelease</tt> will need an update). Below is a sample CLI session of updating the demo to 0.20.3:
 
<pre>
 
<pre>
 +
cd ~/racktables
 +
git fetch
 +
git checkout RackTables-0.20.3
 
cd
 
cd
tar xzf RackTables-0.19.14.tar.gz
+
ln -s racktables RackTables-0.20.3
cp local.php secret.php RackTables-0.19.13/wwwroot/inc/
+
# the symlink to ~/secret.php is already in wwwroot/inc/
 
cd ~/racktables-contribs/
 
cd ~/racktables-contribs/
 
git pull
 
git pull
 
cd
 
cd
~/racktables-contribs/demoreload.sh 0.19.14 rackdemo
+
~/racktables-contribs/demo.racktables.org/demoreload.sh 0.20.3 rackdemo yes
 
crontab -e
 
crontab -e
rm www/index.php
+
# ../../racktables/wwwroot/index.php is already linked as www/demo/index.php
ln -s ../RackTables-0.19.14/wwwroot/index.php www/index.php
 
 
</pre>
 
</pre>
* Update IRC channel topic
 

Latest revision as of 14:06, 16 February 2022

pre-release checklist

part 1

Make sure all necessary changes have been committed into the repository:

  • Make sure you have the right branch checked out and no pending changes are in the working copy:
    git status
    
  • If the new release should have any release notes, make sure these appear both in wwwroot/inc/upgrade.php and in README.
  • Update ChangeLog file to have the current date on the to-be version line.
  • Make sure upgrade.php has the to-be version listed in $versionhistory and getUpgradeBatch(). It is normal to accumulate updates in getUpgradeBatch() long before the release, this way on the release day you will have nothing to do in upgrade.php. But if you had no changes to DB since the last release, you are likely to see there changes missing. Just make sure the new version is in both places anyway.
  • Bump up CODE_VERSION in wwwroot/inc/config.php. DON'T do this unless you really intend to make a release right now.
  • Produce a commit with all changes pending thus far:
    git add ChangeLog wwwroot/inc/config.php
    git commit
    
  • Check the source code out from the same branch to a clean location to test it.
    git clone git@github.com:RackTables/racktables.git
    cd racktables
    git checkout master # or maintenance
    
  • The application must be able to install itself using its own installer (only some of the involved code is in the CI script). Once this is found working, dump the database:
    mysqldump --extended-insert=FALSE --order-by-primary racktables_db > ~/tmp/dump-fresh.sql
    
  • Demo data must be loadable without any errors (this is likely to be OK since this check is now in the CI script):
    mysql racktables_db < scripts/init-sample-racks.sql
    
  • The release being tested must detect and upgrade a database from the previous release(s) correctly. Load the database with one of the previous releases data, then upgrade it with the current upgrader, then dump the DB. Now compare to the previous dump, there must be no meaningful differences.
    # reload using the previous release
    /path/to/racktables-contribs/demo.racktables.org/demoreload.sh X.Y.z racktables_db no
    # (make through upgrade.php)
    mysqldump --extended-insert=FALSE --order-by-primary racktables_db > ~/tmp/dump-upgraded.sql
    diff -u ~/tmp/dump-fresh.sql ~/tmp/dump-upgraded.sql
    
  • part 2 (unit testing)

    The commands below need some proofreading because the test data files in the source code tree still use the racktables MySQL username, which I had for this reason used for the 0.20.12 release. Whatever is the agreed username, it probably should be consistent with what is in the SQL dumps. -- Denis

  • Setup a fresh database and grant access to the 'racktables_user' user. This will be used to create a sample data file that unit tests can utilize.
  • DROP DATABASE IF EXISTS racktables_unittest;
    CREATE DATABASE racktables_unittest CHARACTER SET utf8 COLLATE utf8_general_ci;
    GRANT ALL PRIVILEGES ON racktables_unittest.* TO racktables_user@localhost IDENTIFIED BY 'MY_SECRET_PASSWORD';
    
  • Use the web interface to complete the installation. When prompted to set the admin password, enter 'admin'.
  • Load the sample data.
  • mysql -u racktables_user -p racktables_unittest < scripts/init-sample-racks.sql
  • Export the database to the tests/data dir.
  • mysqldump --skip-comments -u racktables_user -p racktables_unittest > tests/data/$CODE_VERSION.sql
  • Run the unit tests. Fix any failures.
  • cd tests
    ./express.sh
    phpunit --group large
    
  • If all is OK, commit the new SQL dump in the tests/data directory.
  • part 3 (finalization)

  • Test the source by hand as much as you find possible.
  • Look into the error log of the server you used for the tests. There shouldn't be any error/warning messages.
  • Do not proceed further until everything is fixed consistently.

the release itself

git tag RackTables-X.Y.z
git push origin RackTables-X.Y.z

rolling out

producing and publishing deliverables

  • Make two archives:
TAG='RackTables-X.Y.z'
git archive --prefix=$TAG/ -o $TAG.tar.gz $TAG
git archive --prefix=$TAG/ -o $TAG.zip $TAG
  • Upload the tarball and zipfile to SF FRS (from browser or by other means if you prefer). Give the uploaded files a couple minutes to make it through the system to the user-visible download area.
  • Open files section and set the newly uploaded release files as "current".
    • Open properties form (round "(i)" sign) of the previous release tar.gz.
    • Unset all "default download for" checkboxes.
    • Save.
    • Open properties form (round "(i)" sign) of the previous release zip.
    • Unset Windows "default download for" checkbox.
    • Save.
    • In the latest tarball properties form, set all "default download for" checkboxes except Windows.
    • Save.
    • In the latest zipfile properties form, set Windows "default download for" checkbox.
    • Save.
    • Hover the big green "download" button and watch the mouse hint featuring the right version number (sometimes it takes several minutes to see the update).
    • Tip: to update the banner text below the file list of the SF's "Files" section open a terminal connection to SF shell and edit the file /home/frs/project/racktables/README.md (once done, let the SF 5-10 minutes to start using the updated revision).

updating Mantis

  • In MantisBT mark the released version as released (Manage, Manage Projects, RackTables, Versions). Add the next version with the release date several months into the future.

updating the main web-site

  • In racktables-htdocs repository modify and commit header.php.
  • On the web-server run git pull.
  • Open https://racktables.org and test the "download" link to work.

updating other news feeds

  • Send a letter to the racktables-users list (even more so after Freshmeat/Freecode is gone).
  • Update IRC channel topic

updating demo

  • Produce a helper SQL file for the current release in racktables-contribs.
    • Copy the previous init-full-X.Y.z.sql to current init-full-X.Y.z.sql and git add the new file.
    • Take a clean RackTables instance of the current release (either use demoreload on the previous release or install manually).
    • Make an SQL dump of this new installation like this: mysqldump --extended-insert=FALSE --order-by-primary racktables_db > init-full-X.Y.z.sql
    • Edit permissions like this.
    • git add -p the new file again (note the flag). Add relevant chunks only. Quit.
    • git commit; git push
  • Update demo.racktables.org to the current release ($demorelease will need an update). Below is a sample CLI session of updating the demo to 0.20.3:
cd ~/racktables
git fetch
git checkout RackTables-0.20.3
cd
ln -s racktables RackTables-0.20.3
# the symlink to ~/secret.php is already in wwwroot/inc/
cd ~/racktables-contribs/
git pull
cd
~/racktables-contribs/demo.racktables.org/demoreload.sh 0.20.3 rackdemo yes
crontab -e
# ../../racktables/wwwroot/index.php is already linked as www/demo/index.php