from flask import *
import face_recognition
import sqlite3
 
app = Flask (__name__ )


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

@app.route ("/storedata" , methods =[ 'GET' ] )
def storedata():
  # uname    =request.form.get("uname")
  # matching =request.form.get("matching")
  # rtime    =request.form.get("rtime")
  uname    =request.args.get("uname")
  matching =request.args.get("matching")
  rtime    =request.args.get("rtime")
  
  con  = sqlite3.connect("facedb")    # connect  database
  con.row_factory = sqlite3.Row   # create object of Row
  cur = con.cursor()              # create cursor object, which will hold records 
                                  # being fetched from database. 
  cur.execute( "insert into userdata (username ,  matching , recordingtime) values ('%s',%s,'%s')"%(uname,matching,rtime))
  #cur.execute("select * from students where email=='%s' and pswd=='%s'"%(useremail,userpswd))
  con.commit()
  con.close()
   
  return  redirect(url_for( 'datafetch'))

@app.route ("/data" )
def datafetch():
  # connect to Sqlite database and fetch data
  con  = sqlite3.connect("facedb")  # connect sms database
  con.row_factory = sqlite3.Row  # create object of Row
  cur = con.cursor()             # create cursor object, which will hold records 
                        # being fetched from database. 
  cur.execute( "select id, username, matching, recordingtime from userdata order by id desc limit 10")  # execute a SQL query to get the data
  rows = cur.fetchall()          # all the data pulled from database is stored in rows object 
  con.close ()
  return render_template ('data.html', data = rows)

if __name__ == '__main__' : 
  app.run()