FLASKS-APP is a simple web app project using Python3, PostgreSQL, Flask, MaterializeCSS and Heroku as a cloud server.
- Basic knowledge to Programming (Python).
- Basic knowledge to RDBMS or SQL Database (MySQL, PostgreSQL).
- Basic knowledge to Web (HTML, JS, CSS).
- Download or Clone this Repository.
- Create a Python environment:
python3 -m venv venv
source venv/Scripts/activate
- Install Python requirements
pip3 install -r requirements
- Export the variable of your database url provided by Heroku Postgres:
export DATASEBASE_URL=url
- Export the flask environment and app:
export FLASK_APP=application.py
export FLASK_ENV=development
- Create Database on Heroku Postgres:
- Copy this SQL Code '
CREATE TABLE tbl_employee ( emp_id SERIAL NOT NULL, f_name VARCHAR NOT NULL, l_name VARCHAR NOT NULL, m_name VARCHAR NOT NULL, added TIMESTAMP DEFAULT CURRENT_TIMESTAMP );
CREATE TABLE tbl_users( id SERIAL NOT NULL, emp_id INTEGER NOT NULL, username VARCHAR NOT NULL, password VARCHAR NOT NULL, added TIMESTAMP DEFAULT CURRENT_TIMESTAMP );
'
- Run the App:
flask run