flask-sqlalchemy - 数据库问题“无法从字符串中解析 rfc1738 URL”

Question

错误:无法从字符串解析 rfc1738 URL。我尝试了一切，我想我无法解决它。

app.config['SQLALCHEMY_DATABASE_URI'] = 'C:/dev/FlaskBlog/blog.db'

db = SQLAlchemy(app)

class Blogpost(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(50))
    subtitle = db.Column(db.String(50))
    author = db.Column(db.String(20))
    date_posted = db.Column(db.DateTime)
    content = db.Column(db.Text)

当我尝试发布文章时出现问题。

这是 addpost 路由:

@app.route('/addpost', methods=['POST'])
def addpost():
    if request.method == 'POST':
        title = request.form['title']
        subtitle = request.form['subtitle']
        author = request.form['author']
        content = request.form['content']

        post = Blogpost(title=title, subtitle=subtitle, author=author, date_posted=datetime.now())

        db.session.add(post)
        db.session.commit()

        return redirect(url_for('index'))
    else:
        return render_template('index.html')

Answer 1

这里没有测试文件，无法测试。
但是我遇到了同样的错误，我的数据库是SQLite。以下代码对我来说工作正常:

from sqlalchemy import create_engine

# relative path on Linux: with three slashes
e = create_engine('sqlite:///relative/path/to/database.db')

# absolute path on Linux: with four slashes
e = create_engine('sqlite:////absolute/path/to/database.db')

# absolute path on Windows
e = create_engine('sqlite:///C:\\absolute\\path\\to\\database.db')

在你的情况下，我认为你可以将 app.config['SQLALCHEMY_DATABASE_URI'] = 'C:/dev/FlaskBlog/blog.db' 更改为 app.config[' SQLALCHEMY_DATABASE_URI'] = 'sqlite:///C:\\dev\\FlaskBlog\\blog.db'.

详细文档:SQLAlchemy 1.4 Documentation