Simple application with authentication and CRUD functionality using the Python Flask micro-framework
The Installation instruction is referenced for web-server running on Linux.
To use this template, your computer needs:
pip2 install flask
pip2 install flask-mysqldb
pip2 install Flask-WTF
pip2 install passlib
# I set password to '1122'
sudo apt-get install mysql-server libmysqlclient-dev
mysql -u root -p
create database myflaskapp;
use myflaskapp;
create table users(username varchar(100) PRIMARY KEY, department varchar(30), password varchar(100));
create table activities(username varchar(100), activity varchar(200));
create table inform_admin(id int AUTO_INCREMENT PRIMARY KEY, operation varchar(20), activity varchar(200));
create table inform_user(id int AUTO_INCREMENT PRIMARY KEY, username varchar(100), activity varchar(200));
python2 app.pymysql -u root -p