Add initial support for AppVeyor

3 files changed, 91 insertions, 13 deletions

diff --git a/README.md b/README.md
index 922af9a..5d046bd 100644
--- a/README.md
+++ b/README.md
@@ -1,4 +1,5 @@
 [![Build Status](https://travis-ci.org/dshafik/php7-mysql-shim.svg?branch=master)](https://travis-ci.org/dshafik/php7-mysql-shim)
+[![Build status](https://ci.appveyor.com/api/projects/status/tvj60v4y3o0mn4wp?svg=true)](https://ci.appveyor.com/project/dshafik/php7-mysql-shim)
 [![Scrutinizer Code Quality](https://scrutinizer-ci.com/g/dshafik/php7-mysql-shim/badges/quality-score.png?b=master)](https://scrutinizer-ci.com/g/dshafik/php7-mysql-shim/?branch=master)
 [![Code Coverage](https://scrutinizer-ci.com/g/dshafik/php7-mysql-shim/badges/coverage.png?b=master)](https://scrutinizer-ci.com/g/dshafik/php7-mysql-shim/?branch=master)
 [![SensioLabsInsight](https://insight.sensiolabs.com/projects/43c28e54-9c4a-40b4-9cc9-d6409d781dda/mini.png)](https://insight.sensiolabs.com/projects/43c28e54-9c4a-40b4-9cc9-d6409d781dda)
diff --git a/appveyor.yml b/appveyor.yml
new file mode 100644
index 0000000..5e14ed6
--- /dev/null
+++ b/appveyor.yml
@@ -0,0 +1,71 @@
+build: false
+platform:
+  - x64
+clone_folder: c:\projects\php7-mysql-shim
+
+services:
+  - mysql
+
+environment:
+  matrix:
+  - DEPS: lock
+    PHP_VERSION: 5.6
+  - DEPS: low
+    PHP_VERSION: 5.6
+  - DEPS: high
+    PHP_VERSION: 5.6
+  - DEPS: dev
+    PHP_VERSION: 5.6
+  - DEPS: lock
+    PHP_VERSION: 7.0
+  - DEPS: low
+    PHP_VERSION: 7.0
+  - DEPS: high
+    PHP_VERSION: 7.0
+  - DEPS: dev
+    PHP_VERSION: 7.0
+  - DEPS: lock
+    PHP_VERSION: 7.1
+  - DEPS: low
+    PHP_VERSION: 7.1
+  - DEPS: high
+    PHP_VERSION: 7.1
+  - DEPS: dev
+    PHP_VERSION: 7.1
+
+## Cache composer bits
+cache:
+    - '%LOCALAPPDATA%\Composer\files -> composer.lock'
+
+## Set up environment variables
+init:
+    - SET PATH=C:\Program Files\OpenSSL;c:\tools\php;%PATH%
+    - SET COMPOSER_NO_INTERACTION=1
+    - SET PHP=1
+    - SET ANSICON=121x90 (121x90)
+
+## Install PHP and composer, and run the appropriate composer command
+install:
+    - IF EXIST c:\tools\php (SET PHP=0)
+    - ps: appveyor-retry cinst --ignore-checksums -y php --version ((choco search php --exact --all-versions -r | select-string -pattern $Env:PHP_VERSION | Select-Object -first 1) -replace '[php|]','')
+    - cd c:\tools\php
+    - IF %PHP%==1 copy php.ini-production php.ini /Y
+    - IF %PHP%==1 echo date.timezone="UTC" >> php.ini
+    - IF %PHP%==1 echo extension_dir=ext >> php.ini
+    - IF %PHP%==1 echo extension=php_openssl.dll >> php.ini
+    - IF %PHP%==1 echo extension=php_mbstring.dll >> php.ini
+    - IF %PHP%==1 echo extension=php_fileinfo.dll >> php.ini
+    - IF %PHP%==1 IF %PHP_VERSION%==5.6 echo extension=php_mysql.dll >> php.ini
+    - IF %PHP%==1 echo extension=php_mysqli.dll >> php.ini
+    - IF %PHP%==1 echo @php %%~dp0composer.phar %%* > composer.bat
+    - appveyor-retry appveyor DownloadFile https://getcomposer.org/composer.phar
+    - cd c:\projects\php7-mysql-shim
+    - IF %DEPS%==lock appveyor-retry composer install --no-interaction --prefer-source
+    - IF %DEPS%==dev appveyor-retry composer update --minimum-stability=dev --no-interaction --prefer-source
+    - IF %DEPS%==low appveyor-retry composer update --prefer-lowest --no-interaction --prefer-source
+    - IF %DEPS%==high appveyor-retry composer update --no-interaction --prefer-source
+    - composer show
+
+test_script:
+    - cd c:\projects\php7-mysql-shim
+    - vendor/bin/phpunit -c phpunit.xml.dist
\ No newline at end of file
diff --git a/tests/MySqlShimTest.php b/tests/MySqlShimTest.php
index 1ad073f..9952e81 100644
--- a/tests/MySqlShimTest.php
+++ b/tests/MySqlShimTest.php
@@ -16,6 +16,8 @@ class MySqlShimTest extends \PHPUnit_Framework_TestCase
      */
     static protected $host;
 
+    static protected $password = null;
+
     /**
      * @var string Docker container
      */
@@ -44,7 +46,7 @@ class MySqlShimTest extends \PHPUnit_Framework_TestCase
 
     public function test_mysql_connect()
     {
-        $mysql = mysql_connect(static::$host, 'root');
+        $mysql = mysql_connect(static::$host, 'root', static::$password);
         $this->assertConnection($mysql);
     }
 
@@ -55,7 +57,7 @@ class MySqlShimTest extends \PHPUnit_Framework_TestCase
     {
         ini_set('mysqli.default_host', '127.0.0.1');
         ini_set('mysqli.default_user', 'root');
-        ini_set('mysqli.default_pw', '');
+        ini_set('mysqli.default_pw', (static::$password === null) ? '' : static::$password);
 
         $mysql = mysql_connect();
         $this->assertConnection($mysql);
@@ -83,12 +85,12 @@ class MySqlShimTest extends \PHPUnit_Framework_TestCase
      */
     public function test_mysql_connect_new()
     {
-        mysql_connect(static::$host, 'root', null, true);
+        mysql_connect(static::$host, 'root', static::$password, true);
     }
 
     public function test_mysql_connect_options()
     {
-        $mysql = mysql_connect(static::$host, 'root', null, false, MYSQL_CLIENT_COMPRESS);
+        $mysql = mysql_connect(static::$host, 'root', static::$password, false, MYSQL_CLIENT_COMPRESS);
         $this->assertConnection($mysql);
     }
 
@@ -105,8 +107,8 @@ class MySqlShimTest extends \PHPUnit_Framework_TestCase
     {
         $this->skipForHHVM();
 
-        $conn = mysql_connect(static::$host, 'root');
-        $conn2 = mysql_connect(static::$host, 'root');
+        $conn = mysql_connect(static::$host, 'root', static::$password);
+        $conn2 = mysql_connect(static::$host, 'root', static::$password);
 
         $this->assertEquals($conn, $conn2);
 
@@ -123,7 +125,7 @@ class MySqlShimTest extends \PHPUnit_Framework_TestCase
 
     public function test_mysql_pconnect()
     {
-        $conn = mysql_pconnect(static::$host, 'root');
+        $conn = mysql_pconnect(static::$host, 'root', static::$password);
 
         $result = mysql_query("SELECT 'persistent'", $conn);
         $row = mysql_fetch_row($result);
@@ -150,7 +152,7 @@ class MySqlShimTest extends \PHPUnit_Framework_TestCase
 
     public function test_mysql_query_ddl()
     {
-        mysql_connect(static::$host, 'root');
+        mysql_connect(static::$host, 'root', static::$password);
         $result = mysql_query('CREATE DATABASE IF NOT EXISTS shim_test');
         $this->assertTrue($result, mysql_error());
     }
@@ -860,7 +862,7 @@ class MySqlShimTest extends \PHPUnit_Framework_TestCase
 
     public function test_mysql_close()
     {
-        mysql_connect(static::$host, 'root');
+        mysql_connect(static::$host, 'root', static::$password);
         $this->assertTrue(mysql_close());
     }
 
@@ -953,7 +955,7 @@ class MySqlShimTest extends \PHPUnit_Framework_TestCase
     public static function setUpBeforeClass()
     {
         error_reporting(E_ALL & ~E_DEPRECATED);
-        if (getenv('TRAVIS') === false) {
+        if (getenv('TRAVIS') === false && getenv('APPVEYOR') === false) {
             fwrite(STDERR, "=> Finding binaries\n");
             static::$bin['docker'] = $docker = exec('/usr/bin/env which docker');
             if (empty($docker)) {
@@ -988,11 +990,15 @@ class MySqlShimTest extends \PHPUnit_Framework_TestCase
 
 
         static::$host = '0.0.0.0';
+        if (getenv('APPVEYOR') !== false) {
+            static::$host = '127.0.0.1';
+            static::$password = 'Password12!';
+        }
     }
 
     public static function tearDownAfterClass()
     {
-        if (getenv('TRAVIS') === false) {
+        if (getenv('TRAVIS') === false && getenv('APPVEYOR') === false) {
             fwrite(STDERR, "\n\nStopping Docker Container: ");
             $output = exec(static::$bin['docker'] . ' stop ' . static::$container);
             if (trim($output) !== static::$container) {
@@ -1010,7 +1016,7 @@ class MySqlShimTest extends \PHPUnit_Framework_TestCase
             return;
         }
 
-        mysql_connect(static::$host, 'root');
+        mysql_connect(static::$host, 'root', static::$password);
         foreach (self::$dbs as $db) {
             mysql_query("DROP DATABASE IF EXISTS `$db`");
         }
@@ -1216,7 +1222,7 @@ class MySqlShimTest extends \PHPUnit_Framework_TestCase
     {
         self::$dbs[$db] = $db;
 
-        $mysql = mysql_connect(static::$host, 'root');
+        $mysql = mysql_connect(static::$host, 'root', static::$password);
         $this->assertConnection($mysql);
 
         mysql_query('SET NAMES ' . $encoding);