Bravisa Project

Overview

The Bravisa Project is an automated tool developed to streamline the creation of various reports, such as Bravisa Temple Tree lists (BTT List), EPS, SMR, PRS, ERS, IRS, etc. The software is designed to handle daily FB data, which can be inserted into a PostgreSQL database through the application. This data is then processed through a series of transformations that involve combining columns across different tables to generate the reports.

Key Features

• Data Insertion and Management: The tool allows users to insert daily FB data into the database and manage the data by deleting records for a specific day or a span of days.
• Report Generation: Users can generate various reports either together or separately. The reports can also be downloaded for further use.
• Data Transformation: The application automatically processes the inserted data through complex transformations to create the required reports by combining information from different tables.
• Industry Details Management: The tool includes a GUI page for adding new industry details into the database.

The project is built using Flask as the web framework, PostgreSQL as the database, and Python 3.10.9 for the backend logic. The requirements.txt file lists the dependencies required for the project, which include various libraries and tools used for tasks such as data handling, report generation, and web interface management.

Key Packages

• Flask: For building the web application and handling HTTP requests.
• PostgreSQL: For managing the database.
• Pandas: For data manipulation and transformation.
• Numpy: For mathematical and statistical calculations.

Installation and Setup

This section will guide you through the process of installing and setting up the Bravisa Project. Follow the steps below to get started.

Prerequisites

Before you begin, ensure you have the following installed on your system:

• Operating System: Windows.
• Python: Version 3.10.9 or later. Download Python.
• Package Manager: pip or conda. Ensure pip is installed with Python.
• Database: Download PgAdmin. Download PostgreSQL.

Documentation

For detailed information on how to use the Bravisa Project, refer to the Documentation folder. This folder contains various guides and manuals to help you understand and utilize the tool effectively. Navigate to the Documentation folder to access these files.

cd Documentation

Step 1: Clone the Repository

First, clone the project repository to your local machine using Git.

git clone https://github.com/AchuAshwath/BravisaProject.git
cd BravisaProject

Step 2: Create a Virtual Environment (Optional but Recommended)

It’s recommended to create a virtual environment to manage project dependencies.

python -m venv venv

Activate the virtual environment

venv\Scripts\activate

Step 3: Install Dependencies

Install the required Python packages using pip.

pip install -r requirements.txt

Step 4: Setting up the database

First install Postgres and PgAdmin, Download Postgres.

psql -h your_host -U your_username -d your_database -f create_tables.sql
# setup.ipynb includes the script to create schemas and tables
# Run this cell to create all the tables and schemas 

Start the application

python app.py 

After any changes made while development install the Bravisa.exe file using this command,

pyinstaller .\Bravisa.spec --dist-path .

all of bash commands are meant to be run in the BravisaProject/app/... - working directory of this project.