如何使用App Engine中的Python3连接Google Cloud平台中的SQL实例

runtime: python39
instance_class: F2

env_variables:
  CLOUD_SQL_CONNECTION_NAME: <your-connection-name>
  DB_USER: <your-db-username>
  DB_PASSWORD: <your-db-password>
  DB_NAME: <your-db-name>

import pymysql

# 从环境变量中获取连接信息
connection_name = os.environ.get('CLOUD_SQL_CONNECTION_NAME')
db_user = os.environ.get('DB_USER')
db_password = os.environ.get('DB_PASSWORD')
db_name = os.environ.get('DB_NAME')

# 创建数据库连接
conn = pymysql.connect(
    unix_socket=f'/cloudsql/{connection_name}',
    user=db_user,
    password=db_password,
    db=db_name,
    cursorclass=pymysql.cursors.DictCursor
)

# 执行SQL查询
with conn.cursor() as cursor:
    sql = "SELECT * FROM your_table"
    cursor.execute(sql)
    results = cursor.fetchall()

# 关闭数据库连接
conn.close()

gcloud app deploy