python - 尝试使用 Flask 和 SQLAlchemy 访问现有 MySQL 数据库时收到 "No Such Table"错误

Question

myapp.py

#!flask/bin/python
from flask import Flask, request, jsonify
from flask.ext.sqlalchemy import SQLAlchemy

app = Flask(__name__)
db = SQLAlchemy(app)

app.config['SQLAlchemy_DATABASE_URI'] = 'mysql://root:root@localhost/linkmanager'

class Link(db.Model):
    __tablename__ = 'link'
    id = db.Column(db.Integer, primary_key = True)
    title = db.Column(db.Text)
    url = db.Column(db.Text)
    type = db.Column(db.Integer)
    insert_date = db.Column(db.DateTime)

@app.route('/links', methods=['GET'])
def links():
    if request.method == 'GET':
        results = Link.query.limit(10).offset(0).all()

        json_results = []
        for result in results:
            d = {
                    'id': results.id,
                    'title': results.title,
                    'url': results.url,
                    'type': results.type,
                    'insert_date': results.insert_date
                }
            json_results.append(d)
        return jsonify(items=json_results)

if __name__ == '__main__':
    app.run(debug=True)

当我尝试访问 localhost:5000/links 时出现错误消息:

sqlalchemy.exc.OperationalError操作错误:(操作错误)没有这样的表:链接u'SELECT link.id AS link_id，link.title AS link_title，link.url AS link_url，link.type AS link_type，link.insert_date AS link_insert_date\nFROM link\n LIMIT？抵消 ？' (10, 0)

我知道该表确实存在，因为我使用 phpAdmin 设置了它并从命令行访问了它。我也尝试用 Java 连接到它并且成功了......我不知道为什么这不起作用!感谢您的帮助。

Answer 1

您的设置名称错误。改变

app.config['SQLAlchemy_DATABASE_URI'] = 'mysql://root:root@localhost/linkmanager'

至

app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql://root:root@localhost/linkmanager'