mirror of
https://github.com/dnote/dnote
synced 2026-03-15 15:05:51 +01:00
14b0cf623f* Implement basic full text search * Avoid lag in log while making network calls * Allow to restrict search by book name
61 lines
2.7 KiB
Go
61 lines
2.7 KiB
Go
package testutils
|
|
|
|
import (
|
|
"github.com/dnote/cli/infra"
|
|
"testing"
|
|
)
|
|
|
|
// Setup1 sets up a dnote env #1
|
|
// dnote4.json
|
|
func Setup1(t *testing.T, ctx infra.DnoteCtx) {
|
|
db := ctx.DB
|
|
|
|
b1UUID := "js-book-uuid"
|
|
b2UUID := "linux-book-uuid"
|
|
|
|
MustExec(t, "setting up book 1", db, "INSERT INTO books (uuid, label) VALUES (?, ?)", b1UUID, "js")
|
|
MustExec(t, "setting up book 2", db, "INSERT INTO books (uuid, label) VALUES (?, ?)", b2UUID, "linux")
|
|
|
|
MustExec(t, "setting up note 1", db, "INSERT INTO notes (uuid, book_uuid, body, added_on) VALUES (?, ?, ?, ?)", "43827b9a-c2b0-4c06-a290-97991c896653", b1UUID, "Booleans have toString()", 1515199943)
|
|
}
|
|
|
|
// Setup2 sets up a dnote env #2
|
|
// dnote3.json
|
|
func Setup2(t *testing.T, ctx infra.DnoteCtx) {
|
|
db := ctx.DB
|
|
|
|
b1UUID := "js-book-uuid"
|
|
b2UUID := "linux-book-uuid"
|
|
|
|
MustExec(t, "setting up book 1", db, "INSERT INTO books (uuid, label, usn) VALUES (?, ?, ?)", b1UUID, "js", 111)
|
|
MustExec(t, "setting up book 2", db, "INSERT INTO books (uuid, label, usn) VALUES (?, ?, ?)", b2UUID, "linux", 122)
|
|
|
|
MustExec(t, "setting up note 1", db, "INSERT INTO notes (uuid, book_uuid, body, added_on, usn) VALUES (?, ?, ?, ?, ?)", "f0d0fbb7-31ff-45ae-9f0f-4e429c0c797f", b1UUID, "n1 body", 1515199951, 11)
|
|
MustExec(t, "setting up note 2", db, "INSERT INTO notes (uuid, book_uuid, body, added_on, usn) VALUES (?, ?, ?, ?, ?)", "43827b9a-c2b0-4c06-a290-97991c896653", b1UUID, "n2 body", 1515199943, 12)
|
|
MustExec(t, "setting up note 3", db, "INSERT INTO notes (uuid, book_uuid, body, added_on, usn) VALUES (?, ?, ?, ?, ?)", "3e065d55-6d47-42f2-a6bf-f5844130b2d2", b2UUID, "n3 body", 1515199961, 13)
|
|
}
|
|
|
|
// Setup3 sets up a dnote env #1
|
|
// dnote1.json
|
|
func Setup3(t *testing.T, ctx infra.DnoteCtx) {
|
|
db := ctx.DB
|
|
|
|
b1UUID := "js-book-uuid"
|
|
|
|
MustExec(t, "setting up book 1", db, "INSERT INTO books (uuid, label) VALUES (?, ?)", b1UUID, "js")
|
|
|
|
MustExec(t, "setting up note 1", db, "INSERT INTO notes (uuid, book_uuid, body, added_on) VALUES (?, ?, ?, ?)", "43827b9a-c2b0-4c06-a290-97991c896653", b1UUID, "Booleans have toString()", 1515199943)
|
|
}
|
|
|
|
// Setup4 sets up a dnote env #1
|
|
// dnote2.json
|
|
func Setup4(t *testing.T, ctx infra.DnoteCtx) {
|
|
db := ctx.DB
|
|
|
|
b1UUID := "js-book-uuid"
|
|
|
|
MustExec(t, "setting up book 1", db, "INSERT INTO books (uuid, label) VALUES (?, ?)", b1UUID, "js")
|
|
|
|
MustExec(t, "setting up note 1", db, "INSERT INTO notes (rowid, uuid, book_uuid, body, added_on) VALUES (?, ?, ?, ?, ?)", 1, "43827b9a-c2b0-4c06-a290-97991c896653", b1UUID, "Booleans have toString()", 1515199943)
|
|
MustExec(t, "setting up note 2", db, "INSERT INTO notes (rowid, uuid, book_uuid, body, added_on) VALUES (?, ?, ?, ?, ?)", 2, "f0d0fbb7-31ff-45ae-9f0f-4e429c0c797f", b1UUID, "Date object implements mathematical comparisons", 1515199951)
|
|
}
|