亚洲国产日韩欧美一区二区三区,精品亚洲国产成人av在线,国产99视频精品免视看7,99国产精品久久久久久久成人热,欧美日韩亚洲国产综合乱

最近在學(xué)習(xí)Flask Web開發(fā)這本書
用flask-sqlachemy連接到mysql的時候，參考書中提供的URI，把sqlite的改成了mysql的
這是config文件

import os

class Config:
    SECRET_KEY = os.environ.get('SECRET_KEY') or 'hard to guess string'
    FLASKY_ADMIN = os.environ.get('FLASKY_ADMIN')
    SQLALCHEMY_DATABASE_URI = 'mysql+pymysql://root:7123@localhost/database'
    SQLALCHEMY_COMMIT_ON_TEARDOWN = True

    @staticmethod
    def init_app(app):
        pass

config = Config()請輸入代碼

這是__init__文件

from flask import Flask
from flask.ext.bootstrap import Bootstrap
from flask.ext.moment import Moment
from flask.ext.sqlalchemy import SQLAlchemy
from config import config
from flask.ext.login import LoginManager
from flask.ext.pagedown import PageDown
import pymysql

pymysql.install_as_MySQLdb()
bootstrap = Bootstrap()
moment = Moment()
db = SQLAlchemy()
pagedown = PageDown()

login_manager = LoginManager()
login_manager.session_protection = 'strong'
login_manager.login_view = 'auth.login'


def create_app(config):
    app = Flask(__name__)
    app.config.from_object(config)
    config.init_app(app)

    bootstrap.init_app(app)
    moment.init_app(app)
    db.init_app(app)
    login_manager.init_app(app)
    pagedown.init_app(app)

    from .main import main as main_blueprint
    app.register_blueprint(main_blueprint)

    from .auth import auth as auth_blueprint
    app.register_blueprint(auth_blueprint, url_prefix='/auth')

    return app

@login_manager.user_loader
def load_user(user_id):
    return User.query.get(int(user_id))

這是啟動文件manage

#!/usr/bin/env python
import os
from app import create_app, db
from app.models import User, Role
from flask.ext.script import Manager, Shell
from flask.ext.migrate import Migrate, MigrateCommand
from config import config
from flask.ext.sqlalchemy import SQLAlchemy


app = create_app(config)
manager = Manager(app)
migrate = Migrate(app, db)


def make_shell_context():
    return dict(app=app, db=db, User=User, Role=Role)
manager.add_command("shell", Shell(make_context=make_shell_context))
manager.add_command('db', MigrateCommand)


@manager.command
def test():
    """Run the unit tests."""
    import unittest
    tests = unittest.TestLoader().discover('tests')
    unittest.TextTestRunner(verbosity=2).run(tests)


if __name__ == '__main__':
    manager.run()

在使用python manage.py shell后，使用db.create_all()
拋出錯誤

raise InternalError(errno, errorvalue)
sqlalchemy.exc.InternalError: (InternalError) (1049, "Unknown database 'database'") None None

找了半天，開始的時候就是直接改的config里的SQLALCHEMY_DATABASE_URI，會出現(xiàn)ImportError: No module named 'MySQLdb'，我想是因?yàn)闆]有跟MySQL接起來，按照https://www.zhihu.com/question/29719547這個帖子里面講的，用了個pymysql來做，結(jié)果就是上面那個樣子，求教求教
查了挺多資料，似乎還有另外一條路子，就是放棄ORM，用sql語句查詢，用engine建立數(shù)據(jù)庫連接？
謝謝~