From afc61f07e0cb9b2dea24f7602823657bbb454fe4 Mon Sep 17 00:00:00 2001 From: Julien Dessaux Date: Sun, 31 Oct 2021 00:31:45 +0200 Subject: Replaced uuid with the shorter nanoids --- src/database.nim | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) (limited to 'src/database.nim') diff --git a/src/database.nim b/src/database.nim index 37ef8b4..a696d12 100644 --- a/src/database.nim +++ b/src/database.nim @@ -1,7 +1,7 @@ import std / [options, times] import tiny_sqlite -import uuids +import nanoid import dbUtils @@ -49,7 +49,7 @@ proc Migrate*(db: DbConn): bool {.raises: [].} = type ShortUrl* = object ID*: int - Token*: UUID + Token*: string Title*: string Url*: string Created*: DateTime @@ -60,11 +60,11 @@ proc AddUrl*(db: DbConn, url: ShortUrl) {.raises: [SqliteError].} = INSERT INTO url(token, title, url, created, expires) VALUES (?, ?, ?, ?, ?); """) - stmt.exec($url.Token, url.Title, url.Url, url.Created, $url.Expires) + stmt.exec(url.Token, url.Title, url.Url, url.Created, $url.Expires) -proc GetUrl*(db: DbConn, token: UUID): ref ShortUrl {.raises: [SqliteError].} = +proc GetUrl*(db: DbConn, token: string): ref ShortUrl {.raises: [SqliteError].} = let stmt = db.stmt("SELECT id, title, url, created, expires FROM url WHERE token = ?") - for row in stmt.iterate($token): + for row in stmt.iterate(token): new(result) result.ID = row[0].fromDbValue(int) result.Token = token -- cgit v1.2.3