Flask网站sqlalchemy连接mariadb

•    安装python3.6之后建立虚拟环境并启用,退出虚拟环境使用deactivate命令

 1007  python3 -m venv venv  #建立虚拟环境
 1008  source venv/bin/activate #启用虚拟环境
 1009  pip install pyodbc #虚拟环境下安装python扩展包
 1010  pip install --upgrade pip
 1011  pip install pyodbc
 1012  pip install ibm_db
 1013  pip --version
 1014  pip install pymysql #安装mysql驱动

• Flask 中连接mariadb

# coding:utf8

import os
from datetime import datetime

from flask import Flask
from flask_sqlalchemy import SQLAlchemy
import pymysql

app = Flask(__name__)
app.debug = True

app.config["SQLALCHEMY_DATABASE_URI"] = "mysql+pymysql://lubaohui:lubaohui@127.0.0.1:3306/cbdb"
app.config["SQLALCHEMY_TRACK_MODIFICATIONS"] = True

db = SQLALchemy(app)

class User(db.Model):
    id = db.Column(db.Integer, primary_key = True)
    name = db.Column(db.String(100), unique