Class: Admin::RunningResultsController

Inherits:
BaseController show all
Defined in:
app/controllers/admin/running_results_controller.rb

Constant Summary collapse

RUNNING_RESULTS = 
<<-SQL
  SELECT
    title query_title,
    compiled_body query_body,
    TO_CHAR(results.started_at, 'YYYY-MM-DD HH24:MI:SS') started_at,
    ROUND(EXTRACT(EPOCH FROM (now() - results.started_at)::INTERVAL)) duration_seconds,
    users.name author,
    users.role author_role,
    queries.id query_id,
    query_versions.id AS query_version_id,
    version
  FROM results
    LEFT OUTER JOIN query_versions ON query_versions.id = results.query_version_id
    LEFT OUTER JOIN queries ON query_versions.query_id = queries.id
    INNER JOIN users ON results.owner_id = users.id
  WHERE results.status = 'running'
SQL

Constants inherited from ApplicationController

ApplicationController::ALLOWABLE_CONFIGS

Instance Method Summary collapse

Instance Method Details

#index ⇒ Object 



24
25
26
27
28
29
30
31
 
# File 'app/controllers/admin/running_results_controller.rb', line 24

def index
  respond_to do |format|
    format.html
    format.json do
      render json: ActiveRecord::Base.connection.exec_query(RUNNING_RESULTS)
    end
  end
end