Add --diff-mode and remove --dry-run

FNegrirequested to merge
main-I5a0c4ab25fccac5db2c41183eeeecaf96baf508c into main

Replace the existing "--dry-run" mode with a slightly different
"--diff-mode":

  • "diff-mode" is a better name because it's not completely "dry": it
    still has to create the temporary "db_maintain" database to compare
    the view definitions

  • it's more useful than the existing "dry-run", as it lets you see if there
    are any changes between the YAML view definitions and the views
    currently existing in the database

  • with the default "INFO" log level, it will only list tables that need
    creating or updating, and if run with --debug it will also show the
    full SQL diff of views that need an update

  • I also added two additional "INFO"-level logging messages, printing
    the instance names and the db names being processed, while I moved the
    other low-level messages to "DEBUG" level

Bug: T351637

Related MRs:

Edited by FNegri

Merge request reports