Function TestFullSyncNote

pkg/cli/cmd/sync/sync_test.go:578–868

(t *testing.T)

}

func TestFullSyncNote(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, label) VALUES (?, ?)", b1UUID, "b1-label")

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

		n := client.SyncFragNote{
			UUID:     "n1-uuid",
			BookUUID: b1UUID,
			USN:      128,
			AddedOn:  1541232118,
			EditedOn: 1541219321,
			Body:     "n1-body",
			Deleted:  false,
		}

		if err := fullSyncNote(tx, n); 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, 1, "note count mismatch")
		assert.Equalf(t, bookCount, 1, "book count mismatch")

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

		assert.Equal(t, n1.UUID, n.UUID, "n1 UUID mismatch")
		assert.Equal(t, n1.BookUUID, n.BookUUID, "n1 BookUUID mismatch")
		assert.Equal(t, n1.USN, n.USN, "n1 USN mismatch")
		assert.Equal(t, n1.AddedOn, n.AddedOn, "n1 AddedOn mismatch")
		assert.Equal(t, n1.EditedOn, n.EditedOn, "n1 EditedOn mismatch")
		assert.Equal(t, n1.Body, n.Body, "n1 Body mismatch")
		assert.Equal(t, n1.Deleted, n.Deleted, "n1 Deleted mismatch")
		assert.Equal(t, n1.Dirty, false, "n1 Dirty mismatch")
	})

	t.Run("exists on server and client", func(t *testing.T) {
		b1UUID := testutils.MustGenerateUUID(t)
		b2UUID := testutils.MustGenerateUUID(t)
		conflictBookUUID := testutils.MustGenerateUUID(t)