rm-hull / gps-routes-api / 24310622019

36%

push

github

feat: issue #120 phase 1-4 -- query layer refactoring (#121)

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
```

---------

Co-authored-by: gemini-code-assist[bot] <176961590+gemini-code-assist[bot]@users.noreply.github.com>

81 of 600 new or added lines in 5 files covered. (13.5%)

687 of 1896 relevant lines covered (36.23%)

0.39 hits per line