def database_medicines(self):
self.Main.hide()
self.Edit_doctors.hide()
self.Edit_patients.hide()
self.Edit_medicines.hide()
self.Patients.hide()
self.Discount.hide()
self.Edit_discount.hide()
self.Doctors.hide()
self.Medicines.show()
self.pushButton_med_show.clicked.connect(self.load_medicines)
self.pushButton_med_add.clicked.connect(self.add_medicines)
self.pushButton_med_edit.clicked.connect(self.edit_medicines)
self.pushButton_med_del.clicked.connect(self.delete_medicines)
self.pushButton_med_search.clicked.connect(self.search_medicines)
self.pushButton_med_menu.clicked.connect(self.creation)
self.pushButton_22.clicked.connect(self.sort_alpha_medicines)
self.pushButton_19.clicked.connect(self.sort_id_medicines)
self.pushButton_20.clicked.connect(self.sort_cost1_medicines)
self.pushButton_21.clicked.connect(self.sort_cost2_medicines)
self.pushButton_24.clicked.connect(self.database_patients)
self.pushButton_23.clicked.connect(self.database_doctors)
self.pushButton_25.clicked.connect(self.database_visits)
self.pushButton_26.clicked.connect(self.database_discount)
self.tableWidget_medicines.setRowCount(0)
for row_number, row_data in enumerate(
Database_module.read_from_db_med()):
self.tableWidget_medicines.insertRow(row_number)
for column_number, data in enumerate(row_data):
self.tableWidget_medicines.setItem(
row_number, column_number,
QtWidgets.QTableWidgetItem(str(data)))
def load_medicines(self):
self.tableWidget_medicines.setRowCount(0)
for row_number, row_data in enumerate(
Database_module.read_from_db_med()):
self.tableWidget_medicines.insertRow(row_number)
for column_number, data in enumerate(row_data):
self.tableWidget_medicines.setItem(
row_number, column_number,
QtWidgets.QTableWidgetItem(str(data)))