from flask import Flask, render_template, request
from flask.logging import create_logger
from flask_mysqldb import MySQL
from mysql.connector import connection

mysql = MySQL()
app = Flask(__name__)

@app.route('/')
@app.route('/insert')
def insert():
    return render_template('insert.html')

@app.route('/insert_result', methods=['POST'])
def get_insert_result() :
    cnx = connection.MySQLConnection(user='your_user_name', password='your_password',
                                                                   host='your_host', database='your_database')
    cursor = cnx.cursor()
    insert_db = ("INSERT INTO your_table_name"
                                       "(your_value1, your_value2, your_value3, your_value4, your_value5, your_value6)"
                                       "VALUES (%s, %s, %s, %s, %s, %s)")
    value1 = request.form['value1']
    value2 = request.form['value2']
    value3 = request.form['value3']
    value4 = request.form['value4']
    value5 = request.form['value5']
    value6 = request.form['value6']

    data_db = (value1, value2, value3, value4, value5, value6)
    cursor.execute(insert_db, data_db)
    cnx.commit()
    cnx.close()
    return render_template('insert_result.html', value1 = value1)

@app.route('/list')
def list():
    return render_template('list.html')

@app.errorhandler(400)
def internal_error(exception):
    app.logger.error(exception)
    return render_template('400.html'), 400
@app.errorhandler(500)
def internal_error(exception):
    app.logger.error(exception)
    return render_template('500.html'), 500

if __name__ == "__main__":
    app.debug = True
    app.run(host='127.0.0.1')