Fix deprecation warning for sqlalchemy 1.4 (GoogleCloudPlatform#5834)

Andrei-Paul · Takashi Matsuo · shubha-rajan · web-flow · commit f9dc2d67efc9 · 2021-05-21T16:13:41.000-07:00
Calling URL() directly is deprecated and will be disabled in a future release.  The public constructor for URL is now the URL.create() method.
Fixed "# Equivalent URL:" example typo.

Co-authored-by: Takashi Matsuo &lt;tmatsuo@google.com&gt;
Co-authored-by: Shubha Rajan &lt;shubhadayini@google.com&gt;
diff --git a/cloud-sql/postgres/sqlalchemy/main.py b/cloud-sql/postgres/sqlalchemy/main.py
@@ -78,8 +78,8 @@ def init_tcp_connection_engine(db_config):
 
     pool = sqlalchemy.create_engine(
         # Equivalent URL:
-        # postgres+pg8000://<db_user>:<db_pass>@<db_host>:<db_port>/<db_name>
-        sqlalchemy.engine.url.URL(
+        # postgresql+pg8000://<db_user>:<db_pass>@<db_host>:<db_port>/<db_name>
+        sqlalchemy.engine.url.URL.create(
             drivername="postgresql+pg8000",
             username=db_user,  # e.g. "my-database-user"
             password=db_pass,  # e.g. "my-database-password"
@@ -108,9 +108,9 @@ def init_unix_connection_engine(db_config):
     pool = sqlalchemy.create_engine(
 
         # Equivalent URL:
-        # postgres+pg8000://<db_user>:<db_pass>@/<db_name>
+        # postgresql+pg8000://<db_user>:<db_pass>@/<db_name>
         #                         ?unix_sock=<socket_path>/<cloud_sql_instance_name>/.s.PGSQL.5432
-        sqlalchemy.engine.url.URL(
+        sqlalchemy.engine.url.URL.create(
             drivername="postgresql+pg8000",
             username=db_user,  # e.g. "my-database-user"
             password=db_pass,  # e.g. "my-database-password"
