av一区二区在线观看_亚洲男人的天堂网站_日韩亚洲视频_在线成人免费_欧美日韩精品免费观看视频_久草视

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

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

瀏覽:80日期: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...

相關文章:
主站蜘蛛池模板: 日韩欧美三级电影 | 999国产精品视频 | 久久久久久中文字幕 | 久久国产成人 | 一区二区三区日韩 | 可以看黄的视频 | 一区二区三区四区在线视频 | 99精品一区二区三区 | 色视频www在线播放国产人成 | 亚洲高清电影 | 国产精品99999999 | 久久99久久98精品免观看软件 | 国产欧美精品 | 在线欧美小视频 | 狠狠的干| 国产欧美在线 | 91在线观看免费 | 玖玖视频免费 | 国产午夜精品理论片a大结局 | 夜夜爆操 | 亚洲一区视频在线 | 日韩在线大片 | 少妇久久久久 | 国产一区二区在线免费观看 | 香蕉久久久久久 | 欧美日韩一区二区在线 | 成年人免费网站 | 亚洲一区二区在线视频 | 99精品欧美一区二区三区综合在线 | 99久久精品免费看国产免费软件 | 亚洲一区二区三区在线 | 狠狠爱网址 | 亚洲国产成人av好男人在线观看 | 凹凸日日摸日日碰夜夜 | 精品国产一区二区三区免费 | yeyeav| 国产永久免费 | 99r在线| 色婷婷亚洲国产女人的天堂 | 亚洲成人免费电影 | 欧美福利|