久久福利_99r_国产日韩在线视频_直接看av的网站_中文欧美日韩_久久一

您的位置:首頁技術文章
文章詳情頁

mysql - flask-migrate 創建遷移腳本報錯(ValueError: invalid interpolation syntax)

瀏覽:88日期:2022-06-19 18:08:29

問題描述

我是參照flask web開發這本書,數據庫為mysql,說到flask-migrate,我在用命令 python myblog.py db migrate -m “initial migration”創建數據庫遷移腳本時報以下錯誤

(venv) zhaoyb@zhaoyb-pc:~/PycharmProjects/myblog$ python myblog.py db migrate -m 'initial migration' /home/zhaoyb/PycharmProjects/myblog/venv/lib/python3.5/site-packages/flask_sqlalchemy/__init__.py:800: UserWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True to suppress this warning. warnings.warn(’SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True to suppress this warning.’)Traceback (most recent call last): File 'myblog.py', line 77, in <module> manager.run() File '/home/zhaoyb/PycharmProjects/myblog/venv/lib/python3.5/site-packages/flask_script/__init__.py', line 412, in run result = self.handle(sys.argv[0], sys.argv[1:]) File '/home/zhaoyb/PycharmProjects/myblog/venv/lib/python3.5/site-packages/flask_script/__init__.py', line 383, in handle res = handle(*args, **config) File '/home/zhaoyb/PycharmProjects/myblog/venv/lib/python3.5/site-packages/flask_script/commands.py', line 216, in __call__ return self.run(*args, **kwargs) File '/home/zhaoyb/PycharmProjects/myblog/venv/lib/python3.5/site-packages/flask_migrate/__init__.py', line 173, in migrate version_path=version_path, rev_id=rev_id) File '/home/zhaoyb/PycharmProjects/myblog/venv/lib/python3.5/site-packages/alembic/command.py', line 117, in revision script_directory.run_env() File '/home/zhaoyb/PycharmProjects/myblog/venv/lib/python3.5/site-packages/alembic/script/base.py', line 407, in run_env util.load_python_file(self.dir, ’env.py’) File '/home/zhaoyb/PycharmProjects/myblog/venv/lib/python3.5/site-packages/alembic/util/pyfiles.py', line 93, in load_python_file module = load_module_py(module_id, path) File '/home/zhaoyb/PycharmProjects/myblog/venv/lib/python3.5/site-packages/alembic/util/compat.py', line 68, in load_module_py module_id, path).load_module(module_id) File '<frozen importlib._bootstrap_external>', line 388, in _check_name_wrapper File '<frozen importlib._bootstrap_external>', line 809, in load_module File '<frozen importlib._bootstrap_external>', line 668, in load_module File '<frozen importlib._bootstrap>', line 268, in _load_module_shim File '<frozen importlib._bootstrap>', line 693, in _load File '<frozen importlib._bootstrap>', line 673, in _load_unlocked File '<frozen importlib._bootstrap_external>', line 665, in exec_module File '<frozen importlib._bootstrap>', line 222, in _call_with_frames_removed File 'migrations/env.py', line 22, in <module> current_app.config.get(’SQLALCHEMY_DATABASE_URI’)) File '/home/zhaoyb/PycharmProjects/myblog/venv/lib/python3.5/site-packages/alembic/config.py', line 218, in set_main_option self.set_section_option(self.config_ini_section, name, value) File '/home/zhaoyb/PycharmProjects/myblog/venv/lib/python3.5/site-packages/alembic/config.py', line 245, in set_section_option self.file_config.set(section, name, value) File '/usr/lib/python3.5/configparser.py', line 1190, in set super().set(section, option, value) File '/usr/lib/python3.5/configparser.py', line 891, in set value) File '/usr/lib/python3.5/configparser.py', line 401, in before_set 'position %d' % (value, tmp_value.find(’%’)))ValueError: invalid interpolation syntax in ’mysql+pymysql://××××××:×××××××××××@localhost/myblog’ at position 27

這是我的程序代碼

from flask import Flask, render_template, flashfrom flask_wtf import Formfrom wtforms import StringField, SubmitField, PasswordFieldfrom wtforms.validators import Requiredfrom flask_script import Managerfrom flask_bootstrap import Bootstrapfrom flask_sqlalchemy import SQLAlchemyfrom flask_script import Shellfrom flask_migrate import Migrate, MigrateCommandapp = Flask(__name__)app.config[’SECRET_KEY’] = ’hard to guess string’app.config[’SQLALCHEMY_DATABASE_URI’] = ’mysql+pymysql://××××××:××××××××××@localhost/myblog’app.config[’SQLALCHEMY_COMMIT_ON_TEARDOWN’] = Trueapp.config[’DEBUG’] = Truebootstrap = Bootstrap(app)db = SQLAlchemy(app)manager = Manager(app)migrate = Migrate(app, db)manager.add_command(’db’, MigrateCommand)def make_shell_context(): return dict(app=app, db=db, User=User, Role=Role)class User(db.Model): __tablename__ = ’users’ id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(64), unique=True, index=True) role_id = db.Column(db.Integer, db.ForeignKey(’roles.id’)) def __repr__(self):return ’<User %r>’ % self.usernameclass Role(db.Model): __tablename__ = ’roles’ id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(64), unique=True) users = db.relationship(’User’, backref=’role’) def __repr__(self):return ’<Role %r>’ % self.nameclass LoginForm(Form): username = StringField(’用戶名’, validators=[Required()]) password = PasswordField(’密碼’, validators=[Required()]) login = SubmitField(’登錄’)@app.route(’/’, methods=[’GET’, ’POST’])def index(): form = LoginForm() return render_template(’index.html’, form=form, is_active=True)@app.route(’/tweet’)def tweet(): form = LoginForm() return render_template(’tweet.html’, is_actived=True, form=form)@app.errorhandler(404)def page_not_found(e): return render_template(’404.html’), 404@app.errorhandler(404)def page_not_found(e): return render_template(’500.html’), 500manager.add_command(’shell’, Shell(make_context=make_shell_context))if __name__ == ’__main__’: manager.run()

請大家幫我看看

………………………………………………………………………………………………………………

問題原因已找到,書的作者給了回答mysql - flask-migrate 創建遷移腳本報錯(ValueError: invalid interpolation syntax)竟然是mysql密碼里面包含%(話說這個問題真的很難想到,希望大家引以為戒)

問題解答

回答1:

說的很清楚:

ValueError: invalid interpolation syntax in ’mysql+pymysql://××××××:×××××××××××@localhost/myblog’ at position 27

你的URI格式有問題, 建議你用標準的格式: http://flask-sqlalchemy.pocoo...

標準格式的話你需要安裝mysqldb, 有點小坑, 安裝可以參考下面2個鏈接

http://stackoverflow.com/ques...

http://stackoverflow.com/ques...

相關文章:
主站蜘蛛池模板: av一区二区三区 | 欧美日韩中文字幕在线播放 | 成人综合在线观看 | 国产超碰人人爽人人做人人爱 | 国产黄色大片 | 日韩亚洲欧美综合 | 久久精品久久久 | 午夜精品视频 | 日日网 | 999久久久国产999久久久 | 操碰97| 999精品一区 | 欧美精品综合 | 国产亚洲一区在线 | 久久精品欧美一区二区三区不卡 | 日韩在线 | 成人在线免费 | 亚洲一区二区三区四区五区中文 | 欧美日本国产 | 成人免费aaa | 精品国产一区二区三区免费 | 欧美污污 | 成人久久久久久久久 | 国产成人福利视频 | 黄色一级免费电影 | 中文字幕第66页 | 一级免费在线视频 | 国产亚洲欧美在线 | 日韩免费av一区二区 | 国产欧美久久久久久 | 日本精品免费在线观看 | 精久久| 国产999精品久久久久久 | 综合色婷婷一区二区亚洲欧美国产 | 国产在线视频网站 | 国产精品久久久久久婷婷天堂 | 特级毛片在线 | 欧美日韩在线一区 | 欧美日韩国产一区二区三区不卡 | 亚洲国产日本 | 亚州成人 |