Skip to content

Latest commit

 

History

History
29 lines (18 loc) · 601 Bytes

File metadata and controls

29 lines (18 loc) · 601 Bytes

fuel-prices-api

Wraps GOV.UKs petrol prices API to allow historical querying and fast geo-lookup by bounding box

Grafana Dashboard

Import the grafana_dashboard.json and set prometheus as the data source:

screenshot

Useful queries

SELECT node_id, fuel_type, MAX(price_last_updated), COUNT(*)
FROM fuel_prices
GROUP BY node_id, fuel_type
HAVING COUNT(*) > 1;

Running Tests

go test ./... -tags="jsoniter sqlite_math_functions"

References