test

import os
import xlrd
import mysql.connector
import gc

import pandas as pd
from flask import Flask, render_template, request

__author__ = ''

app = Flask(__name__)

APP_ROOT = os.path.dirname(os.path.abspath(__file__))




@app.route("/")
def index():
    return render_template("upload.html")


@app.route("/upload", methods=['POST'])
def upload():
    data = request.files['file']
    df = pd.read_excel(data, sheet_name='Sheet1')
    print(df.columns.tolist())
   // database(df)

    # target = os.path.join(APP_ROOT, 'images/')
    # print(targetile
    #
    # if not os.path.isdir(target):
    #     os.mkdir(target)
    #
    # for file in request.files.getlist("file"):
    #     print(file)
    #     filename = file.filename
    #     destination = "/".join([target, filename])
    #     print(destination)
    #     file.save(destination)

    return render_template("complete.html")






#start()

#if __name__ == "__main__":
 #   app.run()

if __name__ == "__main__":
    app.run(port=4555, debug=True)