Function TestFullSyncBook

pkg/cli/cmd/sync/sync_test.go:870–1058

(t *testing.T)

}

func TestFullSyncBook(t *testing.T) {
	t.Run("exists on server only", func(t *testing.T) {
		// set up
		db := database.InitTestMemoryDB(t)

		b1UUID := testutils.MustGenerateUUID(t)
		database.MustExec(t, "inserting book", db, "INSERT INTO books (uuid, usn, label, dirty, deleted) VALUES (?, ?, ?, ?, ?)", b1UUID, 555, "b1-label", true, false)

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

		b2UUID := testutils.MustGenerateUUID(t)
		b := client.SyncFragBook{
			UUID:    b2UUID,
			USN:     1,
			AddedOn: 1541108743,
			Label:   "b2-label",
			Deleted: false,
		}

		if err := fullSyncBook(tx, b); 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, 2, "book count mismatch")

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

		assert.Equal(t, b1.UUID, b1UUID, "b1 UUID mismatch")
		assert.Equal(t, b1.USN, 555, "b1 USN mismatch")
		assert.Equal(t, b1.Label, "b1-label", "b1 Label mismatch")
		assert.Equal(t, b1.Dirty, true, "b1 Dirty mismatch")
		assert.Equal(t, b1.Deleted, false, "b1 Deleted mismatch")

		assert.Equal(t, b2.UUID, b2UUID, "b2 UUID mismatch")
		assert.Equal(t, b2.USN, b.USN, "b2 USN mismatch")
		assert.Equal(t, b2.Label, b.Label, "b2 Label mismatch")
		assert.Equal(t, b2.Dirty, false, "b2 Dirty mismatch")
		assert.Equal(t, b2.Deleted, b.Deleted, "b2 Deleted mismatch")
	})