Chapter 16. Database service management utility command-line client
The trove-manage client is the command-line interface (CLI) for the Database service management utility API and its extensions. This chapter documents trove-manage version
5.0.0
.
For help on a specific trove-manage command, enter:
trove-manage COMMAND --help
$ trove-manage COMMAND --help
16.1. trove-manage usage Copy linkLink copied to clipboard!
Copy linkLink copied to clipboard!
usage: trove-manage [-h] [--config-dir DIR] [--config-file PATH] [--debug] [--log-config-append PATH] [--log-date-format DATE_FORMAT] [--log-dir LOG_DIR] [--log-file PATH] [--nodebug] [--nouse-syslog] [--noverbose] [--nowatch-log-file] [--syslog-log-facility SYSLOG_LOG_FACILITY] [--use-syslog] [--verbose] [--version] [--watch-log-file] {db_sync,db_upgrade,db_downgrade,datastore_update,datastore_version_update,db_recreate,db_load_datastore_config_parameters,datastore_version_flavor_add,datastore_version_flavor_delete} ...
usage: trove-manage [-h] [--config-dir DIR] [--config-file PATH] [--debug] [--log-config-append PATH] [--log-date-format DATE_FORMAT] [--log-dir LOG_DIR] [--log-file PATH] [--nodebug] [--nouse-syslog] [--noverbose] [--nowatch-log-file] [--syslog-log-facility SYSLOG_LOG_FACILITY] [--use-syslog] [--verbose] [--version] [--watch-log-file] {db_sync,db_upgrade,db_downgrade,datastore_update,datastore_version_update,db_recreate,db_load_datastore_config_parameters,datastore_version_flavor_add,datastore_version_flavor_delete} ...
16.2. trove-manage optional arguments Copy linkLink copied to clipboard!
Copy linkLink copied to clipboard!
- -h, --help
- show this help message and exit
- --config-dir DIR
- Path to a config directory to pull *.conf files from. This file set is sorted, so as to provide a predictable parse order if individual options are over-ridden. The set is parsed after the file(s) specified via previous --config-file, arguments hence over-ridden options in the directory take precedence.
- --config-file PATH
- Path to a config file to use. Multiple config files can be specified, with values in later files taking precedence. Defaults to None.
- --debug, -d
- If set to true, the logging level will be set to DEBUG instead of the default INFO level.
- --log-config-append PATH, --log_config PATH
- The name of a logging configuration file. This file is appended to any existing logging configuration files. For details about logging configuration files, see the Python logging module documentation. Note that when logging configuration files are used then all logging configuration is set in the configuration file and other logging configuration options are ignored (for example, logging_context_format_string).
- --log-date-format DATE_FORMAT
- Defines the format string for %(asctime)s in log records. Default: None . This option is ignored if log_config_append is set.
- --log-dir LOG_DIR, --logdir LOG_DIR
- (Optional) The base directory used for relative log_file paths. This option is ignored if log_config_append is set.
- --log-file PATH, --logfile PATH
- (Optional) Name of log file to send logging output to. If no default is set, logging will go to stderr as defined by use_stderr. This option is ignored if log_config_append is set.
- --nodebug
- The inverse of --debug
- --nouse-syslog
- The inverse of --use-syslog
- --noverbose
- The inverse of --verbose
- --nowatch-log-file
- The inverse of --watch-log-file
- --syslog-log-facility SYSLOG_LOG_FACILITY
- Syslog facility to receive log lines. This option is ignored if log_config_append is set.
- --use-syslog
- Use syslog for logging. Existing syslog format is DEPRECATED and will be changed later to honor RFC5424. This option is ignored if log_config_append is set.
- --verbose, -v
- If set to false, the logging level will be set to WARNING instead of the default INFO level.
- --version
- show program's version number and exit
- --watch-log-file
- Uses logging handler designed to watch file system. When log file is moved or removed this handler will open a new log file with specified path instantaneously. It makes sense only if log_file option is specified and Linux platform is used. This option is ignored if log_config_append is set.
16.3. trove-manage datastore_version_flavor_add Copy linkLink copied to clipboard!
Copy linkLink copied to clipboard!
usage: trove-manage datastore_version_flavor_add [-h] datastore_name datastore_version_name flavor_ids
usage: trove-manage datastore_version_flavor_add [-h] datastore_name datastore_version_name flavor_ids
Adds flavor association to a given datastore and datastore version.
Positional arguments
- datastore_name
- Name of the datastore.
- datastore_version_name
- Name of the datastore version.
- flavor_ids
- Comma separated list of flavor ids.
Optional arguments
- -h, --help
- show this help message and exit
16.4. trove-manage datastore_version_flavor_delete Copy linkLink copied to clipboard!
Copy linkLink copied to clipboard!
usage: trove-manage datastore_version_flavor_delete [-h] datastore_name datastore_version_name flavor_id
usage: trove-manage datastore_version_flavor_delete [-h] datastore_name datastore_version_name flavor_id
Deletes a flavor associated with a given datastore and datastore version.
Positional arguments
- datastore_name
- Name of the datastore.
- datastore_version_name
- Name of the datastore version.
- flavor_id
- The flavor to be deleted for a given datastore and datastore version.
Optional arguments
- -h, --help
- show this help message and exit
16.5. trove-manage datastore_version_update Copy linkLink copied to clipboard!
Copy linkLink copied to clipboard!
usage: trove-manage datastore_version_update [-h] datastore version_name manager image_id packages active
usage: trove-manage datastore_version_update [-h] datastore version_name manager image_id packages active
Add or update a datastore version. If the datastore version already exists, all values except the datastore name and version will be updated.
Positional arguments
- datastore
- Name of the datastore.
- version_name
- Name of the datastore version.
- manager
- Name of the manager that will administer the datastore version.
- image_id
- ID of the image used to create an instance of the datastore version.
- packages
- Packages required by the datastore version that are installed on the guest image.
- active
- Whether the datastore version is active or not. Accepted values are 0 and 1.
Optional arguments
- -h, --help
- show this help message and exit
16.6. trove-manage db_downgrade Copy linkLink copied to clipboard!
Copy linkLink copied to clipboard!
usage: trove-manage db_downgrade [-h] [--repo_path REPO_PATH] version
usage: trove-manage db_downgrade [-h] [--repo_path REPO_PATH] version
Downgrade the database to the specified version.
Positional arguments
- version
- Target version.
Optional arguments
- -h, --help
- show this help message and exit
- --repo_path REPO_PATH
- SQLAlchemy Migrate repository path.
16.7. trove-manage db_load_datastore_config_parameters Copy linkLink copied to clipboard!
Copy linkLink copied to clipboard!
usage: trove-manage db_load_datastore_config_parameters [-h] datastore datastore_version config_file_location
usage: trove-manage db_load_datastore_config_parameters [-h] datastore datastore_version config_file_location
Loads configuration group parameter validation rules for a datastore version into the database.
Positional arguments
- datastore
- Name of the datastore.
- datastore_version
- Name of the datastore version.
- config_file_location
- Fully qualified file path to the configuration group parameter validation rules.
Optional arguments
- -h, --help
- show this help message and exit
16.8. trove-manage db_recreate Copy linkLink copied to clipboard!
Copy linkLink copied to clipboard!
usage: trove-manage db_recreate [-h] [--repo_path REPO_PATH]
usage: trove-manage db_recreate [-h] [--repo_path REPO_PATH]
Drop the database and recreate it.
Optional arguments
- -h, --help
- show this help message and exit
- --repo_path REPO_PATH
- SQLAlchemy Migrate repository path.
16.9. trove-manage db_sync Copy linkLink copied to clipboard!
Copy linkLink copied to clipboard!
usage: trove-manage db_sync [-h] [--repo_path REPO_PATH]
usage: trove-manage db_sync [-h] [--repo_path REPO_PATH]
Populate the database structure
Optional arguments
- -h, --help
- show this help message and exit
- --repo_path REPO_PATH
- SQLAlchemy Migrate repository path.
16.10. trove-manage db_upgrade Copy linkLink copied to clipboard!
Copy linkLink copied to clipboard!
usage: trove-manage db_upgrade [-h] [--version VERSION] [--repo_path REPO_PATH]
usage: trove-manage db_upgrade [-h] [--version VERSION] [--repo_path REPO_PATH]
Upgrade the database to the specified version.
Optional arguments
- -h, --help
- show this help message and exit
- --version VERSION
- Target version. Defaults to the latest version.
- --repo_path REPO_PATH
- SQLAlchemy Migrate repository path.