feat: add is_disabled to chapters itself (#112)

Former-commit-id: 86a6b1564e835d6c637144bf313a9cdec2fc4207

4 files changed, 23 insertions, 21 deletions

diff --git a/backend/database/chapters.sql b/backend/database/chapters.sql
index 9538bed..f61d5bf 100644
--- a/backend/database/chapters.sql
+++ b/backend/database/chapters.sql
@@ -1,17 +1,17 @@
-INSERT INTO chapters(id, game_id, name) VALUES
-(1, 1, 'Chapter 1 - The Coutesy Call'),
-(2, 1, 'Chapter 2 - The Cold Boot'),
-(3, 1, 'Chapter 3 - The Return'),
-(4, 1, 'Chapter 4 - The Surprise'),
-(5, 1, 'Chapter 5 - The Escape'),
-(6, 1, 'Chapter 6 - The Fall'),
-(7, 1, 'Chapter 7 - The Reunion'),
-(8, 1, 'Chapter 8 - The Itch'),
-(9, 1, 'Chapter 9 - The Part Where He Kills You'),
-(10, 2, 'Course 0 - Introduction'),
-(11, 2, 'Course 1 - Team Building'),
-(12, 2, 'Course 2 - Mass And Velocity'),
-(13, 2, 'Course 3 - Hard-Light Surfaces'),
-(14, 2, 'Course 4 - Excursion Funnels'),
-(15, 2, 'Course 5 - Mobility Gels'),
-(16, 2, 'Course 6 - Art Therapy');
\ No newline at end of file
+INSERT INTO chapters(id, game_id, name, is_disabled) VALUES
+(1, 1, 'Chapter 1 - The Coutesy Call', false),
+(2, 1, 'Chapter 2 - The Cold Boot', false),
+(3, 1, 'Chapter 3 - The Return', false),
+(4, 1, 'Chapter 4 - The Surprise', false),
+(5, 1, 'Chapter 5 - The Escape', false),
+(6, 1, 'Chapter 6 - The Fall', false),
+(7, 1, 'Chapter 7 - The Reunion', false),
+(8, 1, 'Chapter 8 - The Itch', false),
+(9, 1, 'Chapter 9 - The Part Where He Kills You', false),
+(10, 2, 'Course 0 - Introduction', true),
+(11, 2, 'Course 1 - Team Building', false),
+(12, 2, 'Course 2 - Mass And Velocity', false),
+(13, 2, 'Course 3 - Hard-Light Surfaces', false),
+(14, 2, 'Course 4 - Excursion Funnels', false),
+(15, 2, 'Course 5 - Mobility Gels', false),
+(16, 2, 'Course 6 - Art Therapy', false);
\ No newline at end of file
diff --git a/backend/database/init.sql b/backend/database/init.sql
index 17a0ce5..9851ad7 100644
--- a/backend/database/init.sql
+++ b/backend/database/init.sql
@@ -23,6 +23,7 @@ CREATE TABLE chapters (
   id SERIAL,
   game_id SMALLINT NOT NULL,
   name TEXT NOT NULL,
+  is_disabled BOOLEAN NOT NULL DEFAULT false,
   PRIMARY KEY (id),
   FOREIGN KEY (game_id) REFERENCES games(id)
 );
diff --git a/backend/handlers/map.go b/backend/handlers/map.go
index d8f2ff0..8b8b9d7 100644
--- a/backend/handlers/map.go
+++ b/backend/handlers/map.go
@@ -365,7 +365,7 @@ func FetchChapters(c *gin.Context) {
                 return
         }
         var response ChaptersResponse
-        rows, err := database.DB.Query(`SELECT c.id, c.name, g.name FROM chapters c INNER JOIN games g ON c.game_id = g.id WHERE game_id = $1`, gameID)
+        rows, err := database.DB.Query(`SELECT c.id, c.name, g.name, c.is_disabled FROM chapters c INNER JOIN games g ON c.game_id = g.id WHERE game_id = $1`, gameID)
         if err != nil {
                 c.JSON(http.StatusOK, models.ErrorResponse(err.Error()))
                 return
@@ -374,7 +374,7 @@ func FetchChapters(c *gin.Context) {
         var gameName string
         for rows.Next() {
                 var chapter models.Chapter
-                if err := rows.Scan(&chapter.ID, &chapter.Name, &gameName); err != nil {
+                if err := rows.Scan(&chapter.ID, &chapter.Name, &gameName, &chapter.IsDisabled); err != nil {
                         c.JSON(http.StatusOK, models.ErrorResponse(err.Error()))
                         return
                 }
diff --git a/backend/models/models.go b/backend/models/models.go
index c380a89..3aa2e9c 100644
--- a/backend/models/models.go
+++ b/backend/models/models.go
@@ -92,8 +92,9 @@ type Game struct {
 }
 
 type Chapter struct {
-        ID   int    `json:"id"`
-        Name string `json:"name"`
+        ID         int    `json:"id"`
+        Name       string `json:"name"`
+        IsDisabled bool   `json:"is_disabled"`
 }
 
 type Category struct {