def sdelete():
riders = ridersClass(dsn = app.config['dsn'])
result = yearstatsClass(dsn = app.config['dsn'])
now = datetime.datetime.now()
if 'delbyrider' in request.form:
STATID = request.form['statid']
result.del_stats_by_rider(STATID)
elif 'delbynum' in request.form:
NUM = request.form['num']
result.del_stats_by_num(NUM)
return render_template('/riders/stats/delete.html', result=result.load_stats(),riders=riders.load_riders(), current_time=now.ctime())
def ssearch():
riders = ridersClass(dsn = app.config['dsn'])
result = yearstatsClass(dsn = app.config['dsn'])
now = datetime.datetime.now()
if 'searchdefault' in request.form:
YEAR = request.form['year']
POSITION = request.form['position']
return render_template('/riders/stats/search.html', result=result.search_stats_default(YEAR, POSITION),riders=riders.load_riders(), current_time=now.ctime())
elif 'searchbyrider' in request.form:
STATID = request.form['statid']
return render_template('/riders/stats/search.html', result=result.search_stats_by_rider(STATID),riders=riders.load_riders(), current_time=now.ctime())
return render_template('/riders/stats/search.html', result=result.load_stats(),riders=riders.load_riders(), current_time=now.ctime())
def sadd():
riders = ridersClass(dsn = app.config['dsn'])
result = yearstatsClass(dsn = app.config['dsn'])
now = datetime.datetime.now()
if 'adddefault' in request.form:
YEAR = request.form['year']
RACES = request.form['races']
VICTORY = request.form['victory']
SECOND = request.form['second']
THIRD = request.form['third']
PODIUM = str(int(VICTORY)+int(SECOND)+int(THIRD))
POLE = request.form['pole']
POINTS = request.form['points']
POSITION= request.form['position']
STATID = request.form['statid']
result.add_stats_default(YEAR, RACES, VICTORY, SECOND, THIRD, PODIUM, POLE, POINTS, POSITION, STATID)
return render_template('/riders/stats/add.html', result=result.load_stats(),riders=riders.load_riders(), current_time=now.ctime())
def stats():
riders = ridersClass(dsn = app.config['dsn'])
result = yearstatsClass(dsn = app.config['dsn'])
now = datetime.datetime.now()
if 'adddefault' in request.form:
YEAR = request.form['year']
RACES = request.form['races']
VICTORY = request.form['victory']
SECOND = request.form['second']
THIRD = request.form['third']
PODIUM = str(int(VICTORY)+int(SECOND)+int(THIRD))
POLE = request.form['pole']
POINTS = request.form['points']
POSITION= request.form['position']
STATID = request.form['statid']
result.add_stats_default(YEAR, RACES, VICTORY, SECOND, THIRD, PODIUM, POLE, POINTS, POSITION, STATID)
elif 'updatebynum' in request.form:
NUM = request.form['num']
YEAR = request.form['year']
RACES = request.form['races']
VICTORY = request.form['victory']
SECOND = request.form['second']
THIRD = request.form['third']
PODIUM = str(int(VICTORY)+int(SECOND)+int(THIRD))
POLE = request.form['pole']
POINTS = request.form['points']
POSITION= request.form['position']
STATID = request.form['statid']
result.update_stats_by_num(NUM, YEAR, RACES, VICTORY, SECOND, THIRD, PODIUM, POLE, POINTS, POSITION, STATID)
elif 'searchdefault' in request.form:
YEAR = request.form['year']
POSITION = request.form['position']
return render_template('/riders/stats.html', result=result.search_stats_default(YEAR, POSITION), riders=riders.load_riders(), current_time=now.ctime())
elif 'searchbyrider' in request.form:
STATID = request.form['statid']
return render_template('/riders/stats.html', result=result.search_stats_by_rider(STATID),riders=riders.load_riders(), current_time=now.ctime())
elif 'delbyrider' in request.form:
STATID = request.form['statid']
result.del_stats_by_rider(STATID)
elif 'delbynum' in request.form:
NUM = request.form['num']
result.del_stats_by_num(NUM)
return render_template('/riders/stats.html', result=result.load_stats(),riders=riders.load_riders(), current_time=now.ctime())
def reset():
with dbapi2.connect(app.config['dsn']) as connection:
cursor = connection.cursor()
query = """DROP TABLE IF EXISTS FANS"""
cursor.execute(query)
cursor = connection.cursor()
query = """DROP TABLE IF EXISTS PERSONAL"""
cursor.execute(query)
cursor = connection.cursor()
query = """DROP TABLE IF EXISTS YEARSTATS"""
cursor.execute(query)
cursor = connection.cursor()
query = """DROP TABLE IF EXISTS RIDERS"""
cursor.execute(query)
riders = ridersClass(dsn = app.config['dsn'])
riders.fill()
stats = yearstatsClass(dsn = app.config['dsn'])
stats.fill()
personal = personalClass(dsn = app.config['dsn'])
personal.fill()
fans = fansClass(dsn = app.config['dsn'])
return redirect(url_for('home_page'))
def slist():
result = yearstatsClass(dsn = app.config['dsn'])
now = datetime.datetime.now()
return render_template('/riders/stats/list.html', result=result.load_stats(), current_time=now.ctime())