prompt: We are currently solving the following issue within our repository. Here is the issue text:
  --- BEGIN ISSUE ---
  Fix sqlalchemy recipe
  Fix sqlalchemy build errors and bump sqlalchemy from 1.3.3 to 2.0+.
  
  
  --- END ISSUE ---
  
  Below are some code segments, each from a relevant file. One or more of these files may contain bugs.
  --- BEGIN FILES ---
  Path: `pythonforandroid/recipes/sqlalchemy/__init__.py`
  Content:
  ```
  1 from pythonforandroid.recipe import CompiledComponentsPythonRecipe
  2 
  3 
  4 class SQLAlchemyRecipe(CompiledComponentsPythonRecipe):
  5     name = 'sqlalchemy'
  6     version = '1.3.3'
  7     url = 'https://pypi.python.org/packages/source/S/SQLAlchemy/SQLAlchemy-{version}.tar.gz'
  8     call_hostpython_via_targetpython = False
  9 
  10     depends = ['setuptools']
  11 
  12     patches = ['zipsafe.patch']
  13 
  14 
  15 recipe = SQLAlchemyRecipe()
  16
  ```
  --- END FILES ---
  
  Please first localize the bug based on the issue statement, and then generate a patch according to the `git diff` format fenced by three backticks.
  
  Here is an example:
  
  ```diff
  diff --git a/examples/server_async.py b/examples/server_async.py
  --- a/examples/server_async.py
  +++ b/examples/server_async.py
  @@ -313,4 +313,4 @@
   
   
   if __name__ == "__main__":
  -    asyncio.run(run_async_server("."), debug=True)
  +    asyncio.run(run_async_server(), debug=True)
  diff --git a/examples/server_sync.py b/examples/server_sync.py
  --- a/examples/server_sync.py
  +++ b/examples/server_sync.py
  @@ -313,5 +313,5 @@
   
   
   if __name__ == "__main__":
  -    server = run_sync_server(".")
  +    server = run_sync_server()
       server.shutdown()
  
  ```
  
golden_diff: diff --git a/pythonforandroid/recipes/sqlalchemy/__init__.py b/pythonforandroid/recipes/sqlalchemy/__init__.py
  --- a/pythonforandroid/recipes/sqlalchemy/__init__.py
  +++ b/pythonforandroid/recipes/sqlalchemy/__init__.py
  @@ -1,15 +1,15 @@
  -from pythonforandroid.recipe import CompiledComponentsPythonRecipe
  +from pythonforandroid.recipe import PyProjectRecipe
   
   
  -class SQLAlchemyRecipe(CompiledComponentsPythonRecipe):
  +class SQLAlchemyRecipe(PyProjectRecipe):
       name = 'sqlalchemy'
  -    version = '1.3.3'
  -    url = 'https://pypi.python.org/packages/source/S/SQLAlchemy/SQLAlchemy-{version}.tar.gz'
  -    call_hostpython_via_targetpython = False
  -
  +    version = '2.0.30'
  +    url = 'https://github.com/sqlalchemy/sqlalchemy/archive/refs/tags/rel_{}.tar.gz'
       depends = ['setuptools']
   
  -    patches = ['zipsafe.patch']
  +    @property
  +    def versioned_url(self):
  +        return self.url.format(self.version.replace(".", "_"))
   
   
   recipe = SQLAlchemyRecipe()
  
verification_info: {"golden_diff": "diff --git a/pythonforandroid/recipes/sqlalchemy/__init__.py b/pythonforandroid/recipes/sqlalchemy/__init__.py\n--- a/pythonforandroid/recipes/sqlalchemy/__init__.py\n+++ b/pythonforandroid/recipes/sqlalchemy/__init__.py\n@@ -1,15 +1,15 @@\n-from pythonforandroid.recipe import CompiledComponentsPythonRecipe\n+from pythonforandroid.recipe import PyProjectRecipe\n \n \n-class SQLAlchemyRecipe(CompiledComponentsPythonRecipe):\n+class SQLAlchemyRecipe(PyProjectRecipe):\n     name = 'sqlalchemy'\n-    version = '1.3.3'\n-    url = 'https://pypi.python.org/packages/source/S/SQLAlchemy/SQLAlchemy-{version}.tar.gz'\n-    call_hostpython_via_targetpython = False\n-\n+    version = '2.0.30'\n+    url = 'https://github.com/sqlalchemy/sqlalchemy/archive/refs/tags/rel_{}.tar.gz'\n     depends = ['setuptools']\n \n-    patches = ['zipsafe.patch']\n+    @property\n+    def versioned_url(self):\n+        return self.url.format(self.version.replace(\".\", \"_\"))\n \n \n recipe = SQLAlchemyRecipe()\n", "issue": "Fix sqlalchemy recipe\nFix sqlalchemy build errors and bump sqlalchemy from 1.3.3 to 2.0+.\r\n\n", "before_files": [{"content": "from pythonforandroid.recipe import CompiledComponentsPythonRecipe\n\n\nclass SQLAlchemyRecipe(CompiledComponentsPythonRecipe):\n    name = 'sqlalchemy'\n    version = '1.3.3'\n    url = 'https://pypi.python.org/packages/source/S/SQLAlchemy/SQLAlchemy-{version}.tar.gz'\n    call_hostpython_via_targetpython = False\n\n    depends = ['setuptools']\n\n    patches = ['zipsafe.patch']\n\n\nrecipe = SQLAlchemyRecipe()\n", "path": "pythonforandroid/recipes/sqlalchemy/__init__.py"}], "after_files": [{"content": "from pythonforandroid.recipe import PyProjectRecipe\n\n\nclass SQLAlchemyRecipe(PyProjectRecipe):\n    name = 'sqlalchemy'\n    version = '2.0.30'\n    url = 'https://github.com/sqlalchemy/sqlalchemy/archive/refs/tags/rel_{}.tar.gz'\n    depends = ['setuptools']\n\n    @property\n    def versioned_url(self):\n        return self.url.format(self.version.replace(\".\", \"_\"))\n\n\nrecipe = SQLAlchemyRecipe()\n", "path": "pythonforandroid/recipes/sqlalchemy/__init__.py"}]}