Procs
proc `distinct`(self: SqliteQuery): SqliteQuery {....raises: [], tags: [].}
proc avg(self: SqliteQuery; column: string): Future[Option[float]] {. ...raises: [Exception, ValueError], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect, ReadDbEffect].}
proc begin(self: SqliteConnections): owned(Future[void]) {....raises: [Exception], tags: [ RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect].}
proc columns(self: SqliteQuery): Future[seq[string]] {. ...raises: [Exception, ValueError], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect].}
proc commit(self: SqliteConnections): owned(Future[void]) {....raises: [Exception], tags: [ RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect].}
proc count(self: SqliteQuery): Future[int] {....raises: [Exception, ValueError], tags: [ RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect, ReadDbEffect].}
proc delete(self: SqliteQuery): owned(Future[void]) {....raises: [Exception], tags: [ RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect, ReadDbEffect].}
proc delete(self: SqliteQuery; id: int; key = "id"): owned(Future[void]) {. ...raises: [Exception], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect, ReadDbEffect].}
proc exec(self: RawSqliteQuery): owned(Future[void]) {....raises: [Exception], tags: [ RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect].}
- It is only used with raw()
proc find(self: SqliteQuery; id: int; key = "id"): Future[Option[JsonNode]] {. ...raises: [Exception, ValueError], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect, ReadDbEffect].}
proc find(self: SqliteQuery; id: string; key = "id"): Future[Option[JsonNode]] {. ...raises: [Exception, ValueError], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect, ReadDbEffect].}
proc find[T](self: SqliteQuery; id: int; typ: typedesc[T]; key = "id"): Future[ Option[T]]
proc find[T](self: SqliteQuery; id: string; typ: typedesc[T]; key = "id"): Future[ Option[T]]
proc findPlain(self: SqliteQuery; id: int; key = "id"): Future[seq[string]] {. ...raises: [Exception, ValueError], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect, ReadDbEffect].}
proc findPlain(self: SqliteQuery; id: string; key = "id"): Future[seq[string]] {. ...raises: [Exception, ValueError], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect, ReadDbEffect].}
proc first(self: RawSqliteQuery): Future[Option[JsonNode]] {. ...raises: [Exception, ValueError], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect, ReadDbEffect].}
- It is only used with raw()
proc first(self: SqliteQuery): Future[Option[JsonNode]] {. ...raises: [Exception, ValueError], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect, ReadDbEffect].}
proc first[T](self: SqliteQuery; typ: typedesc[T]): Future[Option[T]]
proc firstPlain(self: RawSqliteQuery): Future[seq[string]] {. ...raises: [Exception, ValueError], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect, ReadDbEffect].}
- It is only used with raw()
proc firstPlain(self: SqliteQuery): Future[seq[string]] {. ...raises: [Exception, ValueError], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect, ReadDbEffect].}
proc get(self: RawSqliteQuery): Future[seq[JsonNode]] {. ...raises: [Exception, ValueError], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect, ReadDbEffect].}
- It is only used with raw()
proc get(self: SqliteQuery): Future[seq[JsonNode]] {. ...raises: [Exception, ValueError], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect, ReadDbEffect].}
proc get[T](self: SqliteQuery; typ: typedesc[T]): Future[seq[T]]
proc getPlain(self: RawSqliteQuery): Future[seq[seq[string]]] {. ...raises: [Exception, ValueError], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect, ReadDbEffect].}
- It is only used with raw()
proc getPlain(self: SqliteQuery): Future[seq[seq[string]]] {. ...raises: [Exception, ValueError], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect, ReadDbEffect].}
proc groupBy(self: SqliteQuery; column: string): SqliteQuery {. ...raises: [KeyError], tags: [].}
proc having(self: SqliteQuery; column: string; symbol: string; value: string | int | float | bool): SqliteQuery
proc having(self: SqliteQuery; column: string; symbol: string; value: nil.type): SqliteQuery {. ...raises: [Exception, KeyError], tags: [].}
proc insert(self: SqliteQuery; items: JsonNode): owned(Future[void]) {. ...raises: [Exception], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect, ReadDbEffect].}
proc insert(self: SqliteQuery; items: seq[JsonNode]): owned(Future[void]) {. ...raises: [Exception], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect, ReadDbEffect].}
proc insertId(self: SqliteQuery; items: JsonNode; key = "id"): Future[string] {. ...raises: [Exception, ValueError], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect, ReadDbEffect].}
proc insertId(self: SqliteQuery; items: seq[JsonNode]; key = "id"): Future[ seq[string]] {....raises: [Exception, ValueError], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect, ReadDbEffect].}
proc join(self: SqliteQuery; table: string; column1: string; symbol: string; column2: string): SqliteQuery {....raises: [KeyError], tags: [].}
proc leftJoin(self: SqliteQuery; table: string; column1: string; symbol: string; column2: string): SqliteQuery {....raises: [KeyError], tags: [].}
proc limit(self: SqliteQuery; num: int): SqliteQuery {....raises: [], tags: [].}
proc max(self: SqliteQuery; column: string): Future[Option[string]] {. ...raises: [Exception, ValueError], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect, ReadDbEffect].}
proc min(self: SqliteQuery; column: string): Future[Option[string]] {. ...raises: [Exception, ValueError], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect, ReadDbEffect].}
proc offset(self: SqliteQuery; num: int): SqliteQuery {....raises: [], tags: [].}
proc orderBy(self: SqliteQuery; column: string; order: Order): SqliteQuery {. ...raises: [KeyError], tags: [].}
proc orWhere(self: SqliteQuery; column: string; symbol: string; value: string | int | float | bool): SqliteQuery
proc orWhere(self: SqliteQuery; column: string; symbol: string; value: nil.type): SqliteQuery {. ...raises: [Exception, KeyError], tags: [].}
proc rollback(self: SqliteConnections): owned(Future[void]) {. ...raises: [Exception], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect].}
proc sum(self: SqliteQuery; column: string): Future[Option[float]] {. ...raises: [Exception, ValueError], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect, ReadDbEffect].}
proc table(self: SqliteQuery; tableArg: string): SqliteQuery {....raises: [], tags: [].}
proc update(self: SqliteQuery; items: JsonNode): owned(Future[void]) {. ...raises: [Exception], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect, ReadDbEffect].}
proc where(self: SqliteQuery; column: string; symbol: string; value: string | int | float): SqliteQuery
proc where(self: SqliteQuery; column: string; symbol: string; value: bool): SqliteQuery {. ...raises: [Exception, KeyError], tags: [].}
proc where(self: SqliteQuery; column: string; symbol: string; value: nil.type): SqliteQuery {. ...raises: [Exception, KeyError], tags: [].}
proc whereBetween(self: SqliteQuery; column: string; width: array[2, int | float]): SqliteQuery
proc whereBetween(self: SqliteQuery; column: string; width: array[2, string]): SqliteQuery {. ...raises: [KeyError], tags: [].}
proc whereIn(self: SqliteQuery; column: string; width: seq[int | float | string]): SqliteQuery
proc whereNotBetween(self: SqliteQuery; column: string; width: array[2, int | float]): SqliteQuery
proc whereNotBetween(self: SqliteQuery; column: string; width: array[2, string]): SqliteQuery {. ...raises: [KeyError], tags: [].}
proc whereNotIn(self: SqliteQuery; column: string; width: seq[int | float | string]): SqliteQuery
proc whereNull(self: SqliteQuery; column: string): SqliteQuery {. ...raises: [KeyError], tags: [].}
Templates
template seeder(rdb: SqliteConnections; tableName, column: string; body: untyped): untyped
- The seeder block allows the code in the block to work only when the table or specified column is empty.
template seeder(rdb: SqliteConnections; tableName: string; body: untyped): untyped
- The seeder block allows the code in the block to work only when the table is empty.