rm-hull / fuel-prices-api / 22743229604

46%

push

github

feat: add fuel price snapshot statistics view (#25)

* feat: add daily fuel price statistics view

Introduce a new `daily_fuel_price_stats` database view providing
national and regional fuel price metrics.

-   Enable the `sqlite_math_functions` build tag to support `SQRT` and
    variance calculations within SQLite.
-   Standardize postcodes to **uppercase** in the database to ensure
    consistent grouping by postcode area.
-   Calculate daily `min`, `avg`, `max`, and `stddev` for both national
    and area-specific scopes.
-   Add comprehensive integration tests to verify statistical accuracy.

* feat: migrate fuel stats to a snapshot view

Renamed the stats view and removed the date filter to ensure the
latest price for every station is included, even if not updated
today.

*   Rename `daily_fuel_price_stats` to `fuel_price_snapshot_stats`.
*   Remove the `DATE('now')` filter from the view definition.
*   Update `stats_view_test.go` to handle multi-day data and fix a
    column mapping bug in `Scan`.
*   Add documentation for running tests with required build tags in
    `README.md`.

* Update migrations/000003_add_price_stats_view.down.sql

Co-authored-by: gemini-code-assist[bot] <176961590+gemini-code-assist[bot]@users.noreply.github.com>

* fix: filter empty postcodes in price stats

Exclude invalid or empty postcode areas from the price statistics view
to improve data quality. This prevents records with missing location
data from being grouped into an empty postcode category.

Additionally, handle an un-ignored error when closing database rows in
unit tests.

---------

Co-authored-by: gemini-code-assist[bot] <176961590+gemini-code-assist[bot]@users.noreply.github.com>

1 of 1 new or added line in 1 file covered. (100.0%)

203 of 1088 relevant lines covered (18.66%)

0.2 hits per line