Namespace FishMMO.Database.Npgsql.Services
Namespaces
Classes
- AccountService
Account service providing async operations for account creation and login. Uses EF Core compiled queries for hot paths and the BaseService execution strategy for retries. Returns DatabaseResult for consistent, safe error handling with sanitized messages.
- AuthTokenService
Service for managing authentication tokens. The LoginServer issues tokens; WorldServers and SceneServers validate and check revocation. Uses compiled queries for the hot validation path and raw SQL for writes.
- BaseService<TEntity>
Base class for database services that execute EF Core operations with consistent execution behavior (transactional and read-only), retry behavior for transient failures, and standardized error mapping into DatabaseResult.
- CharacterAbilityService
Service for managing character abilities in the database. Provides async operations for CRUD operations on character ability data. Uses the BaseService execution strategy for automatic retry on transient database failures. Returns DatabaseResult for consistent, safe error handling.
- CharacterAchievementService
Service for managing character achievements in the database. Provides async operations for CRUD operations on character achievement data. Uses the BaseService execution strategy for automatic retry on transient database failures. Returns DatabaseResult for consistent, safe error handling.
- CharacterArchetypeService
Service for managing character archetypes in the database. Provides async operations for CRUD operations on character archetype data. Implements execution strategies for automatic retry on transient database failures. Returns DatabaseResult for consistent, safe error handling.
- CharacterAttributeService
Service for managing character attributes in the database. Provides async operations for CRUD operations on character attribute data. Implements execution strategies for automatic retry on transient database failures. Returns DatabaseResult for consistent, safe error handling.
- CharacterBuffService
Character buff service with async operations, atomic SQL, and DTO pattern. Uses repository pattern with EF Core and raw SQL for race-condition-prone operations. Implements execution strategies for automatic retry on transient database failures. Returns DatabaseResult for consistent, safe error handling with sanitized messages. Follows SOLID principles: SRP, OCP, LSP, ISP, DIP.
- CharacterDialogueChoiceService
Service for the per-character dialogue choice bitmasks. Provides async merge/fetch operations over
character_dialogue_choices. Uses the BaseService execution strategy for automatic retry on transient database failures. Returns DatabaseResult for consistent, safe error handling.
- CharacterFactionService
Service for managing character factions in the database. Provides async operations for CRUD operations on character faction reputation data. Implements execution strategies for automatic retry on transient database failures. Returns DatabaseResult for consistent, safe error handling.
- CharacterFriendService
Service for managing character friend relationships in the database. Provides async operations for CRUD operations on character friend data. Implements execution strategies for automatic retry on transient database failures. Returns DatabaseResult for consistent, safe error handling.
- CharacterGuildService
Service for managing character guild membership in the database. Provides async operations for CRUD operations on character guild membership data. Implements execution strategies for automatic retry on transient database failures. Returns DatabaseResult for consistent, safe error handling.
- CharacterHotkeyService
Service for managing character hotkeys in the database. Provides async operations for CRUD operations on character hotkey bar data. Implements execution strategies for automatic retry on transient database failures. Returns DatabaseResult for consistent, safe error handling.
- CharacterItemCooldownService
Service for managing character item cooldowns in the database. Provides async operations for CRUD operations on character item cooldown data. Uses the BaseService execution strategy for automatic retry on transient database failures. Returns DatabaseResult for consistent, safe error handling.
- CharacterItemService
Service for a character's items across every container.
- CharacterKnownAbilityService
Service for managing character known abilities in the database. Provides async operations for CRUD operations on character known ability data. Uses the BaseService execution strategy for automatic retry on transient database failures. Returns DatabaseResult for consistent, safe error handling.
- CharacterMailService
Service for managing character mail in the database. Provides async operations for CRUD operations on character mail data. Implements execution strategies for automatic retry on transient database failures. Returns DatabaseResult for consistent, safe error handling.
- CharacterPartyService
Service for managing character party membership in the database. Provides async operations for CRUD operations on character party data. Implements execution strategies for automatic retry on transient database failures. Returns DatabaseResult for consistent, safe error handling.
- CharacterPetAttributeService
Service for managing character pet attributes in the database. Provides async operations for CRUD operations on character pet attribute data. Uses the BaseService execution strategy for automatic retry on transient database failures. Returns DatabaseResult for consistent, safe error handling.
- CharacterPetBuffService
Service for managing character pet buffs in the database. Provides async operations for CRUD operations on character pet buff data. Uses the BaseService execution strategy for automatic retry on transient database failures. Returns DatabaseResult for consistent, safe error handling.
- CharacterPetService
Service for managing character pet data in the database. Provides async operations for CRUD operations on character pet data. Implements execution strategies for automatic retry on transient database failures. Returns DatabaseResult for consistent, safe error handling.
- CharacterQuestService
Service for managing character quests in the database. Provides async operations for CRUD operations on character quest data. Uses the BaseService execution strategy for automatic retry on transient database failures. Returns DatabaseResult for consistent, safe error handling.
- CharacterService
Base class for database services that execute EF Core operations with consistent execution behavior (transactional and read-only), retry behavior for transient failures, and standardized error mapping into DatabaseResult.
- CharacterSessionOwnershipService
Proves — inside an open unit of work — that the calling server is still entitled to write a character's state, and holds that entitlement still for the remainder of the transaction.
- CharacterSkillService
Service for managing character skills in the database. Provides async operations for CRUD operations on character skill data. Uses the BaseService execution strategy for automatic retry on transient database failures. Returns DatabaseResult for consistent, safe error handling.
- ChatService
Base class for database services that execute EF Core operations with consistent execution behavior (transactional and read-only), retry behavior for transient failures, and standardized error mapping into DatabaseResult.
- ConnectionTokenKeyService
Service for managing connection token verification keys. LoginServers use this to discover verification keys at startup and to periodically poll for new keys from new regions.
- CurrencyLedgerService
Appends completed currency movements to the economy ledger.
- DeploymentSecretService
Service for managing deployment-global secrets loaded by servers at startup. Uses a compiled query for reads and a raw SQL upsert for writes.
- EmailQueueService
Outbound email queue service. Uses parameterized raw SQL for writes and EF Core compiled queries for reads, following the existing service pattern.
- GuildApplicationService
Base class for database services that execute EF Core operations with consistent execution behavior (transactional and read-only), retry behavior for transient failures, and standardized error mapping into DatabaseResult.
- GuildLogService
Base class for database services that execute EF Core operations with consistent execution behavior (transactional and read-only), retry behavior for transient failures, and standardized error mapping into DatabaseResult.
- GuildRankService
Base class for database services that execute EF Core operations with consistent execution behavior (transactional and read-only), retry behavior for transient failures, and standardized error mapping into DatabaseResult.
- GuildService
Base class for database services that execute EF Core operations with consistent execution behavior (transactional and read-only), retry behavior for transient failures, and standardized error mapping into DatabaseResult.
- GuildUpdateService
Service for managing guild update notifications in the database. Tracks when guilds have been modified so clients can poll for changes. Implements execution strategies for automatic retry on transient database failures. Returns DatabaseResult for consistent, safe error handling.
- KickRequestService
Base class for database services that execute EF Core operations with consistent execution behavior (transactional and read-only), retry behavior for transient failures, and standardized error mapping into DatabaseResult.
- LoginServerService
Login server registration and management service. Uses EF Core compiled queries for hot paths and the BaseService execution strategy for retries.
- LoginServerSigningKeyService
Service for managing per-LoginServer HMAC signing keys. Uses EF Core compiled queries for the hot validation path and raw SQL for inserts.
- PartyService
Service for managing party entities in the database. Provides async operations for party creation, deletion, and retrieval. Implements execution strategies for automatic retry on transient database failures. Returns DatabaseResult for consistent, safe error handling.
- PartyUpdateService
Service for managing party update notifications in the database. Tracks when parties have been modified so clients can poll for changes. Implements execution strategies for automatic retry on transient database failures. Returns DatabaseResult for consistent, safe error handling.
- SceneServerService
Base class for database services that execute EF Core operations with consistent execution behavior (transactional and read-only), retry behavior for transient failures, and standardized error mapping into DatabaseResult.
- SceneService
Base class for database services that execute EF Core operations with consistent execution behavior (transactional and read-only), retry behavior for transient failures, and standardized error mapping into DatabaseResult.
- TwoFactorRecoveryCodeService
Service for managing two-factor recovery codes. Uses raw SQL for writes and compiled queries for reads.
- UnitOfWorkService
Npgsql implementation of IUnitOfWorkService.
- WorldServerService
Base class for database services that execute EF Core operations with consistent execution behavior (transactional and read-only), retry behavior for transient failures, and standardized error mapping into DatabaseResult.
Enums
- BaseService<TEntity>.BulkVersionConflictPolicy
How a bulk versioned write should treat rows that lose the version race.