mirror of
https://github.com/serghey-rodin/vesta.git
synced 2025-02-10 12:03:00 -08:00
52 lines
1.4 KiB
Bash
Executable File
52 lines
1.4 KiB
Bash
Executable File
#!/bin/bash
|
|
# info: list database servers
|
|
# options: TYPE [FORMAT]
|
|
#
|
|
# The function for obtaining the list of all hosts of the same databases' type.
|
|
|
|
|
|
#----------------------------------------------------------#
|
|
# Variable&Function #
|
|
#----------------------------------------------------------#
|
|
|
|
# Argument defenition
|
|
type=${1-mysql}
|
|
format=${2-shell}
|
|
|
|
# Includes
|
|
source $VESTA/func/main.sh
|
|
|
|
|
|
#----------------------------------------------------------#
|
|
# Verifications #
|
|
#----------------------------------------------------------#
|
|
|
|
# Checking args
|
|
#check_args '1' "$#" 'TYPE [FORMAT]'
|
|
|
|
|
|
#----------------------------------------------------------#
|
|
# Action #
|
|
#----------------------------------------------------------#
|
|
|
|
# Defining fileds to select
|
|
conf=$VESTA/conf/$type.conf
|
|
fields='$HOST $CHARSETS $MAX_DB $U_SYS_USERS $U_DB_BASES $TPL $SUSPENDED'
|
|
fields="$fields \$TIME \$DATE"
|
|
|
|
# Listing database
|
|
case $format in
|
|
json) json_list ;;
|
|
plain) nohead=1; shell_list;;
|
|
shell) fields='$HOST $MAX_DB $U_DB_BASES $SUSPENDED $DATE';
|
|
shell_list | column -t ;;
|
|
*) check_args '2' '0' 'TYPE [FORMAT]'
|
|
esac
|
|
|
|
|
|
#----------------------------------------------------------#
|
|
# Vesta #
|
|
#----------------------------------------------------------#
|
|
|
|
exit
|