import MySQLdb
from flask import Flask, abort, request
from serial import Serial

app = Flask(__name__)

ser = Serial("COM3",baudrate=115200)

name = ""
category = ""
locationX, locationY = 0, 0

@app.route('/',methods=['GET','POST'])
def retrieve():
    name = str(request.args.get('name'))
    if "%20" in name:
        name = name.replace("%20"," ")
    category = str(request.args.get('category'))
    if "%20" in category:
        category = category.replace("%20"," ")
    print(name+category)
    cur.execute("SELECT * FROM parts WHERE name LIKE '"+name+"' AND category LIKE '"+category+"'")

    for row in cur.fetchall():
        locationX = int(row[5])
        locationY = int(row[6])
        print("id=%d, category=%s, name=%s, quantity=%d, x=%d, y=%d" % (row[0], row[1], row[2], row[3], row[5], row[6]))
        
    ser.write(str.encode("MOVE,"+str(locationX)+","+str(locationY)+"\n"))
    return "done"

db = MySQLdb.connect(host="192.168.0.7",user="having11",passwd="July41997%",db="components")

cur = db.cursor()
    
if __name__=='__main__':
    try:
        app.run(host='192.168.0.33',port=5000)
    except:
        db.close()
        ser.close()