From 13c21a1bbb2efaf81c7330f039e352ad50cf42dc Mon Sep 17 00:00:00 2001 From: Nicolas Boisselier Date: Sun, 13 Oct 2024 09:50:31 +0200 Subject: [PATCH] etc/dbq/data.php --- etc/dbq/data.php | 13 +++++++++++-- 1 file changed, 11 insertions(+), 2 deletions(-) diff --git a/etc/dbq/data.php b/etc/dbq/data.php index 08a564e2..fb88d572 100644 --- a/etc/dbq/data.php +++ b/etc/dbq/data.php @@ -8,11 +8,20 @@ $DBQ['data'] = [ , ], 'host_git' => [ - 'sql' => "SELECT host" + 'sql' => preg_replace('/[\t\r\n]/',''," + SELECT host + ,max(updated) as last_updated + ,min(updated) as first_updated + ,(SELECT count(val) FROM host_info path WHERE path.host=hi.host AND path.key LIKE '%.path') as repos + ,max((SELECT DISTINCT val FROM host_info ex WHERE ex.host=hi.host AND ex.key LIKE '%.exit_code' LIMIT 1)) as exit + FROM host_info hi + GROUP BY host ORDER BY host +"), + '_sql' => "SELECT host" .",max(updated) as last_updated" .",min(updated) as first_updated" .",(SELECT count(val) FROM host_info path WHERE path.host=hi.host AND path.key LIKE '%.path') as repos" - .",max((SELECT DISTINCT val FROM host_info ex WHERE ex.host=hi.host AND ex.key LIKE '%.exit_code')) as exit" + .",max((SELECT DISTINCT val FROM host_info ex WHERE ex.host=hi.host AND ex.key LIKE '%.exit_code' LIMIT 1)) as exit" ." FROM host_info hi" ." GROUP BY host ORDER BY host" , -- 2.47.3