Class: Admin::RunningResultsController

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

Constant Summary collapse

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

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