flask: 连接到mysql数据库

一，安装到第三方库

$ pip3 install sqlalchemy 
$ pip3 install pymysql

二，连接到数据库

 

import os
from dotenv import load_dotenv

from flask import Flask,jsonify

from sqlalchemy import create_engine
from sqlalchemy import text


# 数据库信息
host = '127.0.0.1'
port = '3306'
database = 'mybase'
username = 'root'
password = 'rootpassword'

# 数据库类型+连接数据库的插件，这里使用的pymysql
DB_URI = f'mysql+pymysql://{username}:{password}@{host}:{port}/{database}'

engine = create_engine(DB_URI)  # 创建引擎

# 判断是否连接成功
conn = engine.connect()  # 获取连接指针
result = conn.execute(text('select * from user'))
# print(result.fetchone())  # 打印第一条
print(result.fetchall())  # 打印所有行

三，测试效果:

$ flask run
打印配置项:
[(1, 'guangkun', '谢广坤', 44), (2, 'zhaosi', '赵四', 35)]