From 2c31075db57bcebe72e2994d67c855aabd3e80e4 Mon Sep 17 00:00:00 2001 From: Nicolas Boisselier Date: Fri, 1 Nov 2019 15:41:05 +0000 Subject: [PATCH] /opt/nb/lib/postgres/mime.sql --- lib/postgres/mime.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/lib/postgres/mime.sql b/lib/postgres/mime.sql index f5f05716..bd109392 100644 --- a/lib/postgres/mime.sql +++ b/lib/postgres/mime.sql @@ -707,7 +707,8 @@ SELECT '>developer.mozilla.org' as log; DELETE FROM tmp_mime; COPY tmp_mime FROM PROGRAM 'true && curl -s \ https://developer.mozilla.org/en-US/docs/Web/HTTP/Basics_of_HTTP/MIME_types/Complete_list_of_MIME_types \ -| xmllint --html --xpath "/html/body//table[@class=\"standard-table\"]" - 2>/dev/null |html2csv - \ +| xmllint --html --xpath "/html/body//table[@class=\"standard-table\"]" - 2>/dev/null \ +| $NB_ROOT/bin/html2csv - \ | tail -n+2 | \ ' WITH (format 'text', NULL ''); INSERT INTO mime SELECT * FROM tmp_mime ON CONFLICT DO NOTHING; -- 2.47.3