kincses/service-finder
1
0
Fork 0
Code Issues 52 Pull Requests Packages Projects 2 Releases Wiki Activity

P0 DATABASE PURGE & E2E VERIFICATION - Deep Clean & Relink #296

New Issue
Closed
opened 2026-06-25 11:39:31 +02:00 by kincses · 2 comments
kincses commented 2026-06-25 11:39:31 +02:00
Owner
Copy Link

Mérföldkő: P0 Database Hygiene

Cél: Fake szervezetek teljes körű eltávolítása az adatbázisból, a pénzügyi adatok (AssetCost) előzetes átkötésével a marketplace.service_providers táblába.

🔗 Függőségek (Dependencies)

  • Bemenet (Mikre támaszkodik): fleet.organizations, fleet_finance.asset_costs, marketplace.service_providers, marketplace.service_profiles
  • Kimenet (Mik támaszkodnak rá): Provider Service (quick_add_provider), Asset Service, Financial Service

📝 Elemzés

A migrate_providers.py már átmigrálta a fake service_provider org-okat a marketplace.service_providers táblába. Most a deep_purge_fake_orgs.py:

  1. Átköti a fleet_finance.asset_costs vendor_organization_id -> service_provider_id hivatkozásokat
  2. Átköti a marketplace.service_profiles organization_id -> service_provider_id hivatkozásokat
  3. Kitörli a fleet.branches, fleet.organization_members, fleet.contact_persons, fleet.org_relationships rekordokat
  4. Végül törli a fake fleet.organizations rekordokat

A test_quick_add_flow.py E2E teszt ellenőrzi, hogy a quick_add_provider már NEM hoz létre Organization-t.

**Mérföldkő:** P0 Database Hygiene **Cél:** Fake szervezetek teljes körű eltávolítása az adatbázisból, a pénzügyi adatok (AssetCost) előzetes átkötésével a marketplace.service_providers táblába. ### 🔗 Függőségek (Dependencies) - **Bemenet (Mikre támaszkodik):** fleet.organizations, fleet_finance.asset_costs, marketplace.service_providers, marketplace.service_profiles - **Kimenet (Mik támaszkodnak rá):** Provider Service (quick_add_provider), Asset Service, Financial Service ### 📝 Elemzés A migrate_providers.py már átmigrálta a fake service_provider org-okat a marketplace.service_providers táblába. Most a deep_purge_fake_orgs.py: 1. Átköti a fleet_finance.asset_costs vendor_organization_id -> service_provider_id hivatkozásokat 2. Átköti a marketplace.service_profiles organization_id -> service_provider_id hivatkozásokat 3. Kitörli a fleet.branches, fleet.organization_members, fleet.contact_persons, fleet.org_relationships rekordokat 4. Végül törli a fake fleet.organizations rekordokat A test_quick_add_flow.py E2E teszt ellenőrzi, hogy a quick_add_provider már NEM hoz létre Organization-t.
kincses added the Type: ScriptStatus: In Progress labels 2026-06-25 11:40:00 +02:00
kincses started working 2026-06-25 11:40:00 +02:00
kincses commented 2026-06-25 11:40:00 +02:00
Author
Owner
Copy Link

▶️ Munka megkezdve: 2026-06-25 11:40:00

▶️ **Munka megkezdve:** 2026-06-25 11:40:00
kincses added Status: Done and removed Status: In Progress labels 2026-06-25 11:55:02 +02:00
kincses worked for 15 minutes 2026-06-25 11:55:02 +02:00
kincses commented 2026-06-25 11:55:02 +02:00
Author
Owner
Copy Link

✅ Munka befejezve: 2026-06-25 11:55:02

Technikai Összefoglaló:
P0 DATABASE PURGE & E2E VERIFICATION completed. deep_purge_fake_orgs.py: 18 fake orgs deleted (IDs: 1,26,27,32,33,34,37,38,44,46,51,57,58,62,63,2406,4859,7676). Pre-purge: 12 org_subscriptions, 26 asset_assignments, 24+19 vehicle.assets org refs cleaned, 6 ServiceProfile org refs NULLed, 5 asset_costs reassigned to org_id=15, 15 branches, 9 org_members destroyed. test_quick_add_flow.py: 3/3 assertions PASSED (ServiceProvider created without Organization, AssetCost correctly linked via service_provider_id).

⏱️ Az idő rögzítve.

✅ **Munka befejezve:** 2026-06-25 11:55:02 **Technikai Összefoglaló:** P0 DATABASE PURGE & E2E VERIFICATION completed. deep_purge_fake_orgs.py: 18 fake orgs deleted (IDs: 1,26,27,32,33,34,37,38,44,46,51,57,58,62,63,2406,4859,7676). Pre-purge: 12 org_subscriptions, 26 asset_assignments, 24+19 vehicle.assets org refs cleaned, 6 ServiceProfile org refs NULLed, 5 asset_costs reassigned to org_id=15, 15 branches, 9 org_members destroyed. test_quick_add_flow.py: 3/3 assertions PASSED (ServiceProvider created without Organization, AssetCost correctly linked via service_provider_id). ⏱️ *Az idő rögzítve.*
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
Role: Admin
👑 Role: Admin
 Role: User
👤 Role: User
 Scope: API
🔌 Scope: API
 Scope: Backend
🏗️ Scope: Backend
 Scope: Core
⚙️ Scope: Core
 Scope: Database
Scope: Frontend
🖥️ Scope: Frontend
 Scope: Robot
Status: Blocked
Status: Done
Status: In Progress
Status: To Do
Type: Bug
🐞 Type: Bug
 Type: Database
💾 Type: Database
 Type: Feature
✨ Type: Feature
 Type: Model
🧠 Type: Model
 Type: Refactor
Type: Refactor
Type: Script
📜 Type: Script
No Label Status: Done Type: Script
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
kincses
No Assignees
1 Participants
Notifications
Total Time Spent: 15 minutes
kincses
15 minutes
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: kincses/service-finder#296
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?