Add a small tool to inspect databases

[GernotMaier]

Add a simple tool to quickly list the available databases and its collections. I've need this now a couple of times and it is simply faster than opening robot 3T (or something similar). Also means that we reduce the necessity that developers install robot 3T. And the last point is that this is a tool to quickly check the mongoDB status.

This gives e.g. (with my limited local database instance and not the full one running at DESY)

python simtools/applications/db_inspect_databases.py --db_name all
Database: Staging-CTA-Simulation-Model-v0-3-0
   Collections: ['configuration_sim_telarray', 'telescopes', 'metadata', 'sites', 'calibration_devices', 'fs.files', 'fs.chunks']

[ctao-dpps-sonarqube[bot]]

• 0.00% Coverage on New Code (is less than 80.00%)

Analysis Details

0 Issues

• 0 Bugs
• 0 Vulnerabilities
• 0 Code Smells

Coverage and Duplications

• 0.00% Coverage (93.50% Estimated after merge)
• 0.00% Duplicated Code (0.10% Estimated after merge)

Project ID: gammasim_simtools_AY_ssha9WiFxsX-2oy_w

View in SonarQube

[ctao-dpps-sonarqube[bot]]

• 0.00% Coverage on New Code (is less than 80.00%)

Analysis Details

0 Issues

• 0 Bugs
• 0 Vulnerabilities
• 0 Code Smells

Coverage and Duplications

• 0.00% Coverage (93.50% Estimated after merge)
• 0.00% Duplicated Code (0.10% Estimated after merge)

Project ID: gammasim_simtools_AY_ssha9WiFxsX-2oy_w

View in SonarQube

[ctao-dpps-sonarqube[bot]]

• 32.50% Coverage on New Code (is less than 80.00%)

Analysis Details

2 Issues

• 0 Bugs
• 0 Vulnerabilities
• 2 Code Smells

Coverage and Duplications

• 32.50% Coverage (92.30% Estimated after merge)
• 0.00% Duplicated Code (0.10% Estimated after merge)

Project ID: gammasim_simtools_AY_ssha9WiFxsX-2oy_w

View in SonarQube

[ctao-dpps-sonarqube[bot]]

• 29.30% Coverage on New Code (is less than 80.00%)

Analysis Details

2 Issues

• 0 Bugs
• 0 Vulnerabilities
• 2 Code Smells

Coverage and Duplications

• 29.30% Coverage (92.10% Estimated after merge)
• 0.00% Duplicated Code (0.10% Estimated after merge)

Project ID: gammasim_simtools_AY_ssha9WiFxsX-2oy_w

View in SonarQube

[ctao-dpps-sonarqube[bot]]

Analysis Details

16 Issues

• 0 Bugs
• 0 Vulnerabilities
• 16 Code Smells

Coverage and Duplications

• 92.80% Coverage (91.80% Estimated after merge)
• 0.00% Duplicated Code (0.10% Estimated after merge)

Project ID: gammasim_simtools_AY_ssha9WiFxsX-2oy_w

View in SonarQube

[ctao-dpps-sonarqube[bot]]

• 0.40% Coverage on New Code (is less than 80.00%)

Analysis Details

3 Issues

• 0 Bugs
• 0 Vulnerabilities
• 3 Code Smells

Coverage and Duplications

• 0.40% Coverage (87.20% Estimated after merge)
• 0.00% Duplicated Code (0.10% Estimated after merge)

Project ID: gammasim_simtools_AY_ssha9WiFxsX-2oy_w

View in SonarQube

[VictorBarbosaMartins]

I am starting reviewing this, but I already have a question. What do you mean by local database instance? These are DBs hosted locally in your laptop? this is quite strange to me, as the very concept of DB is to make it remotely accessible in the most efficient way possible. Perhaps I missed something, but can you please clarify this to me?

[GernotMaier]

Exactly. You can run the DB locally, which is especially useful for heaving development and debugging, tests. etc without having any impact on the remove DB which is used by others.

[GernotMaier]

Thanks for the review!