src/dbUtils.nim


1
2
3
4
5
6
7
8
9
10
11
12
13

import std/times
import tiny_sqlite

proc toDbValue*(t: DateTime): DbValue {.raises: [].}=
    DbValue(kind: sqliteText, strVal: $t)

proc fromDbValue*(value: DbValue, T: typedesc[DateTime]): DateTime {.raises: [].}=
  try:
    case value.kind:
      of sqliteText: return times.parse(value.strVal, "yyyy-MM-dd'T'HH:mm:sszzz")
      else: return
  except TimeParseError:
    return