def get(self): result = [] filter_exp = None with sqla_session() as session: query = session.query(Device) query = build_filter(Device, query) for instance in query: result.append(instance.as_dict()) return result
def get(self): result = empty_result() result['data'] = {'mgmtdomains': []} filter_exp = None with sqla_session() as session: query = session.query(Mgmtdomain) query = build_filter(Mgmtdomain, query).limit(limit_results()) for instance in query: result['data']['mgmtdomains'].append(instance.as_dict()) return result
def device_get(cls, hostname=''): result = [] with sqla_session() as session: if hostname != '': instance: Device = session.query(Device).filter( Device.hostname == hostname).one_or_none() return instance.id else: query = session.query(Device) query = build_filter(Device, query) for instance in query: result.append(instance.as_dict()) return result
def get(self): """ Get all management domains """ result = empty_result() result['data'] = {'mgmtdomains': []} filter_exp = None with sqla_session() as session: query = session.query(Mgmtdomain) try: query = build_filter(Mgmtdomain, query).limit(limit_results()) except Exception as e: return empty_result(status='error', data="Unable to filter mgmtdomains: {}".format(e)), 400 for instance in query: result['data']['mgmtdomains'].append(instance.as_dict()) return result
def get(self): """ Get all devices """ data = {'devices': []} total_count = 0 with sqla_session() as session: query = session.query(Device, func.count(Device.id).over().label('total')) try: query = build_filter(Device, query) except Exception as e: return empty_result(status='error', data="Unable to filter devices: {}".format(e)), 400 for instance in query: data['devices'].append(instance.Device.as_dict()) total_count = instance.total resp = make_response(json.dumps(empty_result(status='success', data=data)), 200) resp.headers['X-Total-Count'] = total_count resp.headers['Content-Type'] = 'application/json' return resp