influxdata / Litmus

testing framework
0 stars 0 forks source link

Quartz query: get api usage #195

Closed gshif closed 4 years ago

gshif commented 5 years ago

Test quartz's query(defined in https://github.com/influxdata/quartz/blob/cloud-two-dev/lib/quartz/two/billing/organization_usage.ex):

 def get_api_usage(org_id, start, stop) do

    from(bucket: "system_usage")
    |> range(start: #{start}, stop: #{stop})
    |> filter(fn: (r) =>
      r.org_id == "#{org_id}"
      and r._measurement == "http_request" and
      ((r.endpoint == "/api/v2/write" and
        r._field == "req_bytes" and
        r.hostname !~ /^gateway-internal/) or
      (r.endpoint == "/api/v2/query" and r._field == "resp_bytes"))
    )
    |> group()
    |> aggregateWindow(every: 1h, fn: count)
    |> fill(column: "_value", value: 0)
    |> rename(columns: {_value: "requests_count"})
    |> yield(name: "requests_count")
Nlyandres commented 4 years ago

API usage was removed from Quartz and this query is obsolete