sZh`SSKrSSKrSSKrSSKrSSKrSSKJr SrSrSr Sr Sr Sr S r g) N)datetimezapp/facial_attendance_db.dbc[RR[5(d [ S5 [ R "[5nUR5nURS5 URS5 UR5Vs/sHo"SPM nnSU;aURS5 SU;aURS5 URS 5 URS 5 UR5Vs/sHo"SPM nnS U;aURS 5 URS 5 URS5 UR5Vs/sHo"SPM nnS U;aURS5 UR5 SSS5 gs snfs snfs snf!,(df  g=f)zMSets up the database and creates necessary tables or migrates them if needed.z Creating facial_attendance_db...a CREATE TABLE IF NOT EXISTS USERS ( id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, email TEXT, employee_code TEXT, UNIQUE(name, email, employee_code) ) zPRAGMA table_info(USERS)emailz'ALTER TABLE USERS ADD COLUMN email TEXT employee_codez/ALTER TABLE USERS ADD COLUMN employee_code TEXTa, CREATE TABLE IF NOT EXISTS attendance ( id INTEGER PRIMARY KEY AUTOINCREMENT, user_id INTEGER, timestamp DATETIME DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY(user_id) REFERENCES USERS(id) ON DELETE CASCADE ) zPRAGMA table_info(attendance)user_idz1ALTER TABLE attendance ADD COLUMN user_id INTEGERa8 CREATE TABLE IF NOT EXISTS USER_IMAGES ( id INTEGER PRIMARY KEY AUTOINCREMENT, user_id INTEGER, image_path TEXT, encoding TEXT NOT NULL, FOREIGN KEY(user_id) REFERENCES USERS(id) ON DELETE CASCADE ) zPRAGMA table_info(USER_IMAGES)z2ALTER TABLE USER_IMAGES ADD COLUMN user_id INTEGERN) ospathexists APP_DB_FILEprintsqlite3connectcursorexecutefetchallcommit)connrrowcolumnss 7D:\DownLoads\facial_attendance_system-main\app\utils.pydb_setupr sw 77>>+ & & 01  %   12%+__%67%6cq6%67 ' ! NND E ' ) NNL M    67%+__%67%6cq6%67 G # NNN O    78%+__%67%6cq6%67 G # NNO P a & %8 88[ & %s9AF/F !A$F/F%A F/ F*.)F/ F// F=c[RRU5(aH[R"U5n[R "U5nU(aUS$[ SUS35 g[ SUS35 g)z"Encodes the face in an image file.rzWarning: No faces found in 'z'.zError: Image file ' ' not found.N)r r r face_recognitionload_image_fileface_encodingsr )img_pathimg_data img_encodingss r encode_imgr!@sq ww~~h#33H=(77A  # # ,XJb9:  #H:\:; c/n[R"[5nUR5nUR S5R 5nUHJn[ R"[R"US55nURUSUSU45 ML SSS5 U$!,(df  U$=f![an[SU35 SnAU$SnAff=f)z&Loads all encodings from the database.z$SELECT id, name, encoding FROM USERSrrNzError loading encodings: ) rrr rrrnparrayjsonloadsappend Exceptionr )encoding_listsrrresultsrencodinges rload_encodingsr/LsN/ __[ )T[[]Fnn%KLUUWG88DJJs1v$67%%s1vs1vx&@A* * )  / )!-.. /s5B:BB(B:( B72B:7B:: CCCc[R"[5nUR5nUR SU45 UR 5nU(a\USn[ R"5RS5nUR SXE45 UR5 [SUS35 O[SUS35 S S S 5 g !,(df  g =f![Ran[S U35 S nAg S nAff=f) z"Marks attendance for a given user.z!SELECT id FROM USERS WHERE name=?rz%Y-%m-%d %H:%M:%Sz9INSERT INTO attendance (user_id, timestamp) VALUES (?, ?)zAttendance marked for .zUser 'rNzError marking attendance: ) rrr rrfetchonernowstrftimerr Error) user_namerrrr local_timer.s rmark_attendancer8Zs0 __[ )T[[]F NN> M//#Ca&%\\^445HI Z]d\qr .yk;<yk67* ) ) ==0 *1#.//0s5CB&C C CCCD0DDc[R"[5nUR5nUR S5R 5nUsSSS5 $!,(df  /$=f![ an[SU35 SnA/$SnAff=f)z1Fetches all attendance records with user details.z SELECT u.name, u.employee_code, a.timestamp FROM attendance a JOIN USERS u ON a.user_id = u.id ORDER BY a.timestamp DESC Nz Error fetching attendance logs: )rrr rrrr*r )rrr,r.s rfetch_attendance_logsr:ms 6 __[ )T[[]Fnn&   * ) ) I 6 0455 I6s4A)1A A) A&!A)&A)) B 3BB c[R"[5nUR5nUR SU45R 5nUHJunU(dM[ RRU5(dM4[ R"U5 ML UR SU45 UR SU45 UR SU45 UR5 SSS5 g!,(df  g=f)z7Deletes a user and all their data (images, attendance).z2SELECT image_path FROM USER_IMAGES WHERE user_id=?z'DELETE FROM USER_IMAGES WHERE user_id=?z&DELETE FROM attendance WHERE user_id=?zDELETE FROM USERS WHERE id=?N) rrr rrrr r r remover)rrrimagesrs r delete_userr>}s  % TW^V`ajjl!KXxBGGNN844 (#" @7*M?'L5zB  & % %s>C/"C/A#C// C=)r rr'rnumpyr%rr rr!r/r8r:r>r"rrAs;  + 4l  0& r"