Function TestUpdateNote

pkg/server/app/notes_test.go:152–231

(t *testing.T)

}

func TestUpdateNote(t *testing.T) {
	testCases := []struct {
		userUSN int
	}{
		{
			userUSN: 8,
		},
		{
			userUSN: 102229,
		},
		{
			userUSN: 8099,
		},
	}

	for idx, tc := range testCases {
		t.Run(fmt.Sprintf("test case %d", idx), func(t *testing.T) {
			db := testutils.InitMemoryDB(t)

			user := testutils.SetupUserData(db, "user@test.com", "password123")
			testutils.MustExec(t, db.Model(&user).Update("max_usn", tc.userUSN), "preparing user max_usn for test case")

			anotherUser := testutils.SetupUserData(db, "another@test.com", "password123")
			testutils.MustExec(t, db.Model(&anotherUser).Update("max_usn", 55), "preparing user max_usn for test case")

			b1 := database.Book{UserID: user.ID, Label: "js", Deleted: false}
			testutils.MustExec(t, db.Save(&b1), "preparing b1 for test case")

			note := database.Note{UserID: user.ID, Deleted: false, Body: "test content", BookUUID: b1.UUID}
			testutils.MustExec(t, db.Save(&note), "preparing note for test case")

			// Assert FTS table has original content
			var ftsBodyBefore string
			testutils.MustExec(t, db.Raw("SELECT body FROM notes_fts WHERE rowid = ?", note.ID).Scan(&ftsBodyBefore), "querying notes_fts before update")
			assert.Equal(t, ftsBodyBefore, "test content", "FTS body mismatch before update")

			c := clock.NewMock()
			content := "updated test content"

			a := NewTest()
			a.DB = db
			a.Clock = c

			tx := db.Begin()
			if _, err := a.UpdateNote(tx, user, note, &UpdateNoteParams{
				Content: &content,
			}); err != nil {
				tx.Rollback()
				t.Fatal(errors.Wrap(err, "updating note"))
			}
			tx.Commit()

			var bookCount, noteCount int64
			var noteRecord database.Note
			var userRecord database.User

			testutils.MustExec(t, db.Model(&database.Book{}).Count(&bookCount), "counting book for test case")
			testutils.MustExec(t, db.Model(&database.Note{}).Count(&noteCount), "counting notes for test case")