orms / SQLAlchemy support for SQLite Cloud Python driver

[jacobprall]

#2

[unatarajan]

Including

• Py SDK improvements spec with SQLAlchemy requirements and
• the UserWarning that arises when Pandas methods are used.

Will test again after fix is implemented.

[danielebriggi]

Updates for the fix of these tests will be tracked here: #32

---

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

[danielebriggi]

@unatarajan the packaged has been updated. You can see to use sqlalchemy now instead of pandas for sqlitecloud integration