feat(backend): Upgrade Provider models with vehicle and specialization arrays #382

New Issue

kincses · 2026-07-01T02:32:54+02:00

kincses commented

2026-07-01 02:32:54 +02:00

Mérföldkő: P0 Provider Taxonomy & 3D Filtering
Cél: Upgrade ServiceProvider and ServiceProfile models with multi-dimensional array/JSONB columns for 3D filtering capability

🔗 Függőségek (Dependencies)

Bemenet (Mikre támaszkodik): Existing ServiceProvider, ServiceProfile SQLAlchemy models; Pydantic schemas in admin_providers.py
Kimenet (Mik támaszkodnak rá): Card 2 (Admin PATCH fix), Card 3 (Frontend Matrix UI)

📝 Feladat részletei

Modellek bővítése: Add (ARRAY of VARCHAR, e.g. 'car', 'hgv', 'van', 'motorcycle', 'agricultural') and (JSONB for brand/propulsion type arrays) to both ServiceProvider and ServiceProfile models
Alembic migráció: Generate and apply migration for the new columns
Pydantic séma frissítés: Update (and related schemas) in admin_providers.py to accept , , and
GET response: Ensure GET endpoints return these new fields

**Mérföldkő:** P0 Provider Taxonomy & 3D Filtering **Cél:** Upgrade ServiceProvider and ServiceProfile models with multi-dimensional array/JSONB columns for 3D filtering capability ### 🔗 Függőségek (Dependencies) - **Bemenet (Mikre támaszkodik):** Existing ServiceProvider, ServiceProfile SQLAlchemy models; Pydantic schemas in admin_providers.py - **Kimenet (Mik támaszkodnak rá):** Card 2 (Admin PATCH fix), Card 3 (Frontend Matrix UI) ### 📝 Feladat részletei 1. **Modellek bővítése:** Add (ARRAY of VARCHAR, e.g. 'car', 'hgv', 'van', 'motorcycle', 'agricultural') and (JSONB for brand/propulsion type arrays) to both ServiceProvider and ServiceProfile models 2. **Alembic migráció:** Generate and apply migration for the new columns 3. **Pydantic séma frissítés:** Update (and related schemas) in admin_providers.py to accept , , and 4. **GET response:** Ensure GET endpoints return these new fields

kincses added the Status: To Do Type: Model Scope: Backend Type: Feature Role: Admin Scope: Database labels 2026-07-01 02:32:54 +02:00

kincses commented

2026-07-01 02:34:17 +02:00

Javított leírás (backtick-ekkel):

Mérföldkő: P0 Provider Taxonomy & 3D Filtering
Cél: Upgrade ServiceProvider and ServiceProfile models with multi-dimensional array/JSONB columns for 3D filtering capability

🔗 Függőségek (Dependencies)

Bemenet (Mikre támaszkodik): Existing ServiceProvider, ServiceProfile SQLAlchemy models; Pydantic schemas in admin_providers.py
Kimenet (Mik támaszkodnak rá): Card 2 (Admin PATCH fix), Card 3 (Frontend Matrix UI)

📝 Feladat részletei

Modellek bővítése: Add supported_vehicle_classes (ARRAY of VARCHAR, e.g. car, hgv, van, motorcycle, agricultural) and specializations (JSONB for brand/propulsion type arrays) to both ServiceProvider and ServiceProfile models
Alembic migráció: Generate and apply migration for the new columns
Pydantic séma frissítés: Update ProviderUpdateInput (and related schemas) in admin_providers.py to accept supported_vehicle_classes: Optional[List[str]], specializations: Optional[Dict[str, List[str]]], and category_ids: Optional[List[int]]
GET response: Ensure GET endpoints return these new fields

**Javított leírás (backtick-ekkel):** **Mérföldkő:** P0 Provider Taxonomy & 3D Filtering **Cél:** Upgrade ServiceProvider and ServiceProfile models with multi-dimensional array/JSONB columns for 3D filtering capability ### 🔗 Függőségek (Dependencies) - **Bemenet (Mikre támaszkodik):** Existing ServiceProvider, ServiceProfile SQLAlchemy models; Pydantic schemas in admin_providers.py - **Kimenet (Mik támaszkodnak rá):** Card 2 (Admin PATCH fix), Card 3 (Frontend Matrix UI) ### 📝 Feladat részletei 1. **Modellek bővítése:** Add `supported_vehicle_classes` (ARRAY of VARCHAR, e.g. car, hgv, van, motorcycle, agricultural) and `specializations` (JSONB for brand/propulsion type arrays) to both ServiceProvider and ServiceProfile models 2. **Alembic migráció:** Generate and apply migration for the new columns 3. **Pydantic séma frissítés:** Update `ProviderUpdateInput` (and related schemas) in admin_providers.py to accept `supported_vehicle_classes: Optional[List[str]]`, `specializations: Optional[Dict[str, List[str]]]`, and `category_ids: Optional[List[int]]` 4. **GET response:** Ensure GET endpoints return these new fields

kincses added Status: In Progress and removed Status: To Do labels 2026-07-01 02:37:04 +02:00

kincses started working 2026-07-01 02:37:04 +02:00

kincses commented

2026-07-01 02:37:04 +02:00

▶️ Munka megkezdve: 2026-07-01 02:37:04

▶️ **Munka megkezdve:** 2026-07-01 02:37:04

kincses added Status: Done and removed Status: In Progress labels 2026-07-01 02:40:45 +02:00

kincses worked for 3 minutes

2026-07-01 02:40:45 +02:00

kincses closed this issue

2026-07-01 02:40:45 +02:00

kincses commented

2026-07-01 02:40:45 +02:00

✅ Munka befejezve: 2026-07-01 02:40:44

Technikai Összefoglaló:
P0: Backend Database Models - 3D Filtering Matrix. Added supported_vehicle_classes (ARRAY) and specializations (JSONB) to ServiceProvider and ServiceProfile ORM models. Updated Pydantic schemas (ProviderUpdateInput, ProviderDetail, ProviderQuickAddIn, ProviderUpdateIn, ProviderSearchResult) with new fields. Sync Engine: 1293 OK, 4 Fixed, 0 Extra. All 4 columns verified in database.

⏱️ Az idő rögzítve.

✅ **Munka befejezve:** 2026-07-01 02:40:44 **Technikai Összefoglaló:** P0: Backend Database Models - 3D Filtering Matrix. Added supported_vehicle_classes (ARRAY) and specializations (JSONB) to ServiceProvider and ServiceProfile ORM models. Updated Pydantic schemas (ProviderUpdateInput, ProviderDetail, ProviderQuickAddIn, ProviderUpdateIn, ProviderSearchResult) with new fields. Sync Engine: 1293 OK, 4 Fixed, 0 Extra. All 4 columns verified in database. ⏱️ *Az idő rögzítve.*

Sign in to join this conversation.

1 Participants

Notifications

Total Time Spent: 3 minutes

kincses

3 minutes

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: kincses/service-finder#382