Base de donnees

Persistance via EF Core 10 + PostgreSQL.

Contexte EF

• AppDbContext: AdvancedDevSample.Infrastructure/Persistence/AppDbContext.cs
• provider principal: UseNpgsql(...)
• repli possible: base in-memory (UseInMemoryDatabase)

Tables principales

• Products
• Categories
• PriceHistories
• Users
• RefreshTokens
• AuditLogs

Schema relationnel simplifie

erDiagram
  CATEGORIES ||--o{ PRODUCTS : contient
  PRODUCTS ||--o{ PRICE_HISTORIES : historise
  USERS ||--o{ REFRESH_TOKENS : possede
  USERS ||--o{ AUDIT_LOGS : genere

  CATEGORIES {
    guid Id PK
    string Name
    bool IsActive
  }
  PRODUCTS {
    guid Id PK
    string Name
    string Sku UK
    decimal Price
    guid CategoryId FK
    bool IsActive
  }
  PRICE_HISTORIES {
    guid Id PK
    guid ProductId FK
    decimal OldPrice
    decimal NewPrice
    datetime ChangedAt
  }
  USERS {
    guid Id PK
    string Email UK
    string PasswordHash
    string Role
    bool IsActive
  }
  REFRESH_TOKENS {
    guid Id PK
    string Token UK
    guid UserId FK
    datetime ExpiresAt
    datetime RevokedAt
  }
  AUDIT_LOGS {
    guid Id PK
    guid UserId FK
    string Action
    datetime CreatedAt
  }

Contraintes

• Products.Sku unique (si non null)
• Users.Email unique
• RefreshTokens.Token unique (stocke la version hashee du refresh token)
• precision prix 18,2
• precision remise 5,2

Relations

• Product -> Category (SetNull)
• PriceHistory -> Product (Cascade)
• RefreshToken -> User (Cascade)
• AuditLog -> User (FK nullable selon type d'evenement)

Migrations

Dossier:

• AdvancedDevSample.Infrastructure/Persistence/Migrations

Comportement au demarrage:

• UseMigrations=true + migrations presentes -> Migrate()
• sans migration en Development -> EnsureCreated()
• sans migration hors Development -> erreur de demarrage

flowchart TD
  BOOT[Demarrage API] --> CHECK{Migrations presentes?}
  CHECK -->|Oui et UseMigrations=true| APPLY[Migrate()]
  CHECK -->|Non| ENV{Environnement Development?}
  ENV -->|Oui| CREATE[EnsureCreated()]
  ENV -->|Non| FAIL[Arret: migration manquante]

Seeding (Development)

Ordre:

1. AdminUserSeeder
2. CategorySeeder
3. ProductSeeder
4. PriceHistorySeeder

flowchart LR
  A[AdminUserSeeder] --> B[CategorySeeder]
  B --> C[ProductSeeder]
  C --> D[PriceHistorySeeder]

Details:

• admin cree seulement si aucun admin n'existe
• admin cree seulement si ADMIN_EMAIL et ADMIN_PASSWORD sont definis
• categories predefinies + categories aleatoires
• produits predefinis + 20 produits aleatoires
• historiques de prix aleatoires par produit

Verification derive modele

dotnet ef migrations has-pending-model-changes \
  --project AdvancedDevSample.Infrastructure/AdvancedDevSample.Infrastructure.csproj \
  --startup-project AdvancedDevSample.Api/AdvancedDevSample.Api.csproj \
  --context AppDbContext