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()