def ftournaments():
with dbapi2.connect(app.config['dsn']) as connection:
_tourList = dbmanager.getTournaments(connection)
_sponsorList = dbmanager.getSponsor(connection)
_channelList = dbmanager.getChannels(connection)
_info = layoutInfo('Snooker is about having the best offensive play possible.','RONNIE O-SULLIVAN','static/img/players.jpg')
return render_template('ftournament.html', tournamentList = _tourList, info = _info, sponsorList = _sponsorList, channelList = _channelList)
def fmatches():
with dbapi2.connect(app.config['dsn']) as connection:
_matchList = dbmanager.getMathes(connection)
_sponsorList = dbmanager.getSponsor(connection)
_channelList = dbmanager.getChannels(connection)
_info = layoutInfo('Looking for perfection is the only way.','RONNIE O-SULLIVAN','static/img/players.jpg')
return render_template('fmatches.html', matchList = _matchList, info = _info, sponsorList = _sponsorList, channelList = _channelList)
def frecords():
with dbapi2.connect(app.config['dsn']) as connection:
_recordList = dbmanager.getRecords(connection)
_sponsorList = dbmanager.getSponsor(connection)
_channelList = dbmanager.getChannels(connection)
_info = layoutInfo('Never mind what others do; do better than yourself.','RONNIE O-SULLIVAN','static/img/players.jpg')
return render_template('frecords.html', recordList = _recordList, info = _info, sponsorList = _sponsorList, channelList = _channelList)
def ftickets():
with dbapi2.connect(app.config['dsn']) as connection:
_ticketList = dbmanager.getTickets(connection)
_sponsorList = dbmanager.getSponsor(connection)
_channelList = dbmanager.getChannels(connection)
_info = layoutInfo('If you go step by step, with confidence, you can go far.','RONNIE O-SULLIVAN','static/img/players.jpg')
return render_template('ftickets.html', ticketList = _ticketList, info = _info, sponsorList = _sponsorList, channelList = _channelList)
def news():
with dbapi2.connect(app.config['dsn']) as connection:
_newsList = dbmanager.getNews(connection)
_sponsorList = dbmanager.getSponsor(connection)
_channelList = dbmanager.getChannels(connection)
_info = layoutInfo('All about Snooker','Daily News for Snooker','static/img/home-bg.jpg')
return render_template('fnews.html', newsList = _newsList, info = _info, sponsorList = _sponsorList, channelList = _channelList)
def fplayers():
with dbapi2.connect(app.config['dsn']) as connection:
_playerList = dbmanager.getPlayers(connection)
_sponsorList = dbmanager.getSponsor(connection)
_channelList = dbmanager.getChannels(connection)
_info = layoutInfo('The game of snooker has been everything to me.','RONNIE O-SULLIVAN','static/img/players.jpg')
return render_template('fplayers.html', playerList = _playerList, info = _info, sponsorList = _sponsorList, channelList = _channelList)
def newsDetail(newsid):
with dbapi2.connect(app.config['dsn']) as connection:
_news = dbmanager.getNewsWithID(newsid,connection)
_sponsorList = dbmanager.getSponsor(connection)
_channelList = dbmanager.getChannels(connection)
_info = layoutInfo(_news.getTitle(),'',_news.getImageUrl())
_comments = dbmanager.getComments(newsid,connection)
return render_template('/fnews_detail.html',news = _news, info = _info, commentList = _comments, sponsorList = _sponsorList, channelList = _channelList)
def sponsor():
with dbapi2.connect(app.config['dsn']) as connection:
if(request.method == 'GET'):
_sponsorList = dbmanager.getSponsor(connection)
return render_template('sponsor.html', sponsorList = _sponsorList)
if(request.form["action"] == "add_sponsor_action"):
dbmanager.addSponsor(request.form['add_name'], request.form['add_imageURL'], request.form['add_extURL'], connection)
return redirect(url_for('sponsor'))
if(request.form["action"] == "delete_sponsor_action"):
dbmanager.deleteSponsor(request.form['id'], connection)
return redirect(url_for('sponsor'))
return render_template('sponsor.html')
