def post(self): if not request.json: abort(400) else: data = request.json polleddata = session.query( models.Polleddata).filter_by(id=data.get('id')).first() if polleddata is None: return custom_response_flask_restful(request, 404, "polleddata chua ton tai", None, None) if data.get('name'): polleddata.name = data.get('name') if data.get('agent'): polleddata.agent = data.get('agent') if data.get('period'): polleddata.period = data.get('period') if data.get('active'): polleddata.active = data.get('active') if data.get('threshold_activate'): polleddata.threshold_activate = data.get('threshold_activate') if data.get('devicedetails_did'): polleddata.devicedetails_did = data.get('devicedetails_did') if data.get('groupdevices_group_id'): polleddata.groupdevices_group_id = data.get( 'groupdevices_group_id') if data.get('threshold_lists_id'): polleddata.threshold_lists_id = data.get('threshold_lists_id') if data.get('metricdetails_metricid'): polleddata.metricdetails_metricid = data.get( 'metricdetails_metricid') session.add(polleddata) session.commit() res = models.to_json(polleddata, 'Polleddata', False) session.close() return custom_response_flask_restful(request, 201, None, None, res)
def post(self): if not request.json: abort(400) else: data = request.json device = session.query( models.Devicedetail).filter_by(did=data.get('did')).first() if device is None: return custom_response_flask_restful(request, 404, "device chua ton tai", None, None) if data.get('mode'): device.mode = data.get('mode') if data.get('status'): device.status = data.get('status') if data.get('errorstring'): device.errorstring = data.get('errorstring') if data.get('timeinterval'): device.timeinterval = data.get('timeinterval') device.last_updated_on = datetime.now() if data.get('isprofilebased'): device.isprofilebased = data.get('isprofilebased') if data.get('fetch_rules'): device.fetch_rules = data.get('fetch_rules') if data.get('ip'): device.ip = data.get('ip') session.add(device) session.commit() res = models.to_json(device, 'Devicedetail', False) session.close() return custom_response_flask_restful(request, 201, None, None, res)
def post(self): if not request.json: abort(400) else: data = request.json threshold_lists = session.query(models.Threshold_list).filter_by(id=data.get('threshold_lists_id')).first() if threshold_lists is None: return custom_response_flask_restful(request, 404, "threshold_lists chua ton tai", None, None) thresholdobject = models.Thresholdobject(name=data.get('name', ""), kind=data.get('kind', ""), priority=data.get('priority', ""), category=data.get('category', ""), thresholdvalue=data.get('thresholdvalue', ""), rearmvalue=data.get('rearmvalue', ""), mmessage=data.get('mmessage', ""), allowed=data.get('allowed', ""), is_customize=data.get('is_customize', ""), consecutive_time=data.get('consecutive_time', ""), operator=data.get('operator', ""), severity=data.get('severity', "") , threshold_lists_id=data.get('threshold_lists_id', "") ) session.add(thresholdobject) session.commit() res = models.to_json(thresholdobject, 'Thresholdobject', False) session.close() return custom_response_flask_restful(request, 201, None, None, res)
def post(self): if not request.json: abort(400) else: data = request.json if data.get("rearmvalue") is None: return custom_response_flask_restful(request, 404, "rearmvalue phai duoc set", None, None) threshold_list = session.query(models.Threshold_list).filter_by( id=data.get('threshold_list_id')).first() if threshold_list is None: return custom_response_flask_restful( request, 404, "threshold_list chua ton tai", None, None) thresholdobjects = threshold_list.thresholdobjects for i in range(0, len(thresholdobjects)): thresholdobjects[i].thresholdvalue = data.get('threshold_value_' + str(i + 1)) thresholdobjects[i].rearmvalue = data.get('rearmvalue') session.add(threshold_list) session.commit() res = models.to_json(threshold_list, 'Threshold_list', False) session.close() return custom_response_flask_restful(request, 201, None, None, res)
def post(self): if not request.json: abort(400) else: data = request.json metricdetail = session.query(models.Metricdetail).filter_by(metricid=data.get('metricdetails_metricid')).first() if metricdetail is None: return custom_response_flask_restful(request, 404, "metricdetail chua ton tai", None, None) threshold_lists = session.query(models.Threshold_list).filter_by(id=data.get('threshold_lists_id')).first() if threshold_lists is None: return custom_response_flask_restful(request, 404, "threshold_lists chua ton tai", None, None) groupdevices = session.query(models.Groupdevice).filter_by(group_id=data.get('groupdevices_group_id')).first() if groupdevices is None: return custom_response_flask_restful(request, 404, "groupdevices chua ton tai", None, None) devicedetails = session.query(models.Devicedetail).filter_by(did=data.get('devicedetails_did')).first() if devicedetails is None: return custom_response_flask_restful(request, 404, "devicedetails chua ton tai", None, None) polleddata = models.Polleddata(name=data.get('name', ""), agent=data.get('agent', ""), period=data.get('period', ""), active=data.get('active', ""), threshold_activate=data.get('threshold_activate', ""), devicedetails_did=data.get('devicedetails_did', ""), groupdevices_group_id=data.get('groupdevices_group_id', ""), threshold_lists_id=data.get('threshold_lists_id', ""), metricdetails_metricid=data.get('metricdetails_metricid', "")) session.add(polleddata) session.commit() res = models.to_json(polleddata, 'Polleddata', False) session.close() return custom_response_flask_restful(request, 201, None, None, res)
def post(self): if not request.json: abort(400) else: data = request.json if data.get('metricdetail_id') is None or data.get('threshold_list_id') is None: return custom_response_flask_restful(request, 404, "metricdetail_id and threshold_list_id is required", None, None) metricdetail = session.query(models.Metricdetail).filter_by(metricid=data.get('metricdetail_id')).first() if metricdetail is None: return custom_response_flask_restful(request, 404, "metricdetail chua ton tai", None, None) threshold_lists = session.query(models.Threshold_list).filter_by(id=data.get('threshold_list_id')).first() if threshold_lists is None: return custom_response_flask_restful(request, 404, "threshold_lists chua ton tai", None, None) check_polldata= session.query(models.Polldatatemplate).filter_by(metricdetail_id=data.get('metricdetail_id'), threshold_list_id=data.get('threshold_list_id', "")).first() if check_polldata is not None: return custom_response_flask_restful(request, 404, "polldatatemplate voi metric id: " + str(data.get('metricdetail_id')) + " threshold_list_id " + str(data.get('threshold_list_id')) + " da ton tai. Please change to update polldatatemplate with id: "+ str(check_polldata.id) , None, None) polldatatemplate = models.Polldatatemplate(name=data.get('name', ""), agent=data.get('agent', ""), period=data.get('period', ""), active=data.get('active', ""), oid=data.get('oid', ""), threshold_activate=data.get('threshold_activate', ""), protocol=data.get('protocol', ""), metricdetail_id=data.get('metricdetail_id', ""), threshold_list_id=data.get('threshold_list_id', "")) session.add(polldatatemplate) session.commit() res = models.to_json(polldatatemplate, 'Polldatatemplate', False) session.close() return custom_response_flask_restful(request, 201, None, None, res)
def post(self): if not request.json: abort(400) else: data = request.json groupdevicesdevicedetail = session.query( models.Groupdevicesdevicedetail).filter_by( id=data.get('id')).first() if groupdevicesdevicedetail is None: return custom_response_flask_restful( request, 404, "groupdevicesdevicedetail chua ton tai", None, None) if data.get('devicedetail_did'): groupdevicesdevicedetail.devicedetail_did = data.get( 'devicedetail_did') if data.get('groupdevice_id'): groupdevicesdevicedetail.groupdevice_id = data.get( 'groupdevice_id') session.add(groupdevicesdevicedetail) session.commit() res = models.to_json(groupdevicesdevicedetail, 'Groupdevicesdevicedetail', False) session.close() return custom_response_flask_restful(request, 201, None, None, res)
def post(self): if not request.json: abort(400) else: data = request.json polldatatemplate = session.query( models.Polldatatemplate).filter_by(id=data.get('id')).first() if polldatatemplate is None: return custom_response_flask_restful( request, 404, "polldatatemplate chua ton tai", None, None) if data.get('name'): polldatatemplate.name = data.get('name') if data.get('agent'): polldatatemplate.agent = data.get('agent') if data.get('period'): polldatatemplate.period = data.get('period') if data.get('active'): polldatatemplate.active = data.get('active') if data.get('oid'): polldatatemplate.oid = data.get('oid') if data.get('threshold_activate'): polldatatemplate.threshold_activate = data.get( 'threshold_activate') if data.get('protocol'): polldatatemplate.protocol = data.get('protocol') if data.get('metricdetail_id'): polldatatemplate.metricdetail_id = data.get('metricdetail_id') if data.get('threshold_list_id'): polldatatemplate.threshold_list_id = data.get('threshold_list_id') session.add(polldatatemplate) session.commit() res = models.to_json(polldatatemplate, 'Polldatatemplate', False) session.close() return custom_response_flask_restful(request, 201, None, None, res)
def post(self): if not request.json: abort(400) else: data = request.json metricdetails = session.query(models.Metricdetail).filter_by( metricid=data.get('metricid')).first() if metricdetails is None: return custom_response_flask_restful(request, 404, "metricdetails chua ton tai", None, None) protocoldetails = session.query(models.Protocoldetail).filter_by( protocolid=data.get('protocolid')).first() if protocoldetails is None: return custom_response_flask_restful( request, 404, "protocoldetails chua ton tai", None, None) if data.get('metricname'): metricdetails.metricname = data.get('metricname') if data.get('description'): metricdetails.description = data.get('description') if data.get('displayname'): metricdetails.displayname = data.get('displayname') if data.get('metrictype'): metricdetails.metrictype = data.get('metrictype') if data.get('datatype'): metricdetails.datatype = data.get('datatype') if data.get('protocolid'): metricdetails.protocolid = data.get('protocolid') session.add(metricdetails) session.commit() res = models.to_json(metricdetails, 'Metricdetail', False) session.close() return custom_response_flask_restful(request, 201, None, None, res)
def post(self): if not request.json: abort(400) else: data = request.json devicedetail = session.query(models.Devicedetail).filter_by(did=data.get('deviceid')).first() if devicedetail is None: return custom_response_flask_restful(request, 404, "devicedetail chua ton tai", None, None) metricdetail = session.query(models.Metricdetail).filter_by(metricid=data.get('metricid')).first() if metricdetail is None: return custom_response_flask_restful(request, 404, "metricdetail chua ton tai", None, None) alert = models.Alert(alarmRaisedTime=data.get('alarmRaisedTime', ""), alarmChangedTime=data.get('alarmChangedTime', ""), alarmClearedTime=data.get('alarmClearedTime', ""), state=data.get('state', ""), perceivedSeverity=data.get('perceivedSeverity', ""), eventTime=data.get('eventTime', ""), eventType=data.get('eventType', ""), faultType=data.get('faultType', ""), probableCause=data.get('probableCause', ""), isRootCause=data.get('isRootCause', ""), correlatedAlarmId=data.get('correlatedAlarmId', ""), faultDetails=data.get('faultDetails', ""), deviceid=data.get('deviceid', ""), metricid=data.get('metricid', "")) session.add(alert) session.commit() res = models.to_json(alert, 'Alert', False) session.close() return custom_response_flask_restful(request, 201, None, None, res)
def get(self): if not (request.args.get('device_id') or request.args.get('metricid')): abort(400) data = { 'device_id': int(request.args.get('device_id')), 'metricid': int(request.args.get('metricid')) } metricdetail = session.query(models.Metricdetail).filter_by( metricid=data.get('metricid')).first() if metricdetail is None: return custom_response_flask_restful(request, 404, "metricdetail chua ton tai", None, None) device = session.query(models.Devicedetail).filter_by( did=data.get('device_id', "")).first() if device is None: return custom_response_flask_restful(request, 404, "device chua ton tai", None, None) polleddata = session.query(models.Polleddata).filter_by( devicedetails_did=device.did, metricdetails_metricid=metricdetail.metricid).first() if polleddata is None: return custom_response_flask_restful(request, 404, "polleddata chua ton tai", None, None) threshold_list_id = polleddata.threshold_lists_id threshold_list = session.query( models.Threshold_list).filter_by(id=threshold_list_id).first() if threshold_list is None: return custom_response_flask_restful( request, 404, "threshold_list chua ton tai", None, None) else: thresholdobjects = threshold_list.thresholdobjects res_json = { 'metricdetail': models.to_json(metricdetail, 'Metricdetail', False), 'device': models.to_json(device, 'Devicedetail', False), 'polleddata': models.to_json(polleddata, 'Polleddata', False), 'threshold_list': models.to_json(threshold_list, 'Threshold_list', False), 'thresholdobjects': models.to_json(thresholdobjects, 'Thresholdobject', True) } session.commit() session.close() return custom_response_flask_restful(request, 201, None, 'Ok roi nhe', res_json)
def get(self, alertid): alert = session.query(models.Alert).filter_by(alertid=alertid).first() session.commit() if alert is None: abort(400) return custom_response_flask_restful( request, 200, None, None, models.to_json(alert, 'Alert', False))
def get(self, id): polleddata = session.query(models.Polleddata).filter_by(id=id).first() session.commit() if polleddata is None: abort(400) return custom_response_flask_restful( request, 200, None, None, models.to_json(polleddata, 'Polleddata', False))
def get(self, did): devicedetails = session.query( models.Devicedetail).filter_by(did=did).first() session.commit() if devicedetails is None: abort(400) return custom_response_flask_restful( request, 200, None, None, models.to_json(devicedetails, 'Devicedetail', False))
def get(self, id): thresholdobjects = session.query( models.Thresholdobject).filter_by(id=id).first() session.commit() if thresholdobjects is None: abort(400) return custom_response_flask_restful( request, 200, None, None, models.to_json(thresholdobjects, 'Thresholdobject', False))
def get(self, protocolid): protocoldetails = session.query( models.Protocoldetail).filter_by(protocolid=protocolid).first() session.commit() if protocoldetails is None: abort(400) return custom_response_flask_restful( request, 200, None, None, models.to_json(protocoldetails, 'Protocoldetail', False))
def get(self, metricid): metricdetails = session.query( models.Metricdetail).filter_by(metricid=metricid).first() session.commit() if metricdetails is None: abort(400) return custom_response_flask_restful( request, 200, None, None, models.to_json(metricdetails, 'Metricdetail', False))
def get(self, group_id): groupalerts = session.query( models.Groupalert).filter_by(group_id=group_id).first() session.commit() if groupalerts is None: abort(400) return custom_response_flask_restful( request, 200, None, None, models.to_json(groupalerts, 'Groupalert', False))
def post(self): if not request.json: abort(400) else: data = request.json protocoldetail = session.query(models.Protocoldetail).filter_by( protocolid=data.get('protocolid')).first() if protocoldetail is None: return custom_response_flask_restful( request, 404, "protocoldetail chua ton tai", None, None) if data.get('protocolname'): protocoldetail.protocolname = data.get('protocolname') session.add(protocoldetail) session.commit() res = models.to_json(protocoldetail, 'Protocoldetail', False) session.close() return custom_response_flask_restful(request, 201, None, None, res)
def post(self): if not request.json: abort(400) else: data = request.json threshold_list = session.query( models.Threshold_list).filter_by(id=data.get('id')).first() if threshold_list is None: return custom_response_flask_restful( request, 404, "threshold_list chua ton tai", None, None) if data.get('description'): threshold_list.description = data.get('description') session.add(threshold_list) session.commit() res = models.to_json(threshold_list, 'Threshold_list', False) session.close() return custom_response_flask_restful(request, 201, None, None, res)
def get(self, id): groupdevicesdevicedetails = session.query( models.Groupdevicesdevicedetail).filter_by(id=id).first() session.commit() if groupdevicesdevicedetails is None: abort(400) return custom_response_flask_restful( request, 200, None, None, models.to_json(groupdevicesdevicedetails, 'Groupdevicesdevicedetail', False))
def get(self, id): groupdevicepolledatatemplate = session.query( models.Groupevicepolledatatemplate).filter_by(id=id).first() session.commit() if groupdevicepolledatatemplate is None: abort(400) return custom_response_flask_restful( request, 200, None, None, models.to_json(groupdevicepolledatatemplate, 'Groupevicepolledatatemplate', False))
def post(self): if not request.json: abort(400) else: data = request.json groupdevices = session.query(models.Groupdevice).filter_by(group_id=data.get('groupdevices_group_id')).first() if groupdevices is None: return custom_response_flask_restful(request, 404, "groupdevices chua ton tai", None, None) polldatatemplate = session.query(models.Polldatatemplate).filter_by(id=data.get('polldatatemplate_id')).first() if polldatatemplate is None: return custom_response_flask_restful(request, 404, "polldatatemplate chua ton tai", None, None) groupdevicepolledatatemplate = models.Groupevicepolledatatemplate( groupdevices_group_id=data.get('groupdevices_group_id', ""), polldatatemplate_id=data.get('polldatatemplate_id', "")) session.add(groupdevicepolledatatemplate) session.commit() res = models.to_json(groupdevicepolledatatemplate, 'Groupevicepolledatatemplate', False) session.close() return custom_response_flask_restful(request, 201, None, None, res)
def post(self): if not request.json: abort(400) else: data = request.json alert = session.query( models.Alert).filter_by(alertid=data.get('alertid')).first() if alert is None: return custom_response_flask_restful(request, 404, "alert chua ton tai", None, None) if data.get('alarmRaisedTime'): alert.alarmRaisedTime = data.get('alarmRaisedTime') if data.get('alarmChangedTime'): alert.alarmChangedTime = data.get('alarmChangedTime') if data.get('alarmClearedTime'): alert.alarmClearedTime = data.get('alarmClearedTime') if data.get('state'): alert.state = data.get('state') if data.get('perceivedSeverity'): alert.perceivedSeverity = data.get('perceivedSeverity') if data.get('eventTime'): alert.eventTime = data.get('eventTime') if data.get('eventType'): alert.eventType = data.get('eventType') if data.get('faultType'): alert.faultType = data.get('faultType') if data.get('probableCause'): alert.probableCause = data.get('probableCause') if data.get('isRootCause'): alert.isRootCause = data.get('isRootCause') if data.get('correlatedAlarmId'): alert.correlatedAlarmId = data.get('correlatedAlarmId') if data.get('faultDetails'): alert.faultDetails = data.get('faultDetails') if data.get('deviceid'): alert.deviceid = data.get('deviceid') if data.get('metricid'): alert.metricid = data.get('metricid') session.add(alert) session.commit() res = models.to_json(alert, 'Alert', False) session.close() return custom_response_flask_restful(request, 201, None, None, res)
def post(self): if not request.json: abort(400) else: data = request.json groupalert = models.Groupalert(group_name=data.get('group_name', ""), group_desc=data.get('group_desc', "")) session.add(groupalert) session.commit() res = models.to_json(groupalert, 'Groupalert', False) session.close() return custom_response_flask_restful(request, 201, None, None, res)
def post(self): if not request.json: abort(400) else: data = request.json groupdevice = session.query(models.Groupdevice).filter_by( group_id=data.get('group_id')).first() if groupdevice is None: return custom_response_flask_restful(request, 404, "groupdevice chua ton tai", None, None) if data.get('group_name'): groupdevice.group_name = data.get('group_name') if data.get('group_desc'): groupdevice.group_desc = data.get('group_desc') if data.get('is_manual'): groupdevice.is_manual = data.get('is_manual') session.add(groupdevice) session.commit() res = models.to_json(groupdevice, 'Groupdevice', False) session.close() return custom_response_flask_restful(request, 201, None, None, res)
def post(self): if not request.json: abort(400) else: data = request.json if data.get("rearmvalue") is None: return custom_response_flask_restful(request, 404, "rearmvalue phai duoc set", None, None) metricdetail = session.query(models.Metricdetail).filter_by( metricid=data.get('metricid')).first() if metricdetail is None: return custom_response_flask_restful(request, 404, "metricdetail chua ton tai", None, None) device = session.query(models.Devicedetail).filter_by( did=data.get('device_id', "")).first() if device is None: return custom_response_flask_restful(request, 404, "device chua ton tai", None, None) polleddata = session.query(models.Polleddata).filter_by( devicedetails_did=device.did, metricdetails_metricid=metricdetail.metricid).first() if polleddata is None: return custom_response_flask_restful(request, 404, "polleddata chua ton tai", None, None) threshold_list_id = polleddata.threshold_lists_id threshold_list = session.query( models.Threshold_list).filter_by(id=threshold_list_id).first() if threshold_list is None: return custom_response_flask_restful( request, 404, "threshold_list chua ton tai", None, None) else: for id in range(1, 5): if data.get('threshold_value_' + str(id)): thresholdobject = models.Thresholdobject( name='threshold_template_' + data.get('group_name', ""), kind="long", priority=id, thresholdvalue=data.get('threshold_value_' + str(id)), rearmvalue=data.get('rearmvalue', ""), operator='operator', is_customize=False, threshold_lists_id=threshold_list.id) session.add(thresholdobject) session.commit() res = models.to_json(threshold_list, 'Threshold_list', False) session.close() return custom_response_flask_restful( request, 201, None, 'Ok roi nhe, check in http://127.0.0.1:1234/api/v1/threshold_lists/' + str(threshold_list.id), res)
def post(self): if not request.json: abort(400) else: data = request.json protocoldetail = models.Protocoldetail(protocolname=data.get('protocolname', "")) session.add(protocoldetail) session.commit() new_protocoldetail = models.Protocoldetail(protocolname=data.get('protocolname', "")) res = models.to_json(protocoldetail, 'Protocoldetail', False) session.close() return custom_response_flask_restful(request, 201, None, None, res)
def post(self): if not request.json: abort(400) else: data = request.json threshold_list = models.Threshold_list(description=data.get('description', "")) session.add(threshold_list) session.commit() res = models.to_json(threshold_list, 'Threshold_list', False) session.close() return custom_response_flask_restful(request, 201, None, None, res)
def post(self): if not request.json: abort(400) else: data = request.json metricdetail = session.query(models.Metricdetail).filter_by( metricid=data.get('metricid')).first() if metricdetail is None: return custom_response_flask_restful(request, 404, "metricdetail chua ton tai", None, None) device = session.query(models.Devicedetail).filter_by( did=data.get('device_id', "")).first() if device is None: return custom_response_flask_restful(request, 404, "device chua ton tai", None, None) polleddata = session.query(models.Polleddata).filter_by( devicedetails_did=device.did, metricdetails_metricid=metricdetail.metricid).first() if polleddata is None: return custom_response_flask_restful(request, 404, "polleddata chua ton tai", None, None) threshold_list_id = polleddata.threshold_lists_id threshold_list = session.query( models.Threshold_list).filter_by(id=threshold_list_id).first() if threshold_list is None: return custom_response_flask_restful( request, 404, "threshold_list chua ton tai", None, None) else: thresholdobject = session.query(models.Thresholdobject).filter_by( id=data.get('threshold_id'), threshold_lists_id=threshold_list.id).first() if thresholdobject is None: return custom_response_flask_restful( request, 404, "thresholdobject chua ton tai", None, None) else: session.delete(thresholdobject) session.commit() res = models.to_json(threshold_list, 'Threshold_list', False) session.close() return custom_response_flask_restful( request, 201, None, 'Ok roi nhe, check in http://127.0.0.1:1234/api/v1/threshold_lists/' + str(threshold_list.id), res)