sqlalchemy / last failing tests #32

Activity

1. danielebriggi

   added

   enhancementNew feature or requestNew feature or request

   on Aug 26, 2024
2. danielebriggi

   self-assigned this

   on Aug 26, 2024
3. unatarajan commented on Sep 2, 2024

   

   unatarajan

   on Sep 2, 2024

   More actions

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