How adityapathak499/e-commerce works
Project type and purpose
• This is a monolithic, backend-only Flask e-commerce application offering a REST API for user authentication, CSV data ingestion/cleaning, and summary report generation. It uses SQLAlchemy as an ORM over a local SQLite database and reads/writes CSV files on the filesystem.
File structure
• Top-level files
• app.py – single Flask application entry point
• ecommerce.db – SQLite database file
• products.csv – input data file
• summary_report.csv – output file
• requirements.txt – Python dependencies
• sql_assement_query.txt – scratch SQL queries
• No separate “frontend” directory—this is an API-only service with modules inside app.py (e.g., auth routes, data-processing routes).
README for additional insights
• Three core features/endpoints:
1. POST /signup – create users (JWT token issued)
2. POST /login – user authentication, returns JWT
3. GET /summary_report – processes products.csv, writes summary_report.csv
• Technologies called out: Flask, SQLAlchemy, SQLite, JWT, CSV processing.
Main components and their relationships
a. Components
• Client (Browser or API Consumer)
• Flask Application (app.py)
– Authentication Module (signup/login)
– Data Processing Module (CSV ingestion, cleaning)
– Reporting Module (summary generation)
• Persistence
– SQLite Database (ecommerce.db) via SQLAlchemy
• File Storage
– products.csv (input), summary_report.csv (output)
• External Libraries/Services
– JWT library for token handling
– CSV/Pandas (or Python csv) for data processing
b. Interactions / Data Flow
1. Client → HTTP POST /signup or /login → Flask Authentication Module → SQLite (create/fetch user) → JWT token → Client
2. Client → HTTP GET /summary_report (with JWT) → Flask Reporting Module →
a. Reads products.csv from FS
b. Optionally queries ecommerce.db for sales data
c. Aggregates and writes summary_report.csv to FS → Response
c. Architectural patterns
• Layered monolith:
Presentation (Flask routes) → Business Logic (modules in app.py) → Persistence (SQLite + file I/O)
• Stateless API using JWT for session management
d. Key technologies
• Python 3.x, Flask, Flask-JWT (or PyJWT), SQLAlchemy, SQLite, csv or Pandas