fix: sqlalchemy dependencies (GoogleCloudPlatform#12760)

wiktorn · web-flow · commit dfdeaad78254 · 2025-01-23T10:38:32.000-05:00
diff --git a/cloud-sql/mysql/sqlalchemy/Dockerfile b/cloud-sql/mysql/sqlalchemy/Dockerfile
@@ -1,4 +1,4 @@
-# Copyright 2019 Google, LLC.
+# Copyright 2019 Google LLC
 #
 # Licensed under the Apache License, Version 2.0 (the "License");
 # you may not use this file except in compliance with the License.
@@ -14,7 +14,9 @@
 
 # Use the official Python image.
 # https://hub.docker.com/_/python
-FROM python:3.11
+FROM python:3.13
+
+RUN apt-get update
 
 # Copy application dependency manifests to the container image.
 # Copying this separately prevents re-running pip install on every code change.
diff --git a/cloud-sql/mysql/sqlalchemy/requirements.txt b/cloud-sql/mysql/sqlalchemy/requirements.txt
@@ -1,5 +1,5 @@
 Flask==2.2.2
-SQLAlchemy==2.0.24
+SQLAlchemy==2.0.36
 PyMySQL==1.1.1
 gunicorn==22.0.0
 cloud-sql-python-connector==1.2.4
diff --git a/cloud-sql/postgres/sqlalchemy/Dockerfile b/cloud-sql/postgres/sqlalchemy/Dockerfile
@@ -1,4 +1,4 @@
-# Copyright 2019 Google, LLC.
+# Copyright 2019 Google LLC
 #
 # Licensed under the Apache License, Version 2.0 (the "License");
 # you may not use this file except in compliance with the License.
@@ -14,7 +14,9 @@
 
 # Use the official Python image.
 # https://hub.docker.com/_/python
-FROM python:3
+FROM python:3.13
+
+RUN apt-get update
 
 # Copy application dependency manifests to the container image.
 # Copying this separately prevents re-running pip install on every code change.
diff --git a/cloud-sql/postgres/sqlalchemy/requirements.txt b/cloud-sql/postgres/sqlalchemy/requirements.txt
@@ -1,6 +1,6 @@
 Flask==2.2.2
 pg8000==1.31.2
-SQLAlchemy==2.0.24
+SQLAlchemy==2.0.36
 cloud-sql-python-connector==1.9.1
 gunicorn==22.0.0
 functions-framework==3.5.0
diff --git a/cloud-sql/sql-server/sqlalchemy/Dockerfile b/cloud-sql/sql-server/sqlalchemy/Dockerfile
@@ -1,4 +1,4 @@
-# Copyright 2020 Google, LLC.
+# Copyright 2020 Google LLC
 #
 # Licensed under the Apache License, Version 2.0 (the "License");
 # you may not use this file except in compliance with the License.
@@ -14,7 +14,7 @@
 
 # Use the official Python image.
 # https://hub.docker.com/_/python
-FROM python:3.11-buster
+FROM python:3.13
 
 RUN apt-get update
 
diff --git a/cloud-sql/sql-server/sqlalchemy/requirements.txt b/cloud-sql/sql-server/sqlalchemy/requirements.txt
@@ -2,7 +2,7 @@ Flask==2.2.2
 gunicorn==22.0.0
 python-tds==1.15.0
 pyopenssl==24.0.0
-SQLAlchemy==2.0.24
+SQLAlchemy==2.0.36
 cloud-sql-python-connector==1.9.1
 sqlalchemy-pytds==1.0.2
 functions-framework==3.5.0
