def player_page(key=None,operation=None,error=None):
if request.method == 'GET':
if request.args.get('operation') == 'delete':
store = player_operations()
result=store.delete_player(request.args.get('key'))
return redirect(url_for('admin.player_page',error=result))
else:
store = player_operations()
players=store.get_players()
now = datetime.datetime.now()
error = request.args.get('error')
return render_template('admin_players.html', players=players, error=error, current_time=now.ctime())
else:
if request.form['submit']=='cancel':
return redirect(url_for('admin.player_page'))
else:
if request.form['key_value']=='':
name = request.form['name']
surname = request.form['surname']
birthdate = request.form['birthdate']
height = request.form['height']
weight = request.form['weight']
startdate = request.form['startdate']
teamid = request.form['teamid']
countryid = request.form['countryid']
genderid = request.form['genderid']
positionid = request.form['positionid']
handid = request.form['handid']
number = request.form['number']
player = Player(None, name, surname, birthdate, height, weight, startdate, teamid, None, countryid, None, genderid, None, positionid, None, handid, None, number, 0)
store = player_operations()
result=store.add_player(player)
return redirect(url_for('admin.player_page', error=result))
else:
name = request.form['name']
surname = request.form['surname']
birthdate = request.form['birthdate']
height = request.form['height']
weight = request.form['weight']
startdate = request.form['startdate']
teamid = request.form['teamid']
countryid = request.form['countryid']
genderid = request.form['genderid']
positionid = request.form['positionid']
handid = request.form['handid']
number = request.form['number']
key = request.form['key_value']
store = player_operations()
result=store.update_player(key,name, surname, birthdate, height, weight, startdate, teamid, countryid, genderid, positionid, handid, number)
return redirect(url_for('admin.player_page', error=result))
def statistic_edit_page(key=None):
store = statistic_operations()
storeSeason = season_operations()
storePlayer = player_operations()
statistic = store.get_statistic(key) if key is not None else None
seasons = storeSeason.get_seasons()
players = storePlayer.get_players()
now = datetime.datetime.now()
return render_template('statistic_edit.html', statistic=statistic, seasons=seasons,players=players, current_time=now.ctime())
def transfer_edit_page(key=None):
store = transfer_operations()
storeTeam = team_operations()
storeSeason = season_operations()
storePlayer = player_operations()
transfer = store.get_transfer(key) if key is not None else None
teams = storeTeam.get_teams()
seasons = storeSeason.get_seasons()
players = storePlayer.get_players()
now = datetime.datetime.now()
return render_template('transfer_edit.html', transfer=transfer, teams=teams,seasons=seasons,players=players, current_time=now.ctime())
def player_edit_page(key=None):
store = player_operations()
storeCountry = country_operations()
storeTeam = team_operations()
storeGender = gender_operations()
storePosition = position_operations()
storeHand = hand_operations()
player = store.get_player(key) if key is not None else None
teams = storeTeam.get_teams()
countries = storeCountry.get_countries()
genders = storeGender.get_genders()
positions = storePosition.get_positions()
hands = storeHand.get_hands()
now = datetime.datetime.now()
return render_template('player_edit.html', player=player, teams=teams, countries=countries, genders=genders, positions=positions, hands=hands, current_time=now.ctime())
def get_statistic(self, key):
global connection
storeSeason = season_operations()
storePlayer = player_operations()
try:
connection = dbapi2.connect(dsn)
cursor = connection.cursor()
statement = """SELECT objectid, assistnumber, blocknumber, score, cardnumber, seasonid, playerid FROM statistic where (objectid=%s and deleted=0)"""
cursor.execute(statement, (key,))
id,assistnumber,blocknumber, score, cardnumber, seasonid, playerid=cursor.fetchone()
cursor.close()
except dbapi2.DatabaseError:
if connection:
connection.rollback()
finally:
if connection:
connection.close()
return Statistic(id, assistnumber, blocknumber, score, cardnumber, seasonid, storeSeason.get_season(seasonid), playerid, storePlayer.get_player(playerid), 0)
def get_transfer(self, key):
global connection
storeTeam = team_operations()
storeSeason = season_operations()
storePlayer = player_operations()
try:
connection = dbapi2.connect(dsn)
cursor = connection.cursor()
statement = """SELECT objectid, playerid, oldteamid, newteamid, seasonid FROM transfer where (objectid=%s and deleted=0)"""
cursor.execute(statement, (key,))
id,playerid,oldteamid,newteamid,seasonid=cursor.fetchone()
cursor.close()
except dbapi2.DatabaseError:
if connection:
connection.rollback()
finally:
if connection:
connection.close()
return Transfer(id, playerid,storePlayer.get_player(playerid), oldteamid, storeTeam.get_team(oldteamid), newteamid, storeTeam.get_team(newteamid), seasonid, storeSeason.get_season(seasonid), 0)
def get_statistics(self):
global connection
storeSeason = season_operations()
storePlayer = player_operations()
statistics=[]
try:
connection = dbapi2.connect(dsn)
cursor = connection.cursor()
statement = """SELECT statistic.objectid, statistic.assistnumber, statistic.blocknumber, statistic.score, statistic.cardnumber, statistic.seasonid, statistic.playerid FROM statistic where statistic.deleted=0 ORDER BY objectid"""
cursor.execute(statement)
statistics = [(key, Statistic(key, assistnumber, blocknumber,score, cardnumber, seasonid, storeSeason.get_season(seasonid), playerid, storePlayer.get_player(playerid), 0)) for key, assistnumber, blocknumber, score, cardnumber, seasonid, playerid in cursor]
cursor.close()
except dbapi2.DatabaseError:
if connection:
connection.rollback()
finally:
if connection:
connection.close()
return statistics
def get_transfers(self):
global connection
storeTeam = team_operations()
storeSeason = season_operations()
storePlayer = player_operations()
transfers=[]
try:
connection = dbapi2.connect(dsn)
cursor = connection.cursor()
statement = """SELECT transfer.objectid, transfer.playerid, transfer.oldteamid, transfer.newteamid, transfer.seasonid FROM transfer where transfer.deleted=0 ORDER BY objectid"""
cursor.execute(statement)
transfers = [(key, Transfer(key, playerid,storePlayer.get_player(playerid), oldteamid,storeTeam.get_team(oldteamid), newteamid, storeTeam.get_team(newteamid), seasonid, storeSeason.get_season(seasonid), 0)) for key, playerid, oldteamid, newteamid, seasonid in cursor]
cursor.close()
except dbapi2.DatabaseError:
if connection:
connection.rollback()
finally:
if connection:
connection.close()
return transfers
def player_page():
if request.method == 'GET':
store = player_operations()
players=store.get_players()
now = datetime.datetime.now()
return render_template('player.html', players=players, current_time=now.ctime())
