vesta/bin/v_list_db_hosts
2011-06-14 00:22:25 +03:00

61 lines
1.5 KiB
Bash
Executable File

#!/bin/bash
# info: listing data base servers
#----------------------------------------------------------#
# Variable&Function #
#----------------------------------------------------------#
# Argument defenition
type="$1"
format="${2-shell}"
limit="${3-1000}"
offset="${4-1}"
# Importing variables
source $VESTA/conf/vars.conf
source $V_FUNC/shared_func.sh
#----------------------------------------------------------#
# Verifications #
#----------------------------------------------------------#
# Checking args
check_args '1' "$#" 'type [format] [limit] [offset]'
# Checking argument format
format_validation 'limit' 'offset'
# Checking db type
is_type_valid 'db' "$type"
#----------------------------------------------------------#
# Action #
#----------------------------------------------------------#
# Defining config type
conf="$V_DB/$type.conf"
# Defining fileds to select
fields='$HOST $PORT $MAX_USERS $MAX_DB $U_SYS_USERS $U_DB_BASES $ACTIVE $DATE'
# Listing database
case $format in
json) v_json_list ;;
shell) fields='$HOST $PORT $MAX_USERS $MAX_DB $U_DB_BASES $ACTIVE $DATE';
v_shell_list | column -t ;;
*) check_args '2' "0" 'type [format] [limit] [offset]'
esac
#----------------------------------------------------------#
# Vesta #
#----------------------------------------------------------#
# Logging
log_event 'system' "$V_EVENT"
exit $OK