Lyo.ShortUrl.Postgres 3.0.0

Lyo.ShortUrl.Postgres

EF Core schema and DbContext registration for a PostgreSQL-backed short-URL store.

This package has no PostgresShortUrlService / PostgresShortUrlStore. It ships the database pieces (DbContext, entities, migrations, options, and DI helpers for the context). To get an IShortUrlService that talks to this schema, implement one on ShortUrlDbContext (or use Lyo.ShortUrl.ShortUrlService for id-only generation. That class does not persist anything).

Examples

Service registration (Extensions)

services.AddShortUrlDbContextFactoryFromConfiguration(configuration);

services.AddSingleton<IShortUrlService, MyEfBackedShortUrlService>();
// where MyEfBackedShortUrlService takes IDbContextFactory<ShortUrlDbContext>
// and IShortUrlGenerator (services.AddShortUrlGenerator()).

Package contents

• ShortUrlDbContext + ShortUrlDbContextFactory under Database/, with DbSet<ShortUrlEntity> and DbSet<UrlClickEntity>. The default schema is "url".
• ShortUrlEntity. The canonical short-link row: string-keyed Id (max 100 chars) used as the short code, LongUrl (≤ 1024), optional CustomAlias, CreatedTimestamp / UpdatedTimestamp / ExpirationDate / LastAccessedDate, ClickCount, IsActive, and a Clicks navigation. Includes a FromShortenRequest(...) factory and a BuildShortUrl(baseUrl) helper that mirrors Lyo.ShortUrl.ShortUrlService's BaseUrl behaviour.
• UrlClickEntity. Append-only click log row (ShortUrlId FK, ClickedAt, optional IpAddress / UserAgent / Referrer).
• *EntityConfiguration Fluent API mappings under the same folder.
• PostgresShortUrlOptions (SectionName = "PostgresShortUrl", Schema = "url", ConnectionString, EnableAutoMigrations).
• Constants.Metrics names (urlshortener.postgres.statistics.duration, .delete.duration, .update.duration), reserved for downstream service implementations.
• InitialCreate migration under Migrations/.

Service registration (Extensions)

There is intentionally no AddPostgresShortUrlStore / AddPostgresShortUrlService. See the note at the top of this README. Wire your own service on top of the factory, for example:

Database schema

(Exact table / column names follow the EF defaults plus the configurations under Database/. The migrations history is tracked in __EFMigrationsHistory under the same url schema.)

Dependencies

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

• Lyo.Exceptions (direct, lyo)
• Lyo.Postgres (direct, lyo)
• Lyo.ShortUrl (direct, lyo)
• Microsoft.Extensions.Configuration.Binder 10.0.5 (direct, microsoft)
• Lyo.Common.Core (transitive, lyo)
• Lyo.Health (transitive, lyo)
• Lyo.Metrics (transitive, lyo)
• Lyo.Result (transitive, lyo)
• Microsoft.Bcl.AsyncInterfaces 10.0.5 (transitive, microsoft, netstandard2.0)
• 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)
• 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)