Give database version in console system:status command

[C-Duv]

The CLI/Console's system:status command has a database "db" section where it gives information about database status.

{
    "glpi": {
        "status": "OK"
    },
    "db": {
        "status": "OK",
        "main": {
            "status": "OK"
        },
        "replicas": {
            "status": "NO_DATA",
            "servers": []
        }
    },
    …
}

I think it would be useful (for unattended deployment/provisioning) to know what's the database version and whether it's up-to-date or not.

This information can be added to the system:status command which would, on a outdated database, output something like:

{
    "glpi": {
        "status": "OK"
    },
    "db": {
        "status": "OK",
        "version": {
            "installed": "11.0.6@84160e91f70f353b33495a7928e5b1476d4b6d98",
            "defined": "11.0.8@7b129479687ebafebb6966eaa1d72cb683390613",
            "uptodate": false
        },
        "main": {
            "status": "OK"
        },
        "replicas": {
            "status": "NO_DATA",
            "servers": []
        }
    },
    …
}

and, on a up-to-date database:

{
    "glpi": {
        "status": "OK"
    },
    "db": {
        "status": "OK",
        "version": {
            "installed": "11.0.8@7b129479687ebafebb6966eaa1d72cb683390613",
            "defined": "11.0.8@7b129479687ebafebb6966eaa1d72cb683390613",
            "uptodate": true
        },
        "main": {
            "status": "OK"
        },
        "replicas": {
            "status": "NO_DATA",
            "servers": []
        }
    },
    …
}

Example use case:

Your Ansible task wants to install a plugin after updating GLPI: the bin/console plugin:install command will fail until GLPI has been updated.

When plugin:install is attempted, output is as follows:

$ bin/console plugin:install someplugin
The GLPI codebase has been updated. The update of the GLPI database is necessary.
Run the "php bin/console database:update" command to process to the update.

Calling idempotent system:status command to read JSON's db.version.uptodate key would tell Ansible if it has to run bin/console database:update.

[C-Duv]

I've opened a PR: glpi-project/glpi#24753