Demonstrates creating a TCP connection to Cloud SQL for SQL Server using SQLAlchemy.
Documentation pages that include this code sample
To view the code sample used in context, see the following documentation:
- Connecting from App Engine flexible environment to Cloud SQL
- Connecting from App Engine standard environment to Cloud SQL
- Connecting from Cloud Functions to Cloud SQL
- Connecting from Cloud Run to Cloud SQL
- Connecting Overview
- Connecting using the Cloud SQL Auth proxy
# Remember - storing secrets in plaintext is potentially unsafe. Consider using # something like https://cloud.google.com/secret-manager/docs/overview to help keep # secrets secret. db_user = os.environ["DB_USER"] db_pass = os.environ["DB_PASS"] db_name = os.environ["DB_NAME"] db_host = os.environ["DB_HOST"] # Extract host and port from environment variable DB_HOST host_args = db_host.split(":") db_hostname, db_port = host_args, int(host_args) # SQL Server drivers don't account for this if db_hostname == "localhost": db_hostname = "127.0.0.1" # The SQLAlchemy engine will help manage interactions, including automatically # managing a pool of connections to your database pool = sqlalchemy.create_engine( # Equivalent URL: # mssql+pytds://<db_user>:<db_pass>@/<host>:<port>/<db_name>?driver=ODBC+Driver+17+for+SQL+Server sqlalchemy.engine.url.URL.create( "mssql+pytds", username=db_user, password=db_pass, database=db_name, host=db_hostname, port=db_port, ), **db_config )
To search and filter code samples for other Google Cloud products, see the Google Cloud sample browser.