rm-hull / fuel-prices-api / 23378851659

46%

Build Type

push

github

Committed by web-flow

Commit Message

feat: add SQL query latency metrics (#38)

* chore: bump project dependencies

Update the following packages to their latest versions:
* `github.com/bytedance/gopkg`
* `github.com/cockroachdb/redact`
* `github.com/klauspost/compress`
* `github.com/oapi-codegen/runtime`

* feat: add SQL query latency metrics

Introduced Prometheus histogram metrics to track SQL execution
latency across repository operations.

```mermaid
sequenceDiagram
    participant Repo as sqliteRepository
    participant M as SqlMetrics
    participant DB as SQLite DB

    Repo->>Repo: Record(start)
    Repo->>DB: Execute Query
    DB-->>Repo: Result
    Repo->>M: Record(duration)
    M->>M: Observe latency
```

* refactor: improve json handling and metrics registration

- Centralized `jsoniter` configuration into a dedicated internal file.
- Introduced `RegisterOrPanic` helper to handle idempotent prometheus
  metric registration, preventing panics on duplicate registrations
  while ensuring errors are caught during startup.

* perf: move metrics recording before transaction

Ensure metric duration tracking starts at the entry of the repository
methods to capture the full overhead, including transaction
initialization.

Run Details

33 of 42 new or added lines in 6 files covered. (78.57%)

1 existing line in 1 file now uncovered.

387 of 1350 relevant lines covered (28.67%)

0.31 hits per line