aboutsummaryrefslogtreecommitdiff
path: root/tests/database.nim
blob: 9e8de52db7d831357043b5c55e96b8ae62646fc7 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
include ../src/database

import unittest

const someTime = initDuration(seconds=1)
let testingNow = times.now() - 60 * someTime
let later = testingNow + 30 * someTime

suite "database":
  test "url":
    let db = openDatabase(":memory:")
    check db.Migrate() == true
    let u = ShortUrl(
      Token: "token",
      Title: "title",
      Url: "url",
      Created: testingNow,
      Expires: later,
    )
    db.AddUrl(u)
    try:
      db.AddUrl(u)
      check false
    except SqliteError:
      discard
    var u2 = db.GetUrl(u.Token)
    check u2.ID == 1
    check u2.Token == "token"
    check u2.Title == "title"
    check u2.Url == "url"
    check u2.Created - testingNow < someTime
    check u2.Expires - later < someTime
    db.CleanExpired()
    try:
      discard db.GetUrl("token")
    except SqliteError:
      check false
    u2.Expires = testingNow + 120 * someTime
    db.AddUrl(u2[])
    db.CleanExpired()
    check db.GetUrl("token") != nil