def court_page(key=None,operation=None,error=None):
if request.method == 'GET':
if request.args.get('operation') == 'delete':
store = court_operations()
result=store.delete_court(request.args.get('key'))
return redirect(url_for('admin.court_page', error=result))
else:
store = court_operations()
courts=store.get_courts()
now = datetime.datetime.now()
error = request.args.get('error')
return render_template('admin_courts.html', courts=courts, error=error, current_time=now.ctime())
else:
if request.form['submit']=='cancel':
return redirect(url_for('admin.court_page'))
else:
if request.form['key_value']=='':
name = request.form['name']
address = request.form['address']
capacity = request.form['capacity']
court = Court(None ,name, address,capacity,0)
store = court_operations()
result=store.add_court(court)
return redirect(url_for('admin.court_page', error=result))
else:
name = request.form['name']
address = request.form['address']
capacity = request.form['capacity']
key = request.form['key_value']
store = court_operations()
result=store.update_court(key, name, address, capacity)
return redirect(url_for('admin.court_page', error=result))
def team_edit_page(key=None):
store = team_operations()
storeCourt = court_operations()
storeCountry = country_operations()
team = store.get_team(key) if key is not None else None
courts = storeCourt.get_courts()
countries = storeCountry.get_countries()
now = datetime.datetime.now()
return render_template('team_edit.html', team=team, courts=courts, countries=countries, current_time=now.ctime())
def match_edit_page(key=None):
store = match_operations()
storeTeam = team_operations()
storeCourt = court_operations()
match = store.get_match(key) if key is not None else None
teams = storeTeam.get_teams()
courts = storeCourt.get_courts()
now = datetime.datetime.now()
return render_template('match_edit.html', match=match, teams=teams, courts=courts, current_time=now.ctime())
def get_team(self, key):
global connection
try:
connection = dbapi2.connect(dsn)
cursor = connection.cursor()
statement = """SELECT objectid, name, shirtcolour, foundationdate, countryid, courtid FROM team where (objectid=%s and deleted=0)"""
cursor.execute(statement, (key,))
id,name,color,date,countryid,courtid=cursor.fetchone()
cursor.close()
storeCountry = country_operations()
storeCourt = court_operations()
except dbapi2.DatabaseError:
if connection:
connection.rollback()
finally:
if connection:
connection.close()
return Team(id,name, color, date, countryid, storeCountry.get_country(countryid), courtid, storeCourt.get_court(courtid),0)
def get_teams(self):
teams=[]
global connection
storeCountry = country_operations()
storeCourt = court_operations()
try:
connection = dbapi2.connect(dsn)
cursor = connection.cursor()
statement = """SELECT team.objectid, team.name, team.shirtcolour, team.foundationdate, team.countryid,team.courtid FROM team WHERE team.deleted = 0 ORDER BY objectid """
cursor.execute(statement)
teams = [(key, Team(key,name,color,date,countryid, storeCountry.get_country(countryid),courtid,storeCourt.get_court(courtid) , 0)) for key, name, color, date, countryid, courtid in cursor]
cursor.close()
except dbapi2.DatabaseError:
if connection:
connection.rollback()
finally:
if connection:
connection.close()
return teams
def get_match(self, key):
global connection
storeCourt = court_operations()
storeTeam = team_operations()
try:
connection = dbapi2.connect(dsn)
cursor = connection.cursor()
statement = """SELECT objectid, hometeamid, awayteamid, courtid, matchdate FROM match WHERE (objectid=%s and deleted=0)"""
cursor.execute(statement, (key,))
id,hometeamid,awayteamid,courtid,matchdate=cursor.fetchone()
cursor.close()
except dbapi2.DatabaseError:
if connection:
connection.rollback()
finally:
if connection:
connection.close()
return Match(id, hometeamid, storeTeam.get_team(hometeamid), awayteamid, storeTeam.get_team(awayteamid), courtid, storeCourt.get_court(courtid), matchdate, 0)
def get_matches(self):
matches=[]
global connection
storeCourt = court_operations()
storeTeam = team_operations()
try:
connection = dbapi2.connect(dsn)
cursor = connection.cursor()
statement = """SELECT objectid, hometeamid, awayteamid, courtid, matchdate FROM match WHERE deleted = 0 ORDER BY objectid"""
cursor.execute(statement)
matches = [(key, Match(key, hometeamid, storeTeam.get_team(hometeamid), awayteamid, storeTeam.get_team(awayteamid), courtid, storeCourt.get_court(courtid), matchdate, 0)) for key, hometeamid, awayteamid, courtid, matchdate in cursor]
cursor.close()
except dbapi2.DatabaseError:
if connection:
connection.rollback()
finally:
if connection:
connection.close()
return matches
def court_edit_page(key=None):
store = court_operations()
court = store.get_court(key) if key is not None else None
now = datetime.datetime.now()
return render_template('court_edit.html', court=court, current_time=now.ctime())