如何在Kubernetes集群中运行python的pymysql作为dockerized容器的一部分来连接到Google Cloud SQL？

FROM python:3.9

# 安装所需的依赖项
RUN pip install pymysql

# 设置工作目录
WORKDIR /app

# 将应用程序代码复制到容器中
COPY . /app

# 设置入口点命令
CMD ["python", "app.py"]

docker build -t your-image-name:tag .
docker push your-image-name:tag

apiVersion: apps/v1
kind: Deployment
metadata:
  name: your-deployment
spec:
  replicas: 1
  selector:
    matchLabels:
      app: your-app
  template:
    metadata:
      labels:
        app: your-app
    spec:
      containers:
        - name: your-container
          image: your-image-name:tag
          ports:
            - containerPort: 8080
          env:
            - name: DB_HOST
              value: your-cloud-sql-instance-connection-name
            - name: DB_USER
              value: your-db-username
            - name: DB_PASSWORD
              value: your-db-password

kubectl apply -f your-deployment-file.yaml

kubectl get pods

import pymysql

# 连接到Google Cloud SQL
connection = pymysql.connect(
    host='your-cloud-sql-instance-connection-name',
    user='your-db-username',
    password='your-db-password',
    db='your-db-name',
    charset='utf8mb4',
    cursorclass=pymysql.cursors.DictCursor
)

# 执行SQL查询
try:
    with connection.cursor() as cursor:
        sql = "SELECT * FROM your-table"
        cursor.execute(sql)
        result = cursor.fetchall()
        print(result)
finally:
    connection.close()