def del_material_record(dict_data):
with Globals.get_mysql_wrapper().session_scope() as session:
target_obj = session.query(MaterialRecord).filter_by(
id=dict_data['id']).first()
session.delete(target_obj)
return 'success'
def update_landing_page(dict_data):
with Globals.get_mysql_wrapper().session_scope() as session:
session.query(LandingPage).filter_by(
id=dict_data['id']).update(dict_data)
return 'success'
def update_resource(dict_data):
with Globals.get_mysql_wrapper().session_scope() as session:
session.query(Resources).filter_by(
id=dict_data['id']).update(dict_data)
return 'success'
def del_landing_page(dict_data):
with Globals.get_mysql_wrapper().session_scope() as session:
target_obj = session.query(LandingPage).filter_by(
id=dict_data['id']).first()
session.delete(target_obj)
return 'success'
def update_material(dict_data):
with Globals.get_mysql_wrapper().session_scope() as session:
session.query(Material).filter_by(asin=dict_data['asin']).update(dict_data)
return 'success'
def del_material(dict_data):
with Globals.get_mysql_wrapper().session_scope() as session:
target_obj = session.query(Material).filter_by(asin=dict_data['asin']).first()
session.delete(target_obj)
return 'success'
def update_case_status(dict_data):
with Globals.get_mysql_wrapper().session_scope() as session:
session.query(AdCase).filter_by(id=dict_data['id']).update(
status=dict_data['status'])
return 'success'
def del_case(dict_data):
with Globals.get_mysql_wrapper().session_scope() as session:
session.query(AdCase).filter_by(uid=dict_data['uid']).filter(
AdCase.id.in_(dict_data['id'])).delete(synchronize_session=False)
return 'success'
