Drop SQLAlchemy v1.3 support ref #1337

seratch · seratch · commit f65d89b6bccc · 2023-02-18T15:58:26.000+09:00
diff --git a/.github/workflows/ci-build.yml b/.github/workflows/ci-build.yml
@@ -31,6 +31,12 @@ jobs:
     - name: Run validation
       run: |
         python setup.py validate
+    - name: Run tests for SQLAlchemy v1.4 (backward-compatibility)
+      run: |
+        # Install v1.4 for testing
+        pip install "SQLAlchemy>=1.4,<2"
+        python setup.py unit_tests --test-target tests/slack_sdk/oauth/installation_store/test_sqlalchemy.py && \
+        python setup.py unit_tests --test-target tests/slack_sdk/oauth/state_store/test_sqlalchemy.py
     - name: Run codecov (only 3.9)
       run: |
         python_version=`python -V`
diff --git a/setup.py b/setup.py
@@ -337,7 +337,9 @@ def run(self):
             # used only under slack_sdk/*_store
             "boto3<=2",
             # InstallationStore/OAuthStateStore
-            "SQLAlchemy>=1,<3",
+            # Since v3.20, we no longer support SQLAlchemy 1.3 or older.
+            # If you need to use a legacy version, please add our v3.19.5 code to your project.
+            "SQLAlchemy>=1.4,<3",
             # Socket Mode
             # websockets 9 is not compatible with Python 3.10
             "websockets>=10,<11" if sys.version_info.minor > 6 else "websockets>=9.1,<10",
