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)
