Module: RailsWorkflow::Db::Mysql

Defined in:

lib/rails_workflow/db/mysql.rb

Constant Summary

COUNT_STATUSES =

"SELECT status, cnt FROM\n         (\n              SELECT @row_number:=CASE\n                                      WHEN @status=status THEN @row_number+1\n                                      ELSE 1\n                                  END AS row_number,\n                     cnt,\n                     @status:=status as status\n              FROM\n                ( SELECT count(*) AS cnt,\n                         a.status\n                  FROM rails_workflow_processes a\n                  LEFT JOIN rails_workflow_processes b ON a.status=b.status\n                  GROUP BY a.status,a.id\n                ) tmp,\n                (SELECT @row_number:=0,@status:=-1) AS t\n         ) t1 WHERE row_number = 1\n"