def insert_callback():
status, result = con.execute_query(
con.insert_query.format(table=con.current_table,
values="({0},{1},{2})".format(
shop_id.get(), monthly_profit.get(),
address.get())))
con.text_label['text'] = status
def insert_callback():
status, result = con.execute_query(
con.insert_query.format(table=con.current_table,
values="({0},{1},{2})".format(
order_id.get(), customer_id.get(),
assortment_id.get())))
con.text_label['text'] = status
def insert_callback():
status, result = con.execute_query(
con.insert_query.format(table=con.current_table,
values="({0},{1},{2},{3})".format(
customer_id.get(), raiting.get(),
worker_id.get(), name.get())))
con.text_label['text'] = status
def insert_callback():
status, result = con.execute_query(
con.insert_query.format(table=con.current_table,
values="({0},{1},{2},{3},{4})".format(
worker_id.get(), shop_id.get(),
name.get(), surname.get(),
position.get())))
con.text_label['text'] = status
def insert_callback():
status, result = con.execute_query(
con.insert_query.format(
table=con.current_table,
values="({commodity_id},{name},{price})".format(
commodity_id=commodity_id.get(),
name=name.get(),
price=price.get())))
con.text_label['text'] = status
def delete_statement():
status, result = con.execute_query(
con.delete_query.format(table=con.current_table,
field=current_field_name,
value=value.get()))
con.text_label['text'] = status