def save_to_db(self): if not self.validate_fields(): self.dialog = MsgForm("Поля не прошли проверки") return connection = mysqlx.get_session(mysql_config) msg = "Сохранено" query = "" if self.insert: query = "Insert into garage.avto values(\"{0}\",\"{1}\", \"{2}\" ,{3})".format( self.MarkEdit.text(), self.NumberEdit.text(), str(dt_date(int(self.DateEdit.text()), 1, 1)), self.IdEdit.text()) else: try: query = "Update garage.avto set mark=\"{0}\", number=\"{1}\", date=\"{2}\" where id={3}".format( self.MarkEdit.text(), self.NumberEdit.text(), str(dt_date(int(self.DateEdit.text()), 1, 1)), self.IdEdit.text()) except Exception as e: print(e) try: connection.sql(query).execute() except Exception as e: msg = "Ошибка сохранения" finally: connection.close() self.dialog = MsgForm(msg) if self.pre_exit is not None: self.pre_exit(self, self.obj_out) if self.insert: self.insert = False
def save_to_db(self): if not self.validate_fields(): self.dialog = MsgForm("Поля не прошли проверки") return msg = "Сохранено" connection = mysqlx.get_session(mysql_config) if self.insert: query = "Insert into garage.driver values(\"{0}\",\"{1}\", \"{2}\" ,{3},{4})".format( self.NameEdit.text(), self.OldEdit.text(), self.ExperienceEdit.text(), self.PaymentEdit.text(), self.IdEdit.text()) else: query = "Update garage.driver set name=\"{0}\", old=\"{1}\", experience=\"{2}\", payment=\"{3}\" where id={4}".format( self.NameEdit.text(), self.OldEdit.text(), self.ExperienceEdit.text(), self.PaymentEdit.text(), self.IdEdit.text()) try: connection.sql(query).execute() except: msg = "Ошибка сохранения" finally: connection.close() self.dialog = MsgForm(msg) if self.pre_exit is not None: self.pre_exit(self, self.obj_out) if self.insert: self.insert = False
def save_to_db(self): msg = "Сохранено" connection = mysqlx.get_session(mysql_config) if not self.validate_fields(): self.dialog = MsgForm("Поля не прошли проверки") return try: if self.insert: query = "Insert into garage.route values(\"{0}\",\"{1}\", \"{2}\" ,{3},\"{4}\",{5},{6},{7})".format( self.StartEdit.text(), self.FinishEdit.text(), self.PlanTextEdit.toPlainText(), 1 if self.SuccessCheck.isChecked() else 0, self.ClientEdit.text(), self.avtos[self.AvtoComboBox.currentText()], self.drivers[self.DriverComboBox.currentText()], self.IdEdit.text()) else: try: query = "Update garage.route set start=\"{0}\", finish=\"{1}\", plane=\"{2}\", " \ "success={3}, client=\"{4}\", id_driver={5},id_avto={6} where id={7}"\ .format( self.StartEdit.text(), self.FinishEdit.text(), self.PlanTextEdit.toPlainText(), 1 if self.SuccessCheck.isChecked() else 0, self.ClientEdit.text(), self.drivers[self.DriverComboBox.currentText()], self.avtos[self.AvtoComboBox.currentText()], self.IdEdit.text() ) except Exception as e: raise Exception connection.sql(query).execute() except Exception as e: msg = "Ошибка сохранения" print(e) finally: connection.close() self.dialog = MsgForm(msg) if self.pre_exit is not None: self.pre_exit(self, self.obj_out) if self.insert: self.insert = False
def save_to_db(self): connection = mysqlx.get_session(mysql_config) msg = "Сохранено" if not self.validate_fields(): self.dialog = MsgForm("Поля не прошли проверки") return try: if self.insert: query = "Insert into garage.user values({0},{1},\"{2}\", \"{3}\" ,\"{4}\")".format( self.IdEdit.text(), self.poss[self.PosComboBox.currentText()], self.LoginEdit.text(), self.PasswordEdit.text(), self.NameEdit.text(), ) else: try: query = "Update garage.user set login=\"{0}\", password=\"{1}\", name=\"{2}\", id_position={3} where id={4}".format( self.LoginEdit.text(), self.PasswordEdit.text(), self.NameEdit.text(), self.poss[self.PosComboBox.currentText()], self.IdEdit.text(), ) except Exception as e: raise Exception connection.sql(query).execute() except Exception as e: msg = "Ошибка сохранения" finally: connection.close() self.dialog = MsgForm(msg) if self.pre_exit is not None: self.pre_exit(self, self.obj_out) if self.insert: self.insert = False
def avto_delete(self): reply = QMessageBox.question( self, 'Удалить!', 'Вы действительно хотите удалить запись?', QMessageBox.Yes | QMessageBox.No) if reply != QMessageBox.Yes: return selected_row = self.tableWidget.currentItem().row() if selected_row == None: self.dialog = MsgForm("Выбирите строку в таблице") return id = self.tableWidget.item(selected_row, 3).text() self.session = mysqlx.get_session(mysql_config) query = "Delete from garage.avto where id={}".format(id) self.session.sql(query).execute() self.session.close() self.tableWidget.removeRow(selected_row)
def driver_update(self): selected_row = self.tableWidget_2.currentItem() if selected_row == None: self.dialog = MsgForm("Выбирите строку в таблице") # self.dialog.show() return selected_row = selected_row.row() self.window = DriverForm(pre_exit=self.driver_update_pre_exit, obj_out=self.tableWidget_2) self.window.fill_fields( name=self.tableWidget_2.item(selected_row, 0).text(), old=self.tableWidget_2.item(selected_row, 1).text(), experience=self.tableWidget_2.item(selected_row, 2).text(), payment=self.tableWidget_2.item(selected_row, 3).text(), id=self.tableWidget_2.item(selected_row, 4).text()) self.window.show()
def user_update(self): selected_row = self.tableWidget_4.currentItem() if selected_row == None: self.dialog = MsgForm("Выбирите строку в таблице") return selected_row = selected_row.row() self.window = UserForm(pre_exit=self.user_update_pre_exit, obj_out=self.tableWidget_4) self.window.fill_fields( id=self.tableWidget_4.item(selected_row, 0).text(), id_position=2 if self.tableWidget_4.item(selected_row, 1).text() == 'диспетчер' else 1, login=self.tableWidget_4.item(selected_row, 2).text(), password=self.tableWidget_4.item(selected_row, 3).text(), name=self.tableWidget_4.item(selected_row, 4).text(), ) self.window.show()
def avto_update(self): selected_row = self.tableWidget.currentItem() if selected_row == None: self.dialog = MsgForm("Выбирите строку в таблице") # self.dialog.show() return selected_row = selected_row.row() self.window = AvtoForm(pre_exit=self.avto_update_pre_exit, obj_out=self.tableWidget) self.window.fill_fields(mark=self.tableWidget.item(selected_row, 0).text(), number=self.tableWidget.item(selected_row, 1).text(), date=self.tableWidget.item(selected_row, 2).text(), id=self.tableWidget.item(selected_row, 3).text()) self.window.show()
def route_update(self): selected_row = self.tableWidget_3.currentItem() if selected_row == None: self.dialog = MsgForm("Выбирите строку в таблице") return selected_row = selected_row.row() self.window = RouteForm(pre_exit=self.route_update_pre_exit, obj_out=self.tableWidget_3) self.window.fill_fields( start=self.tableWidget_3.item(selected_row, 0).text(), finish=self.tableWidget_3.item(selected_row, 1).text(), plane=self.tableWidget_3.item(selected_row, 2).text(), success=self.tableWidget_3.item(selected_row, 3).text() in ['1'], client=self.tableWidget_3.item(selected_row, 4).text(), id_avto=self.tableWidget_3.item(selected_row, 5).text(), id_driver=self.tableWidget_3.item(selected_row, 7).text(), id=self.tableWidget_3.item(selected_row, 8).text(), ) self.window.show()