A platform for community discussion. Free, open, simple.
# frozen_string_literal: true
module DiscourseDataExplorer
module Statistics
extend PeriodCountHelper
def self.queries_total
{ count: Query.user_queries.count }
end
def self.queries_created
period_counts(Query.user_queries, :created_at, count: false)
end
def self.queries_edited
period_counts(Query.user_queries.where("updated_at > created_at"), :updated_at, count: false)
end
def self.queries_executed
period_counts(QueryStat.for_user_queries, :date, count: false) do |scope|
scope.distinct.count(:query_id)
end
end
def self.executions
period_counts(QueryStat.for_user_queries, :date) { |scope| scope.sum(:total_runs) }
end
end
end