Index

API symbols

autoIncrement:

• pragmas: autoIncrement()

cascade:

• pragmas: cascade()

commit:

• ponairi: commit(db)

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

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](db; table: typedesc[seq[T]]): T
• ponairi: find[T: SomeTable | tuple](db; table: typedesc[seq[T]]; query: SqlQuery; args): T

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

load:

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

newConn:

• ponairi: newConn(file: string): DbConn

primary:

• pragmas: primary()

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[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(src: DbValue; dest: var Time)
• ponairi: to[T: SomeTable | tuple](row: Row; dest: var T)

upsert:

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