Web: Provide a database status page

[sneumann]

Hi, it would be great to have a status page showing the database content:

metchem=# select library.library_name, count(*), library.last_updated,library.library_link from library, substance where library.library_id=substance.library_id group by library.library_name, library.last_updated, library.library_link;
 library_name | count  | last_updated |         library_link         
--------------+--------+--------------+------------------------------
 chebi        | 105236 | 2020-11-11   | https://www.ebi.ac.uk/chebi
 lipidmaps    |  42259 | 2020-11-10   | http://www.lipidmaps.org
 swisslipids  | 592076 | 2020-11-10   | https://www.swisslipids.org/
...

Also possibly include status of local datasets:

for F in *.txt ; do echo -e "$F\t$(wc -l $F)\t$(date -r $F -R )" ; done

[sneumann]

Example for a simple popup:
https://github.com/ipb-halle/MetFragRelaunched/blob/master/MetFragWeb/src/main/webapp/includes/dialogs/expiredSessionDialog.xhtml

One place with SQL queries is

MetFragRelaunched/MetFragLib/src/main/java/de/ipbhalle/metfraglib/database/LocalMetChemDatabase.java

Line 105 in c57f9d2

public ArrayList<String> getCandidateIdentifiers(String molecularFormula) {