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()
import cv2 import os import glob from database import Connection ##===================Connection Establishment===================================================================== username, password = '******', 'password' conn = Connection(username, password) conn.connect() conn.create_table() name=input('Enter your name ') x = conn.insert_value(name) ids = conn.select_value(name) conn.close_connection() ##=====================Camera Starts for dataset creation========================================================== cam = cv2.VideoCapture(0) detector=cv2.CascadeClassifier('cascade/haarcascade_frontalface_default.xml') if(int(x) == 1): q = "dataset/"+str(ids)+"*.jpg" w = [] for file in glob.glob(q): w.append(int(file.strip().split('\\')[-1].split('.')[1])) i = sorted(w)[-1] print("i =",i) else: i=0 offset=50 os.makedirs('dataset', exist_ok=True)