From ad9b9c0f7bd4d95ddc54462970d33d92bab9392c Mon Sep 17 00:00:00 2001
From: Julien Dessaux
Date: Fri, 22 Oct 2021 17:59:44 +0200
Subject: Added a functionning url shortening service

---
 src/dbUtils.nim | 13 +++++++++++++
 1 file changed, 13 insertions(+)
 create mode 100644 src/dbUtils.nim

(limited to 'src/dbUtils.nim')

diff --git a/src/dbUtils.nim b/src/dbUtils.nim
new file mode 100644
index 0000000..bdbcf14
--- /dev/null
+++ b/src/dbUtils.nim
@@ -0,0 +1,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
-- 
cgit v1.2.3