# src/allographer/query_builder/models/postgres/postgres_query

Theme:

- Index

Search:
Group by:

# Imports

../../libs/postgres/postgres_impl, ../../enums, postgres_types

# Procs

    proc `distinct`(self: PostgresQuery): PostgresQuery {....raises: [], tags: [],
        forbids: [].}

    proc groupBy(self: PostgresQuery; column: string): PostgresQuery {.
        ...raises: [KeyError], tags: [], forbids: [].}

    proc having(self: PostgresQuery; column: string; symbol: string;
                value: string | int | float | bool): PostgresQuery

    proc having(self: PostgresQuery; column: string; symbol: string; value: nil.type): PostgresQuery {.
        ...raises: [CatchableError, KeyError], tags: [], forbids: [].}

    proc join(self: PostgresQuery; table: string; column1: string; symbol: string;
              column2: string): PostgresQuery {....raises: [KeyError], tags: [],
        forbids: [].}

    proc leftJoin(self: PostgresQuery; table: string; column1: string;
                  symbol: string; column2: string): PostgresQuery {.
        ...raises: [KeyError], tags: [], forbids: [].}

    proc limit(self: PostgresQuery; num: int): PostgresQuery {....raises: [], tags: [],
        forbids: [].}

    proc offset(self: PostgresQuery; num: int): PostgresQuery {....raises: [],
        tags: [], forbids: [].}

    proc orderBy(self: PostgresQuery; column: string; order: Order): PostgresQuery {.
        ...raises: [KeyError], tags: [], forbids: [].}

    proc orWhere(self: PostgresQuery; column: string; symbol: string;
                 value: string | int | float | bool): PostgresQuery

    proc orWhere(self: PostgresQuery; column: string; symbol: string;
                 value: nil.type): PostgresQuery {.
        ...raises: [CatchableError, KeyError], tags: [], forbids: [].}

    proc raw(self: PostgresConnections; sql: string; arges = newJArray()): RawPostgresQuery {.
        ...raises: [], tags: [], forbids: [].}

  arges is `JArray`

  can't use BLOB data.

    proc select(self: PostgresConnections; columnsArg: varargs[string]): PostgresQuery {.
        ...raises: [], tags: [], forbids: [].}

    proc table(self: PostgresConnections; tableArg: string): PostgresQuery {.
        ...raises: [], tags: [], forbids: [].}

    proc table(self: PostgresQuery; tableArg: string): PostgresQuery {....raises: [],
        tags: [], forbids: [].}

    proc where(self: PostgresQuery; column: string; symbol: string;
               value: string | int | float): PostgresQuery

    proc where(self: PostgresQuery; column: string; symbol: string; value: bool): PostgresQuery {.
        ...raises: [CatchableError, KeyError], tags: [], forbids: [].}

    proc where(self: PostgresQuery; column: string; symbol: string; value: nil.type): PostgresQuery {.
        ...raises: [CatchableError, KeyError], tags: [], forbids: [].}

    proc whereBetween(self: PostgresQuery; column: string;
                      width: array[2, int | float]): PostgresQuery

    proc whereBetween(self: PostgresQuery; column: string; width: array[2, string]): PostgresQuery {.
        ...raises: [KeyError], tags: [], forbids: [].}

    proc whereIn(self: PostgresQuery; column: string;
                 width: seq[int | float | string]): PostgresQuery

    proc whereNotBetween(self: PostgresQuery; column: string;
                         width: array[2, int | float]): PostgresQuery

    proc whereNotBetween(self: PostgresQuery; column: string;
                         width: array[2, string]): PostgresQuery {.
        ...raises: [KeyError], tags: [], forbids: [].}

    proc whereNotIn(self: PostgresQuery; column: string;
                    width: seq[int | float | string]): PostgresQuery

    proc whereNull(self: PostgresQuery; column: string): PostgresQuery {.
        ...raises: [KeyError], tags: [], forbids: [].}