def get_all_missions_for_user(self, _userID):
con = None
try:
con = self.database_connector
with con:
con.rollback()
cur = con.cursor()
cur.execute("SELECT * FROM mission WHERE userID = ?", (_userID,))
con.commit()
multiple_mission_data = cur.fetchall()
mission_list = []
for mission in multiple_mission_data:
mission_list.append(mission_bean(mission[1],mission[2],mission[3],mission[4],mission[5],mission[6],mission[7],mission[8],mission[0]))
return mission_list
except lite.Error, e:
return False,str(e)
def add_user_mission():
if session.get("logged_user_id"):
title = request.args.get("title")
description = request.args.get("description")
start = request.args.get("start")
goal = request.args.get("goal")
units = request.args.get("units")
current_track = 0
end = "01/01/1970"
complete = 0
new_user_mission = mission_bean(
session.get("logged_user_id"), title, description, current_track, goal, units, start, end, complete
)
if factory.get_mission_dao().add_new_user_mission(new_user_mission) is True:
return "true"
else:
return "false"
return redirect("/")
