python - 如何使用 SQLAlchemy 将远程 mySQL 数据库连接到烧瓶应用程序?
问题描述
我想将在线 MySQL DB 连接到我制作的烧瓶应用程序,这样我就可以摆脱 localhost 的东西。
我有这个代码
from flask import Flask, request, jsonify
from flask_sqlalchemy import SQLAlchemy
import os
import uuid
from werkzeug.security import generate_password_hash , check_password_hash
app = Flask(__name__)
app.config['SECRET_KEY'] = 'thisissecret'
# app.config['SQLALCHEMY_DATABASE_URI'] = os.environ['sqlite:////Users/confuapplication/PycharmProjects/untitled/.db']
app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql://saifaliunity:123123123!@saifaliunity.mysql.pythonanywhere-services.com/saifaliunity$todo';
# app.config['SQLALCHEMY_DATABASE_URI'] = os.environ['DATABASE_URL']
db = SQLAlchemy(app)
很好,这就是 localhost 环境,我已经在线设置了 MySQL 和 python 应用程序,并想为烧瓶应用程序设置 dbname、主机、用户名、密码。但不知道如何做到这一点。
使用下面的答案后,这是错误日志。
2019-02-26 10:16:54,896: Error running WSGI application
2019-02-26 10:16:54,900: ModuleNotFoundError: No module named 'flask_app'
2019-02-26 10:16:54,900: File "/var/www/saifaliunity_pythonanywhere_com_wsgi.py", line 16, in <module>
2019-02-26 10:16:54,900: from flask_app import app as application # noqa
2019-02-26 10:16:54,901: ***************************************************
2019-02-26 10:16:54,901: If you're seeing an import error and don't know why,
2019-02-26 10:16:54,901: we have a dedicated help page to help you debug:
2019-02-26 10:16:54,901: https://help.pythonanywhere.com/pages/DebuggingImportError/
2019-02-26 10:16:54,902: ***************************************************
2019-02-26 12:58:20,238: Error running WSGI application
2019-02-26 12:58:20,278: ModuleNotFoundError: No module named 'flask_app'
2019-02-26 12:58:20,279: File "/var/www/saifaliunity_pythonanywhere_com_wsgi.py", line 16, in <module>
2019-02-26 12:58:20,279: from flask_app import app as application # noqa
2019-02-26 12:58:20,279: ***************************************************
2019-02-26 12:58:20,280: If you're seeing an import error and don't know why,
2019-02-26 12:58:20,280: we have a dedicated help page to help you debug:
2019-02-26 12:58:20,280: https://help.pythonanywhere.com/pages/DebuggingImportError/
2019-02-26 12:58:20,280: ***************************************************
2019-02-26 12:58:21,842: Error running WSGI application
2019-02-26 12:58:21,843: ModuleNotFoundError: No module named 'flask_app'
2019-02-26 12:58:21,843: File "/var/www/saifaliunity_pythonanywhere_com_wsgi.py", line 16, in <module>
2019-02-26 12:58:21,843: from flask_app import app as application # noqa
2019-02-26 12:58:21,844: ***************************************************
2019-02-26 12:58:21,844: If you're seeing an import error and don't know why,
2019-02-26 12:58:21,844: we have a dedicated help page to help you debug:
2019-02-26 12:58:21,844: https://help.pythonanywhere.com/pages/DebuggingImportError/
2019-02-26 12:58:21,844: ***************************************************
解决方案
SQLALCHEMY_DATABASE_URI
应该是、mysql://username:password@server/db
替换username
、password
和使用您的值。server
db
有关更多详细信息,请参阅文档:http: //flask-sqlalchemy.pocoo.org/2.3/config/
推荐阅读
- python - 问:Python 脚本变成 ececutable NOT WORKING (pyinstaller / cx_Freeze)
- solr - 如何查看 Solr 对 Solr 查询未返回的文档的解释
- android - 清洁架构 - 在使用存储库模式和用例刷新的同时获取缓存数据
- php - 将常量的 count() 赋值给常量
- php - 使用php将变量替换为html时无法打开word文档
- django - 使用 docker 时,我无法从 Django 访问挂载目录
- python - 如何将下载和解压缩的文本文件加载到熊猫数据框中?
- python - 使用 sk-learn 基于字符串特征预测数值特征
- javascript - 如何在我的电脑上运行谷歌使用的 JS 代码?
- node.js - 日历邀请 nodejs 中的 icalender