SQLAlchemy的连接
from sqlalchemy import create_engine, Column, Integer, String, DateTime, MetaData
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker, session, scoped_session
# 建立与数据库的连接 root是用户名 ，123456是密码 @localhost/SQL是本地的数据库
engine = create_engine('mysql+pymysql://root:123456@localhost/SQL')
# 定义模型类及其数据连接会话
DBsession = sessionmaker(bind=engine)
dbsession = scoped_session(DBsession) # 线程安全
Base = declarative_base()
# 定义模型
class User(Base):
__tablename__ = "user"
# 如果在SQLAlchemy里面直接创建表结构，则详细定义列
userid = Column(Integer, primary_key=True)
username = Column(String(50))
password = Column(String(32))
User.metadata.create_all(engine) # 创建表
