rm-hull / gps-routes-api / 24308993190

36%

main: 36%

Pull #121

github

feat: add database dialect abstraction

Introduce a `Dialect` interface to support cross-database compatibility,
allowing the `QueryBuilder` to generate syntax specific to PostgreSQL
and SQLite.

```mermaid
classDiagram
    class Dialect {
        <<interface>>
        +FormatParam(int) string
        +BuildArrayOverlapQuery(string, string) string
        +BuildFullTextQuery(string, string) string
        +PrepareParam(any) any
    }
    class PostgreSQLDialect
    class SQLiteDialect
    class QueryBuilder {
        -Dialect dialect
    }

    Dialect <|.. PostgreSQLDialect
    Dialect <|.. SQLiteDialect
    QueryBuilder --> Dialect
```

81 of 641 new or added lines in 5 files covered. (12.64%)

687 of 1937 relevant lines covered (35.47%)

0.38 hits per line