Changes between Initial Version and Version 1 of UserReadsAChapter

Timestamp:

03/05/26 15:37:51 (2 weeks ago)

Author:

211099

Comment:

--

UserReadsAChapter

@@ +1 @@
+==  User Reads a Chapter
+
+=== Actor: **Guest User / Regular User / Writer**
+A user opens and reads a specific chapter of a story, and the system records the view count for that chapter.
+**1.** The user selects a chapter from the story page.
+
+**2.** The system retrieves the full chapter content.
+{{{#!sql
+SELECT chapter_id, chapter_number, chapter_name, title, 
+       content, word_count, rating, published_at, view_count
+FROM CHAPTER
+WHERE chapter_id = 1 AND story_id = 1;
+}}}
+
+**3.** The system increments the view count for that chapter.
+{{{#!sql
+UPDATE CHAPTER
+SET view_count = view_count + 1,
+    updated_at = CURRENT_TIMESTAMP
+WHERE chapter_id = 1;
+}}}
+
+**4.** The system displays navigation buttons to the previous and next chapters.
+{{{#!sql
+SELECT chapter_id, chapter_number, title
+FROM CHAPTER
+WHERE story_id = 1
+AND chapter_number IN (
+    (SELECT chapter_number - 1 FROM CHAPTER WHERE chapter_id = 1),
+    (SELECT chapter_number + 1 FROM CHAPTER WHERE chapter_id = 1)
+)
+ORDER BY chapter_number ASC;
+}}}
+
+**5.**The user finishes reading and navigates to the next chapter.