summaryrefslogtreecommitdiff
path: root/view_meeting.py
diff options
context:
space:
mode:
Diffstat (limited to 'view_meeting.py')
-rw-r--r--view_meeting.py15
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)