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: "Az0f8uSeK9",
      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 == u.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(u.Token)
    except SqliteError:
      check false
    u2.Expires = testingNow + 120 * someTime
    db.AddUrl(u2[])
    db.CleanExpired()
    check db.GetUrl(u.Token) != nil