mult1mate\crontab\DbHelper::getReportSql PHP Метод

    public static function getReportSql()
    {
        return "\n        SELECT t.command, t.task_id,\n        SUM(CASE WHEN tr.status = 'started' THEN 1 ELSE 0 END) AS started,\n        SUM(CASE WHEN tr.status = 'completed' THEN 1 ELSE 0 END) AS completed,\n        SUM(CASE WHEN tr.status = 'error' THEN 1 ELSE 0 END) AS error,\n        round(AVG(tr.execution_time),2) AS time_avg,\n        count(*) AS runs\n        FROM task_runs AS tr\n        LEFT JOIN tasks AS t ON t.task_id=tr.task_id\n        WHERE tr.ts BETWEEN ? AND ? + INTERVAL 1 DAY\n        GROUP BY command\n        ORDER BY tr.task_id";
    }

 public function testGetReportSql()
 {
     $sql = DbHelper::getReportSql();
     $this->assertTrue(is_string($sql));
 }