[wp-trac] [WordPress Trac] #30462: Test multiple MySQL versions on Travis

[WordPress Trac]

#30462: Test multiple MySQL versions on Travis
---------------------------------------+------------------------------
 Reporter:  pento                      |       Owner:
     Type:  enhancement                |      Status:  new
 Priority:  normal                     |   Milestone:  Awaiting Review
Component:  Build/Test Tools           |     Version:
 Severity:  normal                     |  Resolution:
 Keywords:  needs-refresh needs-patch  |     Focuses:
---------------------------------------+------------------------------

Comment (by netweb):

 Just leaving these notes somewhere related, they came about on the way to
 r37555, but will be handy for this ticket in creating a large set of DB
 tests...

 {{{
 Travis CI


 Both these HHVM jobs work correctly

 This first (basic) uses HHVM 3.6.x (No longer supported) on Ubuntu Precise
 with MySQL 5.5
   - php: hhvm
     env: WP_TRAVISCI=travis:phpunit MATRIX_OS="precise"
 MATRIX_SUDO="inherited" MATRIX_OS_GROUP="standard" MATRIX_OS_PHP="HHVM
 3.6.6~precise" MATRIX_SQL="MySQL 5.5"

 This second job uses the current HHVM 3.13.x branch on Ubuntu Trusty with
 MySQL 5.6 (group:edge probably can be removed)
   - php: hhvm
     env: WP_TRAVISCI=travis:phpunit MATRIX_OS="trusty"
 MATRIX_SUDO="required" MATRIX_OS_GROUP="edge" MATRIX_OS_PHP="HHVM
 3.13.1~trusty" MATRIX_SQL="MySQL 5.6"
     group: edge
     addons:
       apt:
         packages:
         - mysql-server-5.6
         - mysql-client-core-5.6
         - mysql-client-5.6

 This batch of jobs works but should be added to the Travis MySQL ticket:
   - php: 7
     env: MATRIX_OS="trusty" MATRIX_SUDO="required"
 MATRIX_OS_GROUP="standard" MATRIX_OS_PHP="PHP 7.0" MATRIX_SQL="MySQL 5.6"
     addons:
       apt:
         packages:
         - mysql-server-5.6
         - mysql-client-core-5.6
         - mysql-client-5.6
   - php: 7
     env: MATRIX_OS="trusty" MATRIX_SUDO="inherited"
 MATRIX_OS_GROUP="standard" MATRIX_OS_PHP="PHP 7.0" MATRIX_SQL="MariaDB
 10.1"
     addons:
       mariadb: 10.1
   - php: 7
     env: MATRIX_OS="trusty" MATRIX_SUDO="inherited"
 MATRIX_OS_GROUP="standard" MATRIX_OS_PHP="PHP 7.0" MATRIX_SQL="MariaDB
 10.0"
     addons:
       mariadb: 10.0
   - php: 7
     env: MATRIX_OS="trusty" MATRIX_SUDO="inherited"
 MATRIX_OS_GROUP="standard" MATRIX_OS_PHP="PHP 7.0" MATRIX_SQL="MariaDB
 5.5"
     addons:
       mariadb: 5.5

 This batch of jobs also work and should be added to an a daily Travis CI
 database job (along with Jorbin's 78 character set/collation jobs)
   - php: 7
     env: DB=utf8mb4:utf8mb4_unicode_ci MATRIX_OS="trusty"
 MATRIX_SUDO="required" MATRIX_OS_GROUP="standard" MATRIX_OS_PHP="PHP 7.0"
 MATRIX_SQL="MySQL 5.6"
     addons:
       apt:
         packages:
         - mysql-server-5.6
         - mysql-client-core-5.6
         - mysql-client-5.6
   - php: 7
     env: DB=utf8mb4:utf8mb4_unicode_ci MATRIX_OS="trusty"
 MATRIX_SUDO="inherited" MATRIX_OS_GROUP="standard" MATRIX_OS_PHP="PHP 7.0"
 MATRIX_SQL="MariaDB 10.1"
     addons:
       mariadb: 10.1
   - php: 7
     env: DB=utf8mb4:utf8mb4_unicode_520_ci MATRIX_OS="trusty"
 MATRIX_SUDO="required" MATRIX_OS_GROUP="standard" MATRIX_OS_PHP="PHP 7.0"
 MATRIX_SQL="MySQL 5.6"
     addons:
       apt:
         packages:
         - mysql-server-5.6
         - mysql-client-core-5.6
         - mysql-client-5.6
   - php: 7
     env: DB=utf8mb4:utf8mb4_unicode_520_ci MATRIX_OS="trusty"
 MATRIX_SUDO="inherited" MATRIX_OS_GROUP="standard" MATRIX_OS_PHP="PHP 7.0"
 MATRIX_SQL="MariaDB 10.1"
     addons:
       mariadb: 10.1
 - |
   if [[ "$DB" == "utf8mb4:utf8mb4_unicode_ci" ]]; then
     sed -i "s/utf8/utf8mb4/" wp-tests-config.php
     sed -i "s/'DB_COLLATE', ''/'DB_COLLATE', 'utf8mb4_unicode_ci'/" wp-
 tests-config.php
     grep "DB_C" wp-tests-config.php
   fi
 - |
   if [[ "$DB" == "utf8mb4:utf8mb4_unicode_520_ci" ]]; then
     sed -i "s/utf8/utf8mb4/" wp-tests-config.php
     sed -i "s/'DB_COLLATE', ''/'DB_COLLATE', 'utf8mb4_unicode_520_ci'/"
 wp-tests-config.php
     grep "DB_C" wp-tests-config.php
   fi


 MySQL 5.6 jobs to be also added to the MySQL Travis ticket:

   - php: 5.6
     env: MATRIX_OS="trusty" MATRIX_SUDO="required"
 MATRIX_OS_GROUP="standard" MATRIX_OS_PHP="PHP 5.6" MATRIX_SQL="MySQL 5.6"
     addons:
       apt:
         packages:
         - mysql-server-5.6
         - mysql-client-core-5.6
         - mysql-client-5.6
   - php: 5.2
     env: MATRIX_OS="precise" MATRIX_SUDO="inherited"
 MATRIX_OS_GROUP="standard" MATRIX_OS_PHP="PHP 5.2" MATRIX_SQL="MySQL 5.5"
     sudo: false
   - php: 7
     env: MATRIX_OS="trusty" MATRIX_SUDO="required"
 MATRIX_OS_GROUP="standard" MATRIX_OS_PHP="PHP 7.0" MATRIX_SQL="MySQL 5.6"
     addons:
       apt:
         packages:
         - mysql-server-5.6
         - mysql-client-core-5.6
         - mysql-client-5.6




 Proposed Matrix for DB crazyness

 sudo: required
 dist: trusty
 language: php

 php:
   - 5.2
   - 5.6
   - 7.0
   - hhvm

 env:
   matrix:
     - MySQL 5.5
     - MySQL 5.6
     - MariaDB 5.5
     - MariaDB 10.0
     - MariaDB 10.1
 cache:
   apt: true
 }}}

--
Ticket URL: <https://core.trac.wordpress.org/ticket/30462#comment:17>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform