Function TestNoteExpunge

pkg/cli/database/models_test.go:385–445

(t *testing.T)

}

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

	n1 := Note{
		UUID:     "n1-uuid",
		BookUUID: "b9-uuid",
		Body:     "n1 body",
		AddedOn:  1542058874,
		EditedOn: 0,
		USN:      22,
		Deleted:  false,
		Dirty:    false,
	}
	n2 := Note{
		UUID:     "n2-uuid",
		BookUUID: "b10-uuid",
		Body:     "n2 body",
		AddedOn:  1542058875,
		EditedOn: 0,
		USN:      39,
		Deleted:  false,
		Dirty:    false,
	}

	MustExec(t, "inserting n1", db, "INSERT INTO notes (uuid, book_uuid, usn, added_on, edited_on, body, deleted, dirty) VALUES (?, ?, ?, ?, ?, ?, ?, ?)", n1.UUID, n1.BookUUID, n1.USN, n1.AddedOn, n1.EditedOn, n1.Body, n1.Deleted, n1.Dirty)
	MustExec(t, "inserting n2", db, "INSERT INTO notes (uuid, book_uuid, usn, added_on, edited_on, body, deleted, dirty) VALUES (?, ?, ?, ?, ?, ?, ?, ?)", n2.UUID, n2.BookUUID, n2.USN, n2.AddedOn, n2.EditedOn, n2.Body, n2.Deleted, n2.Dirty)

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

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

	tx.Commit()

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

	assert.Equalf(t, noteCount, 1, "note count mismatch")

	var n2Record Note
	MustScan(t, "getting n2",
		db.QueryRow("SELECT uuid, book_uuid, body, added_on, edited_on, usn, deleted, dirty FROM notes WHERE uuid = ?", n2.UUID),
		&n2Record.UUID, &n2Record.BookUUID, &n2Record.Body, &n2Record.AddedOn, &n2Record.EditedOn, &n2Record.USN, &n2Record.Deleted, &n2Record.Dirty)

	assert.Equal(t, n2Record.UUID, n2.UUID, "n2 uuid mismatch")
	assert.Equal(t, n2Record.BookUUID, n2.BookUUID, "n2 bookUUID mismatch")
	assert.Equal(t, n2Record.Body, n2.Body, "n2 body mismatch")
	assert.Equal(t, n2Record.AddedOn, n2.AddedOn, "n2 addedOn mismatch")
	assert.Equal(t, n2Record.EditedOn, n2.EditedOn, "n2 editedOn mismatch")
	assert.Equal(t, n2Record.USN, n2.USN, "n2 usn mismatch")