Index

API symbols

`[]`:

• macroUtils: `[]`(items: seq[Pragma]; name: string): Pragma

autoIncrement:

• pragmas: autoIncrement()

cascade:

• pragmas: cascade()

commit:

• ponairi: commit(db)

contains:

• macroUtils: contains(t: CacheTable; key: string): bool
• macroUtils: contains(items: seq[Pragma]; name: string): bool

create:

• ponairi: create[T: SomeTable](db; table: typedesc[T])
• ponairi: create(db; tables: varargs[typed])

dbValue:

• ponairi: dbValue(e: enum): DbValue
• ponairi: dbValue(b: bool): DbValue
• ponairi: dbValue(d: DateTime): DbValue
• ponairi: dbValue(t: Time): DbValue

delete:

• ponairi: delete[T: SomeTable](db; item: T)

drop:

• ponairi: drop[T: object](db; table: typedesc[T])

exists:

• ponairi: exists[T: SomeTable](db; item: T): bool

explain:

• ponairi: explain(db; query: SqlQuery): string

find:

• ponairi: find[T: SomeTable](db; table: typedesc[Option[T]]; query: SqlQuery; args): Option[ T]
• ponairi: find[T: SomeTable](db; table: typedesc[seq[T]]): seq[T]
• ponairi: find[T: SomeTable | tuple](db; table: typedesc[seq[T]]; query: SqlQuery; args): seq[ T]
• ponairi: find[T: SomeTable | tuple](db; table: typedesc[T]; query: SqlQuery; args): T
• ponairi: find[T: SomeTable | tuple](db; table: typedesc[seq[T]]): T
• ponairi: find[T: SomeTable | tuple](db; table: typedesc[seq[T]]; query: SqlQuery; args): T

getColumn:

• macroUtils: getColumn(pragma: Pragma): string

getName:

• macroUtils: getName(n: NimNode): string

getProperties:

• macroUtils: getProperties(impl: NimNode): seq[Property]

getTable:

• macroUtils: getTable(pragma: Pragma): string

hasProperty:

• macroUtils: hasProperty(obj: NimNode; property: string | NimNode): bool

index:

• pragmas: index(name = "")

initPragma:

• macroUtils: initPragma(pragmaVal: NimNode): Pragma

insert:

• ponairi: insert[T: SomeTable](db; items: openArray[T])
• ponairi: insert[T: SomeTable](db; item: T)

insertID:

• ponairi: insertID[T: SomeTable](db; item: T): int64

isOptional:

• macroUtils: isOptional(prop: Property): bool

isPrimary:

• macroUtils: isPrimary(prop: Property): bool

load:

• ponairi: load[C: SomeTable](db; child: C; field: untyped): object

lookupImpl:

• macroUtils: lookupImpl(T: NimNode): NimNode

newConn:

• ponairi: newConn(file: string): DbConn

Pragma:

• macroUtils: Pragma

primary:

• pragmas: primary()

Property:

• macroUtils: Property

references:

• pragmas: references(column: untyped)

rollback:

• ponairi: rollback(db)

SomeTable:

• ponairi: SomeTable

sqlType:

• ponairi: sqlType(T: typedesc[bool]): string
• ponairi: sqlType(T: typedesc[DateTime]): string
• ponairi: sqlType[V](T: typedesc[Option[V]]): string
• ponairi: sqlType(T: typedesc[SomeFloat]): string
• ponairi: sqlType(T: typedesc[SomeOrdinal]): string
• ponairi: sqlType(T: typedesc[string]): string
• ponairi: sqlType(T: typedesc[Time]): string

startTransaction:

• ponairi: startTransaction(db)

to:

• ponairi: to(src: DbValue; dest: var bool)
• ponairi: to(src: DbValue; dest: var DateTime)
• ponairi: to[T](src: DbValue; dest: var Option[T])
• ponairi: to(src: DbValue; dest: var string)
• ponairi: to[T: SomeOrdinal](src: DbValue; dest: var T)
• ponairi: to[T: SomeFloat](src: DbValue; dest: var T)
• ponairi: to(src: DbValue; dest: var Time)
• ponairi: to[T: SomeTable | tuple](row: Row; dest: var T)

transaction:

• ponairi: transaction(db; body: untyped)

uniqueIndex:

• pragmas: uniqueIndex(name = "")

upsert:

• ponairi: upsert(db; item: untyped; excludes: varargs[untyped])