修复 macOS 环境使用 Flask 连接数据库
背景:
近日想做一个 flask 项目,需要连接 mysql 数据库,但解决各种版本问题后还是无法在数据库中插入数据
macOs 安装mysqlclient解决方案
demo 代码部分:
from flask import Flask, url_for
from flask_sqlalchemy import SQLAlchemy
from index import route
from logs import setup_log
app = Flask(__name__)
app.register_blueprint(route, url_prefix='/api')
app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql://root:xxx@localhost:3306/test'
app.config['SQLALCHEMY_TRACK_MODIFICATIONS']=True
SQLALCHEMY_ECHO = True
db = SQLAlchemy(app)
def create():
# models
class Person(db.Model):
__tablename__ = 'persons'
__table_args__ = {'extend_existing': True}
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(