✈️ Aircraft Parts Management – Tech Exercise

This is a desktop-style full-stack application built using Flask, React, and PyWebView. The app allows users to upload Excel files containing data on aircrafts, parts, and materials, and then performs automatic correlation and allows modifications through a clean, React-based interface.

---

⚙️ Features

• 📤 Upload Excel files for:

  • Aircrafts
  • Parts
  • Materials

• 🔗 Automatic linking between aircrafts, parts, and materials

• ✏️ Modify uploaded data directly from the interface

• 📊 Display structured views for easier navigation

• 🖥️ Runs as a native-like desktop application using pywebview

• 🧠 Database interactions via SQLAlchemy

• 🧬 Alembic-based schema migrations

---

🧱 Tech Stack

Backend

• Flask
• SQLAlchemy
• Alembic
• pandas – Excel parsing
• pywebview – Desktop wrapper

Frontend

• React
• CSS / Tailwind

---

🚀 Getting Started

1. Clone the repository

git clone https://github.com/py39cptCiolacu/Python-React-Web-App.git
cd Python-React-Web-App

2. Install dependencies

pip install -r requiements.txt

3. Create and populate db

python /back/utils/populate_db.py

4. Open frontend

cd /front
npm run dev

5. Start the application

python run_application.py