Function TestSyncDeleteBook

pkg/cli/cmd/sync/sync_test.go:353–576

(t *testing.T)

}

func TestSyncDeleteBook(t *testing.T) {
	t.Run("exists on server only", func(t *testing.T) {
		// set up
		db := database.InitTestMemoryDB(t)
		database.MustExec(t, "inserting b1 for test case %d", db, "INSERT INTO books (uuid, label) VALUES (?, ?)", "b1-uuid", "b1-label")

		var b1 database.Book
		database.MustScan(t, "getting b1 for test case",
			db.QueryRow("SELECT uuid, label, usn, dirty FROM books WHERE uuid = ?", "b1-uuid"),
			&b1.UUID, &b1.Label, &b1.USN, &b1.Dirty)

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

		if err := syncDeleteBook(tx, "nonexistent-book-uuid"); err != nil {
			tx.Rollback()
			t.Fatal(errors.Wrap(err, "executing").Error())
		}

		tx.Commit()

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

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

		var b1Record database.Book
		database.MustScan(t, "getting b1 for test case",
			db.QueryRow("SELECT uuid, label, usn, dirty FROM books WHERE uuid = ?", "b1-uuid"),
			&b1Record.UUID, &b1Record.Label, &b1Record.USN, &b1Record.Dirty)

		assert.Equal(t, b1Record.UUID, b1.UUID, "b1 UUID mismatch for test case")
		assert.Equal(t, b1Record.Label, b1.Label, "b1 Label mismatch for test case")
		assert.Equal(t, b1Record.USN, b1.USN, "b1 USN mismatch for test case")
		assert.Equal(t, b1Record.Dirty, b1.Dirty, "b1 Dirty mismatch for test case")
	})

	t.Run("local copy is dirty", func(t *testing.T) {
		b1UUID := testutils.MustGenerateUUID(t)

		// set up
		db := database.InitTestMemoryDB(t)

		database.MustExec(t, "inserting b1 for test case %d", db, "INSERT INTO books (uuid, label, usn, dirty) VALUES (?, ?, ?, ?)", b1UUID, "b1-label", 12, true)
		database.MustExec(t, "inserting n1 for test case %d", db, "INSERT INTO notes (uuid, book_uuid, usn, body, added_on, deleted, dirty) VALUES (?, ?, ?, ?, ?, ?, ?)", "n1-uuid", b1UUID, 10, "n1 body", 1541108743, false, true)

		var b1 database.Book
		database.MustScan(t, "getting b1 for test case",
			db.QueryRow("SELECT uuid, label, usn, dirty FROM books WHERE uuid = ?", b1UUID),
			&b1.UUID, &b1.Label, &b1.USN, &b1.Dirty)
		var n1 database.Note
		database.MustScan(t, "getting n1 for test case",