From cf1a1b68adb8b699734cc357adcc1795760a543d Mon Sep 17 00:00:00 2001 From: Nicolas Boisselier Date: Thu, 17 Oct 2024 23:09:08 +0200 Subject: [PATCH] exit --- lib/postgres/host.sql | 1 + 1 file changed, 1 insertion(+) diff --git a/lib/postgres/host.sql b/lib/postgres/host.sql index dd1351fb..10e98e7f 100644 --- a/lib/postgres/host.sql +++ b/lib/postgres/host.sql @@ -5,6 +5,7 @@ CREATE VIEW host AS ,count(*) as infos -- ,array_to_string(array_agg(DISTINCT CASE WHEN key LIKE 'git.%.name' THEN val ELSE null END),' ') as installed ,count(DISTINCT CASE WHEN key LIKE 'git.%.path' THEN val ELSE null END) as repos + ,max(DISTINCT CASE WHEN key LIKE 'git.%.exit_code' THEN val ELSE null END) as exit ,array_to_string(array_agg(DISTINCT CASE WHEN key LIKE 'git.%.branch' THEN val ELSE null END),' ') as branches ,array_to_string(array_agg(DISTINCT CASE WHEN key IN ( 'sys.nproc','sys.arch','sys.model','sys.os' ) THEN val ELSE null END),chr(10)) as product -- NB 17.10.24 ,array_to_string(array_agg(DISTINCT CASE WHEN key IN ( 'sys.nproc','sys.arch','sys.width','sys.product' ) THEN val ELSE null END),chr(10)) as product -- 2.47.3