import sys
import dlib
import cv2
import face_recognition
import os
import psycopg2

if len(sys.argv) < 2:
    print("Usage: face-find <image>")
    exit(1)

# Take the image file name from the command line
file_name = sys.argv[1]

# Create a HOG face detector using the built-in dlib class
face_detector = dlib.get_frontal_face_detector()

# Load the image
image = cv2.imread(file_name)
print(image)

# Run the HOG face detector on the image data
detected_faces = face_detector(image, 1)

print("Found {} faces in the image file {}".format(len(detected_faces), file_name))

connection_db = psycopg2.connect("user='pr0n00gler' password='314159265' host='localhost' dbname='findface'")
db=connection_db.cursor()

# Loop through each face we found in the image
for i, face_rect in enumerate(detected_faces):
    # Detected faces are returned as an object with the coordinates
    # of the top, left, right and bottom edges
    print("- Face #{} found at Left: {} Top: {} Right: {} Bottom: {}".format(i, face_rect.left(), face_rect.top(),
                                                                             face_rect.right(), face_rect.bottom()))
    crop = image[face_rect.top():face_rect.bottom(), face_rect.left():face_rect.right()]

    encodings = face_recognition.face_encodings(crop)
    if len(encodings) > 0:
        query = "SELECT user_id FROM face ORDER BY " + \
                "(CUBE(array[{}]) <-> vec_low) + (CUBE(array[{}]) <-> vec_high) ASC;".format(
            ','.join(str(s) for s in encodings[0][0:63]),
            ','.join(str(s) for s in encodings[0][64:127]),
        )
        print(query)
        db.execute(query)
        print("The number of parts: ", db.rowcount)
        row = db.fetchone()

        while row is not None:
            print(row)
            row = db.fetchone()

        db.close()
    else:
        print("No encodings")

if connection_db is not None:
    connection_db.close()