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())
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())
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'))