xref: /sqlalchemy/tox.ini (revision 22800000)
16b051503SMike Bayer
29281e700SMike Bayer[tox]
3243f9804SMike Bayerenvlist = py{27,34,35,36,37}-{cext,nocext}
49281e700SMike Bayer
59281e700SMike Bayer[testenv]
649dfeda6SMike Bayer# note that we have a .coveragerc file that points coverage specifically
749dfeda6SMike Bayer# at ./lib/sqlalchemy, and *not* at the build that tox might create under .tox.
849dfeda6SMike Bayer# See the notes below for setenv for more detail.
949dfeda6SMike Bayer# also using --cov-append so that we can aggregate multiple runs together.
1049dfeda6SMike Bayer# Jenkins etc. need to call "coverage erase" externally.
1149dfeda6SMike Bayercov_args=--cov=sqlalchemy --cov-report term --cov-append --cov-report xml --exclude-tag memory-intensive --exclude-tag timing-intensive -k "not aaa_profiling"
1249dfeda6SMike Bayer
1322800000SMike Bayerinstall_command=python -m pip install {env:TOX_PIP_OPTS} {opts} {packages}
1422800000SMike Bayer
15086ad9ceSMike Bayerusedevelop=
16086ad9ceSMike Bayer     cov: True
17d100bfcfSMike Bayer
183568e508SMike Bayerdeps=pytest
193568e508SMike Bayer     pytest-xdist
209281e700SMike Bayer     mock
2166e483ebSMike Bayer     # needed only for correct profiling results
2266e483ebSMike Bayer     # due to speed improvements in psycopg2 as of 2.7
2366e483ebSMike Bayer     postgresql: psycopg2>=2.7
248d1579ccSMike Bayer     mysql: mysqlclient
258d1579ccSMike Bayer     mysql: pymysql
2683750628SMike Bayer     mysql: mysql-connector-python
27de73c6d1SMike Bayer     # waiting for https://github.com/oracle/python-cx_Oracle/issues/75
2867a2cd92SMike Bayer     oracle: cx_oracle>=7.0
2967a2cd92SMike Bayer     oracle6: cx_oracle>=6.0.2,!=6.3,!=6.4,<7.0
302e137b39SMike Bayer     oracle5: cx_oracle==5.2.1
318d1579ccSMike Bayer     mssql: pyodbc
328d1579ccSMike Bayer     mssql: pymssql
33d100bfcfSMike Bayer     cov: pytest-cov
349281e700SMike Bayer
3549dfeda6SMike Bayerwhitelist_externals=sh
3649dfeda6SMike Bayer
3749dfeda6SMike Bayer# PYTHONPATH - erased so that we use the build that's present
3849dfeda6SMike Bayer# in .tox as the SQLAlchemy library to be imported
3949dfeda6SMike Bayer#
4049dfeda6SMike Bayer# PYTHONUSERSITE - this *MUST* be set so that the ./lib/ import
4149dfeda6SMike Bayer# set up explicitly in test/conftest.py is *disabled*, again so that
4249dfeda6SMike Bayer# when SQLAlchemy is built into the .tox area, we use that and not the
4349dfeda6SMike Bayer# local checkout, at least when usedevelop=False
4449dfeda6SMike Bayer#
4549dfeda6SMike Bayer# BASECOMMAND - using an env variable here so we can use it
4649dfeda6SMike Bayer# as a substitution in a command (see https://bitbucket.org/hpk42/tox/issues/307/)
4749dfeda6SMike Bayer#
48ffb6fbf8SMike Bayer# only use --dropfirst option if we're *not* using -n;
49ffb6fbf8SMike Bayer# if -n is used, we're working in brand new DBs anyway, dropfirst
50ffb6fbf8SMike Bayer# will collide on CI environments
51f30e35baSMike Bayersetenv=
52f30e35baSMike Bayer    PYTHONPATH=
5349dfeda6SMike Bayer    PYTHONNOUSERSITE=1
5400309662SMike Bayer    BASECOMMAND=python -m pytest --log-info=sqlalchemy.testing
55086ad9ceSMike Bayer
569e6393c6SMike Bayer    WORKERS={env:TOX_WORKERS:-n4}
5767a2cd92SMike Bayer    oracle,oracle6,oracle5: WORKERS={env:TOX_WORKERS:-n2}
58086ad9ceSMike Bayer    nocext: DISABLE_SQLALCHEMY_CEXT=1
59086ad9ceSMike Bayer    cov: COVERAGE={[testenv]cov_args}
609e6393c6SMike Bayer    sqlite: SQLITE={env:TOX_SQLITE:--db sqlite}
619e6393c6SMike Bayer    postgresql: POSTGRESQL={env:TOX_POSTGRESQL:--db postgresql}
629e6393c6SMike Bayer    mysql: MYSQL={env:TOX_MYSQL:--db mysql --db pymysql}
6367a2cd92SMike Bayer    oracle,oracle6,oracle5: ORACLE={env:TOX_ORACLE:--db oracle}
642efd89d0SMike Bayer    mssql: MSSQL={env:TOX_MSSQL:--db mssql --db mssql_pymssql}
6567a2cd92SMike Bayer    oracle,oracle6,oracle5,mssql: IDENTS=--write-idents db_idents.txt
6667a2cd92SMike Bayer    oracle,oracle6,oracle5,mssql: NOMEMORY=--nomemory
67086ad9ceSMike Bayer    backendonly: BACKENDONLY=--backend-only
68f30e35baSMike Bayer
697f423e87SMike Bayer# tox as of 2.0 blocks all environment variables from the
707f423e87SMike Bayer# outside, unless they are here (or in TOX_TESTENV_PASSENV,
71077f26afSMike Bayer# wildcards OK).  Need at least these
737f423e87SMike Bayer
7449dfeda6SMike Bayer# for nocext, we rm *.so in lib in case we are doing usedevelop=True
759281e700SMike Bayercommands=
762efd89d0SMike Bayer  nocext: sh -c "rm -f lib/sqlalchemy/*.so"
772efd89d0SMike Bayer  {env:BASECOMMAND} {env:WORKERS} {env:SQLITE:} {env:POSTGRESQL:} {env:MYSQL:} {env:ORACLE:} {env:MSSQL:} {env:BACKENDONLY:} {env:IDENTS:} {env:NOMEMORY:} {env:COVERAGE:} {posargs}
7867a2cd92SMike Bayer  oracle,oracle6,oracle5,mssql: python reap_dbs.py db_idents.txt
799281e700SMike Bayer
809281e700SMike Bayer[testenv:pep8]
811217d6ceSMike Bayerdeps=flake8
8230ab1a02SMike Bayercommands = python -m flake8 {posargs}
839281e700SMike Bayer
849281e700SMike Bayer[flake8]
859281e700SMike Bayershow-source = True
8686660fefSMike Bayerignore = E711,E712,E721,N806,D
879281e700SMike Bayerexclude=.venv,.git,.tox,dist,doc,*egg,build