你可以使用
flask.current_app
相反。您还必须配置
flask-sqlalchemy
要使用CloudSQL提供的Unix域套接字,请执行以下操作:
from flask import current_app as app
from flask_sqlalchemy import SQLAlchemy
db_user = os.environ.get('CLOUD_SQL_USERNAME')
db_password = os.environ.get('CLOUD_SQL_PASSWORD')
db_name = os.environ.get('CLOUD_SQL_DATABASE_NAME')
db_connection_name = os.environ.get('CLOUD_SQL_CONNECTION_NAME')
app.config['SQLALCHEMY_DATABASE_URI'] = f'postgresql://{db_user}:{db_password}@/{db_name}?host=/cloudsql/{db_connection_name}'
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
db = SQLAlchemy(app)
...
然后您可以查询
User
在您的函数中建模:
def my_function(request):
user = User.query.first()
return f"Hello {user.username)!"