Index

Modules: norm/model, norm/postgres, norm/pragmas, norm/private/dot, norm/private/postgres/dbtypes, norm/private/postgres/rowutils, norm/private/sqlite/dbtypes, norm/private/sqlite/rowutils, norm/sqlite, norm/types.

API symbols

`$`:

• types: `$`[_](s: PaddedStringOfCap[_]): string
• types: `$`[_](s: StringOfCap[_]): string

`==`:

• types: `==`[_](x, y: PaddedStringOfCap[_]): bool
• types: `==`[_](x, y: StringOfCap[_]): bool

col:

• model: col[T: Model](obj: T; fld: string): string
• model: col(T: typedesc[Model]; fld: string): string

cols:

• model: cols[T: Model](obj: T; force = false): seq[string]

count:

• postgres: count(dbConn; T: typedesc[Model]; col = "*"; dist = false; cond = "TRUE"; params: varargs[DbValue, dbValue]): int64
• sqlite: count(dbConn; T: typedesc[Model]; col = "*"; dist = false; cond = "1"; params: varargs[DbValue, dbValue]): int64

createTables:

• postgres: createTables[T: Model](dbConn; obj: T)
• sqlite: createTables[T: Model](dbConn; obj: T)

dbHostEnv:

• postgres: dbHostEnv
• sqlite: dbHostEnv

dbNameEnv:

• postgres: dbNameEnv

dbPassEnv:

• postgres: dbPassEnv

dbType:

• dbtypes: dbType(T: typedesc[bool]): string
• dbtypes: dbType(T: typedesc[DateTime]): string
• dbtypes: dbType(T: typedesc[float32]): string
• dbtypes: dbType(T: typedesc[float64]): string
• dbtypes: dbType(T: typedesc[int16]): string
• dbtypes: dbType(T: typedesc[int32]): string
• dbtypes: dbType(T: typedesc[int64]): string
• dbtypes: dbType(T: typedesc[Model]): string
• dbtypes: dbType[T](_: typedesc[Option[T]]): string
• dbtypes: dbType[C](_: typedesc[PaddedStringOfCap[C]]): string
• dbtypes: dbType(T: typedesc[string]): string
• dbtypes: dbType[C](_: typedesc[StringOfCap[C]]): string
• dbtypes: dbType(T: typedesc[bool]): string
• dbtypes: dbType(T: typedesc[DateTime]): string
• dbtypes: dbType(T: typedesc[DbBlob]): string
• dbtypes: dbType(T: typedesc[Model]): string
• dbtypes: dbType[T](_: typedesc[Option[T]]): string
• dbtypes: dbType[C](_: typedesc[PaddedStringOfCap[C]]): string
• dbtypes: dbType(T: typedesc[SomeFloat]): string
• dbtypes: dbType(T: typedesc[SomeInteger]): string
• dbtypes: dbType(T: typedesc[string]): string
• dbtypes: dbType[C](_: typedesc[StringOfCap[C]]): string

dbUserEnv:

• postgres: dbUserEnv

dbValue:

• dbtypes: dbValue[T: Model](val: Option[T]): DbValue
• dbtypes: dbValue[_](val: PaddedStringOfCap[_]): DbValue
• dbtypes: dbValue[_](val: StringOfCap[_]): DbValue
• dbtypes: dbValue[T: Model](val: T): DbValue
• dbtypes: dbValue(val: bool): DbValue
• dbtypes: dbValue(val: DateTime): DbValue
• dbtypes: dbValue(val: Option[bool]): DbValue
• dbtypes: dbValue(val: Option[DateTime]): DbValue
• dbtypes: dbValue[T: Model](val: Option[T]): DbValue
• dbtypes: dbValue[_](val: PaddedStringOfCap[_]): DbValue
• dbtypes: dbValue[_](val: StringOfCap[_]): DbValue
• dbtypes: dbValue[T: Model](val: T): DbValue

delete:

• postgres: delete[T: Model](dbConn; objs: var openArray[T])
• postgres: delete[T: Model](dbConn; obj: var T)
• sqlite: delete[T: Model](dbConn; objs: var openArray[T])
• sqlite: delete[T: Model](dbConn; obj: var T)

dot:

• dot: dot(obj: ref object; fld: string): untyped

dropDb:

• postgres: dropDb()
• sqlite: dropDb()

fCol:

• model: fCol[T: Model](obj: T; fld: string): string
• model: fCol[T: Model](obj: T; fld, tAls: string): string

fk:

• pragmas: fk(val: typed)

fromRow:

• rowutils: fromRow[T: Model](obj: var T; row: Row)
• rowutils: fromRow[T: Model](obj: var T; row: Row)

getDb:

• postgres: getDb(): DbConn
• sqlite: getDb(): DbConn

insert:

• postgres: insert[T: Model](dbConn; objs: var openArray[T]; force = false)
• postgres: insert[T: Model](dbConn; obj: var T; force = false)
• sqlite: insert[T: Model](dbConn; objs: var openArray[T]; force = false)
• sqlite: insert[T: Model](dbConn; obj: var T; force = false)

isModel:

• model: isModel[T: Model](val: Option[T]): bool
• model: isModel[T: Model](val: T): bool
• model: isModel[T](val: T): bool

joinGroups:

• model: joinGroups[T: Model](obj: T; flds: seq[string] = @[]): seq[ tuple[tbl, tAls, lFld, rFld: string]]

Model:

• model: Model

model:

• model: model[T: Model](val: Option[T]): Option[T]
• model: model[T: Model](val: T): Option[T]
• model: model[T](val: T): Option[Model]

newPaddedStringOfCap:

• types: newPaddedStringOfCap[C: static[int]](val = ""): PaddedStringOfCap[C]

newStringOfCap:

• types: newStringOfCap[C: static[int]](val = ""): StringOfCap[C]

NotFoundError:

• postgres: NotFoundError
• sqlite: NotFoundError

onDelete:

• pragmas: onDelete(val: string)

PaddedStringOfCap:

• types: PaddedStringOfCap

pk:

• pragmas: pk()

rfCols:

• model: rfCols[T: Model](obj: T; flds: seq[string] = @[]): seq[string]

ro:

• pragmas: ro()

rollback:

• postgres: rollback()
• sqlite: rollback()

RollbackError:

• postgres: RollbackError
• sqlite: RollbackError

select:

• postgres: select[T: Model](dbConn; objs: var seq[T]; cond: string; params: varargs[DbValue, dbValue])
• postgres: select[T: Model](dbConn; obj: var T; cond: string; params: varargs[DbValue, dbValue])
• sqlite: select[T: Model](dbConn; objs: var seq[T]; cond: string; params: varargs[DbValue, dbValue])
• sqlite: select[T: Model](dbConn; obj: var T; cond: string; params: varargs[DbValue, dbValue])

selectAll:

• postgres: selectAll[T: Model](dbConn; objs: var seq[T])
• sqlite: selectAll[T: Model](dbConn; objs: var seq[T])

StringOfCap:

• types: StringOfCap

table:

• model: table(T: typedesc[Model]): string

to:

• dbtypes: to(dbVal; T: typedesc[bool]): T:type
• dbtypes: to(dbVal; T: typedesc[DateTime]): T:type
• dbtypes: to(dbVal; T: typedesc[Model]): T:type
• dbtypes: to[T](dbVal; O: typedesc[Option[T]]): O:type
• dbtypes: to[_](dbVal; T: typedesc[PaddedStringOfCap[_]]): T:type
• dbtypes: to(dbVal; T: typedesc[SomeFloat]): T:type
• dbtypes: to(dbVal; T: typedesc[SomeInteger]): T:type
• dbtypes: to(dbVal; T: typedesc[string]): T:type
• dbtypes: to[_](dbVal; T: typedesc[StringOfCap[_]]): T:type
• dbtypes: to(dbVal; T: typedesc[bool]): T:type
• dbtypes: to(dbVal; T: typedesc[DateTime]): T:type
• dbtypes: to(dbVal; T: typedesc[DbBlob]): T:type
• dbtypes: to(dbVal; T: typedesc[Model]): T:type
• dbtypes: to[T](dbVal; O: typedesc[Option[T]]): O:type
• dbtypes: to[_](dbVal; T: typedesc[PaddedStringOfCap[_]]): T:type
• dbtypes: to(dbVal; T: typedesc[SomeFloat]): T:type
• dbtypes: to(dbVal; T: typedesc[SomeInteger]): T:type
• dbtypes: to(dbVal; T: typedesc[string]): T:type
• dbtypes: to[_](dbVal; T: typedesc[StringOfCap[_]]): T:type

toRow:

• rowutils: toRow[T: Model](obj: T; force = false): Row
• rowutils: toRow[T: Model](obj: T; force = false): Row

transaction:

• postgres: transaction(dbConn; body: untyped): untyped
• sqlite: transaction(dbConn; body: untyped): untyped

unique:

• pragmas: unique()

update:

• postgres: update[T: Model](dbConn; objs: var openArray[T])
• postgres: update[T: Model](dbConn; obj: var T)
• sqlite: update[T: Model](dbConn; objs: var openArray[T])
• sqlite: update[T: Model](dbConn; obj: var T)

withDb:

• postgres: withDb(body: untyped): untyped
• sqlite: withDb(body: untyped): untyped