googleapis / python-spanner-sqlalchemy

Apache License 2.0
38 stars 28 forks source link

feat: feat: SQLAlchemy 2.0 support #314

Closed asthamohta closed 1 year ago

asthamohta commented 1 year ago

The following PR adds support for the new version of SqlAlchemy 2.0 which has been supported. The PR provides minimal support of feature which were previously supported for SqlAlchemy 1.3 and 1.4 along with a few new functionalities as provided below:

  1. Support Views
  2. Support getting table info for specific schemas
  3. Get view definition
  4. Get multi columns
  5. Get multi indexes
  6. Get multi PK constraint
  7. Get multi foreign keys
  8. Modify table names in tests to not get view info for emulator
  9. Adding test suite for 2.0 support

Along with this, we will now run SqlAlchemy 2.0 as a system test for pre-submits.