[PROD-008] .NET idempotency rerun E2E and Docker PostgreSQL validation

[ktalpay]

Task ID: PROD-008
Lane: dotnet
Status: merged
Agent: dotnet-agent
Depends on: PROD-007

Goal:
Validate and harden the .NET runtime path with Docker PostgreSQL E2E behavior for schema bootstrap, source-cycle parsing, source-specific master/detail insert, idempotent rerun, and year-state update.

Scope:

• Use the .NET config/redaction boundary.
• Use .NET PostgreSQL schema bootstrap/year-state baseline.
• Use .NET source-cycle orchestration.
• Use .NET source-specific master/detail insert runtime.
• Add opt-in Docker PostgreSQL integration tests or smoke commands.
• Prove duplicate reruns do not duplicate master/detail rows.
• Prove year-state advances only after successful persistence.
• Prove safe no-op/no_available_source_year behavior where applicable.

Non-goals:

• No final project production-ready claim.
• No Python runtime changes.
• No uncontrolled live network calls.
• No production credentials.
• No destructive DB operations.

Acceptance:

• Docker PostgreSQL E2E path exists and is opt-in.
• Schema bootstrap succeeds idempotently.
• One configured local artifact source-family insert succeeds.
• Rerun skips duplicates explicitly.
• Year-state progression is verified.
• Diagnostics redact secrets.
• No generated artifacts.

Task-ID: PROD-008

[github-actions]

Agent Task Watcher updated task status.

Detected task: PROD-008
Merged PR: #629
Task issue status: status:missing -> status:merged

Downstream task update summary:

No dependent tasks were declared in Unblocks:.