src/allographer/v2/query_builder/models/mariadb/mariadb_query

Search:
Group by:

Procs

proc `distinct`(self: MariadbQuery): MariadbQuery {....raises: [], tags: [],
    forbids: [].}
proc groupBy(self: MariadbQuery; column: string): MariadbQuery {.
    ...raises: [KeyError], tags: [], forbids: [].}
proc having(self: MariadbQuery; column: string; symbol: string;
            value: string | int | float | bool): MariadbQuery
proc having(self: MariadbQuery; column: string; symbol: string; value: nil.type): MariadbQuery {.
    ...raises: [CatchableError, KeyError], tags: [], forbids: [].}
proc join(self: MariadbQuery; table: string; column1: string; symbol: string;
          column2: string): MariadbQuery {....raises: [KeyError], tags: [],
    forbids: [].}
proc leftJoin(self: MariadbQuery; table: string; column1: string;
              symbol: string; column2: string): MariadbQuery {.
    ...raises: [KeyError], tags: [], forbids: [].}
proc limit(self: MariadbQuery; num: int): MariadbQuery {....raises: [], tags: [],
    forbids: [].}
proc offset(self: MariadbQuery; num: int): MariadbQuery {....raises: [], tags: [],
    forbids: [].}
proc orderBy(self: MariadbQuery; column: string; order: Order): MariadbQuery {.
    ...raises: [KeyError], tags: [], forbids: [].}
proc orWhere(self: MariadbQuery; column: string; symbol: string;
             value: string | int | float | bool): MariadbQuery
proc orWhere(self: MariadbQuery; column: string; symbol: string; value: nil.type): MariadbQuery {.
    ...raises: [CatchableError, KeyError], tags: [], forbids: [].}
proc raw(self: MariadbConnections; sql: string; arges = newJArray()): RawMariadbQuery {.
    ...raises: [], tags: [], forbids: [].}

arges is JArray [true, 1, 1.1, "str"]

can't use BLOB data.

proc select(self: MariadbConnections; columnsArg: varargs[string]): MariadbQuery {.
    ...raises: [], tags: [], forbids: [].}
proc table(self: MariadbConnections; tableArg: string): MariadbQuery {.
    ...raises: [], tags: [], forbids: [].}
proc table(self: MariadbQuery; tableArg: string): MariadbQuery {....raises: [],
    tags: [], forbids: [].}
proc where(self: MariadbQuery; column: string; symbol: string;
           value: string | int | float): MariadbQuery
proc where(self: MariadbQuery; column: string; symbol: string; value: bool): MariadbQuery {.
    ...raises: [CatchableError, KeyError], tags: [], forbids: [].}
proc where(self: MariadbQuery; column: string; symbol: string; value: nil.type): MariadbQuery {.
    ...raises: [CatchableError, KeyError], tags: [], forbids: [].}
proc whereBetween(self: MariadbQuery; column: string;
                  width: array[2, int | float]): MariadbQuery
proc whereBetween(self: MariadbQuery; column: string; width: array[2, string]): MariadbQuery {.
    ...raises: [KeyError], tags: [], forbids: [].}
proc whereIn(self: MariadbQuery; column: string;
             width: seq[int | float | string]): MariadbQuery
proc whereNotBetween(self: MariadbQuery; column: string;
                     width: array[2, int | float]): MariadbQuery
proc whereNotBetween(self: MariadbQuery; column: string; width: array[2, string]): MariadbQuery {.
    ...raises: [KeyError], tags: [], forbids: [].}
proc whereNotIn(self: MariadbQuery; column: string;
                width: seq[int | float | string]): MariadbQuery
proc whereNull(self: MariadbQuery; column: string): MariadbQuery {.
    ...raises: [KeyError], tags: [], forbids: [].}