rm-hull / fuel-prices-api / 22163985049

20%

Build Type

push

github

Committed by web-flow

Commit Message

feat: add database migrations and price timestamps (#9)

* feat: add database migrations and price timestamps

- Integrate `golang-migrate` to manage **SQLite** schema versions.
- Add `price_change_effective_timestamp` to track when fuel prices
  officially change.
- Simplify API response decoding by removing legacy metadata wrappers
  and batch tracking.
- Update `Dockerfile` and repository tests to support the new
  migration-based workflow.

```mermaid
sequenceDiagram
    participant App as API Server
    participant Mig as golang-migrate
    participant DB as SQLite
    participant API as Gov API

    App->>Mig: Migrate("migrations", dbPath)
    Mig->>DB: Run .up.sql scripts
    App->>API: GetFuelPrices()
    API-->>App: Return prices with effective timestamps
    App->>DB: Upsert prices with PriceChangeEffectiveTimestamp
```

* chore: promote migrate to direct dependency

Promote `github.com/golang-migrate/migrate/v4` from an indirect to a
direct dependency in `go.mod`. This change ensures the library is
explicitly tracked as a requirement for the project.

* fix: close database and migration resources

Ensure migration source and database connections are properly released
to prevent resource leaks and potential file locks:

-   Add `defer m.Close()` in `Migrate` to clean up migration drivers.
-   Update `setupTestDB` to close the database handle before removing
    the temporary file.

Run Details

16 of 37 new or added lines in 5 files covered. (43.24%)

1 existing line in 1 file now uncovered.

173 of 605 relevant lines covered (28.6%)

0.31 hits per line