def Delete_Delivery(): Delivery_ID = request.json['DID'] Conditon = "DELIVERY_ID = '" + str(Delivery_ID) + "'" connector = SQL(server_name, server_admin, server_password) connector.delete_query(table='DELIVERY', sql_condition=Conditon) connector.close_connection() return "1"
def Accept_Request(): reqType = request.json['type'] ManagerID = request.json['MID'] connector = SQL(server_name, server_admin, server_password) if reqType == 'Delivery': Deliver_id = request.json['DID'] Condition = "DELIVERY_ID = '" + str(Deliver_id) + "'" connector.delete_query(table='delivery_verification', sql_condition=Condition) connector.update_query( table='DELIVERY', columns_values_dict={'MANAGER_ID': str(ManagerID)}, sql_condition=Condition) elif reqType == 'Store': Store_id = request.json['SID'] store_branch_id = request.json['BID'] Condition = "STORE_branch_ID = '" + str(store_branch_id) + "'" connector.delete_query(table='store_verification', sql_condition=Condition) connector.update_query( table='Store_branch', columns_values_dict={'MANAGER_ID': str(ManagerID)}, sql_condition=Condition) connector.close_connection() return "1"
def RemoveFromCart(): sql = SQL(server_name, server_admin) dentist_id = request.json['DentistID'] product_id = request.json['ProductID'] sql.delete_query( 'DentistCart', f" DENTIST_ID = {dentist_id} and PRODUCT_ID = {product_id}") sql.close_connection() return "1"
def Delete_Store(): Store_ID = request.json['SID'] Mid = request.json['MID'] Conditon = "STORE_ID = '" + str( Store_ID) + "'" + " AND MANAGER_ID = '" + str(Mid) + "'" print(Conditon) connector = SQL(server_name, server_admin, server_password) connector.delete_query(table='STORE_branch', sql_condition=Conditon) connector.close_connection() return "1"
def Reject_Request(): reqType = request.json['type'] ManagerID = request.json['MID'] connector = SQL(server_name, server_admin, server_password) if reqType == 'Delivery': Deliver_id = request.json['DID'] Condition = "DELIVERY_ID = '" + str(Deliver_id) + "'" connector.delete_query(table='delivery_verification', sql_condition=Condition) elif reqType == 'Store': Store_id = request.json['SID'] Condition = "STORE_ID = '" + str(Store_id) + "'" connector.delete_query(table='store_verification', sql_condition=Condition) connector.close_connection() return "1"
def ClearCart(): sql = SQL(server_name, server_admin) dentist_id = request.json['DentistID'] sql.delete_query('DentistCart', f" DENTIST_ID = {dentist_id}") sql.close_connection() return "1"