def add_car():
idColor = db.get_idcolor(color_input.get())
idModel = db.get_idModel(model_name_input.get())
idBody_type = db.get_idBody_type(body_type_input.get())
values = (transmition_input.get(),
mileage_input.get(), num_ptc_input.get(), price_input.get(),
year_issue_input.get(), float(engine_capacity_input.get()),
int(idColor), int(idBody_type), int(idModel))
db.add_car(values)
messagebox.showinfo('', 'Машина добавлена!')
def add_car():
idColor = db.get_idcolor(color_input.get())
idModel = db.get_idModel(model_name_input.get())
idBody_type = db.get_idBody_type(body_type_input.get())
sql_command = 'INSERT INTO Cars(Transmition, Mileage, PTC, Price, Year_of_issue, Engine_capacity, Color_idColor, Body_type_idBody_type, Model_idModel) VALUES(%s, %s, %s, %s, %s, %s, %s, %s, %s)'
values = (transmition_input.get(),
mileage_input.get(), num_ptc_input.get(), price_input.get(),
year_issue_input.get(), float(engine_capacity_input.get()),
int(idColor), int(idBody_type), int(idModel))
db.execute(sql_command, values)
# commit changes
db.commit()
messagebox.showinfo('', 'Машина добавлена!')
def search_car():
sql_command = "SELECT * FROM Cars WHERE "
where_clauses = []
if not (color_input_s.get() == ''):
idColor = db.get_idcolor(color_input_s.get())
else:
idColor = ''
if not (model_name_input_s.get() == ''):
idModel = db.get_idModel(model_name_input_s.get())
else:
idModel = ''
if not (body_type_input_s.get() == ''):
idBody_type = db.get_idBody_type(body_type_input_s.get())
else:
idBody_type = ''
transmition = transmition_input_s.get()
mileage = mileage_input_s.get()
engineCapacity = engine_capacity_input_s.get()
year = year_issue_input_s.get()
price = price_input_s.get()
car_dict = create_dict(idModel, idBody_type, transmition, idColor, mileage,
engineCapacity, year, price)
for key in car_dict.keys():
if not (car_dict.get(key) == None or car_dict.get(key) == ''):
where_clauses.append(key + "=" + "'" + car_dict.get(key) + "'")
where_clauses = ' AND '.join(where_clauses)
db.execute(sql_command + where_clauses)
result = [i for i in mycursor]
if result:
for i in result:
if db.check_availability(i) == None:
txt.insert(INSERT, display_result(i) + '\n')
else:
messagebox.showinfo('Ошибка',
"Машина с такими характеристиками отсутствует!")
def update_car():
sql_command = 'UPDATE Cars SET %s WHERE idCars=%s'
idCar = idCar_input_c.get()
set_clauses = []
if not (color_input.get() == ''):
idColor = db.get_idcolor(color_input.get())
else:
idColor = ''
if not (model_name_input.get() == ''):
idModel = db.get_idModel(model_name_input.get())
else:
idModel = ''
if not (body_type_input.get() == ''):
idBody_type = db.get_idBody_type(body_type_input.get())
else:
idBody_type = ''
transmition = transmition_input.get()
mileage = mileage_input.get()
engineCapacity = engine_capacity_input.get()
year = year_issue_input.get()
price = price_input.get()
car_dict = create_dict(idModel, idBody_type, transmition, idColor, mileage,
engineCapacity, year, price)
for key in car_dict.keys():
if not (car_dict.get(key) == None or car_dict.get(key) == ''):
set_clauses.append(key + "=" + "'" + car_dict.get(key) + "'")
set_clauses = ', '.join(set_clauses)
print(sql_command % (set_clauses, int(idCar)))
if idCar:
db.execute(sql_command % (set_clauses, int(idCar)))
db.commit()
messagebox.showinfo('', 'Данные успешно изменены!')
else:
messagebox.showinfo('Ошибка!',
'Для изменения необходимо ввести номер машины!')
def search_color_in_db(value):
if not (value == ''):
return db.get_idcolor(color_input_s.get())
else:
return ''