envlist = py

extras=

asyncio

sqlite: aiosqlite

sqlite_file: aiosqlite

# asyncpg doesn't build on free threading backends

py{38,39,310,311,312,313,314}-postgresql: postgresql_asyncpg

mysql: asyncmy

# aioodbc builds on free threading but segfaults once you use it

py{38,39,310,311,312,313,314}-mssql: aioodbc

cov_args=--cov=sqlalchemy --cov-report term --cov-append --cov-report xml --exclude-tag memory-intensive --exclude-tag timing-intensive -k "not aaa_profiling"

usedevelop=

cov: True

extras=

# this can be limited to specific python versions IF there is no

# greenlet available for the most recent python. otherwise

# keep this present in all cases

# py{38,39,310,311,312,313,314,313t,314t}: {[greenletextras]extras}

{[greenletextras]extras}

postgresql: postgresql

postgresql: postgresql_pg8000

postgresql: postgresql_psycopg

mysql: mysql

mysql: pymysql

# see https://jira.mariadb.org/browse/CONPY-318.

# installed manually as part of deps w/ version pin

# mysql: mariadb_connector

oracle: oracle

oracle: oracle_oracledb

mssql: mssql

mssql-py{38,39,310,311,312,313}: mssql_pymssql

mssql: mssql-python

install_command=

# TODO: I can find no way to get pip / tox / anyone to have this

# --only-binary option local to the pymssql install, rather than global

# as it is here.

python -I -m pip install --only-binary=pymssql {opts} {packages}

deps=

typing-extensions>=4.13.0rc1

# see https://jira.mariadb.org/browse/CONPY-318.

# using < to block all future versions for now as it's not clear

# if newer versions will fix the segfault or not

mysql: mariadb<1.1.13

pytest>=7.0.0,<10

# tracked by https://github.com/pytest-dev/pytest-xdist/issues/907

pytest-xdist!=3.3.0

dbapimain-sqlite: git+https://github.com/omnilib/aiosqlite.git\#egg=aiosqlite

dbapimain-postgresql: git+https://github.com/psycopg/psycopg2.git\#egg=psycopg2

dbapimain-postgresql: git+https://github.com/MagicStack/asyncpg.git\#egg=asyncpg

dbapimain-postgresql: git+https://github.com/tlocke/pg8000.git\#egg=pg8000

dbapimain-postgresql: git+https://github.com/psycopg/psycopg.git\#egg=psycopg&subdirectory=psycopg

# dbapimain-postgresql: git+https://github.com/psycopg/psycopg.git\#egg=psycopg-c&subdirectory=psycopg_c

dbapimain-mysql: git+https://github.com/PyMySQL/mysqlclient-python.git\#egg=mysqlclient

dbapimain-mysql: git+https://github.com/PyMySQL/PyMySQL.git\#egg=pymysql

dbapimain-oracle: git+https://github.com/oracle/python-cx_Oracle.git\#egg=cx_Oracle

py313-mssql: git+https://github.com/mkleehammer/pyodbc.git\#egg=pyodbc

dbapimain-mssql: git+https://github.com/mkleehammer/pyodbc.git\#egg=pyodbc

cov: pytest-cov

allowlist_externals=sh

setenv=

PYTHONPATH=

PYTHONNOUSERSITE=1

PYTEST_EXCLUDES=-m "not memory_intensive and not mypy"

PYTEST_COLOR={tty:--color=yes}

MYPY_COLOR={tty:--color-output}

BASECOMMAND=python -m pytest {env:PYTEST_COLOR} --rootdir {toxinidir} --log-info=sqlalchemy.testing

WORKERS={env:TOX_WORKERS:-n4 --max-worker-restart=5}

{py313t,py314t}: PYTHON_GIL=0 # when running with 313t, 314t, go for broke

# affect setup.py to skip or build the cython extensions.

nocext: DISABLE_SQLALCHEMY_CEXT=1

cext: REQUIRE_SQLALCHEMY_CEXT=1

cov: COVERAGE={[testenv]cov_args}

backendonly: PYTEST_EXCLUDES="-m backend"

memusage: PYTEST_EXCLUDES="-m memory_intensive"

memusage: EXTRA_SQLITE_DRIVERS={env:EXTRA_SQLITE_DRIVERS:--dbdriver sqlite}

memusage: EXTRA_PG_DRIVERS={env:EXTRA_PG_DRIVERS:--dbdriver psycopg2}

memusage: WORKERS={env:TOX_WORKERS:-n2}

oracle: WORKERS={env:TOX_WORKERS:-n2 --max-worker-restart=5}

oracle: ORACLE={env:TOX_ORACLE:--db oracle}

oracle: EXTRA_ORACLE_DRIVERS={env:EXTRA_ORACLE_DRIVERS:--dbdriver cx_oracle --dbdriver oracledb --dbdriver oracledb_async}

oracle-nogreenlet: EXTRA_ORACLE_DRIVERS={env:EXTRA_ORACLE_DRIVERS:--dbdriver cx_oracle --dbdriver oracledb}

sqlite: SQLITE={env:TOX_SQLITE:--db sqlite}

sqlite-py{38,39,310,311,312,313,314}: EXTRA_SQLITE_DRIVERS={env:EXTRA_SQLITE_DRIVERS:--dbdriver sqlite --dbdriver pysqlite_numeric --dbdriver aiosqlite}

sqlite-nogreenlet: EXTRA_SQLITE_DRIVERS={env:EXTRA_SQLITE_DRIVERS:--dbdriver sqlite --dbdriver pysqlite_numeric}

sqlite_file: SQLITE={env:TOX_SQLITE_FILE:--db sqlite_file}

sqlite_file: EXTRA_SQLITE_DRIVERS={env:EXTRA_SQLITE_DRIVERS:--dbdriver sqlite --dbdriver aiosqlite}

sqlite_file-nogreenlet: EXTRA_SQLITE_DRIVERS={env:EXTRA_SQLITE_DRIVERS:--dbdriver sqlite}

postgresql: POSTGRESQL={env:TOX_POSTGRESQL:--db postgresql}

postgresql: EXTRA_PG_DRIVERS={env:EXTRA_PG_DRIVERS:--dbdriver psycopg2 --dbdriver asyncpg --dbdriver pg8000 --dbdriver psycopg --dbdriver psycopg_async}

postgresql-nogreenlet: EXTRA_PG_DRIVERS={env:EXTRA_PG_DRIVERS:--dbdriver psycopg2 --dbdriver pg8000 --dbdriver psycopg}

postgresql-{py313t,py314t}: EXTRA_PG_DRIVERS={env:EXTRA_PG_DRIVERS:--dbdriver psycopg2 --dbdriver pg8000 --dbdriver psycopg --dbdriver psycopg_async}

mysql: MYSQL={env:TOX_MYSQL:--db mysql}

mysql: EXTRA_MYSQL_DRIVERS={env:EXTRA_MYSQL_DRIVERS:--dbdriver mysqldb --dbdriver pymysql --dbdriver asyncmy --dbdriver mariadbconnector}

mysql-nogreenlet: EXTRA_MYSQL_DRIVERS={env:EXTRA_MYSQL_DRIVERS:--dbdriver mysqldb --dbdriver pymysql --dbdriver mariadbconnector}

# for mssql, aioodbc frequently segfaults under free-threaded builds

mssql: MSSQL={env:TOX_MSSQL:--db mssql}

mssql: EXTRA_MSSQL_DRIVERS={env:EXTRA_MSSQL_DRIVERS:--dbdriver pyodbc --dbdriver aioodbc --dbdriver pymssql --dbdriver mssqlpython}

mssql-py314: EXTRA_MSSQL_DRIVERS={env:EXTRA_MSSQL_DRIVERS:--dbdriver pyodbc --dbdriver aioodbc --dbdriver mssqlpython}

mssql-{py313t,py314t,nogreenlet: EXTRA_MSSQL_DRIVERS={env:EXTRA_MSSQL_DRIVERS:--dbdriver pyodbc --dbdriver pymssql}

oracle,mssql,sqlite_file: IDENTS=--write-idents db_idents.txt

passenv=

ORACLE_HOME

NLS_LANG

TOX_POSTGRESQL

TOX_POSTGRESQL_PY2K

TOX_MYSQL

TOX_MYSQL_PY2K

TOX_ORACLE

TOX_MSSQL

TOX_SQLITE

TOX_SQLITE_FILE

TOX_WORKERS

EXTRA_SQLITE_DRIVERS

EXTRA_PG_DRIVERS

EXTRA_MYSQL_DRIVERS

EXTRA_ORACLE_DRIVERS

PYTHON_GIL

commands=

# removing *.so from lib/ is only useful when usedevelop=True is enabled,

# otherwise the library was already installed in the tox env with or

# without the cython extensions built. We use usedevelop=True for coverage

# mode.

nocext: sh -c "rm -f lib/sqlalchemy/*.so"

nogreenlet: pip uninstall -y greenlet

{env:BASECOMMAND} {env:WORKERS} {env:SQLITE:} {env:EXTRA_SQLITE_DRIVERS:} {env:POSTGRESQL:} {env:EXTRA_PG_DRIVERS:} {env:MYSQL:} {env:EXTRA_MYSQL_DRIVERS:} {env:ORACLE:} {env:EXTRA_ORACLE_DRIVERS:} {env:MSSQL:} {env:EXTRA_MSSQL_DRIVERS:} {env:IDENTS:} {env:PYTEST_EXCLUDES:} {env:COVERAGE:} {posargs}

oracle,mssql,sqlite_file: python reap_dbs.py db_idents.txt

python tools/warn_tox.py

deps=

greenlet >= 1

mypy >= 2.4

types-greenlet

commands =

mypy {env:MYPY_COLOR} ./lib/sqlalchemy

python tools/warn_tox.py

extras =

{[greenletextras]extras}

deps=

pytest>=7.0.0rc1,<10

pytest-xdist

greenlet >= 1

mypy >= 2.4

types-greenlet

extras=

{[greenletextras]extras}

commands =

pytest {env:PYTEST_COLOR} -m mypy {posargs}

python tools/warn_tox.py

deps=

{[testenv:mypy]deps}

pytest-cov

extras=

{[greenletextras]extras}

commands =

pytest {env:PYTEST_COLOR} -m mypy {env:COVERAGE} {posargs}

python tools/warn_tox.py

setenv=

COVERAGE={[testenv]cov_args}

basepython = python3

extras=

{[greenletextras]extras}

deps=

flake8-pyproject

flake8>=7.3.0

flake8-import-order>=0.19.2

flake8-builtins

flake8-future-annotations>=0.0.5

flake8-docstrings>=1.6.0

flake8-import-single==0.1.5

flake8-unused-arguments

flake8-rst-docstrings

# flake8-rst-docstrings dependency, leaving it here

# in case it requires a version pin

pydocstyle

pygments

black==26.10.1

slotscheck>=0.17.0

# required by generate_tuple_map_overloads

zimports>=0.7.0

allowlist_externals =

env

git

sh

commands =

flake8p ./lib/ ./test/ ./examples/ setup.py doc/build/conf.py {posargs}

# run "unused argument" lints on asyncio, as we have a lot of

# proxy methods here

flake8p --ignore='' --select='U100,U101' ./lib/sqlalchemy/ext/asyncio ./lib/sqlalchemy/orm/scoping.py

black --check ./lib/ ./test/ ./examples/ setup.py doc/build/conf.py

slotscheck -m sqlalchemy

python ./tools/format_docs_code.py --check

python ./tools/generate_tuple_map_overloads.py --check

python ./tools/generate_proxy_methods.py --check

python ./tools/sync_test_files.py --check

python ./tools/generate_sql_functions.py --check

python ./tools/normalize_file_headers.py --check

python ./tools/cython_imports.py --check

python ./tools/walk_packages.py

basepython = {[testenv:lint]basepython}

deps = {[testenv:lint]deps}

allowlist_externals = {[testenv:lint]allowlist_externals}

commands = {[testenv:lint]commands}

extras = {[testenv:lint]extras}

extras=

setenv=

PYTHONNOUSERSITE=1

WORKERS={env:TOX_WORKERS:-n4 --max-worker-restart=5}

PYTEST_COLOR={tty:--color=yes}

PYTEST_EXCLUDES=-m "not memory_intensive and not mypy and not timing_intensive and not gc_intensive"

SQLITE=--db sqlite

commands=

python -m pytest {env:PYTEST_COLOR} {env:WORKERS} {env:PYTEST_EXCLUDES:} {env:SQLITE} {posargs}

oracle,mssql,sqlite_file: python reap_dbs.py db_idents.txt

extras=

asyncio

aiosqlite

setenv=

{[testenv:githubbase]setenv}

REQUIRE_SQLALCHEMY_CEXT=1

SQLITE=--db sqlite --db aiosqlite

commands=

python -m pytest {env:PYTEST_COLOR} {env:WORKERS} {env:PYTEST_EXCLUDES:} {env:SQLITE} {posargs}

oracle,mssql,sqlite_file: python reap_dbs.py db_idents.txt

extras=

setenv=

{[testenv:githubbase]setenv}

REQUIRE_SQLALCHEMY_CEXT=1

deps = {[testenv:githubbase]deps}

commands=

python -m pytest {env:PYTEST_COLOR} {env:WORKERS} {env:PYTEST_EXCLUDES:} {env:SQLITE} {posargs}

oracle,mssql,sqlite_file: python reap_dbs.py db_idents.txt

extras=

setenv=

{[testenv:githubbase]setenv}

DISABLE_SQLALCHEMY_CEXT=1

deps = {[testenv:githubbase]deps}

commands=

python -m pytest {env:PYTEST_COLOR} {env:WORKERS} {env:PYTEST_EXCLUDES:} {env:SQLITE} {posargs}

oracle,mssql,sqlite_file: python reap_dbs.py db_idents.txt