SMslack

This project used MYSQL database and Twilio sms API to build a platform mainly for event organizers to send out notifications and announcements via SMS.

Database Setup

Master branch

Using Firebase Database
Sign up then download your certificate json file from Firebase and place it in /Firebase_cred folder.
Modify Firebase_cred.py to include your json path and database url.

MySQL_database branch

Install MYSQL for database management.

Environment Setup

Have Twilio account ready.
Install ngrok or alternative services to expose localhost.

For ngrok, use the following command in terminal to start:
$ ngrok http FLASK_RUNNING_PORT -host-header="localhost:FLASK_RUNNING_PORT"
Copy generated http link and paste it into your Twilio SMS webhook.

Usage

Enter Twilio api (account_sid and token) information and Twilio phone number in control.py
Fill in database information.
Start app at /gui/main.py

All control functions located in control.py. Modify if needed.

Database Tables

1.Announcement
2.GroupMsg
3.Participant
4.PrivateMsg
5.Project
6.Team

TODO

1.Fix possible bugs and check inputs
2.Rewrite in Express.js and React

Group Members

Haoran He
Qizhi Zhao
YanFeng Lin