8Zh \ddlZddlZddlZddlZddlZddlmZdZdZdZ dZ dZ dZ dS) N)datetimezapp/facial_attendance_db.dbctjtst dt jt5}|}|d|d|d| ddddS#1swxYwYdS)z2Sets up the database and creates necessary tables.z Creating facial_attendance_db...z CREATE TABLE IF NOT EXISTS USERS ( id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT UNIQUE NOT NULL ) z CREATE TABLE IF NOT EXISTS attendance ( id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, timestamp DATETIME DEFAULT CURRENT_TIMESTAMP ) a/ CREATE TABLE IF NOT EXISTS USER_IMAGES ( id INTEGER PRIMARY KEY AUTOINCREMENT, user_id INTEGER NOT NULL, image_path TEXT, encoding TEXT NOT NULL, FOREIGN KEY(user_id) REFERENCES USERS(id) ) N) ospathexists APP_DB_FILEprintsqlite3connectcursorexecutecommit)connr s 7D:\DownLoads\facial_attendance_system-main\app\utils.pydb_setupr s  7>>+ & &2 0111  % %              1s A(CC Cctj|rFtj|}tj|}|r|dSt d|dnt d|ddS)z"Encodes the face in an image file.rzWarning: No faces found in 'z'.zError: Image file 'z ' not found.N)rrrface_recognitionload_image_fileface_encodingsr )img_pathimg_data img_encodingss r encode_imgr(s w~~h<#3H==(7AA  $ # # 9X999:::: :H:::;;; 4cg} tjt5}|}|d}|D]R}t jtj |d}| |d|d|fS dddn #1swxYwYn)#t$r}td|Yd}~nd}~wwxYw|S)z&Loads all encodings from the database.z$SELECT id, name, encoding FROM USERSrNzError loading encodings: ) r r rr r fetchallnparrayjsonloadsappend Exceptionr )encoding_listsrr resultsrowencodinges rload_encodingsr*4sQN/ _[ ) ) BT[[]]Fnn%KLLUUWWG B B8DJs1v$6$677%%s1vs1vx&@AAAA B B B B B B B B B B B B B B B B /// -!--......../ s;CBB;/ C;B??CB?C C-C((C-c tjt5}|}t jd}|d||f|td|dddddS#1swxYwYdS#tj $r}td|Yd}~dSd}~wwxYw)z"Marks attendance for a given user.z%Y-%m-%d %H:%M:%Sz6INSERT INTO attendance (name, timestamp) VALUES (?, ?)zAttendance marked for .NzError marking attendance: ) r r rr rnowstrftimer rr Error) user_namerr local_timer)s rmark_attendancer2Bs.0 _[ ) ) 9T[[]]F!001DEEJ NNSV_akUl m m m KKMMM 79777 8 8 8  9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 =000 .1../////////0s;B/A:B" B/"B&&B/)B&*B//C>CCc8 tjt5}|}|d}|cdddS#1swxYwYn)#t $r}td|Yd}~nd}~wwxYwgS)zFetches all attendance records.z&SELECT name, timestamp FROM attendanceNz Error fetching attendance logs: )r r rr r rr$r )rr r&r)s rfetch_attendance_logsr4Ns6 _[ ) ) T[[]]Fnn%MNNWWYYG                  666 444555555556 Is:A1=A% A1%A))A1,A)-A11 B;BB) rr r!rnumpyrrrrrr*r2r4rrr7s  + <       0 0 0     r