本文整理汇总了Python中db.Database.create_session方法的典型用法代码示例。如果您正苦于以下问题:Python Database.create_session方法的具体用法?Python Database.create_session怎么用?Python Database.create_session使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类db.Database
的用法示例。
在下文中一共展示了Database.create_session方法的3个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: page_of_users
# 需要导入模块: from db import Database [as 别名]
# 或者: from db.Database import create_session [as 别名]
def page_of_users():
# email = input("Enter your email: ")
session = Database.create_session()
session.expire_on_commit = False
# with Database.create_session() as session:
users = session.query(User). \
filter(User.id != None).\
order_by(User.registered.desc())
page_size = 10
current_page = 3
results = users[page_size * current_page:page_size * (current_page+1)]
# results = users[1:5]
for u in results:
print(u.name)
示例2: add_data
# 需要导入模块: from db import Database [as 别名]
# 或者: from db.Database import create_session [as 别名]
def add_data():
session = Database.create_session()
num = session.query(User).count()
if num:
print("data loaded, skipping")
return
u = User(
name='Michael',
email='[email protected]',
pw='a'
)
session.add(u)
u = User(
name='Ted',
email='[email protected]',
pw='9837598w75983749857349857398745'
)
session.add(u)
session.commit()
示例3: find_user
# 需要导入模块: from db import Database [as 别名]
# 或者: from db.Database import create_session [as 别名]
def find_user(email):
# email = input("Enter your email: ")
session = Database.create_session()
session.expire_on_commit = False
# with Database.create_session() as session:
user = session.query(User). \
filter(User.email == email).\
order_by(User.registered.desc())
user = user.first()
if user:
# print("results: {}".format(user.name))
user.name = user.name.upper()
session.commit()
print("Saved user")
session.close()
return user
else:
# print("not found!")
return None