sqlalchemy / last failing tests

[danielebriggi]

Run on Python 3.6 and Python 3.11

Failing tests:

================================================================================================================================================================================ short test summary info ================================================================================================================================================================================
FAILED test/test_suite.py::CompoundSelectTest_sqlite+sqlitecloud_3_34_1::test_limit_offset_in_unions_from_alias - sqlalchemy.exc.DBAPIError: (sqlitecloud.exceptions.SQLiteCloudOperationalError) near "UNION": syntax error
FAILED test/test_suite.py::CompoundSelectTest_sqlite+sqlitecloud_3_34_1::test_limit_offset_selectable_in_unions - sqlalchemy.exc.DBAPIError: (sqlitecloud.exceptions.SQLiteCloudError) Unable to find command (SELECT some_table.id, some_table.x, some_table.y 
FAILED test/test_suite.py::CompoundSelectTest_sqlite+sqlitecloud_3_34_1::test_order_by_selectable_in_unions - sqlalchemy.exc.DBAPIError: (sqlitecloud.exceptions.SQLiteCloudError) Unable to find command (SELECT some_table.id, some_table.x, some_table.y 
FAILED test/test_suite.py::DeprecatedCompoundSelectTest_sqlite+sqlitecloud_3_34_1::test_limit_offset_selectable_in_unions - sqlalchemy.exc.DBAPIError: (sqlitecloud.exceptions.SQLiteCloudError) Unable to find command (SELECT some_table.id, some_table.x, some_table.y 
FAILED test/test_suite.py::DeprecatedCompoundSelectTest_sqlite+sqlitecloud_3_34_1::test_order_by_selectable_in_unions - sqlalchemy.exc.DBAPIError: (sqlitecloud.exceptions.SQLiteCloudError) Unable to find command (SELECT some_table.id, some_table.x, some_table.y 
FAILED test/test_suite.py::ExceptionTest_sqlite+sqlitecloud_3_34_1::test_integrity_error - sqlalchemy.exc.DBAPIError: (sqlitecloud.exceptions.SQLiteCloudIntegrityError) UNIQUE constraint failed: manual_pk.id
FAILED test/test_suite.py::RowCountTest_sqlite+sqlitecloud_3_34_1::test_multi_delete_rowcount - AssertionError: 0 != 2
FAILED test/test_suite.py::RowCountTest_sqlite+sqlitecloud_3_34_1::test_multi_update_rowcount - AssertionError: 0 != 2
================================================================================================================================================================ 8 failed, 323 passed, 285 skipped in 646.12s (0:10:46) =================================================================================================================================================================

[unatarajan]

I ran the SQLAlchemy test suite against the sqlitecloud-py SDK with the following steps:

1. I cloned the Py SDK:

git clone https://github.com/sqlitecloud/sqlitecloud-py.git

2. In VSCode, I opened the above project in a remote development Docker container running Python v.3.7.
3. From sqlitecloud-py directory, I ran:

pip install -r requirements-dev.txt
cp .env.example .env

4. Here's my .env:

SQLITE_CONNECTION_STRING=sqlitecloud://chtwalrwiz.sqlite.cloud
SQLITE_USER={username}
SQLITE_PASSWORD={password}
SQLITE_API_KEY={apikey}
SQLITE_HOST=chtwalrwiz.sqlite.cloud
SQLITE_DB=chinook.sqlite
SQLITE_PORT=8860

6. I ran the tests:

cd sqlalchemy-sqlitecloud
pytest

Results were similar to test results for SQLAlchemy v1.4. Below are the failing tests to review:

====================================================================== short test summary info =======================================================================
FAILED test/test_suite.py::CompoundSelectTest_sqlitecloud+sqlitecloud_3_34_1::test_limit_offset_in_unions_from_alias - sqlalchemy.exc.DBAPIError: (sqlitecloud.exceptions.SQLiteCloudOperationalError) near "UNION": syntax error
FAILED test/test_suite.py::CompoundSelectTest_sqlitecloud+sqlitecloud_3_34_1::test_limit_offset_selectable_in_unions - sqlalchemy.exc.DBAPIError: (sqlitecloud.exceptions.SQLiteCloudError) Unable to find command (SELECT some_table.id, some_table.x, some_table.y 
FAILED test/test_suite.py::CompoundSelectTest_sqlitecloud+sqlitecloud_3_34_1::test_order_by_selectable_in_unions - sqlalchemy.exc.DBAPIError: (sqlitecloud.exceptions.SQLiteCloudError) Unable to find command (SELECT some_table.id, some_table.x, some_table.y 
FAILED test/test_suite.py::DeprecatedCompoundSelectTest_sqlitecloud+sqlitecloud_3_34_1::test_limit_offset_selectable_in_unions - sqlalchemy.exc.DBAPIError: (sqlitecloud.exceptions.SQLiteCloudError) Unable to find command (SELECT some_table.id, some_table.x, some_table.y 
FAILED test/test_suite.py::DeprecatedCompoundSelectTest_sqlitecloud+sqlitecloud_3_34_1::test_order_by_selectable_in_unions - sqlalchemy.exc.DBAPIError: (sqlitecloud.exceptions.SQLiteCloudError) Unable to find command (SELECT some_table.id, some_table.x, some_table.y 
FAILED test/test_suite.py::ExceptionTest_sqlitecloud+sqlitecloud_3_34_1::test_integrity_error - sqlalchemy.exc.DBAPIError: (sqlitecloud.exceptions.SQLiteCloudIntegrityError) UNIQUE constraint failed: manual_pk.id
FAILED test/test_suite.py::RowCountTest_sqlitecloud+sqlitecloud_3_34_1::test_multi_delete_rowcount - AssertionError: 0 != 2
FAILED test/test_suite.py::RowCountTest_sqlitecloud+sqlitecloud_3_34_1::test_multi_update_rowcount - AssertionError: 0 != 2
======================================================= 8 failed, 323 passed, 285 skipped in 499.68s (0:08:19) =======================================================
vscode ➜ /workspaces/sqlitecloud-py/sqlalchemy-sqlitecloud (main) $