Testing is done using pytest. After installing pytest via pip, a typical run of the SQLAlchemy test suite
can be performed by running:
(venv) C:\Users\Gord\git\sqlalchemy-access>pytest
or, for more verbose output:
(venv) C:\Users\Gord\git\sqlalchemy-access>pytest -v
IMPORTANT:
- Enable ExtendedAnsiSQL (
ExtendedAnsiSQL=1) in your ODBC DSN. - Due to a limitation in Access ODBC, a couple of tests require the testing database to contain a User-defined
System Table named
USysSQLAlchemyDUAL. The table must contain exactly one (1) row, but currently the values in that row are irrelevant.