This repository was archived by the owner on May 16, 2026. It is now read-only.
Repository navigation
This repository was archived by the owner on May 16, 2026. It is now read-only.
compliance tests not running with pytest >= 7.0.0 #413
Description
For some reason when the latest pytest is installed, I get
(compliance-3-8) (base) ➜ python-bigquery-sqlalchemy git:(tswast-prerelease) ✗ py.test -vv --junitxml=compliance_3.8_sponge_log.xml --reruns=3 --reruns-delay=60 '--only-rerun=403 Exceeded rate limits' '--only-rerun=409 Already Exists' '--only-rerun=404 Not found' '--only-rerun=400 Cannot execute DML over a non-existent table' tests/sqlalchemy_dialect_compliance/test_dialect_compliance.py
/Users/swast/src/github.com/googleapis/python-bigquery-sqlalchemy/.nox/compliance-3-8/lib/python3.8/site-packages/google/cloud/bigquery/client.py:535: UserWarning: Cannot create BigQuery Storage client, the dependency google-cloud-bigquery-storage is not installed.
warnings.warn(
====================================================================== test session starts =======================================================================
platform darwin -- Python 3.8.10, pytest-7.0.1, pluggy-1.0.0 -- /Users/swast/src/github.com/googleapis/python-bigquery-sqlalchemy/.nox/compliance-3-8/bin/python
cachedir: .pytest_cache
rootdir: /Users/swast/src/github.com/googleapis/python-bigquery-sqlalchemy, configfile: setup.cfg
plugins: rerunfailures-10.2
collected 0 items
---------------------- generated xml file: /Users/swast/src/github.com/googleapis/python-bigquery-sqlalchemy/compliance_3.8_sponge_log.xml -----------------------
===================================================================== no tests ran in 1.52s =====================================================================
And it fails with exit code 5. https://docs.pytest.org/en/latest/reference/exit-codes.html "No tests were collected"
Activity
tswast commentedon Feb 14, 2022
This is a known issue with the SQLAlchemy compliance test suite and fixed in 1.4.28 sqlalchemy/sqlalchemy#7436
Unfortunately, we are stuck on an earlier version for the time being. #385
tswast commentedon Feb 14, 2022
Have a temporary fix (cap the pytest version) in #401. Will leave this issue open but reclassify it as a clean-up we can do after updating SQLAlchemy version.
chalmerlowe commentedon Feb 23, 2023
This was cleaned up.
The limitation based on the sqlalchemy version was eliminated (we now test against versions of sqlachemy > 1.4.28
This allowed us to remove the limits on pytest and now we are able to run pytest > 7.0.0.
Closing.