Function TestUpdateNote_SameContent

pkg/server/app/notes_test.go:233–268

(t *testing.T)

}

func TestUpdateNote_SameContent(t *testing.T) {
	db := testutils.InitMemoryDB(t)

	user := testutils.SetupUserData(db, "user@test.com", "password123")
	b1 := database.Book{UserID: user.ID, Label: "testBook"}
	testutils.MustExec(t, db.Save(&b1), "preparing book")

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

	a := NewTest()
	a.DB = db
	a.Clock = clock.NewMock()

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

	// Assert FTS still has the same content
	var ftsBody string
	testutils.MustExec(t, db.Raw("SELECT body FROM notes_fts WHERE rowid = ?", note.ID).Scan(&ftsBody), "querying notes_fts after update")
	assert.Equal(t, ftsBody, "test content", "FTS body should still be 'test content'")

	// Assert it's still searchable
	var searchCount int64
	testutils.MustExec(t, db.Raw("SELECT COUNT(*) FROM notes_fts WHERE notes_fts MATCH ?", "test").Scan(&searchCount), "searching notes_fts")
	assert.Equal(t, searchCount, int64(1), "Note should still be searchable")
}

func TestDeleteNote(t *testing.T) {
	testCases := []struct {