search

sqlitecloud / sqlitecloud-py

Python drivers for SQLite Cloud
https://sqlitecloud.io
16 stars 2 forks source link

sqlalchemy / last failing tests #32

Open danielebriggi opened 2 months ago

danielebriggi commented 2 months ago

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 commented 2 months ago

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
  5. 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) $