Lyo.Audit.Postgres 1.0.6

Lyo.Audit.Postgres

PostgreSQL implementation of Lyo.Audit using Entity Framework Core. Persists AuditChange and AuditEvent records to PostgreSQL with JSONB columns for dictionary data.

Features

• PostgresAuditRecorder. Implements IAuditRecorder and Lyo.Health.IHealth with PostgreSQL persistence.
• Migrations. EF Core migrations in the audit schema (PostgresAuditOptions.Schema) with audit_changes and audit_events tables.
• Auto migrations. Optional automatic migration on startup via EnableAutoMigrations.

Examples

Quick start

services.AddPostgresAuditRecorder(new PostgresAuditOptions {
    ConnectionString = configuration.GetConnectionString("Audit")!,
    EnableAutoMigrations = true
});

services.AddPostgresAuditRecorderFromConfiguration(configuration);

Quick start (2)

services.AddAuditDbContextFactory(configuration.GetSection("PostgresAudit").Get<PostgresAuditOptions>()!);

Migrations

export AUDIT_CONNECTION_STRING="Host=localhost;Database=audit;Username=postgres;Password=postgres"
dotnet ef migrations add MigrationName --project Core/Audit/Lyo.Audit.Postgres

Registration

Quick start

Need just the factory, for example to share with downstream services or run migrations explicitly?

Health

PostgresAuditRecorder implements Lyo.Health.IHealth with HealthCheckName = "audit-postgres". The probe opens an AuditDbContext and runs Database.CanConnectAsync. Connection failures return HealthResult.Unhealthy. Hosts that resolve IEnumerable<IHealth> include this recorder.

Schema

• audit.audit_changes. id (uuid), timestamp, for_entity_type, for_entity_id (varchar), from_entity_type?, from_entity_id? (varchar), tenant_id? (uuid), old_values_json (jsonb), changed_properties_json (jsonb), created_timestamp, updated_timestamp?
• audit.audit_events. id (uuid), event_type, timestamp, for_entity_type, for_entity_id (varchar), from_entity_type?, from_entity_id? (varchar), tenant_id? (uuid), message?, metadata_json? (jsonb), created_timestamp, updated_timestamp?

Tenancy

AuditChange and AuditEvent records carry an optional TenantId (mapped to the tenant_id column). PostgresAuditRecorder runs every record through TenancyResolver.Resolve using the policy configured in PostgresAuditOptions.Tenancy (inheriting from EntityRefOptions.Mode when unset) before persisting:

• SystemOnly. Caller TenantId is ignored and the row stores null (system-level audit).
• SingleTenantDefault (default). Caller value, falling back to Tenancy.DefaultTenantId then EntityRefOptions.DefaultTenantId.
• MultiTenantStrict. Caller must supply a non-empty TenantId or persistence throws.

Each table has an ix_<table>_tenant index for filtered scans. Use WhereTenant(tenantId) to scope queries to a single tenant (or null for system rows) and WhereTenantOrSystem(tenantId) to include both. See Lyo.EntityReference.Postgres for the policy matrix.

{
  "PostgresAudit": {
    "ConnectionString": "Host=localhost;Database=audit;...",
    "Tenancy": { "Mode": "MultiTenantStrict" }
  }
}

Dependencies

Generated from ProjectReference / PackageReference (same model as docs/Lyo.ProjectGraph.html).

• Lyo.Audit (direct, lyo)
• Lyo.EntityReference.Postgres (direct, lyo)
• Lyo.Exceptions (direct, lyo)
• Lyo.Health (direct, lyo)
• Lyo.Postgres (direct, lyo)
• Microsoft.Extensions.Configuration.Binder 10.0.5 (direct, microsoft)
• Lyo.Common (transitive, lyo)
• Lyo.EntityReference.Models (transitive, lyo)
• Microsoft.EntityFrameworkCore 10.0.5 (transitive, microsoft)
• Microsoft.EntityFrameworkCore.Design 10.0.5 (transitive, microsoft)
• Microsoft.EntityFrameworkCore.Relational 10.0.5 (transitive, microsoft)
• Microsoft.Extensions.DependencyInjection.Abstractions 10.0.5 (transitive, microsoft)
• Microsoft.Extensions.Hosting.Abstractions 10.0.5 (transitive, microsoft)
• Microsoft.Extensions.Logging.Abstractions 10.0.5 (transitive, microsoft)
• Microsoft.Extensions.Options 10.0.5 (transitive, microsoft)
• Microsoft.Extensions.Options.ConfigurationExtensions 10.0.5 (transitive, microsoft)
• Npgsql.EntityFrameworkCore.PostgreSQL 10.0.3 (transitive, third-party)
• System.Memory 4.6.3 (transitive, microsoft, netstandard2.0)
• System.Text.Json 10.0.5 (transitive, microsoft, netstandard2.0)