def update_player_info_page(key = None):
page = Player_info(dsn = app.config['dsn'])
if request.method == 'GET':
return page.open_update_player_info(id = key)
elif 'updateplayer_info' in request.form:
name = request.form['name']
surname = request.form['surname']
country = request.form['country']
club = request.form['club']
best_rating = request.form['best_rating']
best_ranking = request.form['best_ranking']
best_tournament = request.form['best_tournament']
best_tournament_result = request.form['best_tournament_result']
curr_rating = request.form['curr_rating']
curr_ranking = request.form['curr_ranking']
return page.update_player_info(key, name, surname, country, club, best_rating, best_ranking, best_tournament, best_tournament_result, curr_rating, curr_ranking)
else:
return redirect(url_for('home_page'))
def players_page(key = None):
page = Player_info(dsn = app.config['dsn'])
if key == 1:
return page.open_page("name")
elif key == 2:
return page.open_page("surname")
elif key == 3:
return page.open_page("country")
elif key == 4:
return page.open_page("club")
elif key == 5:
return page.open_page("best_rating")
elif key == 6:
return page.open_page("best_ranking")
elif key == 7:
return page.open_page("best_tournament")
elif key == 8:
return page.open_page("best_tournament_result")
elif key == 9:
return page.open_page("curr_rating")
elif key == 10:
return page.open_page("curr_ranking")
elif request.method == 'GET':
return page.open_page()
elif 'initializeTable' in request.form:
return page.init_table()
elif 'addplayer' in request.form:
name = request.form['name']
surname = request.form['surname']
country = request.form['country']
club = request.form['club']
best_rating = request.form['best_rating']
best_ranking = request.form['best_ranking']
best_tournament = request.form['best_tournament']
best_tournament_result = request.form['best_tournament_result']
curr_rating = request.form['curr_rating']
curr_ranking = request.form['curr_ranking']
return page.add_player(name, surname, country, club, best_rating, best_ranking, best_tournament, best_tournament_result, curr_rating, curr_ranking)
elif 'deleteplayer' in request.form:
name = request.form['name']
surname = request.form['surname']
return page.delete_player(name, surname)
elif 'deleteplayerwithid' in request.form:
id = request.form['id']
return page.delete_player_with_id(id)
elif 'findplayer' in request.form:
name = request.form['name']
surname = request.form['surname']
return page.find_player(name, surname)
else:
return redirect(url_for('home_page'))
