flask操作数据库已有的数据表

flask操作数据库已有的数据表

我参考的这一篇https://blog.csdn.net/qq_24964575/article/details/89516955
1、pip install sqlacodegen
2、sqlacodegen mysql+pymysql://root:pwd@localhost:3306/db>models.py
3、建一个config.py

# -*- coding:utf-8 -*-
# Author : vkang
from sqlalchemy import create_engine
from sqlalchemy.orm import Session,sessionmaker, relationship
#密码加密
from werkzeug.security import generate_password_hash, check_password_hash
#从models里导入用户表Login
from models import Login
#密码加密
def set_password(password):
        password_hash = generate_password_hash(password)
        return password_hash
#密码鉴定
def check_password(password_hash, password):
        return check_password_hash(password_hash, password)

engine = create_engine(
    "mysql+pymysql://root:vkang1211@localhost:3306/sina",
    encoding="utf-8",
    )
    
Session = sessionmaker(bind=engine)
session = Session()
#测试
# pw = set_password('vkang12')
# session.add(Login(user='vkang1',email='222@qq.com',pwd=pw,sex='男'))
# session.commit()
# session.close()
# ret = session.query(Login).filter_by(user='vkang1').first()
# print(ret.user)