def show_user_profile(username):
sei = db_session()
us = sei.query(AllOrder).filter(AllOrder.买家会员名 == username).all()
allcost = 0
for i in us:
allcost += i.打款商家金额
print("该会员总消费：" + str(allcost))
sei.close()
db_session.remove()
return username + " 总消费：" + str(allcost)
def deleteevent_command(event):
"""Delete event data to DB."""
try:
db_session.remove()
LoadData.delete_data(event)
except Exception as e:
print(e)
traceback.print_exc()
db_session.rollback()
db_session.remove()
print("Delete event{} to DB.".format(event))
def addadmin_command():
"""Add admin to DB."""
try:
db_session.remove()
LoadData.add_user('1234', 'admin', '*****@*****.**')
except Exception as e:
print(e)
traceback.print_exc()
db_session.rollback()
db_session.remove()
print("Add admin: {} to DB.".format('admin'))
def addevent_command(rootpath, event):
"""Add event data to DB."""
loadData = LoadData(rootpath)
try:
db_session.remove()
loadData.add_data(event)
except Exception as e:
print(e)
traceback.print_exc()
db_session.rollback()
db_session.remove()
print("Load event{} to DB.".format(event))
def initevent_command(rootpath):
"""Add event data to DB."""
loadData = LoadData(rootpath)
try:
db_session.remove()
loadData.initialize_data()
except Exception as e:
print(e)
traceback.print_exc()
db_session.rollback()
db_session.remove()
print("initialize data in DB.")
def index():
'''
u = User('newy----ear','------@localhost')
sei = db_session()
sei.add(u)
sei.commit()'''
sei = db_session()
username = request.args.get('username')
us = sei.query(AllOrder).filter(AllOrder.买家会员名 == username).all()
allcost = 0
for i in us:
allcost += i.打款商家金额
print("该会员总消费：" + str(allcost))
sei.close()
db_session.remove()
return "该会员总消费：" + str(allcost)
def shutdown_session(exception=None):
"""Close the database again at the end of the request."""
db_session.remove()
def shutdown_session(exception=None):
db_session.remove()
