Lyo.Discord.Postgres 2.0.0

Lyo.Discord.Postgres

PostgreSQL persistence plus Lyo.Api endpoint mappings for Discord entities. Schema name is locked to discord (PostgresDiscordOptions.Schema).

Examples

Start here

services.AddPostgresDiscordFromConfiguration(builder.Configuration);
services.AddDiscordGuildSettingsInfrastructure(); // optional, requires AddPostgresConfigStore
services.AddSingleton(new TypeAdapterConfig().ConfigureDiscordMappings());

var app = builder.Build();
app.BuildDiscordGroup();
app.Run();

What's included

• DiscordDbContext (Database/DiscordDbContext.cs) exposes DbSets for DiscordUser, DiscordGuild, DiscordChannel, DiscordEmoji, DiscordRole, DiscordInteraction, DiscordMessage, DiscordAttachment, DiscordReaction (composite key (MessageId, ReactorId, EmojiId)), and DiscordMember (composite key (UserId, GuildId)). Find the model snapshot under Migrations/.
• DiscordDbContextFactory for design-time tools.
• PostgresDiscordOptions (PostgresDiscordOptions.cs). IPostgresMigrationConfig. Section "PostgresDiscord". Properties: ConnectionString, EnableAutoMigrations (default false); Schema = "discord" stays constant.
• Helpers that map endpoints in Extensions.cs and DiscordGuildSettingsEndpoints.cs.
• DiscordGuildSettingsHelper resolves / seeds default DiscordGuildSettings bindings.
• DiscordGuildSettingsDefinitionSeeder. An IHostedService that registers the settings document definition with Lyo.Config.

Wire into DI (Extensions.cs)

Every registration is an IServiceCollection extension (declared inside extension(IServiceCollection services) blocks):

AddPostgresDiscord expects the host to have already registered AddLyoQueryServices, a cache implementation, and an ILyoMapper (for example via MapsterLyoMapper configured by ConfigureDiscordMappings).

Mapster mappings (ConfigureDiscordMappings)

Call once on your TypeAdapterConfig to connect the *Req ↔ EF ↔ *Res mappings used by Lyo.Api CRUD. Two name-sanitizers run for nullable input: DiscordUsernameOrPlaceholder (≤ 35 chars, falls back to "(unknown)") and DiscordGuildNameOrPlaceholder (≤ 50 chars). Audit timestamps (CreatedTimestamp, UpdatedTimestamp) are ignored on request DTOs because the CRUD hooks stamp them.

Endpoint mapping (app.BuildDiscordGroup())

Maps Discord REST endpoints under group "Discord" through the typed CreateBuilder pipeline. Each entity gets ApiFeatureFlag.All | UpsertInheritCreate | UpsertInheritUpdate | PatchInheritsUpdate plus a CrudConfiguration<DiscordDbContext, T, TReq> that stamps CreatedTimestamp / UpdatedTimestamp in BeforeCreate / BeforeUpdate:

BuildDiscordGroup also invokes MapDiscordGuildSettingsEndpoints, which (only when an IConfigStore is registered) maps:

The PUT route checks the guild exists, clears Revision before save, calls NormalizeForPersistence, and returns the persisted value to the caller. The host is expected to layer authorization on top. No auth is wired here by default.

Dependencies

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

• Lyo.Api (direct, lyo)
• Lyo.Config (direct, lyo)
• Lyo.Configuration (direct, lyo)
• Lyo.Discord.Models (direct, lyo)
• Lyo.EntityReference.Models (direct, lyo)
• Lyo.Exceptions (direct, lyo)
• Lyo.Postgres (direct, lyo)
• Mapster 10.0.10 (direct, third-party)
• Microsoft.EntityFrameworkCore 10.0.5 (direct, microsoft)
• Microsoft.EntityFrameworkCore.Design 10.0.5 (direct, microsoft)
• Microsoft.Extensions.Configuration.Binder 10.0.5 (direct, microsoft)
• Microsoft.Extensions.Hosting.Abstractions 10.0.5 (direct, microsoft)
• Lyo.Api.Models (transitive, lyo)
• Lyo.Cache (transitive, lyo)
• Lyo.Common.Core (transitive, lyo)
• Lyo.Common.Json (transitive, lyo)
• Lyo.Common.Metadata (transitive, lyo)
• Lyo.Compression (transitive, lyo)
• Lyo.DateAndTime (transitive, lyo)
• Lyo.Diagnostic (transitive, lyo)
• Lyo.Diagnostic.AspNetCore (transitive, lyo)
• Lyo.Diff (transitive, lyo)
• Lyo.Encryption (transitive, lyo)
• Lyo.Formatter (transitive, lyo)
• Lyo.Hashing (transitive, lyo)
• Lyo.Health (transitive, lyo)
• Lyo.KeyStore (transitive, lyo)
• Lyo.Metrics (transitive, lyo)
• Lyo.PackageMetadata (transitive, lyo)
• Lyo.Parameters (transitive, lyo)
• Lyo.Query (transitive, lyo)
• Lyo.Query.Evaluation (transitive, lyo)
• Lyo.Query.Models (transitive, lyo)
• Lyo.Result (transitive, lyo)
• Lyo.Streams (transitive, lyo)
• Lyo.Validation (transitive, lyo)
• Lyo.Validation.Models (transitive, lyo)
• BouncyCastle.Cryptography 2.6.2 (transitive, third-party, netstandard2.0)
• DynamicExpresso.Core 2.19.3 (transitive, third-party)
• EasyCompressor 2.1.0 (transitive, third-party)
• Konscious.Security.Cryptography.Argon2 1.3.1 (transitive, third-party)
• Microsoft.AspNetCore.OpenApi 10.0.5 (transitive, microsoft)
• Microsoft.Bcl.AsyncInterfaces 10.0.5 (transitive, microsoft, netstandard2.0)
• Microsoft.EntityFrameworkCore.Analyzers 10.0.5 (transitive, microsoft)
• Microsoft.EntityFrameworkCore.Relational 10.0.5 (transitive, microsoft)
• Microsoft.Extensions.Caching.Memory 10.0.5 (transitive, microsoft)
• Microsoft.Extensions.DependencyInjection 10.0.5 (transitive, microsoft)
• Microsoft.Extensions.DependencyInjection.Abstractions 10.0.5 (transitive, microsoft, net10.0, netstandard2.0)
• 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)
• SmartFormat.NET 3.6.1 (transitive, third-party)
• System.Buffers 4.6.1 (transitive, microsoft, netstandard2.0)
• System.ComponentModel.Annotations 5.0.0 (transitive, microsoft)
• System.IO.Hashing 10.0.5 (transitive, microsoft, net10.0)
• System.Memory 4.6.3 (transitive, microsoft, netstandard2.0)
• System.Text.Json 10.0.5 (transitive, microsoft, netstandard2.0)
• System.Threading.Tasks.Extensions 4.6.3 (transitive, microsoft, netstandard2.0)