sqlalchemy session

sessionmaker()

class sqlalchemy.orm.session.sessionmaker(bind=None, class_=<class 'sqlalchemy.orm.session.Session'>, autoflush=True, autocommit=False, expire_on_commit=True, info=None, **kw)

# global scope
Session = sessionmaker(autoflush=False)

# later, in a local scope, create and use a session:
sess = Session(bind=connection)

Session()

class sqlalchemy.orm.session.Session(bind=None, autoflush=True, expire_on_commit=True, _enable_transaction_accounting=True, autocommit=False, twophase=False, weak_identity_map=True, binds=None, extension=None, enable_baked_queries=True, info=None, query_cls=<class 'sqlalchemy.orm.query.Query'>)

方法/属性	参数	返回	说明
add(instance, _warn=True)	模型对象
add_all()			添加数据
close()			关闭回话
close_all()
commit()			提交回话
dirty			已经更新的对象
new			新添加的对象
execute(clause, params=None, mapper=None, bind=None, **kw)	orm，或者sql语句
query(*entities, **kwargs)			查询对象
rollback()			add之后回退
scalar(clause, params=None, mapper=None, bind=None, **kw)