divviup / divviup-api / 9573008562

69%

Build Type

push

github

Committed by web-flow

Commit Message

Move sqlx query logging to debug level (#1128)

By default, `sea_orm::ConnectOptions` will log queries at info ([1]). As
a result, `divviup-api` logs are filled with unhelpful lines like:

```json
{
    "timestamp": "2024-06-18T21:31:41.294043Z",
    "level": "INFO",
    "fields": {
        "summary": "select 1",
        "db.statement": "",
        "rows_affected": 1,
        "rows_returned": 1,
        "elapsed": "171.873\u00b5s"
    },
    "target": "sqlx::query",
    "filename": "/usr/local/cargo/registry/src/index.crates.io-6f17d22bba15001f/sqlx-core-0.7.3/src/logger.rs",
    "line_number": 135,
    "threadId": "ThreadId(4)"
}
```

...which is just the healthcheck succeeding. This commit moves that
logging to debug level, so that we can still opt into it but generate
less noise in normal operation.

[1]: https://docs.rs/sea-orm/0.12.15/sea_orm/struct.ConnectOptions.html#method.sqlx_logging_level

Coverage Stats

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

4 existing lines in 3 files now uncovered.

3940 of 6989 relevant lines covered (56.37%)

106.63 hits per line