Class: Smriti::Services::SwapRefresh

Inherits:
BaseService show all
Defined in:
lib/smriti/services/swap_refresh.rb

Overview

Service that performs a swap-style refresh of a materialised view.

Instead of locking the existing view, this strategy builds a new temporary materialised view and atomically swaps it in. This approach minimizes downtime and allows for safer rebuilds of large views.

Steps:

  1. Create a temporary MV from the provided SQL.
  2. In a transaction: rename original → old, tmp → original, drop old.
  3. Recreate declared unique indexes (if any).

Options:

  • row_count_strategy: (Symbol, default: :none) → one of :estimated, :exact, or :none or nil to control row count reporting

Returns a Smriti::ServiceResponse

Examples:

Direct usage

svc = Smriti::Services::SwapRefresh.new(definition, **options)
response = svc.call
response.success? # => true/false

via job, this is the typical usage and will create a run record in the DB

When definition.refresh_strategy == "concurrent"
Smriti::Jobs::Adapter.enqueue(Smriti::Services::SwapRefresh, definition.id, **options)

See Also:

Constant Summary

Constants inherited from BaseService

BaseService::ALLOWED_ROW_STRATEGIES, BaseService::DEFAULT_NIL_STRATEGY, BaseService::DEFAULT_ROW_STRATEGY, BaseService::UNKNOWN_ROW_COUNT

Instance Attribute Summary

Attributes inherited from BaseService

#definition, #request, #response, #row_count_strategy, #use_transaction

Method Summary

Methods inherited from BaseService

#call, #initialize

Constructor Details

This class inherits a constructor from Smriti::Services::BaseService