postgresql - 将谷歌云功能连接到云 sql (postgreSQL)
问题描述
我正在尝试将谷歌云功能与谷歌云 sql (postgreSQL) 连接起来。
我找到了文档并对文档做了完全相同的事情(我认为......)但我得到了错误。
https://cloud.google.com/sql/docs/postgres/quickstart-connect-functions
我的云功能需求.txt
SQLAlchemy==1.3.12
pg8000==1.13.2
和我的 main.py
import sqlalchemy
# Set the following variables depending on your specific
# connection name and root password from the earlier steps:
connection_name = "tram-2020:us-central1:tram"
db_password = "[my password]"
db_name = "guestbook"
db_user = "postgres"
driver_name = 'postgres+pg8000'
query_string = dict({"unix_sock": "/cloudsql/{}/.s.PGSQL.5432".format(connection_name)})
def insert(request):
request_json = request.get_json()
stmt = sqlalchemy.text('INSERT INTO entries (guestName, content) values ("third guest", "Also this one");')
db = sqlalchemy.create_engine(
sqlalchemy.engine.url.URL(
drivername=driver_name,
username=db_user,
password=db_password,
database=db_name,
query=query_string,
),
pool_size=5,
max_overflow=2,
pool_timeout=30,
pool_recycle=1800
)
try:
with db.connect() as conn:
conn.execute(stmt)
except Exception as e:
return 'Error: {}'.format(str(e))
return 'ok'
我得到了这样的错误
Error: (pg8000.core.ProgrammingError) {'S': 'ERROR', 'V': 'ERROR', 'C': '42703', 'M': 'column "third guest" does not exist', 'P': '50', 'F': 'parse_relation.c', 'L': '3359', 'R': 'errorMissingColumn'}
[SQL: INSERT INTO entries (guestName, content) values ("third guest", "Also this one");]
(Background on this error at: http://sqlalche.me/e/f405)
为什么错误说 MissingColumn,我是否使用了错误的查询?请帮助我..我该如何解决这个问题..
解决方案
推荐阅读
- php - 更改路线和内容而不刷新
- sql-server - 尝试在 SQL Server 中计算 YearWeek - 202153 --> 202100
- elasticsearch - elasticsearch需要多少堆内存?
- android - View.OnClickListner 接口不会触发 onClick 方法?
- reactjs - React SPA 中的深层链接正确回退到 index.html;但之后不会导航回深层链接
- flutter - 防止谷歌地图在 SingleChildScrollView 内滚动
- vega-lite - 使用 Vega-Lite 计算同一字段的负值和正值
- javascript - chess.com API 不会带回一些请求
- c# - 防止 XmlDocument 解释 HTML 代码
- php - using arabic words in pdf