SQLAlchemy install

安装pymysql

1. 进去flask-env虚拟环境
2. pip install pymysql

安装flask-sqlalchemy

1. pip install Flask-SQLAlchemy

初使用

1. 添加config.py在项目目录下

   DEBUG = True
   DIALECT = 'mysql'
   DRIVER = 'pymysql'
   USERNAME = 'lotus'
   PASSWORD = 'ching'
   HOST = '192.168.2.20'
   PORT = '3306'
   DATABASE = 'demo1'
   SQLALCHEMY_TRACK_MODIFICATIONS = False
   SQLALCHEMY_DATABASE_URI = '{}+{}://{}:{}@{}:{}/{}?charset=utf8'.format(DIALECT, DRIVER, USERNAME, PASSWORD, HOST, PORT, DATABASE)
   

2. app.py中导入配置

   from flask import Flask
   from flask_sqlalchemy import SQLAlchemy
   import config
   
   app = Flask(__name__)
   app.config.from_object(config)
   db = SQLAlchemy(app=app)
   db.create_all()
   
   @app.route('/')
   def index():
      return 'Index.'
   
   if __name__ == '__main__':
      app.run()
   

3. 如果能看到flask已经成功监听端口，并且没有任何错误信息，则表示sqlclchemy使用pymysql驱动成功连接到了mysql数据库