Contents

module Timescaledb
  class JobStat < ::Timescaledb::ApplicationRecord
    self.table_name = "timescaledb_information.job_stats"

    belongs_to :job
#    attribute :last_run_duration, :interval

    scope :success, -> { where(last_run_status: "Success") }
    scope :scheduled, -> { where(job_status: "Scheduled") }
    scope :resume, -> do
      select("sum(total_successes)::int as success,
             sum(total_runs)::int as runs,
             sum(total_failures)::int as failures")
        .to_a.map{|e|e.attributes.transform_keys(&:to_sym) }
    end
  end
  JobStats = JobStat
end

Version data entries

7 entries across 7 versions & 1 rubygems

Version	Path
timescaledb-0.3.2	lib/timescaledb/job_stats.rb
timescaledb-0.3.1	lib/timescaledb/job_stats.rb
timescaledb-0.3.0	lib/timescaledb/job_stats.rb
timescaledb-0.2.9	lib/timescaledb/job_stats.rb
timescaledb-0.2.8	lib/timescaledb/job_stats.rb
timescaledb-0.2.7	lib/timescaledb/job_stats.rb
timescaledb-0.2.6	lib/timescaledb/job_stats.rb