Function TestMergeBook

pkg/cli/cmd/sync/sync_test.go:1463–1793

(t *testing.T)

}

func TestMergeBook(t *testing.T) {
	t.Run("insert, no duplicates", func(t *testing.T) {
		// set up
		db := database.InitTestMemoryDB(t)

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

		b1 := client.SyncFragBook{
			UUID:    "b1-uuid",
			USN:     12,
			AddedOn: 1541108743,
			Label:   "b1-label",
			Deleted: false,
		}

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

		tx.Commit()

		// execute
		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",
			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")
		assert.Equal(t, b1Record.Label, b1.Label, "b1 Label mismatch")
		assert.Equal(t, b1Record.USN, b1.USN, "b1 USN mismatch")
	})

	t.Run("insert, 1 duplicate", func(t *testing.T) {
		// set up
		db := database.InitTestMemoryDB(t)
		database.MustExec(t, "inserting book", db, "INSERT INTO books (uuid, usn, label, dirty, deleted) VALUES (?, ?, ?, ?, ?)", "b1-uuid", 1, "foo", false, false)

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

		b := client.SyncFragBook{
			UUID:    "b2-uuid",
			USN:     12,