ClickBank: A Flask Banking Management System

ClickBank is a simple banking management system that allows users to create accounts, deposit, withdraw, and transfer money between accounts.ClickBank is built using Flask, a Python web framework. ClickBank uses MySQL as it's database. The web application is built using HTML, CSS, and Bootstrap.

Features of ClickBank

• Login/Register - Logout functionality
• Create/Update/Delete Customer functionality
• Create/Delete Account
• Amount Withdraw/Deposit/Transfer
• Customer/Account Status Listing page with activity
• Transaction history with excel export

Table of Contents

• Technologies Used
• Python Setup
• Git setup
• Activate Virtual Environment
• Install the required dependencies
• Setup Mysql Database
• Change Configuration file
• Create a database named banking
• Load the banking.sql file
• Running The Flask Project

Technologies Used

• Python
• Flask
• MySQL
• HTML
• CSS
• Bootstrap

Python Setup

Install Python

Git setup

Install Git

Go to a directory you want to work on

Clone the repository:

git clone [email protected]:Anoonaa/Bank-App.git

Activate Virtual Environment, help

python3 -m venv .venv
source .venv/bin/activate

Install the required dependencies.

pip install -r requirements.txt

Download all dependency if any missing:

Setup Mysql Database:

• Install MySQL Community

---

Change Configuration file:

• In ClickBank/.flaskenv change SQLALCHEMY_DATABASE_URI path with your MySQL credentials example:

  • Database name: banking
  • Username:your-username
  • Password:your-password

SQLALCHEMY_DATABASE_URI='mysql+pymysql://<user>:<password>@localhost/banking'

---

Create a database named banking

echo "CREATE DATABASE banking;" | mysql -u root -p

Load the banking.sql file:

• Creates the tables and inserts some dummy data into the tables.

mysql> USE banking;
mysql> SOURCE banking.sql;

OR

mysql -u root -p banking < banking.sql

---

Run The Flask Project

From the root directory of the project, run the following command:

• In ClickBank/

flask run

Open the browser and go to the following URL:

• http://localhost:5000/

---

Authors

• Anoona Sithole - Github / Twitter
• Tafara Nyamhunga - Github / Twitter