Kategoriya daraxti + brend CRUD

finalize-ep-02 yangiladi

Yangilandi: commit_sha

qa-ep-02-t02-s01 izoh qoldirdi

QA PASS (qa-EP-02-T02-S01). Tekshirildi: spec 02_products.md#2.1/#2.2, qoida 28/57, openapi/v1/products.yaml (ProductCategories/Brands taglari) - kod/kontrakt/migratsiya (V8) so'zma-so'z mos. Testlar: flock ostida `mvn -Dtest=ProductCategoryControllerIntegrationTest,BrandControllerIntegrationTest test` - 30/30 yashil (Testcontainers, haqiqiy Postgres 16). Har mezon o'zim tekshirdim: - AC1004: daraja-3 POST -> 409 CATEGORY_DEPTH_INVALID (test + tahlil). Trigger (product_categories_enforce_max_depth, V8) + servis pre-check ikki qatlam. - AC1005: bir xil nom bir ota ostida -> 409 duplicate; turli ota ostida -> ikkalasi ham 201 (ikkala holat ham testda bor). - AC1006: duplikat brend -> 409 DUPLICATE_DICTIONARY_VALUE, message mavjud qatorning nomini o'z ichiga oladi ("Bunday qiymat allaqachon bor: <nom>") - kontraktning o'zida (T00, DuplicateDictionaryValue response example) "havola" aynan shu shaklda belgilangan, alohida id/link maydoni talab qilinmagan. - AC1007: DELETE /brands/{id} yo'q (kontraktda ataylab yo'q) -> 405 METHOD_NOT_ALLOWED; DB darajasida fk_products_brand RESTRICT ham alohida testda tasdiqlangan (real DELETE SQL orqali). MUTATSIYA TEKSHIRUVI (kod vaqtincha buzilib, keyin git checkout bilan qaytarildi): - ProductCategoryService.create() dagi requireLevelOne() o'chirilganda -> AC1004 testi aniq yiqildi. Test ishonchli. - BrandService.requireNoDuplicate() bo'shatilganda -> AC1006 testlaridan 2 tasi yiqildi (message assertion). Test ishonchli. Ikkalasi ham asl holatiga qaytarildi, keyingi to'liq test run 30/30 yashil. Cross-cutting (8 band) - hammasi OK: @Transactional (list/get readOnly, create/update yozuv); single-tenant (tenant_id yo'q); FK haqiqiy (parent_id/brand_id/product_category_id bigint FK, varchar kod emas); async/outbox N/A (bu taskda yo'q); nomlash snake_case+ko'plik+to'liq FK nomlari; precision N/A; soft-delete: spec ataylab active/deleted_at yo'q deb belgilagan (product_categories) - DELETE endpoint umuman yo'q (kontrakt qarori), brands active flag CROSS_CUTTING H ga mos; parol/audit N/A. product_dictionary.manage/product.view - haqiqiy ro'yxatdan o'tgan permission_code (R__permissions_and_currencies_seed.sql), @RequirePermission real HTTP 401/403 bilan tasdiqlangan. Kichik kuzatuv (bloklamayapti, done): ProductCategoryService#saveOrThrowDuplicate DataIntegrityViolationException'ni har doim DUPLICATE_DICTIONARY_VALUE deb talqin qiladi. Juda tor concurrent holatda (bitta so'rov mavjud tugunni descendant qilib reparent qilayotganda, boshqa so'rov aynan o'sha tugun ostida bola yaratsa) DB trigger'ining check_violation'i ham shu yo'l bilan noto'g'ri DUPLICATE_DICTIONARY_VALUE deb qaytishi mumkin (aslida CATEGORY_DEPTH_INVALID kerak edi) - baribir 409 qaytadi, ma'lumot buzilmaydi, faqat kod/xabar noaniq bo'ladi. Follow-up: SQLState (23505 vs 23514) farqlash tavsiya etiladi, lekin AC/kontrakt/testlarni buzmaydi.

qa-ep-02-t02-s01 statusni o'zgartirdi Review → Bajarildi

qa-ep-02-t02-s01 qabul mezonini belgiladi

✓ "Umumiy" brendni o'chirishga urinish rad etiladi (RESTRICT)

qa-ep-02-t02-s01 qabul mezonini belgiladi

✓ Bir xil nomli brend ikkinchi marta → `409 duplicate_dictionary_value` + mavjud qator havolasi

qa-ep-02-t02-s01 qabul mezonini belgiladi

✓ Bir xil nomli sub-kategoriya turli ota ostida yaratiladi (ruxsat, qoida 28 istisnosi)

qa-ep-02-t02-s01 qabul mezonini belgiladi

✓ Daraja-3 tugun yaratishga POST → 400/409 aniq xabar bilan

coder-ep-02-t02-s01 statusni o'zgartirdi Ishlanyapti → Review

coder-ep-02-t02-s01 yangiladi

Yangilandi: branch, commit_sha

coder-ep-02-t02-s01 qabul mezonini belgiladi

✓ "Umumiy" brendni o'chirishga urinish rad etiladi (RESTRICT)

coder-ep-02-t02-s01 qabul mezonini belgiladi

✓ Bir xil nomli brend ikkinchi marta → `409 duplicate_dictionary_value` + mavjud qator havolasi

coder-ep-02-t02-s01 qabul mezonini belgiladi

✓ Bir xil nomli sub-kategoriya turli ota ostida yaratiladi (ruxsat, qoida 28 istisnosi)

coder-ep-02-t02-s01 qabul mezonini belgiladi

✓ Daraja-3 tugun yaratishga POST → 400/409 aniq xabar bilan

coder-ep-02-t02-s01 fayllarni qayd etdi

18 ta fayl qayd etildi

coder-ep-02-t02-s01 statusni o'zgartirdi Backlog → Ishlanyapti

Agent ishni boshladi

coder-ep-02-t02-s01 ishga oldi

pm-agent yangiladi

Yangilandi: estimate_hours

pm-agent yaratdi

Kategoriya daraxti + brend CRUD