ahmido b9c47e7973 feat/006-sot-foundations-assignments (#6 )

## Summary
<!-- Kurz: Was ändert sich und warum? -->

## Spec-Driven Development (SDD)
- [ ] Es gibt eine Spec unter `specs/<NNN>-<feature>/`
- [ ] Enthaltene Dateien: `plan.md`, `tasks.md`, `spec.md`
- [ ] Spec beschreibt Verhalten/Acceptance Criteria (nicht nur Implementation)
- [ ] Wenn sich Anforderungen während der Umsetzung geändert haben: Spec/Plan/Tasks wurden aktualisiert

## Implementation
- [ ] Implementierung entspricht der Spec
- [ ] Edge cases / Fehlerfälle berücksichtigt
- [ ] Keine unbeabsichtigten Änderungen außerhalb des Scopes

## Tests
- [ ] Tests ergänzt/aktualisiert (Pest/PHPUnit)
- [ ] Relevante Tests lokal ausgeführt (`./vendor/bin/sail artisan test` oder `php artisan test`)

## Migration / Config / Ops (falls relevant)
- [ ] Migration(en) enthalten und getestet
- [ ] Rollback bedacht (rückwärts kompatibel, sichere Migration)
- [ ] Neue Env Vars dokumentiert (`.env.example` / Doku)
- [ ] Queue/cron/storage Auswirkungen geprüft

## UI (Filament/Livewire) (falls relevant)
- [ ] UI-Flows geprüft
- [ ] Screenshots/Notizen hinzugefügt

## Notes
<!-- Links, Screenshots, Follow-ups, offene Punkte -->

Co-authored-by: Ahmed Darrazi <ahmeddarrazi@adsmac.local>
Reviewed-on: #6

2025-12-25 14:25:16 +00:00

3.0 KiB

Raw Permalink Blame History

Data Model: SoT Foundations & Assignments (006)

This feature reuses existing snapshot and restore run entities, and introduces a consistent JSON “mapping + decisions” report.

Existing Entities (today)

BackupSet

Purpose: Groups a point-in-time capture for a tenant.
Relationships: hasMany BackupItem.

BackupItem

Purpose: Stores an immutable snapshot item.
Key fields (relevant):
- tenant_id, backup_set_id
- policy_id (nullable)
- policy_identifier (Graph id)
- policy_type (logical type)
- payload (raw JSON)
- metadata (normalized JSON)

RestoreRun

Purpose: Tracks restore preview/execution lifecycle.
Key fields (relevant):
- is_dry_run
- requested_items (selection)
- preview (dry-run decision report)
- results (execution report)
- metadata (extra structured info)

New / Extended Concepts (this feature)

FoundationSnapshot (logical concept)

Represented as a backup_items row.

policy_type (new keys):
- assignmentFilter
- roleScopeTag
- notificationMessageTemplate
policy_identifier: source Graph id
policy_id: null
payload: raw Graph resource JSON

metadata (proposed, shape):

{
  "displayName": "...",
  "kind": "assignmentFilter|roleScopeTag|notificationMessageTemplate",
  "graph": {
    "resource": "deviceManagement/assignmentFilters",
    "apiVersion": "v1.0"
  }
}

RestoreMappingReport (logical concept)

Stored within restore_runs.preview/restore_runs.results.

mappings.foundations[] (proposed shape):

{
  "type": "assignmentFilter",
  "sourceId": "<old-guid>",
  "sourceName": "Filter A",
  "decision": "mapped_existing|created|created_copy|failed",
  "targetId": "<new-guid>",
  "targetName": "Filter A (Copy)",
  "reason": "..."
}

AssignmentDecisionReport (logical concept)