i&4SSKrSSKrSSKJr "SS5rg)N)Configc\rSrSrSr\S5r\S5r\S Sj5r\S5r \S5r SS jr \S 5r \S 5r S rg)RegisteredUserz Model for managing registered users in the database. This table stores metadata about the registration itself, while user_data.json stores HRIS details. cH[RR[R[R [R [R[RS9nU$![RRan[SU35 SnAgSnAff=f)z"Establishes a database connection.)hostportuserpassworddatabasez$Error connecting to MySQL Database: N) mysql connectorconnectrDB_HOSTDB_PORTDB_USER DB_PASSWORDDB_NAMEErrorprint)connes 4/var/www/fran/franai/models/registered_user_model.pyget_db_connection RegisteredUser.get_db_connection sy ??**^^^^^^++ +DK$$  8< = sA(A++B! BB!c [R5nU(dgUR5nURS5 UR 5 [ S5 UR5(a!WR5 UR5 gg![ RRan[ SU35 SnANhSnAff=f!UR5(a!WR5 UR5 ff=f)z?Creates the registered_users table if it doesn't already exist.Na CREATE TABLE IF NOT EXISTS registered_users ( id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, pid INT UNSIGNED NOT NULL, registered_at DATETIME NOT NULL, last_modified DATETIME NOT NULL, last_recognition_timestamp DATETIME NULL, self_register BOOLEAN DEFAULT FALSE, email_timestamp DATETIME NULL, UNIQUE KEY (pid) ) zA[OK] 'registered_users' table exists or was successfully created.z)Error creating 'registered_users' table: ) rrcursorexecutecommitrr rr is_connectedclose)rrrs rcreate_table_if_not_exists)RegisteredUser.create_table_if_not_existss//1  [[]F NN   KKM U V  ""  #$$ C =aSA B B C  ""  #s)!(()@AMM!$'--/>A!(()^_MM!$L'',,}*EE DJ  ""  #    ""  #s)1BC2$C-2C5-C22C558D-cp[R5nU(dgUR5nURSU45 UR 5nUSLUR 5(a!UR 5 UR 5 $$![RRaQn[SUSU35 SnAUR 5(a!WR 5 UR 5 ggSnAff=f!UR 5(a!WR 5 UR 5 ff=f)z4Checks if a user is already registered by their PID.Fz/SELECT pid FROM registered_users WHERE pid = %sNz$Error checking registration for PID r%) rrrrrJr r!r rrr)r)rrresultrs r is_registeredRegisteredUser.is_registereds//1 [[]F NNLsf U__&F%   ""  # $$  8RsC D  ""  #    ""  #s)6B C:)C5:C=5C::C==8D5)F)r= NNF)__name__ __module__ __qualname____firstlineno____doc__ staticmethodrr"r-r0r4r[r^rb__static_attributes__rdrrrs   :  D*0Tl$rmr)mysql.connectorr datetimefranai.services.configrrrdrmrrqs)BBrm