src/allographer/v2/query_builder/models/sqlite/sqlite_exec

Search:
Group by:

Procs

proc avg(self: SqliteQuery; column: string): Future[Option[float]] {.
    ...stackTrace: false, raises: [Exception, ValueError], tags: [RootEffect,
    WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect,
    ReadDbEffect], forbids: [].}
proc begin(self: SqliteConnections): owned(Future[void]) {....stackTrace: false,
    raises: [Exception], tags: [RootEffect, WriteDirEffect, ReadDirEffect,
                                ReadIOEffect, WriteIOEffect, TimeEffect],
    forbids: [].}
proc columns(self: SqliteQuery): Future[seq[string]] {....stackTrace: false,
    raises: [Exception, ValueError], tags: [RootEffect, WriteDirEffect,
    ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect], forbids: [].}
proc commit(self: SqliteConnections): owned(Future[void]) {....stackTrace: false,
    raises: [Exception], tags: [RootEffect, WriteDirEffect, ReadDirEffect,
                                ReadIOEffect, WriteIOEffect, TimeEffect],
    forbids: [].}
proc count(self: SqliteQuery): Future[int] {....stackTrace: false,
    raises: [Exception, ValueError], tags: [RootEffect, WriteDirEffect,
    ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect, ReadDbEffect],
    forbids: [].}
proc delete(self: SqliteQuery): owned(Future[void]) {....stackTrace: false,
    raises: [Exception], tags: [RootEffect, WriteDirEffect, ReadDirEffect,
                                ReadIOEffect, WriteIOEffect, TimeEffect,
                                ReadDbEffect], forbids: [].}
proc delete(self: SqliteQuery; id: int; key = "id"): owned(Future[void]) {.
    ...stackTrace: false, raises: [Exception], tags: [RootEffect, WriteDirEffect,
    ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect, ReadDbEffect],
    forbids: [].}
proc exec(self: RawSqliteQuery): owned(Future[void]) {....stackTrace: false,
    raises: [Exception], tags: [RootEffect, WriteDirEffect, ReadDirEffect,
                                ReadIOEffect, WriteIOEffect, TimeEffect],
    forbids: [].}
It is only used with raw()
proc find(self: SqliteQuery; id: int; key = "id"): Future[Option[JsonNode]] {.
    ...stackTrace: false, raises: [Exception, ValueError], tags: [RootEffect,
    WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect,
    ReadDbEffect], forbids: [].}
proc find(self: SqliteQuery; id: string; key = "id"): Future[Option[JsonNode]] {.
    ...stackTrace: false, raises: [Exception, ValueError], tags: [RootEffect,
    WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect,
    ReadDbEffect], forbids: [].}
proc findPlain(self: SqliteQuery; id: int; key = "id"): Future[seq[string]] {.
    ...stackTrace: false, raises: [Exception, ValueError], tags: [RootEffect,
    WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect,
    ReadDbEffect], forbids: [].}
proc findPlain(self: SqliteQuery; id: string; key = "id"): Future[seq[string]] {.
    ...stackTrace: false, raises: [Exception, ValueError], tags: [RootEffect,
    WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect,
    ReadDbEffect], forbids: [].}
proc first(self: RawSqliteQuery): Future[Option[JsonNode]] {....stackTrace: false,
    raises: [Exception, ValueError], tags: [RootEffect, WriteDirEffect,
    ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect, ReadDbEffect],
    forbids: [].}
It is only used with raw()
proc first(self: SqliteQuery): Future[Option[JsonNode]] {....stackTrace: false,
    raises: [Exception, ValueError], tags: [RootEffect, WriteDirEffect,
    ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect, ReadDbEffect],
    forbids: [].}
proc firstPlain(self: RawSqliteQuery): Future[seq[string]] {....stackTrace: false,
    raises: [Exception, ValueError], tags: [RootEffect, WriteDirEffect,
    ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect, ReadDbEffect],
    forbids: [].}
It is only used with raw()
proc firstPlain(self: SqliteQuery): Future[seq[string]] {....stackTrace: false,
    raises: [Exception, ValueError], tags: [RootEffect, WriteDirEffect,
    ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect, ReadDbEffect],
    forbids: [].}
proc get(self: RawSqliteQuery): Future[seq[JsonNode]] {....stackTrace: false,
    raises: [Exception, ValueError], tags: [RootEffect, WriteDirEffect,
    ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect, ReadDbEffect],
    forbids: [].}
It is only used with raw()
proc get(self: SqliteQuery): Future[seq[JsonNode]] {....stackTrace: false,
    raises: [Exception, ValueError], tags: [RootEffect, WriteDirEffect,
    ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect, ReadDbEffect],
    forbids: [].}
proc getPlain(self: RawSqliteQuery): Future[seq[seq[string]]] {.
    ...stackTrace: false, raises: [Exception, ValueError], tags: [RootEffect,
    WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect,
    ReadDbEffect], forbids: [].}
It is only used with raw()
proc getPlain(self: SqliteQuery): Future[seq[seq[string]]] {....stackTrace: false,
    raises: [Exception, ValueError], tags: [RootEffect, WriteDirEffect,
    ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect, ReadDbEffect],
    forbids: [].}
proc insert(self: SqliteQuery; items: JsonNode): owned(Future[void]) {.
    ...stackTrace: false, raises: [Exception], tags: [RootEffect, WriteDirEffect,
    ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect, ReadDbEffect],
    forbids: [].}
proc insert(self: SqliteQuery; items: seq[JsonNode]): owned(Future[void]) {.
    ...stackTrace: false, raises: [Exception], tags: [RootEffect, WriteDirEffect,
    ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect, ReadDbEffect],
    forbids: [].}
proc insertId(self: SqliteQuery; items: JsonNode; key = "id"): Future[string] {.
    ...stackTrace: false, raises: [Exception, ValueError], tags: [RootEffect,
    WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect,
    ReadDbEffect], forbids: [].}
proc insertId(self: SqliteQuery; items: seq[JsonNode]; key = "id"): Future[
    seq[string]] {....stackTrace: false, raises: [Exception, ValueError], tags: [
    RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect,
    TimeEffect, ReadDbEffect], forbids: [].}
proc max(self: SqliteQuery; column: string): Future[Option[string]] {.
    ...stackTrace: false, raises: [Exception, ValueError], tags: [RootEffect,
    WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect,
    ReadDbEffect], forbids: [].}
proc min(self: SqliteQuery; column: string): Future[Option[string]] {.
    ...stackTrace: false, raises: [Exception, ValueError], tags: [RootEffect,
    WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect,
    ReadDbEffect], forbids: [].}
proc rollback(self: SqliteConnections): owned(Future[void]) {....stackTrace: false,
    raises: [Exception], tags: [RootEffect, WriteDirEffect, ReadDirEffect,
                                ReadIOEffect, WriteIOEffect, TimeEffect],
    forbids: [].}
proc sum(self: SqliteQuery; column: string): Future[Option[float]] {.
    ...stackTrace: false, raises: [Exception, ValueError], tags: [RootEffect,
    WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect,
    ReadDbEffect], forbids: [].}
proc update(self: SqliteQuery; items: JsonNode): owned(Future[void]) {.
    ...stackTrace: false, raises: [Exception], tags: [RootEffect, WriteDirEffect,
    ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect, ReadDbEffect],
    forbids: [].}

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.