def markAttendance(prn, classroom, course_name, date_time=datetime.now().strftime("%Y-%m-%d %H:%M:%S")): connection = establishConnection() cursor = connection.cursor() cursor.execute( """SELECT course_code FROM course WHERE course_name = '%s'""" % (course_name)) r = cursor.fetchone() if not r: print( f'Error: Course {course_name} does not exist in the database... Check spelling' ) return 'Failed: Unsuccessful in marking attendnace of student...' else: course_code = r[0] cursor.execute("""INSERT INTO attends VALUES(%s, '%s', '%s', %s) ; """ % (prn, date_time, classroom, course_code)) cursor.close() connection.commit() connection.close() return f"Attendance of student with PRN {prn} for course {course_name} dated on {date_time} in venue {classroom} is succesfully recorded!"
def recordLectureConductedByFaculty(lecture, faculty_name, course_name): connection = establishConnection() cursor = connection.cursor() cursor.execute( """ SELECT emp_id FROM faculty WHERE faculty_name = '%s' """ % (faculty_name)) r = cursor.fetchone() if not r: return 'Error: Faculty name {faculty_name} not found in the database' else: emp_id = r[0] cursor.execute( """SELECT course_code FROM course WHERE course_name = '%s' """ % (course_name)) r = cursor.fetchone() if not r: return 'Error: Course name {course_name} not found in the database' else: course_code = r[0] cursor.execute("""INSERT INTO conducts VALUES('%s', '%s', %s, %s)""" % (lecture[1], lecture[0], emp_id, course_code)) cursor.close() connection.commit() connection.close() return f"Lecture conducted by faculty {faculty_name} dated {lecture[1]} in classroom {lecture[0]} is recorded in the database."
def recordLecture(classroom, date_time=datetime.now().strftime("%Y-%m-%d %H:%M:%S")): connection = establishConnection() cursor = connection.cursor() cursor.execute("INSERT INTO lecture VALUES('%s', '%s')" % (date_time, classroom)) lecture = (classroom, date_time) cursor.close() connection.commit() connection.close() return lecture
lh.landmark2id["PINKY_TIP"]].x isRight = index_x > pinky_x # mediapipe comes with an build in handiness detection, that can be used instead of the custom check #hand_label = results.multi_handedness[hand_idx].classification[0].label #isRight = True if hand_label == "Right" else False handdata.Hand = hd.HandData.HandType.RightHand if isRight else hd.HandData.HandType.LeftHand for hand_idx in range(0, 21): landmark = handdata.Landmarks.add() landmark.X = hand_landmarks.landmark[hand_idx].x landmark.Y = hand_landmarks.landmark[hand_idx].y landmark.Z = hand_landmarks.landmark[hand_idx].z landmark.Type = hand_idx mp_drawing.draw_landmarks(image, hand_landmarks, mp_hands.HAND_CONNECTIONS) connection.send(message.SerializeToString()) if SHOW_WINDOW: cv2.imshow('MediaPipe Hands', image) if cv2.waitKey(5) & 0xFF == 27: break finally: hands.close() cap.release() connection.close()
def close(self): self.keep_running = False for connection in self.connections: connection.close() self.sock.close() while not self.closed: pass
def __del__(self): connection.close()
current_time = time.time() if(current_time - keepalive_time) > 900: logging.add_log(0, "A keepalive was sent") connection.keepalive(active_socket_file) keepalive_time = current_time packet_str = connection.get_message(active_socket_file) if -2 is helpers.main_func(libfap, glider_id_array, towingplane_id_array, active_database_connection, packet_str): break except KeyboardInterrupt: logging.add_log(0, "KeyboardInterrupt detected -> Quiting") break # <----- while break ------> # Close libfap.py to avoid memory leak libfap.fap_cleanup() connection.close(active_socket) database.logout(active_database_connection) now = time.strftime("%c") logging.add_log(0, ("------------------- Stop ------- %s --------------------------------" % now) ) logging.add_log(1, ("------------------- Stop ------- %s --------------------------------" % now) ) logging.add_log(2, ("------------------- Stop ------- %s --------------------------------" % now) ) logging.log_packet ("------------------- Stop ------- %s --------------------------------" % now)
def disconnect(connection): if (connection.is_connected()): connection.close() print("MySQL connection is closed") else: print("Not connected to the database")
def close_connection(connection): connection.close()
def close(self, reason): if not self.persist: self.queue.clear() connection.close(self.server)