class ReportingAPI::Total

Schema Information

Table name: reporting_api_totals

id                                    :text             primary key
academic_year                         :integer
consent_status                        :integer
has_already_vaccinated_consent        :boolean
is_archived                           :boolean
patient_gender                        :text
patient_local_authority_code          :string
patient_local_authority_official_name :string
patient_school_local_authority_code   :string
patient_school_name                   :text
patient_school_urn                    :string
patient_year_group                    :integer
programme_type                        :enum
status                                :integer
patient_id                            :bigint
session_location_id                   :bigint
team_id                               :bigint

Indexes

ix_rapi_totals_id                     (id) UNIQUE
ix_rapi_totals_session_loc            (session_location_id)
ix_rapi_totals_team_year_prog_status  (team_id,academic_year,programme_type,status)
ix_rapi_totals_year_group             (patient_year_group)

Constants

CONSENT_CONFLICTS
CONSENT_GIVEN
CONSENT_GIVEN_STATUSES
CONSENT_NOT_REQUIRED
CONSENT_NO_RESPONSE
CONSENT_NO_RESPONSE_STATUSES
CONSENT_REFUSED
NO_CONSENT_STATUSES
NO_CONTACT_DETAILS
REQUEST_NOT_SCHEDULED
REQUEST_SCHEDULED
VACCINATED_STATUSES

Public Class Methods

cohort_count ()

Source

# File app/models/reporting_api/total.rb, line 85
def self.cohort_count
  distinct.count(:patient_id)
end

consent_conflicts_count ()

Source

# File app/models/reporting_api/total.rb, line 111
def self.consent_conflicts_count
  where(consent_status: CONSENT_CONFLICTS).distinct.count(:patient_id)
end

consent_given_count ()

Source

# File app/models/reporting_api/total.rb, line 93
def self.consent_given_count
  where(consent_status: CONSENT_GIVEN_STATUSES).distinct.count(:patient_id)
end

consent_no_response_count ()

Source

# File app/models/reporting_api/total.rb, line 101
def self.consent_no_response_count
  where(consent_status: CONSENT_NO_RESPONSE_STATUSES).distinct.count(
    :patient_id
  )
end

consent_refused_count ()

Source

# File app/models/reporting_api/total.rb, line 107
def self.consent_refused_count
  where(consent_status: CONSENT_REFUSED).distinct.count(:patient_id)
end

no_consent_count ()

Source

# File app/models/reporting_api/total.rb, line 97
def self.no_consent_count
  where(consent_status: NO_CONSENT_STATUSES).distinct.count(:patient_id)
end

refresh! (concurrently: true)

Source

# File app/models/reporting_api/total.rb, line 77
def self.refresh!(concurrently: true)
  Scenic.database.refresh_materialized_view(
    table_name,
    concurrently:,
    cascade: false
  )
end

vaccinated_count ()

Source

# File app/models/reporting_api/total.rb, line 89
def self.vaccinated_count
  vaccinated.distinct.count(:patient_id)
end

with_aggregate_metrics ()

Source

# File app/models/reporting_api/total.rb, line 115
def self.with_aggregate_metrics
  vaccinated_condition =
    "status IN (#{VACCINATED_STATUSES.join(",")}) OR has_already_vaccinated_consent = true"
  consent_given_condition =
    "consent_status IN (#{CONSENT_GIVEN_STATUSES.join(",")})"
  no_consent_condition =
    "consent_status IN (#{NO_CONSENT_STATUSES.join(",")})"
  consent_no_response_condition =
    "consent_status IN (#{CONSENT_NO_RESPONSE_STATUSES.join(",")})"
  select(
    "COUNT(DISTINCT patient_id) AS cohort",
    "COUNT(DISTINCT patient_id) FILTER (WHERE #{vaccinated_condition}) AS vaccinated",
    "COUNT(DISTINCT patient_id) FILTER (WHERE NOT (#{vaccinated_condition})) AS not_vaccinated",
    "COUNT(DISTINCT patient_id) FILTER (WHERE #{consent_given_condition}) AS consent_given",
    "COUNT(DISTINCT patient_id) FILTER (WHERE #{no_consent_condition}) AS no_consent",
    "COUNT(DISTINCT patient_id) FILTER (WHERE #{consent_no_response_condition}) AS consent_no_response",
    "COUNT(DISTINCT patient_id) FILTER (WHERE consent_status = #{CONSENT_REFUSED}) AS consent_refused",
    "COUNT(DISTINCT patient_id) FILTER (WHERE consent_status = #{CONSENT_CONFLICTS}) AS consent_conflicts"
  )
end

Public Instance Methods

readonly? (= true)

Source

# File app/models/reporting_api/total.rb, line 75
  def readonly? = true

  def self.refresh!(concurrently: true)
    Scenic.database.refresh_materialized_view(
      table_name,
      concurrently:,
      cascade: false
    )
  end

  def self.cohort_count
    distinct.count(:patient_id)
  end

  def self.vaccinated_count
    vaccinated.distinct.count(:patient_id)
  end

  def self.consent_given_count
    where(consent_status: CONSENT_GIVEN_STATUSES).distinct.count(:patient_id)
  end

  def self.no_consent_count
    where(consent_status: NO_CONSENT_STATUSES).distinct.count(:patient_id)
  end

  def self.consent_no_response_count
    where(consent_status: CONSENT_NO_RESPONSE_STATUSES).distinct.count(
      :patient_id
    )
  end

  def self.consent_refused_count
    where(consent_status: CONSENT_REFUSED).distinct.count(:patient_id)
  end

  def self.consent_conflicts_count
    where(consent_status: CONSENT_CONFLICTS).distinct.count(:patient_id)
  end

  def self.with_aggregate_metrics
    vaccinated_condition =
      "status IN (#{VACCINATED_STATUSES.join(",")}) OR has_already_vaccinated_consent = true"
    consent_given_condition =
      "consent_status IN (#{CONSENT_GIVEN_STATUSES.join(",")})"
    no_consent_condition =
      "consent_status IN (#{NO_CONSENT_STATUSES.join(",")})"
    consent_no_response_condition =
      "consent_status IN (#{CONSENT_NO_RESPONSE_STATUSES.join(",")})"
    select(
      "COUNT(DISTINCT patient_id) AS cohort",
      "COUNT(DISTINCT patient_id) FILTER (WHERE #{vaccinated_condition}) AS vaccinated",
      "COUNT(DISTINCT patient_id) FILTER (WHERE NOT (#{vaccinated_condition})) AS not_vaccinated",
      "COUNT(DISTINCT patient_id) FILTER (WHERE #{consent_given_condition}) AS consent_given",
      "COUNT(DISTINCT patient_id) FILTER (WHERE #{no_consent_condition}) AS no_consent",
      "COUNT(DISTINCT patient_id) FILTER (WHERE #{consent_no_response_condition}) AS consent_no_response",
      "COUNT(DISTINCT patient_id) FILTER (WHERE consent_status = #{CONSENT_REFUSED}) AS consent_refused",
      "COUNT(DISTINCT patient_id) FILTER (WHERE consent_status = #{CONSENT_CONFLICTS}) AS consent_conflicts"
    )
  end
end