import serial
import time
import MySQLdb as mdb
import datetime

arduino = serial.Serial("/dev/ttyACM0")
arduino.baudrate=9600

while 1:

    data = arduino.readline()
    date = datetime.datetime.now()

    con = mdb.connect('localhost', 'root', 'Id695207', 'spaarpotDb');

    with con:

        cursor = con.cursor()
	if data.strip()  ==  "clear":
		cursor.execute("TRUNCATE TABLE Inhoud")
		con.commit()
		cursor.execute("TRUNCATE TABLE DateTime")
		con.commit()
		cursor.close();
	else:
		cursor.execute("""INSERT INTO spaarpotDb.Inhoud VALUES('', %s)""", (data))
		con.commit()
	        cursor.execute("""INSERT INTO spaarpotDb.DateTime VALUES('', %s)""", (date))
		con.commit()
	        cursor.close()

arduino.close()
