def database_patients(self): self.Main.hide() self.Edit_doctors.hide() self.Doctors.hide() self.Edit_patients.hide() self.Patients.show() self.Edit_discount.hide() self.Medicines.hide() self.Discount.hide() self.Edit_medicines.hide() self.pushButton_pat_show.clicked.connect(self.load_patients) self.pushButton_pat_add.clicked.connect(self.add_patients) self.pushButton_pat_edit.clicked.connect(self.edit_patients) self.pushButton_pat_del.clicked.connect(self.delete_patients) self.pushButton_pat_search.clicked.connect(self.search_patients) self.pushButton_pat_menu.clicked.connect(self.creation) self.pushButton.clicked.connect(self.sort_alpha_patients) self.pushButton_2.clicked.connect(self.sort_id_patients) self.pushButton_3.clicked.connect(self.sort_date_patients) self.pushButton_4.clicked.connect(self.sort_date2_patients) self.pushButton_5.clicked.connect(self.sort_sex1_patients) self.pushButton_6.clicked.connect(self.sort_sex2_patients) self.pushButton_7.clicked.connect(self.database_doctors) self.pushButton_8.clicked.connect(self.database_medicines) self.pushButton_9.clicked.connect(self.database_visits) self.pushButton_10.clicked.connect(self.database_discount) self.tableWidget_patients.setRowCount(0) for row_number, row_data in enumerate( Database_module.read_from_db_pat()): self.tableWidget_patients.insertRow(row_number) for column_number, data in enumerate(row_data): self.tableWidget_patients.setItem( row_number, column_number, QtWidgets.QTableWidgetItem(str(data)))
def load_patients(self): self.lineEdit_7.clear() self.tableWidget_patients.setRowCount(0) for row_number, row_data in enumerate( Database_module.read_from_db_pat()): self.tableWidget_patients.insertRow(row_number) for column_number, data in enumerate(row_data): self.tableWidget_patients.setItem( row_number, column_number, QtWidgets.QTableWidgetItem(str(data)))