def Another(): global saved_ if saved_ == False: faces = [] if len(os.listdir("../Faces/"+str(Details[0]))) > 6: messagebox.showinfo('Delete Extra Images','Kindly delete extra images and keep only 6') return 0 for face in os.listdir("../Faces/"+str(Details[0])): img = cv2.imread("../Faces/"+str(Details[0])+"/"+face) faces.append(ExtractFeatures(img)) faces = np.array(faces) String_Code = faces.__repr__() mydb= connector.connect(host = "localhost", user= "******", passwd = "aayush123", database="testdb") cursor = mydb.cursor() q = "insert into userse (name,age,gender,post,contact,address, encodings) values ( %s , %s , %s , %s , %s , %s , %s )" data = [(Details[1], int(Details[2]), Details[3], Details[4], Details[5], Details[6], String_Code ) ] print(data) cursor.executemany(q,data) mydb.commit() saved_ = True mydb= connector.connect(host = "localhost", user= "******", passwd = "aayush123", database="testdb") cursor = mydb.cursor() cursor.execute("Select count(ID) from userse") result = cursor.fetchall() incrementedID = int(result[0][0]) + 1 top.destroy() Names.EnterData(incrementedID)
def ADD(): window.destroy() Names.EnterData(incrementedID)