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("/")