ModuleNotFoundError：尝试使用 python 连接器连接到 cloudsql 实例时没有名为"google"的模块

Question

getconn现在设置为私有IP

对于下面的代码，我得到ModuleNotFoundError:在第2行没有名为"google"的模块，有人能告诉我在这里安装什么python包吗?

from google.cloud.sql.connector import Connector, IPTypes
import sqlalchemy
def getconn():
conn = connector.connect(
"instancename", # ::
"pymysql",
user="root",
password="secret",
db="mysql",
ip_type=IPTypes.PRIVATE
)
return conn
# create connection pool
pool = sqlalchemy.create_engine(
"mysql+pymysql://",
creator=getconn,
)
# connect to connection pool
with pool.connect() as db_conn:
# query database and fetch results
results = db_conn.execute("SHOW TABLES ")
# show results
for row in results:
print(row)
# cleanup connector
connector.close()

Answer 1

您可能没有安装库:

python3 -m venv venv
source venv/bin/activate
python3 -m pip install cloud-sql-python-connector==0.9.3
python3 -m pip freeze | grep cloud
# cloud-sql-python-connector==0.9.3

参见库的文档:cloud-sql-python-connector