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'