def get_sessions():
missions = db.session.query(Mission).all()
session_missions = []
for mission in missions:
# If on a session date (Saturday going on Sunday for A2)
if ((mission.created.weekday() in [5, 6]) and ((mission.created.hour >= 18) or (mission.created.hour <= 5))):
session_missions.append(mission)
sessions_unsorted = {}
graph_data = {}
for index, mission in enumerate(session_missions):
year, week, __ = mission.created.isocalendar()
key = (year, week)
if key not in sessions_unsorted: # Create a new key/value pair
sessions_unsorted[key] = Session()
player_count = (db.session.query(func.count(Player.id))
.join(Mission).filter(Mission.id == mission.id,
Player.is_jip == False)
.first())[0]
temp_mission = SessionMission(mission, player_count, None, None)
sessions_unsorted[key].add_mission(temp_mission)
else: # Use existing key/value pair
player_count = (db.session.query(func.count(Player.id))
.join(Mission).filter(Mission.id == mission.id,
Player.is_jip == False)
.first())[0]
temp_mission = SessionMission(mission, player_count, None, None)
sessions_unsorted[key].add_mission(temp_mission)
# Sort the dictionary and only retrieve.
sorted_sessions = sorted(sessions_unsorted.items(), key=lambda t: t[0], reverse=True)
# There has to be a better, looping over sorted_session backwards should doit
graph_sessions = sorted(sessions_unsorted.items(), key=lambda t: t[0], reverse=False)
for index, session in enumerate(graph_sessions):
graph_data[index+1] = session[1].show_peak()
return render_template('overview.html', sessions=sorted_sessions, data=graph_data)
def display_session(year, week):
missions = db.session.query(Mission).all()
week = int(week)
year = int(year)
session_missions = Session()
for mission in missions:
if ((mission.created.isocalendar()[1] == week) # Find mission on the date we are looking on
and (mission.created.year == year)
and (mission.created.weekday() in [5, 6]) # Missin in a sat or sunday
and ((mission.created.hour >= 18) or (mission.created.hour <= 5))): # if it was played between 18 and 5
players = db.session.query(Player).filter(
Player.mission_id == mission.id,
Player.player_name is not "HC",
Player.is_jip == False).all()
player_count = (db.session.query(func.count(Player.id))
.join(Mission).filter(Mission.id == mission.id,
Player.is_jip == False)
.first())[0]
groups = {}
for player in players: # Find all groups in missio and place the players in them
key = player.group_name
if key not in groups: # If the key doesnt exist, create new
groups[key] = GroupsInMission()
groups[key].add_member(player)
else: # Use existing key
groups[key].add_member(player)
for key in groups:
groups[key].sort_members()
temp_mission = SessionMission(mission, player_count, players, groups)
session_missions.add_mission(temp_mission)
data = {}
for index, mission in enumerate(session_missions.missions):
data[index+1] = mission.playercount
return render_template('session.html', session=session_missions, data=data)
