cache the list of categories

[dlangille]

re #473 (comment)

[dlangille]

freshports.devgit=# grant select on categories to reading_dev_git;
GRANT

[dlangille]

so far:

[23:00 dev-ingress01 dan ~/scripts] % cat ~/scripts/categories_rebuild_search_html.sh 
#!/bin/sh

# re: https://github.com/FreshPorts/freshports/issues/488
# Let's cache the list of categories for searching.

. /usr/local/etc/freshports/config.sh

export PGDATABASE=$DB
export PGHOST=$HOST
export PGUSER=$DBUSER

#PGUSER=reporting_dev_git

echo $PGDATABASE $PGHOST $PGUSER

#echo "select '            <OPTION VALUE=\\\"' || name || ''\\\" <?php if \(\$category == ''' || name || '''\) echo ''SELECTED''?>>' || name || '</OPTION>' from categories order by name"
#psql

#psql -c "select '            <OPTION VALUE=\"' || name || ''\" <?php if \(\$category == ''' || name || '''\) echo ''SELECTED''?>>' || name || '</OPTION>' from categories order by name;"
psql -t <<EOF
select '            <OPTION VALUE="'  || name || '"<?php if (\$category == ''' || name || ''') echo '' SELECTED''?>>' || name || '</OPTION>' from categories order by name;
EOF

[dlangille]

NOTE to self: this file should go into ~freshports/cache/html on the ingress host - it is safe there from any cache clearing on the WWW host.

[dlangille]

Updated added to test, stage, and prod - waiting for top-of-the-hour periodic scripts to run.

re: https://github.com/FreshPorts/freshports/releases/tag/2.8.2