7b2a904498
feat: migrate to PostgreSQL + SQLAlchemy ORM, rebrand to Nexus Autoparts
...
- Migrate from SQLite to PostgreSQL with normalized schema
- Add 11 lookup tables (fuel_type, body_type, drivetrain, transmission,
materials, position_part, manufacture_type, quality_tier, countries,
reference_type, shapes)
- Rewrite dashboard/server.py (76 routes) using SQLAlchemy text() queries
- Rewrite console/db.py (27 methods) using SQLAlchemy ORM
- Add models.py with 27 SQLAlchemy model definitions
- Add config.py for centralized DB_URL configuration
- Add migrate_to_postgres.py migration script
- Add docs/METABASE_GUIDE.md with complete data entry guide
- Rebrand from "AUTOPARTS DB" to "NEXUS AUTOPARTS"
- Fill vehicle data gaps via NHTSA API + heuristics:
engines (cylinders, power, torque), brands (country, founded_year),
models (body_type, production years), MYE (drivetrain, transmission, trim)
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com >
2026-02-19 05:24:47 +00:00
f395d67136
Initial commit: Sistema Autoparts DB
...
- Base de datos SQLite con información de vehículos
- Dashboard web con Flask y Bootstrap
- Scripts de web scraping para RockAuto
- Interfaz CLI para consultas
- Documentación completa del proyecto
Incluye:
- 12 marcas de vehículos
- 10,923 modelos
- 10,919 especificaciones de motores
- 12,075 combinaciones modelo-año-motor
2026-01-19 08:45:03 +00:00
