#!/usr/bin/env python
# -*- coding: utf8 -*-


import RPi.GPIO as GPIO #for cleanup of pins
import MFRC522 #loads libary
import signal #loads package for loop kill
import time
import mysql.connector as mariadb

mydb = mariadb.connect(user='mysql', password='somepass', database='ICA')


read_loop = True

# Capture input for cleanup when stopped
def end_read(signal,frame):
    global read_loop
    print "Ctrl+C captured, ending read."
    read_loop = False
    GPIO.cleanup()

# Hook for signal input
signal.signal(signal.SIGINT, end_read)

MIFAREReader = MFRC522.MFRC522()

print "Scan ID"

#start read_loop
while read_loop:

    #scan for cards
    (status,TagType) = MIFAREReader.MFRC522_Request(MIFAREReader.PICC_REQIDL)

    #is card
    if status == MIFAREReader.MI_OK:
        (status,uid) = MIFAREReader.MFRC522_Anticoll()
        #Prints string as easy to read
        u_scan = "%s%s%s%s" % (uid[0], uid[1], uid[2], uid[3])
        print(u_scan)
        my_cursor = mydb.cursor()
        my_cursor.execute("SELECT uid FROM ICA.user WHERE uid=%s", (u_scan,))
        result = my_cursor.fetchall()
        for arto in result:
            form = arto[0]
        print (form)
        if form == u_scan:
            print(u_scan + " Authorised")
            my_cursor.execute("SELECT clockin FROM ICA.user WHERE uid=%s", (u_scan,))
            isin = my_cursor.fetchall()
            if isin == none
                my_cursor.execute("INSERT INTO ICA.user(clockin) VALUES (GETDATE())")
            else
                my_cursor.execute("INSERT INTO ICA.user(clockout) VALUES (GETDATE())")
        if form != u_scan:
            print ("Not authorised, " + u_scan + " has been logged")
            my_cursor.execute("INSERTINTO ICA.unauth(uid,times) VALUES (%s,GETDATE()) (u_scan,) ")
        #for rarto in result:
         #   print(row[0] + "authorised")
        time.sleep(2)