Function TestBookExpunge

pkg/cli/database/models_test.go:715–766

(t *testing.T)

}

func TestBookExpunge(t *testing.T) {
	// Setup
	db := InitTestMemoryDB(t)

	b1 := Book{
		UUID:    "b1-uuid",
		Label:   "b1-label",
		USN:     1,
		Deleted: true,
		Dirty:   false,
	}
	b2 := Book{
		UUID:    "b2-uuid",
		Label:   "b2-label",
		USN:     1,
		Deleted: true,
		Dirty:   false,
	}

	MustExec(t, "inserting b1", db, "INSERT INTO books (uuid, label, usn, deleted, dirty) VALUES (?, ?, ?, ?, ?)", b1.UUID, b1.Label, b1.USN, b1.Deleted, b1.Dirty)
	MustExec(t, "inserting b2", db, "INSERT INTO books (uuid, label, usn, deleted, dirty) VALUES (?, ?, ?, ?, ?)", b2.UUID, b2.Label, b2.USN, b2.Deleted, b2.Dirty)

	// execute
	tx, err := db.Begin()
	if err != nil {
		t.Fatal(errors.Wrap(err, "beginning a transaction").Error())
	}

	if err := b1.Expunge(tx); err != nil {
		tx.Rollback()
		t.Fatal(errors.Wrap(err, "executing").Error())
	}

	tx.Commit()

	// test
	var bookCount int
	MustScan(t, "counting books", db.QueryRow("SELECT count(*) FROM books"), &bookCount)

	assert.Equalf(t, bookCount, 1, "book count mismatch")

	var b2Record Book
	MustScan(t, "getting b2",
		db.QueryRow("SELECT uuid, label, usn, deleted, dirty FROM books WHERE uuid = ?", "b2-uuid"),
		&b2Record.UUID, &b2Record.Label, &b2Record.USN, &b2Record.Deleted, &b2Record.Dirty)

	assert.Equal(t, b2Record.UUID, b2.UUID, "b2 uuid mismatch")
	assert.Equal(t, b2Record.Label, b2.Label, "b2 label mismatch")
	assert.Equal(t, b2Record.USN, b2.USN, "b2 usn mismatch")
	assert.Equal(t, b2Record.Deleted, b2.Deleted, "b2 deleted mismatch")
	assert.Equal(t, b2Record.Dirty, b2.Dirty, "b2 dirty mismatch")
}

// TestNoteFTS tests that note full text search indices stay in sync with the notes after insert, update and delete
func TestNoteFTS(t *testing.T) {