sqlalchemy开发笔记
1.query()获取个数<len()与count()>踩坑
use_objs = session.query(UserInfo).filter(UserInfo.name == 'bha')
use_lst = session.query(UserInfo).filter(UserInfo.name == 'bha').all()
print(use_objs.count(), ',', '******start count******')
print(len(use_lst), ',', '******start len******')
use2 = UserInfo()
use2.name = 'bha'
use2.password = 'lisi%d' % i
session.add(use2)
session.commit()
session.flush()
print(use_objs.count(), ',', '******end count******')
print(len(use_lst), ',', '******end len******')
## 输出结果:
# 2,'******start count******'
# 2,'******start len******'
# 3,'******end count******' # 结论是执行count()应该还会查询数据库
# 2,'******end len******' # all()之后,使用len()获取个数,添加数据是不会在查询数据库的