import cv2
from database import Connection
username, password = '******', 'password'
conn = Connection(username, password)
conn.connect()
data = conn.select_all()
names_dict = {}
for ids, name in data:
names_dict[str(ids)] = name
conn.close_connection()
recognizer = cv2.face.LBPHFaceRecognizer_create()
recognizer.read('trainer/trainer.yml')
cascadePath = "cascade/haarcascade_frontalface_default.xml"
faceCascade = cv2.CascadeClassifier(cascadePath)
path = 'dataSet'
cam = cv2.VideoCapture(0)
fontFace = cv2.FONT_HERSHEY_SIMPLEX
fontScale = 1
fontColor = (255, 255, 255)
##width_d, height_d = 720, 720
while True:
ret, im = cam.read()
gray = cv2.cvtColor(im, cv2.COLOR_BGR2GRAY)
faces = faceCascade.detectMultiScale(gray,
scaleFactor=1.1,
username = config.get('MOVIES', 'MYSQL_USER')
password = config.get('MOVIES', 'MYSQL_PASSWORD')
##-----------------------------------------------------------------------------
##-----------------------------------------------------------------------------
conn = Connection(username, password)
conn.connect()
conn.create_table()
print("Enter Number of Users you want to Register", end=" ")
n = int(input())
for i in range(n):
x = input("Email address:")
tv = input("TV series:")
insert = True
for ser in conn.select_value(x):
if ser[0] == tv:
insert = False
if insert:
conn.insert_value(x.lower(), tv.lower())
else:
print("Database already has your information")
email = Email()
grab = grabber()
for x in conn.select_all():
recv, series = x[0], x[1]
email.send(recv, grab.information(series))
conn.close_connection()
