def __init__(self,tsvfile):
if tsvfile is None:
return
pm = PersistenceManager( myapp.db_connector )
league_name = "X-Wing Vassal League Season Two"
league = pm.get_league(league_name)
self.tsv_players = {}
self.divisions = {}
with open(tsvfile, 'rU') as input:
reader = csv.reader( input,delimiter='\t' )
for row in reader:
person_name = unicode(row[0].strip())
email_address = row[1].strip()
challonge_name = unicode(row[2].strip())
time_zone = row[3].strip()
reddit_handle = row[4].strip()
challengeboards_name = row[5].strip()
tier_name = row[6].strip()
tier_number = row[7].strip()
division_name = row[8].strip()
division_letter = row[9].strip()
self.tsv_players[challonge_name] = { 'person_name': person_name,
'email_address' : email_address,
'challonge_name' : challonge_name,
'time_zone' : time_zone,
'reddit_handle' : reddit_handle,
'challengeboards_name':challengeboards_name ,
'tier_name' : tier_name,
'tier_number' : tier_number,
'division_name' : division_name,
'division_letter' : division_letter }
if not self.divisions.has_key( division_name ):
self.divisions[division_name] = { 'name': division_name, 'letter':division_letter, 'tier': tier_name}
if not divisions_href.has_key(division_name):
divisions_href[division_name] = pm.get_division(division_name)
tier_player.division = divisions_href[division_name]
tier_player.tier = tier_player.division.tier
tier_player.challengeboards_handle = decode(tsv_record['challengeboards_name'])
tier_player.challonge_id = player['id']
print player['group_player_ids'][0]
tier_player.group_id = player['group_player_ids'][0]
tier_player.name = lookup_name
tier_player.email_address = decode(tsv_record['email_address'])
tier_player.person_name = decode(tsv_record['person_name'])
tier_player.reddit_handle = decode(tsv_record['reddit_handle'])
tier_player.timezone = decode(tsv_record['time_zone'])
pm.db_connector.get_session().add(tier_player)
pm.db_connector.get_session().commit()
if __name__ == "__main__":
c = ChallongeMatchCSVImporter(sys.argv[1])
pm = PersistenceManager( myapp.db_connector )
challonge_user = os.getenv('CHALLONGE_USER')
challonge_key = os.getenv('CHALLONGE_API_KEY')
ch = ChallongeHelper(challonge_user, challonge_key)
league = pm.get_league( "X-Wing Vassal League Season One")
#create all the divisions for each tier
create_divisions(c,pm)
create_players(c, pm, ch, league)
create_matchups(c, pm, ch, league)
print "looking up division %s for player %s" % (division_name, lookup_name)
if not divisions_href.has_key(division_name):
divisions_href[division_name] = pm.get_division(division_name, league)
tier_player.division = divisions_href[division_name]
tier_player.tier = tier_player.division.tier
tier_player.challengeboards_handle = decode(tsv_record['challengeboards_name'])
tier_player.challonge_id = player['id']
print player['group_player_ids'][0]
tier_player.group_id = player['group_player_ids'][0]
tier_player.name = lookup_name
tier_player.email_address = decode(tsv_record['email_address'])
tier_player.person_name = decode(tsv_record['person_name'])
tier_player.reddit_handle = decode(tsv_record['reddit_handle'])
tier_player.timezone = decode(tsv_record['time_zone'])
pm.db_connector.get_session().add(tier_player)
pm.db_connector.get_session().commit()
if __name__ == "__main__":
c = ChallongeMatchCSVImporter(sys.argv[1])
pm = PersistenceManager( myapp.db_connector )
challonge_user = os.getenv('CHALLONGE_USER')
challonge_key = os.getenv('CHALLONGE_API_KEY')
ch = ChallongeHelper(challonge_user, challonge_key)
league = pm.get_league( "X-Wing Vassal League Season Two")
#create all the divisions for each tier
create_divisions(c,pm,league)
create_players(c, pm, ch, league)
create_matchups(c, pm, ch, league)
divisions_href[division_name] = pm.get_division(
division_name, league)
tier_player.division = divisions_href[division_name]
tier_player.tier = tier_player.division.tier
tier_player.challengeboards_handle = decode(
tsv_record['challengeboards_name'])
tier_player.challonge_id = player['id']
print player['group_player_ids'][0]
tier_player.group_id = player['group_player_ids'][0]
tier_player.name = lookup_name
tier_player.email_address = decode(tsv_record['email_address'])
tier_player.person_name = decode(tsv_record['person_name'])
tier_player.reddit_handle = decode(tsv_record['reddit_handle'])
tier_player.timezone = decode(tsv_record['time_zone'])
pm.db_connector.get_session().add(tier_player)
pm.db_connector.get_session().commit()
if __name__ == "__main__":
c = ChallongeMatchCSVImporter(sys.argv[1])
pm = PersistenceManager(myapp.db_connector)
challonge_user = os.getenv('CHALLONGE_USER')
challonge_key = os.getenv('CHALLONGE_API_KEY')
ch = ChallongeHelper(challonge_user, challonge_key)
league = pm.get_league("X-Wing Vassal League Season Three")
#create all the divisions for each tier
create_divisions(c, pm, league)
create_players(c, pm, ch, league)
create_matchups(c, pm, ch, league)
