add tracking participants and prevent duplicates

1 files changed, 12 insertions, 3 deletions

diff --git a/view_meeting.py b/view_meeting.py
index 00f6ae4..5ec8dd0 100644
--- a/view_meeting.py
+++ b/view_meeting.py
@@ -17,12 +17,21 @@ meeting_id = "meet1"
 
 
 def extract_meeting(meeting_id):
+    # Data from meeting table
     select = cur.execute(f"SELECT * FROM meeting WHERE meeting_id = ?;", (meeting_id,))
-    result = select.fetchall()
-    print(result)
+    result = select.fetchone()
+    meeting_data = {"meeting_id": meeting_id, "title": result[1],
+                    "description": result[2],
+                    "dates": result[3].split(",") if not result[3] is None else "",
+                    "participants": result[4].split(",") if not result[4] is None else ""}
+
+    # Individual dates data
     select = cur.execute(f"SELECT * FROM meeting_dates_{meeting_id};")
     result = select.fetchall()
     print(result)
 
+    return meeting_data
+
 
-extract_meeting(meeting_id)
+meeting_data = extract_meeting(meeting_id)
+print(meeting_data)