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
