一、sqlalchemy的基本使用
注:以下含完整流程代码,该流程为通用流程
①创建对象的基类:所有的模型类继承该基类
Base = declarative_base()
②初始化数据库连接:以mysql数据库为例
engine = create_engine('mysql+mysqlconnector://root:password@localhost:3306/test')
③创建DBSession类型:
DBSession = sessionmaker(bind=engine)
④设置为线程安全
dbseesion = scoped_session(DBseesion)
⑤整体流程
from sqlalchemy import create_engine, MetaData, Table
from sqlalchemy.orm import sessionmaker, scoped_session
from sqlalchemy.ext.declarative import declarative_base
Base = declarative_base()
engine = create_engine("mysql+pymysql://root:root@localhost/woniunote", echo=False)
DBseesion = sessionmaker(bind=engine)
dbseesion = scoped_session(DBseesion)
md = MetaData(bind=engine)
class Users(Base):
__table__ = Table('users', md, autoload=True)
class Article(Base):
__table__ = Table('article', MetaData(bind=engine), autoload=True)