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: [].}