refs #1885 - create a package folder for build-specific scripts and files; move WAG and add latest build.script

git-svn-id: http://dev.piwik.org/svn/trunk@3449 59fd770c-687e-43c8-a1e3-f5a4ff64c105

4 files changed, 260 insertions, 0 deletions

diff --git a/misc/package/WebAppGallery/Manifest.xml b/misc/package/WebAppGallery/Manifest.xml
new file mode 100644
index 0000000000..a252383bb2
--- /dev/null
+++ b/misc/package/WebAppGallery/Manifest.xml
@@ -0,0 +1,13 @@
+<MSDeploy.iisApp>
+  <iisApp path="piwik" />
+  <setAcl
+    path="piwik"
+    setAclUser="anonymousAuthenticationUser"
+    setAclAccess="Modify"
+  />
+  <dbmysql
+    path="install.sql"
+    commandDelimeter="//"
+    removeCommandDelimeter="true"
+  />
+</MSDeploy.iisApp>
diff --git a/misc/package/WebAppGallery/install.sql b/misc/package/WebAppGallery/install.sql
new file mode 100644
index 0000000000..8a751dca8c
--- /dev/null
+++ b/misc/package/WebAppGallery/install.sql
@@ -0,0 +1,15 @@
+USE PlaceholderForDbName;
+
+DROP PROCEDURE IF EXISTS add_user ;
+
+CREATE PROCEDURE add_user()
+BEGIN
+DECLARE EXIT HANDLER FOR 1044 BEGIN END;
+GRANT ALL PRIVILEGES ON PlaceholderForDbName.* to 'PlaceholderForDbUser'@'PlaceholderForServer' IDENTIFIED BY 'PlaceholderForDbPassword';
+FLUSH PRIVILEGES;
+END
+//
+
+CALL add_user() //
+
+DROP PROCEDURE IF EXISTS add_user //
diff --git a/misc/package/WebAppGallery/parameters.xml b/misc/package/WebAppGallery/parameters.xml
new file mode 100644
index 0000000000..cf553f3e90
--- /dev/null
+++ b/misc/package/WebAppGallery/parameters.xml
@@ -0,0 +1,165 @@
+<parameters>
+  <!-- Application install path -->
+  <parameter
+    name="Application Path"
+    description="Full site path where you would like to install your application (for example, Default Web Site/piwik)."
+    defaultValue="Default Web Site/piwik"
+    tags="iisapp">
+    <parameterEntry
+      type="ProviderPath"
+      scope="iisapp"
+      match="piwik"
+    />
+  </parameter>
+
+  <!-- Set access control list -->
+  <parameter
+    name="SetAclParameterTree"
+    description="Sets the ACL on the Installation tree"
+    defaultValue="{Application Path}"
+    tags="Hidden">
+    <parameterEntry
+      type="ProviderPath"
+      scope="setAcl"
+      match="piwik"
+      />
+  </parameter>
+
+  <!-- Database server name -->
+  <parameter
+    name="DbServer"
+    defaultValue="localhost"
+    tags="MySQL,dbServer">
+    <parameterEntry
+      type="TextFile"
+      scope="install.sql$"
+      match="PlaceholderForServer"
+    />
+  </parameter>
+  <parameter
+    name="Automatic Database Server PHP File"
+    defaultValue="host = &quot;{DbServer}&quot;"
+    tags="Hidden, MySQL">
+    <parameterEntry
+      type="TextFile"
+      scope="config\\config.ini.php$"
+      match="host\s*=\s*[^\r\n]*" 
+    />
+  </parameter>
+
+  <!-- Database name -->
+  <parameter
+    name="DbName"
+    defaultValue="piwik"
+    tags="MySQL,dbName">
+    <parameterValidation
+      type="RegularExpression"
+      validationString="^\w{1,16}$"
+    />
+    <parameterEntry
+      type="TextFile"
+      scope="install.sql$"
+      match="PlaceholderForDbName"
+    />
+  </parameter>
+  <parameter
+    name="Automatic Database Name PHP File"
+    defaultValue="dbname = &quot;{DbName}&quot;"
+    tags="Hidden, MySQL">
+    <parameterEntry
+      type="TextFile"
+      scope="config\\config.ini.php$"
+      match="dbname\s*=\s*[^\r\n]*" 
+    />
+  </parameter>
+
+  <!-- Database user name -->
+  <parameter
+    name="DbUsername"
+    defaultValue="piwikuser"
+    tags="MySQL,DbUsername">
+    <parameterValidation
+      type="RegularExpression"
+      validationString="^\w{1,16}$"
+    />
+    <parameterEntry
+      type="TextFile"
+      scope="install.sql$"
+      match="PlaceholderForDbUsername"
+    />
+  </parameter>
+  <parameter
+    name="Automatic Database Username PHP File"
+    defaultValue="username = &quot;{DbUsername}&quot;"
+    tags="Hidden,MySQL">
+    <parameterEntry
+      type="TextFile"
+      scope="config\\config.ini.php$"
+      match="username\s*=\s*[^\r\n]*" 
+    />
+  </parameter>
+
+  <!-- Database user password -->
+  <parameter
+    name="DbPassword"
+    description="Minimum 4 characters and maximum 20 characters"
+    tags="New,Password,MySQL,DbUserPassword">
+    <parameterValidation
+      type="RegularExpression"
+      validationString=".{4,20}"
+    />
+    <parameterEntry
+      type="TextFile"
+      scope="install.sql$"
+      match="PlaceholderForDbPassword"
+    />
+  </parameter>
+  <parameter
+    name="Automatic Database Password PHP File"
+    defaultValue="password = &quot;{DbPassword}&quot;"
+    tags="Hidden, MySQL">
+    <parameterEntry
+      type="TextFile"
+      scope="config\\config.ini.php$"
+      match="password\s*=(.{6,20})&quot;"
+    />
+  </parameter>
+  
+  <!-- Database admin user name -->
+  <parameter
+    name="DbAdminUsername"
+    defaultValue="root"
+    tags="MySQL,DbAdminUsername">
+  </parameter>
+
+  <!-- Database admin user password -->
+  <parameter
+    name="DbAdminPassword"
+    description="Password for the database administrator account."
+    tags="Password,MySQL,DbAdminPassword">
+  </parameter>
+ 
+  <!-- Execute install.sql -->
+  <parameter
+    name="Connection String"
+    defaultValue="Server={DbServer};Database={DbName};uid={DbAdminUsername};Pwd={DbAdminPassword};"
+    tags="Hidden,MySQLConnectionString,Validate,MySQL">
+    <parameterEntry
+      type="ProviderPath"
+      scope="dbmysql"
+      match="install.sql$"
+    />
+  </parameter>
+
+  <!-- Database adapter -->
+  <parameter
+    name="Automatic Database adapter"
+    defaultValue="adapter = &quot;PDO_MYSQL&quot;"
+    tags="Hidden, MySQL">
+    <parameterEntry
+      type="TextFile"
+      scope="config\\config.ini.php$"
+      match="adapter\s*=\s*[^\r\n]*" 
+    />
+  </parameter>
+</parameters>
diff --git a/misc/package/build-last.sh b/misc/package/build-last.sh
new file mode 100644
index 0000000000..fb1a011c4e
--- /dev/null
+++ b/misc/package/build-last.sh
@@ -0,0 +1,67 @@
+#!/bin/bash
+VERSION="1.1b2"
+DEST_PATH=/home/piwik/builds
+URL_REPO=http://piwik@dev.piwik.org/svn/trunk
+URL_TAGS=http://piwik@dev.piwik.org/svn/tags
+HTTP_PATH=/home/www/builds.piwik.org
+
+function die() {
+        echo -e "$0: $1"
+        exit 2
+}
+
+if [ ! -e $DEST_PATH ] ; then
+        echo "Destination directory does not exists... Creating it !";
+        mkdir -p $DEST_PATH;
+fi
+
+echo "checkout repository for tag $VERSION"
+rm -rf $DEST_PATH/piwik_last_version
+svn export $URL_TAGS/$VERSION $DEST_PATH/piwik_last_version > /dev/null || die "Problem checking out the last version tag"
+
+echo "preparing release $VERSION "
+cd $DEST_PATH
+rm -rf $DEST_PATH/piwik
+mv piwik_last_version piwik
+echo `grep "'$VERSION'" piwik/core/Version.php`
+if [ `grep "'$VERSION'" piwik/core/Version.php | wc -l` -ne 1 ]  ; then
+  echo "version $VERSION not matching core/Version.php";
+  exit
+fi
+rm -rf piwik/libs/PhpDocumentor-1.3.2/
+rm -rf piwik/libs/FirePHPCore/
+rm -rf piwik/tmp/cache/*
+rm -rf piwik/tmp/logs/*
+rm -rf piwik/tmp/templates_c/*
+rm -f piwik/misc/db-schema*
+rm -f piwik/misc/diagram_general_request*
+cp piwik/tests/README.txt .
+rm -rf piwik/tests/*
+find piwik/plugins -name tests -type d -exec rm -rf {} \; 2> /dev/null
+mv README.txt piwik/tests/
+cp piwik/misc/How\ to\ install\ Piwik.html .
+cp piwik/misc/WebAppGallery/*.xml .
+
+echo "writing manifest file..."
+find piwik -type f -printf '%s ' -exec md5sum {} \; | fgrep -v 'manifest.inc.php' | sed '1,$ s/\([0-9]*\) \([a-z0-9]*\) *piwik\/\(.*\)/\t\t"\3" => array("\1", "\2"),/; 1 s/^/<?php\n\/\/ This file is automatically generated during the Piwik build process\n class Manifest {\n\tstatic $files=array(\n/; $ s/$/\n\t);\n}/' > piwik/config/manifest.inc.php
+
+echo "packaging release..."
+zip -r piwik-$VERSION.zip piwik How\ to\ install\ Piwik.html *.xml > /dev/null 2> /dev/null
+tar -czf piwik-$VERSION.tar.gz piwik How\ to\ install\ Piwik.html *.xml
+mv piwik-$VERSION.{zip,tar.gz} $HTTP_PATH
+rm -rf piwik
+
+if [ `echo $VERSION | grep -E 'rc|b|a|alpha|beta|dev' -i | wc -l` -eq 1 ]  ; then
+  echo "Beta or RC release";
+  echo $VERSION > $HTTP_PATH/LATEST_BETA
+  echo "build finished! http://builds.piwik.org/piwik-$VERSION.zip"
+else
+  echo "Stable release";
+  #hard linking piwik.org/latest.zip to the newly created build
+  for i in zip tar.gz; do
+    ln -sf $HTTP_PATH/piwik-$VERSION.$i $HTTP_PATH/latest.$i
+  done
+  echo $VERSION > $HTTP_PATH/LATEST
+  echo "build finished! http://piwik.org/latest.zip"
+fi
+