map-services / street-manager-relay

19%

main: 4%

Build Type

Pull #46

github

Committed by rm-hull

Commit Message

feat: add signature v2 support and improve DB layer

- Add support for SNS signature version 2 (SHA256).
- Tighten security by restricting `SigningCertURL` to trusted AWS
domains.
- Refactor `DbRepository` to use a helper approach for event column
mapping,
  improving maintainability and reducing boilerplate.
- Standardize HTTP fetching and error handling across routes.

```mermaid
sequenceDiagram
    participant User as SNS Service
    participant Relay as App
    participant DB as SQLite

    User->>Relay: POST /sns (Message + Signature)
    Relay->>Relay: Verify Signature (v1 or v2)
    Relay->>Relay: Validate Cert URL (amazonaws.com)
    Relay->>DB: Upsert Event (ON CONFLICT)
    DB-->>Relay: OK
    Relay-->>User: 200 OK
```

Pull Request Pull Request #46: feat: add signature v2 support and improve DB layer

Coverage Stats

116 of 227 new or added lines in 8 files covered. (51.1%)

48 existing lines in 1 file now uncovered.

264 of 1368 relevant lines covered (19.3%)

0.2 hits per line