예제 #1
0
def rdelete():
    result = ridersClass(dsn = app.config['dsn'])
    now = datetime.datetime.now()
    if 'deldefault' in request.form:
        NAME = request.form['name']
        SURNAME = request.form['surname']
        result.del_rider_default(NAME, SURNAME)
    elif 'delbynum' in request.form:
        NUM = request.form['num']
        result.del_rider_by_num(NUM)
    return render_template('/riders/delete.html', result=result.load_riders(), current_time=now.ctime())
예제 #2
0
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())
예제 #3
0
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())
예제 #4
0
def fadd():
    riders = ridersClass(dsn = app.config['dsn'])
    personal = personalClass(dsn = app.config['dsn'])
    result = fansClass(dsn = app.config['dsn'])
    now = datetime.datetime.now()
    if 'adddefault' in request.form:
        NAME = request.form['name']
        SURNAME = request.form['surname']
        MAIL = request.form['mail']
        BIRTH = request.form['birth']
        FANSID = request.form['fansid']
        result.add_fans_default(NAME, SURNAME, MAIL, BIRTH, FANSID)
    return render_template('/riders/addfan.html', riders=riders.load_riders(), personal=personal.load_personal(), current_time=now.ctime())
예제 #5
0
def rsearch():
    result = ridersClass(dsn = app.config['dsn'])
    now = datetime.datetime.now()
    if 'searchdefault' in request.form:
        NAME = request.form['name']
        SURNAME = request.form['surname']
        TEAM = request.form['team']
        BRAND = request.form['brand']
        MODEL = request.form['model']
        NATION = request.form['nation']
        return render_template('/riders/search.html', result=result.search_rider_default(NAME,SURNAME, TEAM, BRAND, MODEL, NATION), current_time=now.ctime())
    elif request.method == 'GET':
        return render_template('/riders/search.html', result=result.load_riders(), current_time=now.ctime())
    return render_template('/riders/search.html', result=result.load_riders(), current_time=now.ctime())
예제 #6
0
def radd():
    result = ridersClass(dsn = app.config['dsn'])
    now = datetime.datetime.now()
    if 'adddefault' in request.form:
        NAME = request.form['name']
        SURNAME = request.form['surname']
        AGE = request.form['age']
        GENDER = request.form['gender']
        TEAM = request.form['team']
        BRAND = request.form['brand']
        MODEL = request.form['model']
        NATION = request.form['nation']
        YEARS = request.form['years']
        BIKENO = request.form['bikeno']
        result.add_rider_default(NAME, SURNAME, AGE, GENDER, TEAM, BRAND, MODEL, NATION, YEARS, BIKENO)
    return render_template('/riders/add.html', result=result.load_riders(), current_time=now.ctime())
예제 #7
0
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())
예제 #8
0
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())
예제 #9
0
def fans():
    riders = ridersClass(dsn = app.config['dsn'])
    personal = personalClass(dsn = app.config['dsn'])
    result = fansClass(dsn = app.config['dsn'])
    now = datetime.datetime.now()
    if 'adddefault' in request.form:
        NAME = request.form['name']
        SURNAME = request.form['surname']
        MAIL = request.form['mail']
        BIRTH = request.form['birth']
        FANSID = request.form['fansid']
        result.add_fans_default(NAME, SURNAME, MAIL, BIRTH, FANSID)
    elif 'updatebymail' in request.form:
        CMAIL = request.form['cmail']
        NAME = request.form['name']
        SURNAME = request.form['surname']
        MAIL = request.form['mail']
        BIRTH = request.form['birth']
        result.update_fans_by_mail(NAME, SURNAME, MAIL, BIRTH, CMAIL)
    elif 'updatebynum' in request.form:
        NUM = request.form['num']
        NAME = request.form['name']
        SURNAME = request.form['surname']
        MAIL = request.form['mail']
        BIRTH = request.form['birth']
        FANSID = request.form['fansid']
        result.update_fans_by_rider(NUM, NAME, SURNAME, MAIL, BIRTH, FANSID)
    elif 'searchdefault' in request.form:
        NAME = request.form['name']
        SURNAME = request.form['name']
        MAIL = request.form['mail']
        FANSID = request.form['fansid']
        return render_template('/riders/fans.html', result=result.search_fans_default(NAME, SURNAME, MAIL, FANSID),riders=riders.load_riders(), personal=personal.load_personal(), current_time=now.ctime())
    elif 'delbymail' in request.form:
        MAIL = request.form['mail']
        result.del_fans_by_mail(MAIL)
    elif 'delbynum' in request.form:
        NUM = request.form['num']
        result.del_fans_by_num(NUM)
    return render_template('/riders/fans.html', result=result.load_fans(),riders=riders.load_riders(), personal=personal.load_personal(), current_time=now.ctime())
예제 #10
0
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'))
예제 #11
0
def personal():
    riders = ridersClass(dsn = app.config['dsn'])
    result = personalClass(dsn = app.config['dsn'])
    now = datetime.datetime.now()
    if 'adddefault' in request.form:
        BIRTH = request.form['birth']
        WEIGHT = request.form['weight']
        HEIGHT = request.form['height']
        FAVCIR = request.form['favcir']
        WEBSITE = request.form['website']
        FACEB = request.form['faceb']
        TWIT = request.form['twit']
        INSTA = request.form['insta']
        PERSID = request.form['persid']
        result.add_personal_default(BIRTH, WEIGHT, HEIGHT, FAVCIR, WEBSITE, FACEB, TWIT, INSTA, PERSID)
    elif 'updatebyrider' in request.form:
        BIRTH = request.form['birth']
        WEIGHT = request.form['weight']
        HEIGHT = request.form['height']
        FAVCIR = request.form['favcir']
        WEBSITE = request.form['website']
        FACEB = request.form['faceb']
        TWIT = request.form['twit']
        INSTA = request.form['insta']
        PERSID = request.form['persid']
        result.update_personal_by_rider(BIRTH, WEIGHT, HEIGHT, FAVCIR, WEBSITE, FACEB, TWIT, INSTA, FANS, PERSID)
    elif 'searchdefault' in request.form:
        PERSID = request.form['persid']
        return render_template('/riders/personal.html', result=result.search_personal_default(PERSID),riders=riders.load_riders(), current_time=now.ctime())
    elif 'delbyrider' in request.form:
        PERSID = request.form['persid']
        result.del_personal_by_rider(PERSID)
    elif 'delbynum' in request.form:
        NUM = request.form['num']
        result.del_personal_by_num(NUM)
    return render_template('/riders/personal.html', result=result.load_personal(),riders=riders.load_riders(), current_time=now.ctime())
예제 #12
0
def rlist():
    result = ridersClass(dsn = app.config['dsn'])
    now = datetime.datetime.now()
    return render_template('/riders/list.html', result=result.load_riders(), current_time=now.ctime())