AppVey上Python和sqlserver的多种组合

Question

如何设置一个AppVeyor构建，该构建使用不同的sqlserver、MySQL和Python版本组合运行多个作业？你知道吗

假设我要运行以下组合：

• SQL Server 2012和Python 2.7
• SQL Server 2012和Python 3.4

---

• SQL Server 2014和Python 2.7
• SQL Server 2014和Python 3.4

---

• SQL Server 2016和Python 2.7
• SQL Server 2016和Python 3.6

---

• MySQL 5.7和Python 2.7
• MySQL 5.7和Python 3.6

我该怎么写我的名字供应商.yml文件？到目前为止，我的情况是：

environment:

  matrix:

    # For Python versions available on Appveyor, see
    # http://www.appveyor.com/docs/installed-software#python

    - PYTHON: "C:\\Python27-x64"

    - PYTHON: "C:\\Python34-x64"
      DISTUTILS_USE_SDK: "1"

    - PYTHON: "C:\\Python36-x64"

services:
  - mysql
  - mssql2012sp1
  - mssql2014
  - mssql2016

platform:
  - x86

install:
  - "%PYTHON%\\python.exe -m pip install django==1.10"

test_script:
  - "%PYTHON%\\python.exe manage.py test"

Answer 1

生成矩阵不支持服务维度。因此，需要为SQLServer版本引入环境变量并相应地启动它。 该YAML应适用于：

init:
- cmd: net start %SQL%
environment:
  matrix:
  - SQL: MSSQL$SQL2012SP1
    PYTHON: C:\\Python27-x64
  - SQL: MSSQL$SQL2012SP1
    PYTHON: C:\\Python34-x64
    DISTUTILS_USE_SDK: 1
  - SQL: MSSQL$SQL2014
    PYTHON: C:\\Python27-x64
  - SQL: MSSQL$SQL2014
    PYTHON: C:\\Python34-x64
    DISTUTILS_USE_SDK: 1
  - SQL: MSSQL$SQL2016
    PYTHON: C:\\Python27-x64
  - SQL: MSSQL$SQL2016
    PYTHON: C:\\Python36-x64
  - SQL: MySQL57
    PYTHON: C:\\Python27-x64
  - SQL: MySQL57
    PYTHON: C:\\Python36-x64