PROF-ELECT-WS101

QueSys

QueSysIt is a simple Python Web Based Queueing App using Flask Framework and MaterializeCSS as Front End that works on Raspberry Pi 3 B+.

Prerequisite:

• Basic knowledge to Programming (Python).
• Basic knowledge of MySQL databases.
• Basic knowledge of Electronics.

Requirement:

Installation:

1. Install all Python3 Libraries: sudo pip3 install -r requirements.txt Windows pip install mysqlclient-1.4.4-cp38-cp38-win_amd64.whlLink: (https://sourceforge.net/projects/sox/files/sox/14.4.2/)
2. Linux: apt install python3-mysqldb mariadb-server python3-flask sox
3. Login to MariaDB Console: sudo mysql -u root
4. Create Login Credentials on MariaDB: DROP USER 'root'@'localhost'; CREATE USER 'root'@'localhost' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost'
5. Create a database: CREATE DATABASE db_queuinguser db_queuing;
6. Import the SQL File: source db_queuing.sql
7. Run the App: sudo python3 main.py