Procs
proc avg(self: SurrealQuery; column: string): Future[float] {....stackTrace: false, raises: [Exception, ValueError], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect], forbids: [].}
proc columns(self: SurrealQuery): Future[seq[string]] {....stackTrace: false, raises: [Exception, ValueError], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect], forbids: [].}
proc count(self: SurrealQuery): Future[int] {....stackTrace: false, raises: [Exception, ValueError], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect], forbids: [].}
proc delete(self: SurrealQuery): owned(Future[void]) {....stackTrace: false, raises: [Exception], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect], forbids: [].}
- https://surrealdb.com/docs/surrealql/statements/delete
proc delete(self: SurrealQuery; id: SurrealId): owned(Future[void]) {. ...stackTrace: false, raises: [Exception], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect], forbids: [].}
- https://surrealdb.com/docs/surrealql/statements/delete
proc exec(self: RawSurrealQuery): owned(Future[void]) {....stackTrace: false, raises: [Exception], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect], forbids: [].}
-
It is only used with raw()
proc find(self: SurrealQuery; id: SurrealId; key = "id"): Future[ Option[JsonNode]] {....stackTrace: false, raises: [Exception, ValueError], tags: [ RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect], forbids: [].}
proc first(self: RawSurrealQuery): Future[Option[JsonNode]] {....stackTrace: false, raises: [Exception, ValueError], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect], forbids: [].}
- It is only used with raw()
proc first(self: SurrealQuery): Future[Option[JsonNode]] {....stackTrace: false, raises: [Exception, ValueError], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect], forbids: [].}
proc get(self: RawSurrealQuery): Future[seq[JsonNode]] {....stackTrace: false, raises: [Exception, ValueError], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect], forbids: [].}
- It is only used with raw()
proc get(self: SurrealQuery): Future[seq[JsonNode]] {....stackTrace: false, raises: [Exception, ValueError], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect], forbids: [].}
- https://surrealdb.com/docs/surrealql/statements/select
proc info(self: RawSurrealQuery): Future[JsonNode] {....stackTrace: false, raises: [Exception, ValueError], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect], forbids: [].}
-
Get all response.
proc insert(self: SurrealQuery; items: JsonNode): owned(Future[void]) {. ...stackTrace: false, raises: [Exception], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect], forbids: [].}
- https://surrealdb.com/docs/surrealql/statements/insert
proc insert(self: SurrealQuery; items: seq[JsonNode]): owned(Future[void]) {. ...stackTrace: false, raises: [Exception], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect], forbids: [].}
- https://surrealdb.com/docs/surrealql/statements/insert
proc insertId(self: SurrealQuery; items: JsonNode; key = "id"): Future[SurrealId] {. ...stackTrace: false, raises: [Exception, ValueError], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect], forbids: [].}
- https://surrealdb.com/docs/surrealql/statements/insert
proc insertId(self: SurrealQuery; items: seq[JsonNode]; key = "id"): Future[ seq[SurrealId]] {....stackTrace: false, raises: [Exception, ValueError], tags: [ RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect], forbids: [].}
proc max(self: SurrealQuery; column: string; collaction: Collation = None): Future[ string] {....stackTrace: false, raises: [Exception, ValueError], tags: [ RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect], forbids: [].}
- = ORDER BY {column} {collaction} DESC LIMIT 1
proc min(self: SurrealQuery; column: string; collaction: Collation = None): Future[ string] {....stackTrace: false, raises: [Exception, ValueError], tags: [ RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect], forbids: [].}
- = ORDER BY {column} {collaction} ASC LIMIT 1
proc sum(self: SurrealQuery; column: string): Future[float] {....stackTrace: false, raises: [Exception, ValueError], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect], forbids: [].}
proc update(self: SurrealConnections; id: SurrealId; items: JsonNode): owned( Future[void]) {....stackTrace: false, raises: [Exception], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect], forbids: [].}
- https://surrealdb.com/docs/surrealql/statements/update
proc update(self: SurrealQuery; items: JsonNode): owned(Future[void]) {. ...stackTrace: false, raises: [Exception], tags: [RootEffect, WriteDirEffect, ReadDirEffect, ReadIOEffect, WriteIOEffect, TimeEffect], forbids: [].}
- https://surrealdb.com/docs/surrealql/statements/update
Templates
template seeder(rdb: SurrealConnections; 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: SurrealConnections; tableName: string; body: untyped): untyped
- The seeder block allows the code in the block to work only when the table is empty.