def export_all_lists(): pm = PersistenceManager(myapp.db_connector) tourneys = pm.get_tourneys(); make_header = True rows = [] for tourney in tourneys: ret = get_tourney_lists_as_text(tourney, make_header) make_header = False rows.extend( ret ) event = Event(remote_address=myapp.remote_address(request), event_date=func.now(), event="export all tourney lists") pm.db_connector.get_session().add(event) pm.db_connector.get_session().commit() return csv_response( rows, "all_lists_download.csv")
def store_champs(): store_champs = simple_cache.get('store-champ-data') if store_champs is None: pm = PersistenceManager(myapp.db_connector) tourneys = pm.get_tourneys() store_champs = [] for tourney in tourneys: for rank in tourney.rankings: if tourney.is_store_championship(): rec = { 'tourney' : decode(tourney.tourney_name), 'num_participants': tourney.participant_count, 'player' : decode(rank.player.player_name), 'swiss_standing': rank.rank, 'championship_standing' : rank.elim_rank, 'pretty_print' : rank.pretty_print() } store_champs.append(rec) simple_cache.set( 'store-champ-data', store_champs, timeout=5*60) return render_template( 'store_champ_lists.html', championship_lists=store_champs)