AMA Consultng project.

• link to task document

• github repo

• Group members: Rishi Dilip, Ioanna Damianov, Krisha Dani, Madhav Nair, Naman Rusia

• Group Liason: Ayush

Tech Stack and implementaton:

• Backend: Flask (python server library)
• Database: Supabase (Easiest)
• Frontend: React.js (easiest)
• Slack Integration: Slack API + Webhooks for automated messages
• Hosting: Firebase? dont worry about it for now.

backend API endpoints:

• /users/ GET List all users
• /users/{id} GET Get user details
• /fun_facts/ GET Retrieve all fun facts
• /fun_facts/ POST Submit fun facts
• /ama/select POST Randomly selects a user
• /ama/announce POST Sends Slack message
• /ama/history GET Get past AMA details
• /admin/override POST Manually select AMA

Slack Integration;

• basic tutorial on how to create a slackbot

schema:

Users

• id (Primary Key)
• name
• email
• role (User/Admin)
• slack_id
• created_at

Fun Facts

• id (Primary Key)
• user_id (Foreign Key → Users)
• fact_text
• created_at

AMA:

• id (Primary Key)
• user_id (Foreign Key → Users)
• selected_date
• blurb
• formatted_message
• sent_status (Boolean)