Open margaretmm opened 6 years ago
import json from urllib import response
import python_http_client import sys import time
import http.client import urllib
def rest_get(host,url,auth=0): conn = http.client.HTTPConnection(host) if auth: headers = { 'Accept': 'application / json', 'Connection': 'keep-alive', 'Authorization': 'Bearer '+auth } conn.request("GET", url,headers=headers) else: conn.request("GET", url) r = conn.getresponse() print(r.status, r.reason) data1 = r.read() print(data1)
def rest_post(host,url,data,auth=0): conn = http.client.HTTPConnection(host)
if auth: headers = { 'Accept': 'application / json', 'Content-Type': 'application / json; charset=UTF-8', 'Connection': 'keep-alive', 'Authorization': 'Bearer ' + auth } conn.request("POST", url, body=json.dumps(data),headers=headers) else: conn.request("POST", url, body=json.dumps(data)) r = conn.getresponse() print(r.status, r.reason) data1 = r.read() print(data1)
if name == 'main': auth_edit="eyJrIjoiQXZISTdPSEN5THMxNW81cm54SmVOajA4MWhIeFVZNHUiLCJuIjoiam1ldGVyIiwiaWQiOjF9" auth_admin="eyJrIjoia2FQOEdWQk05VTZuSEZYVThBZlluVE1uMjlvcUhrT0UiLCJuIjoiam1ldGVyX2FkbWluIiwiaWQiOjF9" dashboard_json = { "dashboard": { "__requires": [ { "type": "panel", "id": "text", "name": "Text", "version": "" }, { "type": "panel", "id": "singlestat", "name": "Singlestat", "version": "" }, { "type": "panel", "id": "graph", "name": "Graph", "version": "" }, { "type": "panel", "id": "table", "name": "Table", "version": "" }, { "type": "grafana", "id": "grafana", "name": "Grafana", "version": "4.0.2" }, { "type": "datasource", "id": "influxdb", "name": "InfluxDB", "version": "1.0.0" } ], "id": None, "title": "ds_exe_id_4351", "description": "This dashboard shows live load test metrics provided by JMeter.", "tags": [], "style": "dark", "timezone": "browser", "editable": True, "sharedCrosshair": True, "hideControls": False, "time": { "from": "now-1d/d", "to": "now-1d/d" }, "timepicker": { "refresh_intervals": [ "5s", "10s", "30s", "1m", "5m", "15m", "30m", "1h", "2h", "1d" ], "time_options": [ "5m", "15m", "1h", "6h", "12h", "24h", "2d", "7d", "30d" ] }, "templating": { "list": [ { "allValue": None, "current": {}, "datasource": "ds_exe_id_4351", "hide": 0, "includeAll": False, "label": "Request", "multi": False, "name": "request", "options": [], "query": "SHOW TAG VALUES FROM \"requestsRaw\" WITH KEY = \"requestName\"", "refresh": 1, "regex": "", "sort": 0, "tagValuesQuery": None, "tagsQuery": None, "type": "query" }, { "auto": False, "current": { "tags": [], "text": "1m", "value": "60" }, "datasource": None, "hide": 0, "includeAll": False, "label": "Aggregation Interval", "multi": False, "name": "aggregation", "options": [ { "selected": False, "text": "1s", "value": "1" }, { "selected": False, "text": "10s", "value": "10" }, { "selected": False, "text": "30s", "value": "30" }, { "selected": True, "text": "1m", "value": "60" }, { "selected": False, "text": "10m", "value": "600" }, { "selected": False, "text": "30m", "value": "1800" }, { "selected": False, "text": "1h", "value": "3600" } ], "query": "1,10,30,60,600,1800,3600", "refresh": 0, "type": "custom", "allValue": None } ] }, "annotations": { "list": [ { "datasource": "ds_exe_id_4351", "enable": True, "iconColor": "rgb(23, 255, 0)", "name": "Test Start", "query": "SELECT FROM testStartEnd WHERE type='started'", "tagsColumn": "type", "titleColumn": "testName" }, { "datasource": "ds_exe_id_4351", "enable": True, "iconColor": "rgba(255, 96, 96, 1)", "name": "Test End", "query": "SELECT FROM testStartEnd WHERE type='finished'", "tagsColumn": "type", "titleColumn": "testName" } ] }, "refresh": "5s", "schemaVersion": 13, "version": 2, "links": [], "gnetId": 1152, "rows": [ { "title": "Overview", "panels": [ { "content": "<h3 style=\"text-align: center;\">The following panels show aggregated metrics for <span style=\"color: #00ccff;\">all requests", "editable": True, "error": False, "height": "180", "id": 25, "links": [], "mode": "html", "span": 2, "title": "", "transparent": True, "type": "text" }, { "cacheTimeout": None, "colorBackground": False, "colorValue": False, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "datasource": "ds_exe_id_4351", "editable": True, "error": False, "format": "none", "gauge": { "maxValue": 100, "minValue": 0, "show": False, "thresholdLabels": False, "thresholdMarkers": True }, "height": "120", "id": 14, "interval": None, "links": [], "mappingType": 1, "mappingTypes": [ { "name": "value to text", "value": 1 }, { "name": "range to text", "value": 2 } ], "maxDataPoints": 100, "NonePointMode": "connected", "NoneText": None, "postfix": "", "postfixFontSize": "50%", "prefix": "", "prefixFontSize": "50%", "rangeMaps": [ { "from": "None", "text": "N/A", "to": "None" } ], "span": 2, "sparkline": { "fillColor": "rgba(31, 118, 189, 0.18)", "full": False, "lineColor": "rgb(31, 120, 193)", "show": False }, "targets": [ { "dsType": "influxdb", "groupBy": [], "measurement": "virtualUsers", "policy": "default", "query": "SELECT last(\"startedThreads\") FROM \"virtualUsers\" WHERE $timeFilter", "rawQuery": True, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "meanActiveThreads" ], "type": "field" } ] ], "tags": [] } ], "thresholds": "", "title": "Active Users", "transparent": True, "type": "singlestat", "valueFontSize": "80%", "valueMaps": [ { "op": "=", "text": "N/A", "value": "None" } ], "valueName": "current" }, { "cacheTimeout": None, "colorBackground": False, "colorValue": False, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "datasource": "ds_exe_id_4351", "decimals": 1, "editable": True, "error": False, "format": "ops", "gauge": { "maxValue": 100, "minValue": 0, "show": False, "thresholdLabels": False, "thresholdMarkers": True }, "height": "120", "id": 17, "interval": None, "links": [], "mappingType": 1, "mappingTypes": [ { "name": "value to text", "value": 1 }, { "name": "range to text", "value": 2 } ], "maxDataPoints": 100, "NonePointMode": "connected", "NoneText": None, "postfix": "", "postfixFontSize": "30%", "prefix": "", "prefixFontSize": "50%", "rangeMaps": [ { "from": "None", "text": "N/A", "to": "None" } ], "span": 2, "sparkline": { "fillColor": "rgba(31, 118, 189, 0.18)", "full": False, "lineColor": "rgb(31, 120, 193)", "show": False }, "targets": [ { "dsType": "influxdb", "groupBy": [], "measurement": "virtualUsers", "policy": "default", "query": "SELECT count(\"responseTime\")/$aggregation FROM \"requestsRaw\" WHERE $timeFilter GROUP BY time([[aggregation]]s) fill(null)", "rawQuery": True, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "finishedThreads" ], "type": "field" } ] ], "tags": [] } ], "thresholds": "", "title": "Overall Throughput", "transparent": True, "type": "singlestat", "valueFontSize": "80%", "valueMaps": [ { "op": "=", "text": "N/A", "value": "None" } ], "valueName": "current" }, { "cacheTimeout": None, "colorBackground": False, "colorValue": False, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "datasource": "ds_exe_id_4351", "decimals": 1, "editable": True, "error": False, "format": "percentunit", "gauge": { "maxValue": 1, "minValue": None, "show": True, "thresholdLabels": False, "thresholdMarkers": True }, "height": "180", "id": 18, "interval": None, "links": [], "mappingType": 1, "mappingTypes": [ { "name": "value to text", "value": 1 }, { "name": "range to text", "value": 2 } ], "maxDataPoints": 100, "NonePointMode": "connected", "NoneText": None, "postfix": "", "postfixFontSize": "30%", "prefix": "", "prefixFontSize": "50%", "rangeMaps": [ { "from": "None", "text": "N/A", "to": "None" } ], "span": 2, "sparkline": { "fillColor": "rgba(31, 118, 189, 0.18)", "full": False, "lineColor": "rgb(31, 120, 193)", "show": False }, "targets": [ { "dsType": "influxdb", "groupBy": [], "measurement": "virtualUsers", "policy": "default", "query": "SELECT 1 - sum(\"errorCount\")/count(\"responseTime\") FROM \"requestsRaw\" WHERE $timeFilter", "rawQuery": True, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "finishedThreads" ], "type": "field" } ] ], "tags": [] } ], "thresholds": "-1,-1", "title": "Success Rate", "transparent": True, "type": "singlestat", "valueFontSize": "80%", "valueMaps": [ { "op": "=", "text": "N/A", "value": "None" } ], "valueName": "current" }, { "cacheTimeout": None, "colorBackground": False, "colorValue": False, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "datasource": "ds_exe_id_4351", "decimals": 0, "editable": True, "error": False, "format": "none", "gauge": { "maxValue": 100, "minValue": 0, "show": False, "thresholdLabels": False, "thresholdMarkers": True }, "height": "120", "id": 20, "interval": None, "links": [], "mappingType": 1, "mappingTypes": [ { "name": "value to text", "value": 1 }, { "name": "range to text", "value": 2 } ], "maxDataPoints": 100, "NonePointMode": "connected", "NoneText": None, "postfix": "", "postfixFontSize": "30%", "prefix": "", "prefixFontSize": "50%", "rangeMaps": [ { "from": "None", "text": "N/A", "to": "None" } ], "span": 2, "sparkline": { "fillColor": "rgba(31, 118, 189, 0.18)", "full": False, "lineColor": "rgb(31, 120, 193)", "show": False }, "targets": [ { "dsType": "influxdb", "groupBy": [], "measurement": "virtualUsers", "policy": "default", "query": "SELECT count(\"responseTime\") FROM \"requestsRaw\" WHERE $timeFilter", "rawQuery": True, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "finishedThreads" ], "type": "field" } ] ], "tags": [] } ], "thresholds": "", "title": "Request Count", "transparent": True, "type": "singlestat", "valueFontSize": "80%", "valueMaps": [ { "op": "=", "text": "N/A", "value": "None" } ], "valueName": "current" }, { "cacheTimeout": None, "colorBackground": False, "colorValue": False, "colors": [ "rgb(109, 109, 109)", "rgba(237, 129, 40, 0.89)", "rgba(126, 0, 0, 0.9)" ], "datasource": "ds_exe_id_4351", "decimals": 2, "editable": True, "error": False, "format": "percentunit", "gauge": { "maxValue": 1, "minValue": None, "show": True, "thresholdLabels": False, "thresholdMarkers": True }, "height": "180", "id": 21, "interval": None, "links": [], "mappingType": 1, "mappingTypes": [ { "name": "value to text", "value": 1 }, { "name": "range to text", "value": 2 } ], "maxDataPoints": 100, "NonePointMode": "connected", "NoneText": None, "postfix": "", "postfixFontSize": "30%", "prefix": "", "prefixFontSize": "50%", "rangeMaps": [ { "from": "None", "text": "N/A", "to": "None" } ], "span": 2, "sparkline": { "fillColor": "rgba(31, 118, 189, 0.18)", "full": False, "lineColor": "rgb(31, 120, 193)", "show": False }, "targets": [ { "dsType": "influxdb", "groupBy": [], "measurement": "virtualUsers", "policy": "default", "query": "SELECT sum(\"errorCount\")/count(\"responseTime\") FROM \"requestsRaw\" WHERE $timeFilter", "rawQuery": True, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "finishedThreads" ], "type": "field" } ] ], "tags": [] } ], "thresholds": "0.01,0.1", "title": "Error Rate", "transparent": True, "type": "singlestat", "valueFontSize": "80%", "valueMaps": [ { "op": "=", "text": "N/A", "value": "None" } ], "valueName": "current" }, { "aliasColors": {}, "bars": False, "datasource": "ds_exe_id_4351", "editable": True, "error": False, "fill": 1, "grid": {}, "height": "300", "id": 6, "legend": { "avg": False, "current": False, "max": False, "min": False, "show": True, "total": False, "values": False }, "lines": True, "linewidth": 1, "links": [], "NonePointMode": "None", "percentage": False, "pointradius": 5, "points": False, "renderer": "flot", "seriesOverrides": [ { "alias": "Throughput", "yaxis": 2 } ], "span": 12, "stack": False, "steppedLine": False, "targets": [ { "alias": "Num Users", "dsType": "influxdb", "groupBy": [ { "params": [ "10s" ], "type": "time" }, { "params": [ "None" ], "type": "fill" } ], "hide": False, "measurement": "virtualUsers", "policy": "default", "query": "SELECT mean(\"startedThreads\") FROM \"virtualUsers\" WHERE $timeFilter GROUP BY time([[aggregation]]s) fill(null)", "rawQuery": True, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "startedThreads" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "Throughput", "dsType": "influxdb", "groupBy": [ { "params": [ "10s" ], "type": "time" }, { "params": [ "None" ], "type": "fill" } ], "hide": False, "measurement": "requestsRaw", "policy": "default", "query": "SELECT count(\"responseTime\")/$aggregation FROM \"requestsRaw\" WHERE $timeFilter GROUP BY time([[aggregation]]s) fill(null)", "rawQuery": True, "refId": "B", "resultFormat": "time_series", "select": [ [ { "params": [ "responseTime" ], "type": "field" }, { "params": [], "type": "count" } ] ], "tags": [] } ], "thresholds": [], "timeFrom": None, "timeShift": None, "title": "Load", "tooltip": { "msResolution": False, "shared": True, "sort": 0, "value_type": "individual" }, "type": "graph", "xaxis": { "mode": "time", "name": None, "show": True, "values": [] }, "yaxes": [ { "format": "short", "label": None, "logBase": 1, "max": None, "min": None, "show": True }, { "format": "ops", "label": "", "logBase": 1, "max": None, "min": None, "show": True } ] }, { "columns": [], "datasource": "ds_exe_id_4351", "editable": True, "error": False, "fontSize": "80%", "height": "300", "id": 9, "links": [], "pageSize": 10, "scroll": True, "showHeader": True, "sort": { "col": 0, "desc": True }, "span": 12, "styles": [ { "dateFormat": "YYYY-MM-DD HH:mm:ss", "pattern": "Time", "type": "date" }, { "colorMode": "cell", "colors": [ "rgba(0, 0, 0, 0)", "rgba(183, 84, 26, 0.89)", "rgba(245, 54, 54, 0.9)" ], "decimals": 2, "pattern": "Error Rate", "thresholds": [ "0.00000001", "0.01" ], "type": "number", "unit": "percentunit" }, { "colorMode": None, "colors": [ "rgba(50, 172, 45, 0.97)", "rgba(237, 129, 40, 0.89)", "rgba(245, 54, 54, 0.9)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 2, "pattern": "/.*/", "thresholds": [ "0.01", "0.05" ], "type": "number", "unit": "short" } ], "targets": [ { "alias": "", "dsType": "influxdb", "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "None" ], "type": "fill" } ], "hide": False, "measurement": "requests", "policy": "default", "query": "SELECT count(responseTime) as Count, mean(responseTime) as Avg, min(responseTime) as Min, median(responseTime) as Median, percentile(responseTime, 90) as \"90%\",percentile(responseTime, 95) as \"95%\",percentile(responseTime, 99) as \"99%\", max(responseTime) as Max, (sum(errorCount)/count(responseTime)) as \"Error Rate\" FROM \"requestsRaw\" WHERE $timeFilter GROUP BY requestName", "rawQuery": True, "refId": "A", "resultFormat": "table", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] } ], "title": "Metrics Overview", "transform": "table", "transparent": False, "type": "table" } ], "showTitle": False, "titleSize": "h3", "height": 250, "repeat": None, "repeatRowId": None, "repeatIteration": None, "collapse": False }, { "title": "Selected Request - $request", "panels": [ { "content": "<h3 style=\"text-align: center;\">The following panels show request-specific metrics for the request <span style=\"color: #00ccff;\">\"[[request]]\"", "editable": True, "error": False, "height": "110", "id": 23, "links": [], "mode": "html", "span": 12, "title": "", "transparent": True, "type": "text" }, { "aliasColors": {}, "bars": False, "datasource": "ds_exe_id_4351", "editable": True, "error": False, "fill": 1, "grid": {}, "height": "300px", "id": 7, "legend": { "alignAsTable": True, "avg": True, "current": True, "max": True, "min": True, "show": True, "total": False, "values": True }, "lines": True, "linewidth": 1, "links": [], "NonePointMode": "connected", "percentage": False, "pointradius": 5, "points": False, "renderer": "flot", "seriesOverrides": [], "span": 6, "stack": False, "steppedLine": False, "targets": [ { "alias": "Throughput", "dsType": "influxdb", "groupBy": [ { "params": [ "10s" ], "type": "time" }, { "params": [ "None" ], "type": "fill" } ], "measurement": "requestsRaw", "policy": "default", "query": "SELECT count(\"responseTime\")/$aggregation FROM \"requestsRaw\" WHERE \"requestName\" =~ /^$request$/ AND $timeFilter GROUP BY time([[aggregation]]s) fill(null)", "rawQuery": True, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "responseTime" ], "type": "field" }, { "params": [], "type": "count" } ] ], "tags": [ { "key": "requestName", "operator": "=~", "value": "/^$request$/" } ] } ], "thresholds": [], "timeFrom": None, "timeShift": None, "title": "Throughput", "tooltip": { "msResolution": False, "shared": True, "sort": 0, "value_type": "individual" }, "type": "graph", "xaxis": { "mode": "time", "name": None, "show": True, "values": [] }, "yaxes": [ { "format": "ops", "label": "", "logBase": 1, "max": None, "min": None, "show": True }, { "format": "short", "label": None, "logBase": 1, "max": None, "min": None, "show": True } ] }, { "cacheTimeout": None, "colorBackground": False, "colorValue": False, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(61, 165, 30, 0.97)" ], "datasource": "ds_exe_id_4351", "editable": True, "error": False, "format": "percentunit", "gauge": { "maxValue": 1, "minValue": 0, "show": True, "thresholdLabels": False, "thresholdMarkers": True }, "height": "180", "id": 12, "interval": None, "links": [], "mappingType": 1, "mappingTypes": [ { "name": "value to text", "value": 1 }, { "name": "range to text", "value": 2 } ], "maxDataPoints": 100, "NonePointMode": "connected", "NoneText": None, "postfix": "", "postfixFontSize": "50%", "prefix": "", "prefixFontSize": "50%", "rangeMaps": [ { "from": "None", "text": "N/A", "to": "None" } ], "span": 2, "sparkline": { "fillColor": "rgba(31, 118, 189, 0.18)", "full": False, "lineColor": "rgb(31, 120, 193)", "show": False }, "targets": [ { "dsType": "influxdb", "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "None" ], "type": "fill" } ], "measurement": "requests", "policy": "default", "query": "SELECT 1 - sum(\"errorCount\")/count(\"responseTime\") FROM \"requestsRaw\" WHERE $timeFilter AND \"requestName\" =~ /^$request$/", "rawQuery": True, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] } ], "thresholds": "-1,-1", "title": "Success Rate", "transparent": True, "type": "singlestat", "valueFontSize": "80%", "valueMaps": [ { "op": "=", "text": "N/A", "value": "None" } ], "valueName": "current" }, { "cacheTimeout": None, "colorBackground": False, "colorValue": False, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(4, 106, 0, 0.97)" ], "datasource": "ds_exe_id_4351", "editable": True, "error": False, "format": "none", "gauge": { "maxValue": 100, "minValue": 0, "show": False, "thresholdLabels": False, "thresholdMarkers": True }, "height": "160", "id": 3, "interval": None, "links": [], "mappingType": 1, "mappingTypes": [ { "name": "value to text", "value": 1 }, { "name": "range to text", "value": 2 } ], "maxDataPoints": 100, "NonePointMode": "connected", "NoneText": None, "postfix": "", "postfixFontSize": "50%", "prefix": "", "prefixFontSize": "50%", "rangeMaps": [ { "from": "None", "text": "N/A", "to": "None" } ], "span": 2, "sparkline": { "fillColor": "rgba(31, 118, 189, 0.18)", "full": False, "lineColor": "rgb(31, 120, 193)", "show": False }, "targets": [ { "dsType": "influxdb", "groupBy": [], "measurement": "requestsRaw", "policy": "default", "query": "SELECT count(\"responseTime\") FROM \"requestsRaw\" WHERE \"requestName\" =~ /^$request$/ AND $timeFilter", "rawQuery": True, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "responseTime" ], "type": "field" }, { "params": [], "type": "count" } ] ], "tags": [ { "key": "requestName", "operator": "=~", "value": "/^$request$/" } ] } ], "thresholds": "", "title": "Request Count", "transparent": True, "type": "singlestat", "valueFontSize": "80%", "valueMaps": [ { "op": "=", "text": "N/A", "value": "None" } ], "valueName": "current" }, { "cacheTimeout": None, "colorBackground": False, "colorValue": False, "colors": [ "rgb(100, 100, 100)", "rgba(237, 129, 40, 0.89)", "rgba(150, 20, 20, 0.9)" ], "datasource": "ds_exe_id_4351", "decimals": 2, "editable": True, "error": False, "format": "percentunit", "gauge": { "maxValue": 1, "minValue": 0, "show": True, "thresholdLabels": False, "thresholdMarkers": True }, "height": "180", "id": 5, "interval": None, "links": [], "mappingType": 1, "mappingTypes": [ { "name": "value to text", "value": 1 }, { "name": "range to text", "value": 2 } ], "maxDataPoints": 100, "NonePointMode": "connected", "NoneText": None, "postfix": "", "postfixFontSize": "50%", "prefix": "", "prefixFontSize": "50%", "rangeMaps": [ { "from": "None", "text": "N/A", "to": "None" } ], "span": 2, "sparkline": { "fillColor": "rgba(31, 118, 189, 0.18)", "full": False, "lineColor": "rgb(31, 120, 193)", "show": False }, "targets": [ { "dsType": "influxdb", "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "None" ], "type": "fill" } ], "measurement": "requests", "policy": "default", "query": "SELECT sum(\"errorCount\")/count(\"responseTime\") FROM \"requestsRaw\" WHERE $timeFilter AND \"requestName\" =~ /^$request$/", "rawQuery": True, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] } ], "thresholds": "0.01,0.1", "title": "Error Rate", "transparent": True, "type": "singlestat", "valueFontSize": "80%", "valueMaps": [ { "op": "=", "text": "N/A", "value": "None" } ], "valueName": "current" }, { "content": "", "editable": True, "error": False, "height": "110", "id": 24, "links": [], "mode": "markdown", "span": 6, "title": "", "transparent": True, "type": "text" }, { "aliasColors": { "95 perc": "#F9934E", "99 perc": "#E24D42", "Max": "#BF1B00" }, "bars": False, "datasource": "ds_exe_id_4351", "editable": True, "error": False, "fill": 3, "grid": {}, "height": "300", "id": 1, "legend": { "alignAsTable": False, "avg": False, "current": False, "max": False, "min": False, "show": True, "total": False, "values": False }, "lines": True, "linewidth": 1, "links": [], "NonePointMode": "None", "percentage": False, "pointradius": 5, "points": False, "renderer": "flot", "seriesOverrides": [ { "alias": "Mean", "zindex": 3 }, { "alias": "90 perc", "zindex": 2 }, { "alias": "95 perc", "zindex": 1 }, { "alias": "99 perc", "zindex": 0 }, { "alias": "Max", "zindex": -1 } ], "span": 6, "stack": False, "steppedLine": False, "targets": [ { "alias": "Mean", "dsType": "influxdb", "groupBy": [ { "params": [ "$aggregation" ], "type": "time" }, { "params": [ "None" ], "type": "fill" } ], "measurement": "requestsRaw", "policy": "default", "query": "SELECT mean(\"responseTime\") FROM \"requestsRaw\" WHERE \"requestName\" =~ /^$request$/ AND $timeFilter GROUP BY time([[aggregation]]s) fill(null)", "rawQuery": True, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "responseTime" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [ { "key": "requestName", "operator": "=~", "value": "/^$request$/" } ] }, { "alias": "90 perc", "dsType": "influxdb", "groupBy": [ { "params": [ "$aggregation" ], "type": "time" }, { "params": [ "None" ], "type": "fill" } ], "measurement": "requestsRaw", "policy": "default", "query": "SELECT percentile(\"responseTime\", 90) FROM \"requestsRaw\" WHERE \"requestName\" =~ /^$request$/ AND $timeFilter GROUP BY time([[aggregation]]s) fill(null)", "rawQuery": True, "refId": "B", "resultFormat": "time_series", "select": [ [ { "params": [ "responseTime" ], "type": "field" }, { "params": [ "90" ], "type": "percentile" } ] ], "tags": [ { "key": "requestName", "operator": "=~", "value": "/^$request$/" } ] }, { "alias": "95 perc", "dsType": "influxdb", "groupBy": [ { "params": [ "$aggregation" ], "type": "time" }, { "params": [ "None" ], "type": "fill" } ], "measurement": "requestsRaw", "policy": "default", "query": "SELECT percentile(\"responseTime\", 95) FROM \"requestsRaw\" WHERE \"requestName\" =~ /^$request$/ AND $timeFilter GROUP BY time([[aggregation]]s) fill(null)", "rawQuery": True, "refId": "D", "resultFormat": "time_series", "select": [ [ { "params": [ "responseTime" ], "type": "field" }, { "params": [ 95 ], "type": "percentile" } ] ], "tags": [ { "key": "requestName", "operator": "=~", "value": "/^$request$/" } ] }, { "alias": "99 perc", "dsType": "influxdb", "groupBy": [ { "params": [ "$aggregation" ], "type": "time" }, { "params": [ "None" ], "type": "fill" } ], "measurement": "requestsRaw", "policy": "default", "query": "SELECT percentile(\"responseTime\", 99) FROM \"requestsRaw\" WHERE \"requestName\" =~ /^$request$/ AND $timeFilter GROUP BY time([[aggregation]]s) fill(null)", "rawQuery": True, "refId": "C", "resultFormat": "time_series", "select": [ [ { "params": [ "responseTime" ], "type": "field" }, { "params": [ "99" ], "type": "percentile" } ] ], "tags": [ { "key": "requestName", "operator": "=~", "value": "/^$request$/" } ] }, { "alias": "Max", "dsType": "influxdb", "groupBy": [ { "params": [ "$aggregation" ], "type": "time" }, { "params": [ "None" ], "type": "fill" } ], "measurement": "requestsRaw", "policy": "default", "query": "SELECT max(\"responseTime\") FROM \"requestsRaw\" WHERE \"requestName\" =~ /^$request$/ AND $timeFilter GROUP BY time([[aggregation]]s) fill(null)", "rawQuery": True, "refId": "E", "resultFormat": "time_series", "select": [ [ { "params": [ "responseTime" ], "type": "field" }, { "params": [], "type": "max" } ] ], "tags": [ { "key": "requestName", "operator": "=~", "value": "/^$request$/" } ] } ], "thresholds": [], "timeFrom": None, "timeShift": None, "title": "Response Times", "tooltip": { "msResolution": True, "shared": True, "sort": 0, "value_type": "individual" }, "type": "graph", "xaxis": { "mode": "time", "name": None, "show": True, "values": [] }, "yaxes": [ { "format": "ms", "label": None, "logBase": 1, "max": None, "min": None, "show": True }, { "format": "short", "label": None, "logBase": 1, "max": None, "min": None, "show": True } ] }, { "aliasColors": {}, "bars": False, "datasource": "ds_exe_id_4351", "editable": True, "error": False, "fill": 1, "grid": {}, "height": "300", "id": 11, "legend": { "alignAsTable": True, "avg": True, "current": True, "max": True, "min": True, "show": True, "total": False, "values": True }, "lines": True, "linewidth": 2, "links": [], "NonePointMode": "connected", "percentage": False, "pointradius": 5, "points": False, "renderer": "flot", "seriesOverrides": [], "span": 6, "stack": False, "steppedLine": False, "targets": [ { "alias": "Errors per Second", "dsType": "influxdb", "groupBy": [ { "params": [ "$aggregation" ], "type": "time" }, { "params": [ "None" ], "type": "fill" } ], "measurement": "requestsRaw", "policy": "default", "query": "SELECT sum(\"errorCount\")/$aggregation FROM \"requestsRaw\" WHERE \"requestName\" =~ /^$request$/ AND $timeFilter GROUP BY time([[aggregation]]s) fill(null)", "rawQuery": True, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "errorCount" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [ { "key": "requestName", "operator": "=~", "value": "/^$request$/" } ] } ], "timeFrom": None, "timeShift": None, "title": "Error Rate", "tooltip": { "msResolution": False, "shared": True, "sort": 0, "value_type": "cumulative" }, "type": "graph", "xaxis": { "show": True, "mode": "time", "name": None, "values": [] }, "yaxes": [ { "format": "short", "label": "errors / s", "logBase": 1, "max": None, "min": "0", "show": True }, { "format": "short", "label": "", "logBase": 1, "max": None, "min": None, "show": True } ], "thresholds": [] } ], "showTitle": False, "titleSize": "h3", "height": "250px", "repeat": None, "repeatRowId": None, "repeatIteration": None, "collapse": False } ] }, "folderId": 0, "overwrite": False }
ds_json={ "name":"test_datasource",
"type":"influxdb", "url":"http://10.66.170.42:8086", "access":"proxy", "basicAuth":False, "password": "", "user": "", "database": "jmeter2", "basicAuth": False, "basicAuthUser": "basicuser", "basicAuthPassword": "basicuser", "isDefault": False }
#rest_get("10.66.170.42:3000","/api/datasources/1",auth_admin) #rest_post("10.66.170.42:3000","/api/datasources",ds_json,auth_admin) rest_post("10.66.170.42:3000","/api/dashboards/db",dashboard_json,auth_admin)
!/usr/bin/env python
-- coding: utf-8 --
import json from urllib import response
import python_http_client import sys import time
interval unit: seceond
import http.client import urllib
def rest_get(host,url,auth=0): conn = http.client.HTTPConnection(host) if auth: headers = { 'Accept': 'application / json', 'Connection': 'keep-alive', 'Authorization': 'Bearer '+auth } conn.request("GET", url,headers=headers) else: conn.request("GET", url) r = conn.getresponse() print(r.status, r.reason) data1 = r.read() print(data1)
def rest_post(host,url,data,auth=0): conn = http.client.HTTPConnection(host)
if name == 'main': auth_edit="eyJrIjoiQXZISTdPSEN5THMxNW81cm54SmVOajA4MWhIeFVZNHUiLCJuIjoiam1ldGVyIiwiaWQiOjF9" auth_admin="eyJrIjoia2FQOEdWQk05VTZuSEZYVThBZlluVE1uMjlvcUhrT0UiLCJuIjoiam1ldGVyX2FkbWluIiwiaWQiOjF9" dashboard_json = { "dashboard": { "__requires": [ { "type": "panel", "id": "text", "name": "Text", "version": "" }, { "type": "panel", "id": "singlestat", "name": "Singlestat", "version": "" }, { "type": "panel", "id": "graph", "name": "Graph", "version": "" }, { "type": "panel", "id": "table", "name": "Table", "version": "" }, { "type": "grafana", "id": "grafana", "name": "Grafana", "version": "4.0.2" }, { "type": "datasource", "id": "influxdb", "name": "InfluxDB", "version": "1.0.0" } ], "id": None, "title": "ds_exe_id_4351", "description": "This dashboard shows live load test metrics provided by JMeter.", "tags": [], "style": "dark", "timezone": "browser", "editable": True, "sharedCrosshair": True, "hideControls": False, "time": { "from": "now-1d/d", "to": "now-1d/d" }, "timepicker": { "refresh_intervals": [ "5s", "10s", "30s", "1m", "5m", "15m", "30m", "1h", "2h", "1d" ], "time_options": [ "5m", "15m", "1h", "6h", "12h", "24h", "2d", "7d", "30d" ] }, "templating": { "list": [ { "allValue": None, "current": {}, "datasource": "ds_exe_id_4351", "hide": 0, "includeAll": False, "label": "Request", "multi": False, "name": "request", "options": [], "query": "SHOW TAG VALUES FROM \"requestsRaw\" WITH KEY = \"requestName\"", "refresh": 1, "regex": "", "sort": 0, "tagValuesQuery": None, "tagsQuery": None, "type": "query" }, { "auto": False, "current": { "tags": [], "text": "1m", "value": "60" }, "datasource": None, "hide": 0, "includeAll": False, "label": "Aggregation Interval", "multi": False, "name": "aggregation", "options": [ { "selected": False, "text": "1s", "value": "1" }, { "selected": False, "text": "10s", "value": "10" }, { "selected": False, "text": "30s", "value": "30" }, { "selected": True, "text": "1m", "value": "60" }, { "selected": False, "text": "10m", "value": "600" }, { "selected": False, "text": "30m", "value": "1800" }, { "selected": False, "text": "1h", "value": "3600" } ], "query": "1,10,30,60,600,1800,3600", "refresh": 0, "type": "custom", "allValue": None } ] }, "annotations": { "list": [ { "datasource": "ds_exe_id_4351", "enable": True, "iconColor": "rgb(23, 255, 0)", "name": "Test Start", "query": "SELECT FROM testStartEnd WHERE type='started'", "tagsColumn": "type", "titleColumn": "testName" }, { "datasource": "ds_exe_id_4351", "enable": True, "iconColor": "rgba(255, 96, 96, 1)", "name": "Test End", "query": "SELECT FROM testStartEnd WHERE type='finished'", "tagsColumn": "type", "titleColumn": "testName" } ] }, "refresh": "5s", "schemaVersion": 13, "version": 2, "links": [], "gnetId": 1152, "rows": [ { "title": "Overview", "panels": [ { "content": "<h3 style=\"text-align: center;\">The following panels show aggregated metrics for <span style=\"color: #00ccff;\">all requests", "editable": True, "error": False, "height": "180", "id": 25, "links": [], "mode": "html", "span": 2, "title": "", "transparent": True, "type": "text" }, { "cacheTimeout": None, "colorBackground": False, "colorValue": False, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "datasource": "ds_exe_id_4351", "editable": True, "error": False, "format": "none", "gauge": { "maxValue": 100, "minValue": 0, "show": False, "thresholdLabels": False, "thresholdMarkers": True }, "height": "120", "id": 14, "interval": None, "links": [], "mappingType": 1, "mappingTypes": [ { "name": "value to text", "value": 1 }, { "name": "range to text", "value": 2 } ], "maxDataPoints": 100, "NonePointMode": "connected", "NoneText": None, "postfix": "", "postfixFontSize": "50%", "prefix": "", "prefixFontSize": "50%", "rangeMaps": [ { "from": "None", "text": "N/A", "to": "None" } ], "span": 2, "sparkline": { "fillColor": "rgba(31, 118, 189, 0.18)", "full": False, "lineColor": "rgb(31, 120, 193)", "show": False }, "targets": [ { "dsType": "influxdb", "groupBy": [], "measurement": "virtualUsers", "policy": "default", "query": "SELECT last(\"startedThreads\") FROM \"virtualUsers\" WHERE $timeFilter", "rawQuery": True, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "meanActiveThreads" ], "type": "field" } ] ], "tags": [] } ], "thresholds": "", "title": "Active Users", "transparent": True, "type": "singlestat", "valueFontSize": "80%", "valueMaps": [ { "op": "=", "text": "N/A", "value": "None" } ], "valueName": "current" }, { "cacheTimeout": None, "colorBackground": False, "colorValue": False, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "datasource": "ds_exe_id_4351", "decimals": 1, "editable": True, "error": False, "format": "ops", "gauge": { "maxValue": 100, "minValue": 0, "show": False, "thresholdLabels": False, "thresholdMarkers": True }, "height": "120", "id": 17, "interval": None, "links": [], "mappingType": 1, "mappingTypes": [ { "name": "value to text", "value": 1 }, { "name": "range to text", "value": 2 } ], "maxDataPoints": 100, "NonePointMode": "connected", "NoneText": None, "postfix": "", "postfixFontSize": "30%", "prefix": "", "prefixFontSize": "50%", "rangeMaps": [ { "from": "None", "text": "N/A", "to": "None" } ], "span": 2, "sparkline": { "fillColor": "rgba(31, 118, 189, 0.18)", "full": False, "lineColor": "rgb(31, 120, 193)", "show": False }, "targets": [ { "dsType": "influxdb", "groupBy": [], "measurement": "virtualUsers", "policy": "default", "query": "SELECT count(\"responseTime\")/$aggregation FROM \"requestsRaw\" WHERE $timeFilter GROUP BY time([[aggregation]]s) fill(null)", "rawQuery": True, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "finishedThreads" ], "type": "field" } ] ], "tags": [] } ], "thresholds": "", "title": "Overall Throughput", "transparent": True, "type": "singlestat", "valueFontSize": "80%", "valueMaps": [ { "op": "=", "text": "N/A", "value": "None" } ], "valueName": "current" }, { "cacheTimeout": None, "colorBackground": False, "colorValue": False, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "datasource": "ds_exe_id_4351", "decimals": 1, "editable": True, "error": False, "format": "percentunit", "gauge": { "maxValue": 1, "minValue": None, "show": True, "thresholdLabels": False, "thresholdMarkers": True }, "height": "180", "id": 18, "interval": None, "links": [], "mappingType": 1, "mappingTypes": [ { "name": "value to text", "value": 1 }, { "name": "range to text", "value": 2 } ], "maxDataPoints": 100, "NonePointMode": "connected", "NoneText": None, "postfix": "", "postfixFontSize": "30%", "prefix": "", "prefixFontSize": "50%", "rangeMaps": [ { "from": "None", "text": "N/A", "to": "None" } ], "span": 2, "sparkline": { "fillColor": "rgba(31, 118, 189, 0.18)", "full": False, "lineColor": "rgb(31, 120, 193)", "show": False }, "targets": [ { "dsType": "influxdb", "groupBy": [], "measurement": "virtualUsers", "policy": "default", "query": "SELECT 1 - sum(\"errorCount\")/count(\"responseTime\") FROM \"requestsRaw\" WHERE $timeFilter", "rawQuery": True, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "finishedThreads" ], "type": "field" } ] ], "tags": [] } ], "thresholds": "-1,-1", "title": "Success Rate", "transparent": True, "type": "singlestat", "valueFontSize": "80%", "valueMaps": [ { "op": "=", "text": "N/A", "value": "None" } ], "valueName": "current" }, { "cacheTimeout": None, "colorBackground": False, "colorValue": False, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "datasource": "ds_exe_id_4351", "decimals": 0, "editable": True, "error": False, "format": "none", "gauge": { "maxValue": 100, "minValue": 0, "show": False, "thresholdLabels": False, "thresholdMarkers": True }, "height": "120", "id": 20, "interval": None, "links": [], "mappingType": 1, "mappingTypes": [ { "name": "value to text", "value": 1 }, { "name": "range to text", "value": 2 } ], "maxDataPoints": 100, "NonePointMode": "connected", "NoneText": None, "postfix": "", "postfixFontSize": "30%", "prefix": "", "prefixFontSize": "50%", "rangeMaps": [ { "from": "None", "text": "N/A", "to": "None" } ], "span": 2, "sparkline": { "fillColor": "rgba(31, 118, 189, 0.18)", "full": False, "lineColor": "rgb(31, 120, 193)", "show": False }, "targets": [ { "dsType": "influxdb", "groupBy": [], "measurement": "virtualUsers", "policy": "default", "query": "SELECT count(\"responseTime\") FROM \"requestsRaw\" WHERE $timeFilter", "rawQuery": True, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "finishedThreads" ], "type": "field" } ] ], "tags": [] } ], "thresholds": "", "title": "Request Count", "transparent": True, "type": "singlestat", "valueFontSize": "80%", "valueMaps": [ { "op": "=", "text": "N/A", "value": "None" } ], "valueName": "current" }, { "cacheTimeout": None, "colorBackground": False, "colorValue": False, "colors": [ "rgb(109, 109, 109)", "rgba(237, 129, 40, 0.89)", "rgba(126, 0, 0, 0.9)" ], "datasource": "ds_exe_id_4351", "decimals": 2, "editable": True, "error": False, "format": "percentunit", "gauge": { "maxValue": 1, "minValue": None, "show": True, "thresholdLabels": False, "thresholdMarkers": True }, "height": "180", "id": 21, "interval": None, "links": [], "mappingType": 1, "mappingTypes": [ { "name": "value to text", "value": 1 }, { "name": "range to text", "value": 2 } ], "maxDataPoints": 100, "NonePointMode": "connected", "NoneText": None, "postfix": "", "postfixFontSize": "30%", "prefix": "", "prefixFontSize": "50%", "rangeMaps": [ { "from": "None", "text": "N/A", "to": "None" } ], "span": 2, "sparkline": { "fillColor": "rgba(31, 118, 189, 0.18)", "full": False, "lineColor": "rgb(31, 120, 193)", "show": False }, "targets": [ { "dsType": "influxdb", "groupBy": [], "measurement": "virtualUsers", "policy": "default", "query": "SELECT sum(\"errorCount\")/count(\"responseTime\") FROM \"requestsRaw\" WHERE $timeFilter", "rawQuery": True, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "finishedThreads" ], "type": "field" } ] ], "tags": [] } ], "thresholds": "0.01,0.1", "title": "Error Rate", "transparent": True, "type": "singlestat", "valueFontSize": "80%", "valueMaps": [ { "op": "=", "text": "N/A", "value": "None" } ], "valueName": "current" }, { "aliasColors": {}, "bars": False, "datasource": "ds_exe_id_4351", "editable": True, "error": False, "fill": 1, "grid": {}, "height": "300", "id": 6, "legend": { "avg": False, "current": False, "max": False, "min": False, "show": True, "total": False, "values": False }, "lines": True, "linewidth": 1, "links": [], "NonePointMode": "None", "percentage": False, "pointradius": 5, "points": False, "renderer": "flot", "seriesOverrides": [ { "alias": "Throughput", "yaxis": 2 } ], "span": 12, "stack": False, "steppedLine": False, "targets": [ { "alias": "Num Users", "dsType": "influxdb", "groupBy": [ { "params": [ "10s" ], "type": "time" }, { "params": [ "None" ], "type": "fill" } ], "hide": False, "measurement": "virtualUsers", "policy": "default", "query": "SELECT mean(\"startedThreads\") FROM \"virtualUsers\" WHERE $timeFilter GROUP BY time([[aggregation]]s) fill(null)", "rawQuery": True, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "startedThreads" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "Throughput", "dsType": "influxdb", "groupBy": [ { "params": [ "10s" ], "type": "time" }, { "params": [ "None" ], "type": "fill" } ], "hide": False, "measurement": "requestsRaw", "policy": "default", "query": "SELECT count(\"responseTime\")/$aggregation FROM \"requestsRaw\" WHERE $timeFilter GROUP BY time([[aggregation]]s) fill(null)", "rawQuery": True, "refId": "B", "resultFormat": "time_series", "select": [ [ { "params": [ "responseTime" ], "type": "field" }, { "params": [], "type": "count" } ] ], "tags": [] } ], "thresholds": [], "timeFrom": None, "timeShift": None, "title": "Load", "tooltip": { "msResolution": False, "shared": True, "sort": 0, "value_type": "individual" }, "type": "graph", "xaxis": { "mode": "time", "name": None, "show": True, "values": [] }, "yaxes": [ { "format": "short", "label": None, "logBase": 1, "max": None, "min": None, "show": True }, { "format": "ops", "label": "", "logBase": 1, "max": None, "min": None, "show": True } ] }, { "columns": [], "datasource": "ds_exe_id_4351", "editable": True, "error": False, "fontSize": "80%", "height": "300", "id": 9, "links": [], "pageSize": 10, "scroll": True, "showHeader": True, "sort": { "col": 0, "desc": True }, "span": 12, "styles": [ { "dateFormat": "YYYY-MM-DD HH:mm:ss", "pattern": "Time", "type": "date" }, { "colorMode": "cell", "colors": [ "rgba(0, 0, 0, 0)", "rgba(183, 84, 26, 0.89)", "rgba(245, 54, 54, 0.9)" ], "decimals": 2, "pattern": "Error Rate", "thresholds": [ "0.00000001", "0.01" ], "type": "number", "unit": "percentunit" }, { "colorMode": None, "colors": [ "rgba(50, 172, 45, 0.97)", "rgba(237, 129, 40, 0.89)", "rgba(245, 54, 54, 0.9)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 2, "pattern": "/.*/", "thresholds": [ "0.01", "0.05" ], "type": "number", "unit": "short" } ], "targets": [ { "alias": "", "dsType": "influxdb", "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "None" ], "type": "fill" } ], "hide": False, "measurement": "requests", "policy": "default", "query": "SELECT count(responseTime) as Count, mean(responseTime) as Avg, min(responseTime) as Min, median(responseTime) as Median, percentile(responseTime, 90) as \"90%\",percentile(responseTime, 95) as \"95%\",percentile(responseTime, 99) as \"99%\", max(responseTime) as Max, (sum(errorCount)/count(responseTime)) as \"Error Rate\" FROM \"requestsRaw\" WHERE $timeFilter GROUP BY requestName", "rawQuery": True, "refId": "A", "resultFormat": "table", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] } ], "title": "Metrics Overview", "transform": "table", "transparent": False, "type": "table" } ], "showTitle": False, "titleSize": "h3", "height": 250, "repeat": None, "repeatRowId": None, "repeatIteration": None, "collapse": False }, { "title": "Selected Request - $request", "panels": [ { "content": "<h3 style=\"text-align: center;\">The following panels show request-specific metrics for the request <span style=\"color: #00ccff;\">\"[[request]]\"", "editable": True, "error": False, "height": "110", "id": 23, "links": [], "mode": "html", "span": 12, "title": "", "transparent": True, "type": "text" }, { "aliasColors": {}, "bars": False, "datasource": "ds_exe_id_4351", "editable": True, "error": False, "fill": 1, "grid": {}, "height": "300px", "id": 7, "legend": { "alignAsTable": True, "avg": True, "current": True, "max": True, "min": True, "show": True, "total": False, "values": True }, "lines": True, "linewidth": 1, "links": [], "NonePointMode": "connected", "percentage": False, "pointradius": 5, "points": False, "renderer": "flot", "seriesOverrides": [], "span": 6, "stack": False, "steppedLine": False, "targets": [ { "alias": "Throughput", "dsType": "influxdb", "groupBy": [ { "params": [ "10s" ], "type": "time" }, { "params": [ "None" ], "type": "fill" } ], "measurement": "requestsRaw", "policy": "default", "query": "SELECT count(\"responseTime\")/$aggregation FROM \"requestsRaw\" WHERE \"requestName\" =~ /^$request$/ AND $timeFilter GROUP BY time([[aggregation]]s) fill(null)", "rawQuery": True, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "responseTime" ], "type": "field" }, { "params": [], "type": "count" } ] ], "tags": [ { "key": "requestName", "operator": "=~", "value": "/^$request$/" } ] } ], "thresholds": [], "timeFrom": None, "timeShift": None, "title": "Throughput", "tooltip": { "msResolution": False, "shared": True, "sort": 0, "value_type": "individual" }, "type": "graph", "xaxis": { "mode": "time", "name": None, "show": True, "values": [] }, "yaxes": [ { "format": "ops", "label": "", "logBase": 1, "max": None, "min": None, "show": True }, { "format": "short", "label": None, "logBase": 1, "max": None, "min": None, "show": True } ] }, { "cacheTimeout": None, "colorBackground": False, "colorValue": False, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(61, 165, 30, 0.97)" ], "datasource": "ds_exe_id_4351", "editable": True, "error": False, "format": "percentunit", "gauge": { "maxValue": 1, "minValue": 0, "show": True, "thresholdLabels": False, "thresholdMarkers": True }, "height": "180", "id": 12, "interval": None, "links": [], "mappingType": 1, "mappingTypes": [ { "name": "value to text", "value": 1 }, { "name": "range to text", "value": 2 } ], "maxDataPoints": 100, "NonePointMode": "connected", "NoneText": None, "postfix": "", "postfixFontSize": "50%", "prefix": "", "prefixFontSize": "50%", "rangeMaps": [ { "from": "None", "text": "N/A", "to": "None" } ], "span": 2, "sparkline": { "fillColor": "rgba(31, 118, 189, 0.18)", "full": False, "lineColor": "rgb(31, 120, 193)", "show": False }, "targets": [ { "dsType": "influxdb", "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "None" ], "type": "fill" } ], "measurement": "requests", "policy": "default", "query": "SELECT 1 - sum(\"errorCount\")/count(\"responseTime\") FROM \"requestsRaw\" WHERE $timeFilter AND \"requestName\" =~ /^$request$/", "rawQuery": True, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] } ], "thresholds": "-1,-1", "title": "Success Rate", "transparent": True, "type": "singlestat", "valueFontSize": "80%", "valueMaps": [ { "op": "=", "text": "N/A", "value": "None" } ], "valueName": "current" }, { "cacheTimeout": None, "colorBackground": False, "colorValue": False, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(4, 106, 0, 0.97)" ], "datasource": "ds_exe_id_4351", "editable": True, "error": False, "format": "none", "gauge": { "maxValue": 100, "minValue": 0, "show": False, "thresholdLabels": False, "thresholdMarkers": True }, "height": "160", "id": 3, "interval": None, "links": [], "mappingType": 1, "mappingTypes": [ { "name": "value to text", "value": 1 }, { "name": "range to text", "value": 2 } ], "maxDataPoints": 100, "NonePointMode": "connected", "NoneText": None, "postfix": "", "postfixFontSize": "50%", "prefix": "", "prefixFontSize": "50%", "rangeMaps": [ { "from": "None", "text": "N/A", "to": "None" } ], "span": 2, "sparkline": { "fillColor": "rgba(31, 118, 189, 0.18)", "full": False, "lineColor": "rgb(31, 120, 193)", "show": False }, "targets": [ { "dsType": "influxdb", "groupBy": [], "measurement": "requestsRaw", "policy": "default", "query": "SELECT count(\"responseTime\") FROM \"requestsRaw\" WHERE \"requestName\" =~ /^$request$/ AND $timeFilter", "rawQuery": True, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "responseTime" ], "type": "field" }, { "params": [], "type": "count" } ] ], "tags": [ { "key": "requestName", "operator": "=~", "value": "/^$request$/" } ] } ], "thresholds": "", "title": "Request Count", "transparent": True, "type": "singlestat", "valueFontSize": "80%", "valueMaps": [ { "op": "=", "text": "N/A", "value": "None" } ], "valueName": "current" }, { "cacheTimeout": None, "colorBackground": False, "colorValue": False, "colors": [ "rgb(100, 100, 100)", "rgba(237, 129, 40, 0.89)", "rgba(150, 20, 20, 0.9)" ], "datasource": "ds_exe_id_4351", "decimals": 2, "editable": True, "error": False, "format": "percentunit", "gauge": { "maxValue": 1, "minValue": 0, "show": True, "thresholdLabels": False, "thresholdMarkers": True }, "height": "180", "id": 5, "interval": None, "links": [], "mappingType": 1, "mappingTypes": [ { "name": "value to text", "value": 1 }, { "name": "range to text", "value": 2 } ], "maxDataPoints": 100, "NonePointMode": "connected", "NoneText": None, "postfix": "", "postfixFontSize": "50%", "prefix": "", "prefixFontSize": "50%", "rangeMaps": [ { "from": "None", "text": "N/A", "to": "None" } ], "span": 2, "sparkline": { "fillColor": "rgba(31, 118, 189, 0.18)", "full": False, "lineColor": "rgb(31, 120, 193)", "show": False }, "targets": [ { "dsType": "influxdb", "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "None" ], "type": "fill" } ], "measurement": "requests", "policy": "default", "query": "SELECT sum(\"errorCount\")/count(\"responseTime\") FROM \"requestsRaw\" WHERE $timeFilter AND \"requestName\" =~ /^$request$/", "rawQuery": True, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] } ], "thresholds": "0.01,0.1", "title": "Error Rate", "transparent": True, "type": "singlestat", "valueFontSize": "80%", "valueMaps": [ { "op": "=", "text": "N/A", "value": "None" } ], "valueName": "current" }, { "content": "", "editable": True, "error": False, "height": "110", "id": 24, "links": [], "mode": "markdown", "span": 6, "title": "", "transparent": True, "type": "text" }, { "aliasColors": { "95 perc": "#F9934E", "99 perc": "#E24D42", "Max": "#BF1B00" }, "bars": False, "datasource": "ds_exe_id_4351", "editable": True, "error": False, "fill": 3, "grid": {}, "height": "300", "id": 1, "legend": { "alignAsTable": False, "avg": False, "current": False, "max": False, "min": False, "show": True, "total": False, "values": False }, "lines": True, "linewidth": 1, "links": [], "NonePointMode": "None", "percentage": False, "pointradius": 5, "points": False, "renderer": "flot", "seriesOverrides": [ { "alias": "Mean", "zindex": 3 }, { "alias": "90 perc", "zindex": 2 }, { "alias": "95 perc", "zindex": 1 }, { "alias": "99 perc", "zindex": 0 }, { "alias": "Max", "zindex": -1 } ], "span": 6, "stack": False, "steppedLine": False, "targets": [ { "alias": "Mean", "dsType": "influxdb", "groupBy": [ { "params": [ "$aggregation" ], "type": "time" }, { "params": [ "None" ], "type": "fill" } ], "measurement": "requestsRaw", "policy": "default", "query": "SELECT mean(\"responseTime\") FROM \"requestsRaw\" WHERE \"requestName\" =~ /^$request$/ AND $timeFilter GROUP BY time([[aggregation]]s) fill(null)", "rawQuery": True, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "responseTime" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [ { "key": "requestName", "operator": "=~", "value": "/^$request$/" } ] }, { "alias": "90 perc", "dsType": "influxdb", "groupBy": [ { "params": [ "$aggregation" ], "type": "time" }, { "params": [ "None" ], "type": "fill" } ], "measurement": "requestsRaw", "policy": "default", "query": "SELECT percentile(\"responseTime\", 90) FROM \"requestsRaw\" WHERE \"requestName\" =~ /^$request$/ AND $timeFilter GROUP BY time([[aggregation]]s) fill(null)", "rawQuery": True, "refId": "B", "resultFormat": "time_series", "select": [ [ { "params": [ "responseTime" ], "type": "field" }, { "params": [ "90" ], "type": "percentile" } ] ], "tags": [ { "key": "requestName", "operator": "=~", "value": "/^$request$/" } ] }, { "alias": "95 perc", "dsType": "influxdb", "groupBy": [ { "params": [ "$aggregation" ], "type": "time" }, { "params": [ "None" ], "type": "fill" } ], "measurement": "requestsRaw", "policy": "default", "query": "SELECT percentile(\"responseTime\", 95) FROM \"requestsRaw\" WHERE \"requestName\" =~ /^$request$/ AND $timeFilter GROUP BY time([[aggregation]]s) fill(null)", "rawQuery": True, "refId": "D", "resultFormat": "time_series", "select": [ [ { "params": [ "responseTime" ], "type": "field" }, { "params": [ 95 ], "type": "percentile" } ] ], "tags": [ { "key": "requestName", "operator": "=~", "value": "/^$request$/" } ] }, { "alias": "99 perc", "dsType": "influxdb", "groupBy": [ { "params": [ "$aggregation" ], "type": "time" }, { "params": [ "None" ], "type": "fill" } ], "measurement": "requestsRaw", "policy": "default", "query": "SELECT percentile(\"responseTime\", 99) FROM \"requestsRaw\" WHERE \"requestName\" =~ /^$request$/ AND $timeFilter GROUP BY time([[aggregation]]s) fill(null)", "rawQuery": True, "refId": "C", "resultFormat": "time_series", "select": [ [ { "params": [ "responseTime" ], "type": "field" }, { "params": [ "99" ], "type": "percentile" } ] ], "tags": [ { "key": "requestName", "operator": "=~", "value": "/^$request$/" } ] }, { "alias": "Max", "dsType": "influxdb", "groupBy": [ { "params": [ "$aggregation" ], "type": "time" }, { "params": [ "None" ], "type": "fill" } ], "measurement": "requestsRaw", "policy": "default", "query": "SELECT max(\"responseTime\") FROM \"requestsRaw\" WHERE \"requestName\" =~ /^$request$/ AND $timeFilter GROUP BY time([[aggregation]]s) fill(null)", "rawQuery": True, "refId": "E", "resultFormat": "time_series", "select": [ [ { "params": [ "responseTime" ], "type": "field" }, { "params": [], "type": "max" } ] ], "tags": [ { "key": "requestName", "operator": "=~", "value": "/^$request$/" } ] } ], "thresholds": [], "timeFrom": None, "timeShift": None, "title": "Response Times", "tooltip": { "msResolution": True, "shared": True, "sort": 0, "value_type": "individual" }, "type": "graph", "xaxis": { "mode": "time", "name": None, "show": True, "values": [] }, "yaxes": [ { "format": "ms", "label": None, "logBase": 1, "max": None, "min": None, "show": True }, { "format": "short", "label": None, "logBase": 1, "max": None, "min": None, "show": True } ] }, { "aliasColors": {}, "bars": False, "datasource": "ds_exe_id_4351", "editable": True, "error": False, "fill": 1, "grid": {}, "height": "300", "id": 11, "legend": { "alignAsTable": True, "avg": True, "current": True, "max": True, "min": True, "show": True, "total": False, "values": True }, "lines": True, "linewidth": 2, "links": [], "NonePointMode": "connected", "percentage": False, "pointradius": 5, "points": False, "renderer": "flot", "seriesOverrides": [], "span": 6, "stack": False, "steppedLine": False, "targets": [ { "alias": "Errors per Second", "dsType": "influxdb", "groupBy": [ { "params": [ "$aggregation" ], "type": "time" }, { "params": [ "None" ], "type": "fill" } ], "measurement": "requestsRaw", "policy": "default", "query": "SELECT sum(\"errorCount\")/$aggregation FROM \"requestsRaw\" WHERE \"requestName\" =~ /^$request$/ AND $timeFilter GROUP BY time([[aggregation]]s) fill(null)", "rawQuery": True, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "errorCount" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [ { "key": "requestName", "operator": "=~", "value": "/^$request$/" } ] } ], "timeFrom": None, "timeShift": None, "title": "Error Rate", "tooltip": { "msResolution": False, "shared": True, "sort": 0, "value_type": "cumulative" }, "type": "graph", "xaxis": { "show": True, "mode": "time", "name": None, "values": [] }, "yaxes": [ { "format": "short", "label": "errors / s", "logBase": 1, "max": None, "min": "0", "show": True }, { "format": "short", "label": "", "logBase": 1, "max": None, "min": None, "show": True } ], "thresholds": [] } ], "showTitle": False, "titleSize": "h3", "height": "250px", "repeat": None, "repeatRowId": None, "repeatIteration": None, "collapse": False } ] }, "folderId": 0, "overwrite": False }
"type":"influxdb", "url":"http://10.66.170.42:8086", "access":"proxy", "basicAuth":False, "password": "", "user": "", "database": "jmeter2", "basicAuth": False, "basicAuthUser": "basicuser", "basicAuthPassword": "basicuser", "isDefault": False }
rest_get("10.66.170.42:3000", "/org/apikeys")