V25 — `tasks` (agregat talab, `task_type` CHECK bilan)

finalize-ep-07 yangiladi

Yangilandi: pr_url

qa-ep-07-t01-s02 statusni o'zgartirdi Review → Bajarildi

qa-ep-07-t01-s02 izoh qoldirdi

QA 2-o'tish (mustaqil mutatsiya sinovi) — O'TDI. SQL o'zgarmagan: git diff 496615d -- V25__tasks.sql BO'SH. Tuzatish faqat testda (527803f). Baseline: 34 test / 0 failure (oldingi o'tishda 23 edi). BESHALA MUTATSIYA O'LDI (har biri FOREGROUND yurgizildi, keyin git checkout bilan tiklandi): (b) V25:44 status DEFAULT 'new'->'cancelled' -> FAIL: productionTaskDefaultsApplyWhenColumnsAreOmitted — expected "new" but was "cancelled" (b2) V25:32 task_type DEFAULT 'production'->'picking' -> FAIL: o'sha test — chk_tasks_type_fields buzildi (Failing row: picking + 6 maydon to'la) (c) V25:101 production shoxidan required_qty IS NOT NULL o'chirildi -> FAIL: productionTaskMissingEachRequiredFieldIsRejected[5] (d) V25:98 production shoxidan variant_operation_id IS NOT NULL o'chirildi -> FAIL: productionTaskMissingEachRequiredFieldIsRejected[2] (e) V25:108 picking shoxidan recipe_version_id IS NULL o'chirildi -> FAIL: pickingTaskWithEachNonNullProductionFieldIsRejected[4] Omon qolgan mutatsiya YO'Q. DEFAULT testi kod darajasida tekshirildi — TAUTOLOGIYA EMAS: insertTaskWithDefaultTypeAndStatus (TasksTableMigrationTest.java:512-533) INSERT ustun ro'yxatiga task_type/status ni UMUMAN kiritmaydi (faqat 9 ta ustun: production_run_id, variant_operation_id, product_variant_id, recipe_version_id, required_qty, origin, organization_id, profession_id, created_by_user_id), keyin DB dan o'qib assert qiladi. Eski productionTaskCanBeInsertedWithDefaults endi faqat qty_claimed/qty_confirmed DEFAULT 0 ni tekshiradi. FP-18 QAMROVI: 12/12 holat (surefire nomlaridan sanaldi). production shoxi 6/6 — productionTaskMissingEachRequiredFieldIsRejected[1..6]: production_run_id, variant_operation_id, product_variant_id, recipe_version_id, required_qty, profession_id (har birida qolgan 5 tasi to'g'ri to'ldirilgan). picking shoxi 6/6 — pickingTaskWithEachNonNullProductionFieldIsRejected[1..6]: o'sha 6 maydon (har birida bittasi to'ldirilgan, qolgani NULL). Qo'shimcha: pickingTaskWithoutOrderIdIsRejected (order_id NOT NULL), pickingTaskWithNonOrderOriginIsRejected (origin='order'), ikkala shox uchun ijobiy holat. Qolgan mezonlar (green test bilan): 3172 negativeQtyClaimed/ConfirmedIsRejectedByCheckConstraint + numericColumnsHaveSpecifiedPrecision (numeric(18,4)); 3173 orderIdColumnHasNoForeignKeyConstraint; 3174 requiredIndexesExist. Cross-cutting: tenant_id yo'q (AR-1) ✓; katalog FK'lari oddiy FK (AR-10) ✓; snake_case + ko'plik ✓; qty numeric(18,4) ✓; fizik DELETE yo'q ✓. Yakuniy holat: 34/34 yashil, git diff 496615d -- V25__tasks.sql bo'sh, ishchi daraxt toza (faqat begona staged openapi/v1/tasks.yaml). Eslatma: yugurish davomida src/main/java/uz/erpbom/tasks/entity/Work.java da begona mutatsiya (brak_loss_snapshot_qa_mutant) ko'rindi — parallel EP-07-T01-S06 QA'siniki, TEGILMADI, o'zi tiklandi; mening natijalarimga ta'sir qilmadi (har yugurishda aynan kutilgan bitta failure).

qa-ep-07-t01-s02 qabul mezonini belgiladi

✓ Indekslar: `production_run_id`, `profession_id`, `status`, `organization_id`, `variant_operation_id`

qa-ep-07-t01-s02 qabul mezonini belgiladi

✓ `order_id` — FK'SIZ `bigint` (V24 bilan bir xil sabab, izoh yozilgan)

qa-ep-07-t01-s02 qabul mezonini belgiladi

✓ `qty_claimed`/`qty_confirmed` `numeric(18,4) NOT NULL DEFAULT 0` + `CHECK (qty_claimed >= 0 AND qty_confirmed >= 0)`

qa-ep-07-t01-s02 qabul mezonini belgiladi

✓ CHECK (picking): o'sha oltita maydon NULL va `order_id` NOT NULL va `origin = 'order'`

qa-ep-07-t01-s02 qabul mezonini belgiladi

✓ CHECK (production): `production_run_id`, `variant_operation_id`, `product_variant_id`, `recipe_version_id`, `required_qty`, `profession_id` — NOT NULL

qa-ep-07-t01-s02 qabul mezonini belgiladi

✓ `status` CHECK: `new` | `in_progress` | `completed` | `cancelled`, default `new`

qa-ep-07-t01-s02 qabul mezonini belgiladi

✓ `task_type` CHECK: `production` | `picking`, default `production`

coder-ep-07-t01-s02 yangiladi

Yangilandi: commit_sha

coder-ep-07-t01-s02 fayllarni qayd etdi

1 ta fayl qayd etildi

coder-ep-07-t01-s02 statusni o'zgartirdi Ishlanyapti → Review

coder-ep-07-t01-s02 qabul mezonini belgiladi

✓ CHECK (picking): o'sha oltita maydon NULL va `order_id` NOT NULL va `origin = 'order'`

coder-ep-07-t01-s02 qabul mezonini belgiladi

✓ CHECK (production): `production_run_id`, `variant_operation_id`, `product_variant_id`, `recipe_version_id`, `required_qty`, `profession_id` — NOT NULL

coder-ep-07-t01-s02 qabul mezonini belgiladi

✓ `status` CHECK: `new` | `in_progress` | `completed` | `cancelled`, default `new`

coder-ep-07-t01-s02 qabul mezonini belgiladi

✓ `task_type` CHECK: `production` | `picking`, default `production`

qa-ep-07-t01-s02 statusni o'zgartirdi Review → Ishlanyapti

qa-ep-07-t01-s02 izoh qoldirdi

QA (qa-EP-07-T01-S02) — QAYTARILDI: migratsiya MAZMUNI to'g'ri, TEST QAMROVI defektli (mutatsiya bilan isbotlangan). MIGRATSIYA — o'tdi. V25__tasks.sql qo'lda o'qildi: task_type CHECK (:77-78) + DEFAULT 'production' (:32); status CHECK (:79-80) + DEFAULT 'new' (:44); origin CHECK (:81-82) — hammasi openapi/v1/tasks.yaml enum'lari (TaskType :1314, TaskStatus :1297, TaskOrigin :1280) bilan AYNAN mos. FP-18 chk_tasks_type_fields (:94-113) mantiqan TO'LIQ: production shoxida 6 maydon IS NOT NULL, picking shoxida o'sha 6 maydon IS NULL + order_id IS NOT NULL + origin='order'. Kamchilik topilmadi. Baseline: 23/23 yashil. DEFEKT 1 (mezon 3170) — TasksTableMigrationTest.java:188 productionTaskMissingRequiredFieldIsRejected 6 maydondan FAQAT profession_id ni sinaydi. Qamralmagan 5 holat: production_run_id / variant_operation_id / product_variant_id / recipe_version_id / required_qty NULL. ISBOT: V25:101 dan 'AND required_qty IS NOT NULL' olib tashlandi -> 23/23 YASHIL (mutatsiya OMON QOLDI). Kutilgan: yiqilish. DEFEKT 2 (mezon 3171) — TasksTableMigrationTest.java:212 pickingTaskWithNonNullProductionFieldIsRejected 6 maydondan FAQAT product_variant_id ni sinaydi. Qamralmagan 5 holat: production_run_id / variant_operation_id / recipe_version_id / required_qty / profession_id NOT NULL bo'lganda. (order_id NULL :226 va origin!='order' :239 — QAMRALGAN: picking shoxidan origin='order' olib tashlanganda pickingTaskWithNonOrderOriginIsRejected YIQILDI.) DEFEKT 3 (mezonlar 3168, 3169) — TasksTableMigrationTest.java:91 productionTaskCanBeInsertedWithDefaults TAUTOLOGIK: insertTaskRaw (:463) task_type va status ni HAR DOIM INSERT ustunlar ro'yxatiga qo'shadi, test esa o'zi yozgan qiymatni o'qib tasdiqlaydi (:104-105). DEFAULT'lar umuman sinalmagan. ISBOT: V25:44 DEFAULT 'new' -> DEFAULT 'cancelled' -> 23/23 YASHIL (mutatsiya OMON QOLDI). task_type DEFAULT ham xuddi shu sababdan sinalmagan. Tuzatish: task_type/status ustunlarini INSERT ro'yxatiga QO'SHMAYDIGAN alohida test yozilsin (qty_claimed/qty_confirmed uchun to'g'ri qo'llangan naqsh) va DB qaytargan qiymat 'production'/'new' ekani tasdiqlansin. O'TGAN MEZONLAR: 3172 (numeric(18,4) NOT NULL DEFAULT 0 :41-43 + CHECK>=0 :83-86; testlar :263 :291 :417 — haqiqiy assert'lar), 3173 (order_id FK'siz bigint :51 + sabab izohi :21-26 :48-50; test :388 information_schema orqali), 3174 (5 ta talab qilingan indeks :119-126; test :401 pg_indexes orqali). FK maqsadlari mustaqil tasdiqlandi: production_runs(V24) product_variants(V9) variant_operations(V10) recipe_versions(V10) professions(V19) organizations(V2) users(V4) — hammasi bigint identity PK. Mutatsiyalardan keyin V25__tasks.sql TIKLANDI — 496615d bilan bayt-ma-bayt bir xil (md5 db894b520c61bb7b5e2f9fb8a2b0da1e), git status toza. Kodga o'zgartirish kiritilmadi.

qa-ep-07-t01-s02 qabul mezonini belgiladi

✗ CHECK (picking): o'sha oltita maydon NULL va `order_id` NOT NULL va `origin = 'order'`

qa-ep-07-t01-s02 qabul mezonini belgiladi

✗ CHECK (production): `production_run_id`, `variant_operation_id`, `product_variant_id`, `recipe_version_id`, `required_qty`, `profession_id` — NOT NULL

qa-ep-07-t01-s02 qabul mezonini belgiladi

✗ `status` CHECK: `new` | `in_progress` | `completed` | `cancelled`, default `new`

qa-ep-07-t01-s02 qabul mezonini belgiladi

✗ `task_type` CHECK: `production` | `picking`, default `production`

qa-ep-07-t01-s02 qabul mezonini belgiladi

✓ Indekslar: `production_run_id`, `profession_id`, `status`, `organization_id`, `variant_operation_id`

qa-ep-07-t01-s02 qabul mezonini belgiladi

✓ `order_id` — FK'SIZ `bigint` (V24 bilan bir xil sabab, izoh yozilgan)

qa-ep-07-t01-s02 qabul mezonini belgiladi

✓ `qty_claimed`/`qty_confirmed` `numeric(18,4) NOT NULL DEFAULT 0` + `CHECK (qty_claimed >= 0 AND qty_confirmed >= 0)`

coder-ep-07-t01-s02 izoh qoldirdi

Ish yakunlangan: test 23/23 yashil (Testcontainers PG16), criteria 7/7 met, commit 496615d (faqat V25__tasks.sql + TasksTableMigrationTest.java, pathspec bilan tekshirilgan), status=review. Background+Monitor orqali natija shu sessiyada foreground-ekvivalent olindi, navbat tashlab ketilmadi.

coder-ep-07-t01-s02 statusni o'zgartirdi Ishlanyapti → Review

coder-ep-07-t01-s02 yangiladi

Yangilandi: branch, commit_sha

coder-ep-07-t01-s02 qabul mezonini belgiladi

✓ Indekslar: `production_run_id`, `profession_id`, `status`, `organization_id`, `variant_operation_id`

coder-ep-07-t01-s02 qabul mezonini belgiladi

✓ `order_id` — FK'SIZ `bigint` (V24 bilan bir xil sabab, izoh yozilgan)

coder-ep-07-t01-s02 qabul mezonini belgiladi

✓ `qty_claimed`/`qty_confirmed` `numeric(18,4) NOT NULL DEFAULT 0` + `CHECK (qty_claimed >= 0 AND qty_confirmed >= 0)`

coder-ep-07-t01-s02 qabul mezonini belgiladi

✓ CHECK (picking): o'sha oltita maydon NULL va `order_id` NOT NULL va `origin = 'order'`

coder-ep-07-t01-s02 qabul mezonini belgiladi

✓ CHECK (production): `production_run_id`, `variant_operation_id`, `product_variant_id`, `recipe_version_id`, `required_qty`, `profession_id` — NOT NULL

coder-ep-07-t01-s02 qabul mezonini belgiladi

✓ `status` CHECK: `new` | `in_progress` | `completed` | `cancelled`, default `new`

coder-ep-07-t01-s02 qabul mezonini belgiladi

✓ `task_type` CHECK: `production` | `picking`, default `production`

coder-ep-07-t01-s02 fayllarni qayd etdi

2 ta fayl qayd etildi

coder-ep-07-t01-s02 statusni o'zgartirdi Backlog → Ishlanyapti

Agent ishni boshladi

coder-ep-07-t01-s02 ishga oldi

pm-agent yaratdi

V25 — `tasks` (agregat talab, `task_type` CHECK bilan)