Provisioning: Install MySQL x86 and x64 libraries to Windows10 x64
authorAkseli Salovaara <akseli.salovaara@qt.io>
Thu, 15 Dec 2016 07:05:11 +0000 (09:05 +0200)
committerTony Sarajärvi <tony.sarajarvi@qt.io>
Fri, 10 Feb 2017 06:14:06 +0000 (06:14 +0000)
Install both x86 and x64 libraries in order to enable Windows x86
builds on Windows x64 hosts. Environment variables are used by Coin.

Change-Id: I8eea51a0bfd05bc72d1d004649211c7bc5901d97
Reviewed-by: Tony Sarajärvi <tony.sarajarvi@qt.io>
coin/provisioning/qtci-windows-10-x86_64/mysql.ps1 [new file with mode: 0644]

diff --git a/coin/provisioning/qtci-windows-10-x86_64/mysql.ps1 b/coin/provisioning/qtci-windows-10-x86_64/mysql.ps1
new file mode 100644 (file)
index 0000000..5e75f66
--- /dev/null
@@ -0,0 +1,112 @@
+#############################################################################
+##
+## Copyright (C) 2017 The Qt Company Ltd.
+## Contact: http://www.qt.io/licensing/
+##
+## This file is part of the provisioning scripts of the Qt Toolkit.
+##
+## $QT_BEGIN_LICENSE:LGPL21$
+## Commercial License Usage
+## Licensees holding valid commercial Qt licenses may use this file in
+## accordance with the commercial license agreement provided with the
+## Software or, alternatively, in accordance with the terms contained in
+## a written agreement between you and The Qt Company. For licensing terms
+## and conditions see http://www.qt.io/terms-conditions. For further
+## information use the contact form at http://www.qt.io/contact-us.
+##
+## GNU Lesser General Public License Usage
+## Alternatively, this file may be used under the terms of the GNU Lesser
+## General Public License version 2.1 or version 3 as published by the Free
+## Software Foundation and appearing in the file LICENSE.LGPLv21 and
+## LICENSE.LGPLv3 included in the packaging of this file. Please review the
+## following information to ensure the GNU Lesser General Public License
+## requirements will be met: https://www.gnu.org/licenses/lgpl.html and
+## http://www.gnu.org/licenses/old-licenses/lgpl-2.1.html.
+##
+## As a special exception, The Qt Company gives you certain additional
+## rights. These rights are described in The Qt Company LGPL Exception
+## version 1.1, included in the file LGPL_EXCEPTION.txt in this package.
+##
+## $QT_END_LICENSE$
+##
+#############################################################################
+
+. "$PSScriptRoot\..\common\helpers.ps1"
+
+# This script installs MySQL $version.
+# Both x86 and x64 versions needed when x86 integrations are done on x64 machine
+
+$version = "5.6.11"
+$packagex64 = "C:\Windows\temp\mysql-$version-win64.zip"
+$packagex86 = "C:\Windows\temp\mysql-$version-win32.zip"
+
+function CheckAndRemovePreviousInstallation
+{
+    Param (
+        [string]$InstallFolder
+    )
+    echo "Check for previous installation..."
+    $FolderExists = Test-Path $ExistingInstallation
+    If ($FolderExists -eq $True) {
+        echo "Removing previous installation ($ExistingInstallation)"
+        Remove-Item $ExistingInstallation -recurse
+    }
+}
+
+function DownloadAndInstall
+{
+    Param (
+        [string]$arch,
+        [string]$externalUrl,
+        [string]$internalUrl,
+        [string]$package,
+        [string]$sha1,
+        [string]$installPath
+    )
+
+   echo "Fetching from URL ..."
+   Download $externalUrl $internalUrl $package
+   Verify-Checksum $package $sha1
+   Extract-Zip $package $installPath
+}
+
+# Install x64 bit version
+$architecture = "x64"
+$installFolder = "C:\Utils\my_sql"
+$existingInstallation = "$installFolder\my_sql"
+$internalUrl = "http://ci-files01-hki.ci.local/input/windows/mysql-$version-winx64"
+$sha1 = "f4811512b5f3c8ad877ee4feba2062312a0acc38"
+
+echo "Check and remove previous installation ..."
+CheckAndRemovePreviousInstallation $existingInstallation
+DownloadAndInstall $architecture $internalUrl $internalUrl $packagex64 $sha1 $installFolder
+Rename-Item -path $installFolder\mysql-$version-winx64 -newName $installFolder\my_sql
+
+echo "Remove downloaded package ..."
+Remove-Item $packagex64
+
+echo "Set environment variables ..."
+[Environment]::SetEnvironmentVariable("MYSQL_INCLUDE_x64", "$installFolder\my_sql\include", "Machine")
+[Environment]::SetEnvironmentVariable("MYSQL_LIB_x64", "$installFolder\my_sql\lib", "Machine")
+
+# Install x86 bit version
+$architecture = "x86"
+$installFolder = "C:\Utils\my_sql$architecture"
+$existingInstallation = "$installFolder\my_sql"
+$internalUrl = "http://ci-files01-hki.ci.local/input/windows/mysql-$version-win32"
+$sha1 = "e0aa62d5c5d6c6ec28906a831752d04336562679"
+
+echo "Check and remove previous installation ..."
+CheckAndRemovePreviousInstallation $existingInstallation
+DownloadAndInstall $architecture $internalUrl $internalUrl $packagex86 $sha1 $installFolder
+Rename-Item -path $installFolder\mysql-$version-win32 -newName $installFolder\my_sql
+
+echo "Remove downloaded package ..."
+Remove-Item $packagex86
+
+echo "Set environment variables ..."
+[Environment]::SetEnvironmentVariable("MYSQL_INCLUDE_x86", "$installFolder\my_sql\include", "Machine")
+[Environment]::SetEnvironmentVariable("MYSQL_LIB_x86", "$installFolder\my_sql\lib", "Machine")
+
+# Store version information to ~/versions.txt, which is used to print version information to provision log.
+echo "MySQL = $version" >> ~/versions.txt