vesta/bin/v_list_db_bases

#!/bin/bash
# info: listing data bases
# options: user [format]
#
# The function for obtaining the list of all user's databases.


#----------------------------------------------------------#
#                    Variable&Function                     #
#----------------------------------------------------------#

# Argument defenition
user=$1
format=${2-shell}

# Importing variables
source $VESTA/conf/vars.conf
source $V_FUNC/shared.func


#----------------------------------------------------------#
#                    Verifications                         #
#----------------------------------------------------------#

# Checking args
check_args '1' "$#" 'user [format]'

# Checking argument format
format_validation 'user'

# Checking user
is_user_valid


#----------------------------------------------------------#
#                       Action                             #
#----------------------------------------------------------#

# Defining config
conf=$V_USERS/$user/db.conf

# Defining fileds to select
fields='$DB $USER $HOST $TYPE $CHARSET $U_DISK $SUSPEND $DATE'

# Listing databases
case $format in 
    json)   json_list ;;
    plain)  nohead=1; shell_list ;;
    shell)  fields='$DB $USER $HOST $TYPE $U_DISK $DATE';
            shell_list | column -t ;;
    *)      check_args '1' '0' 'user [format]'
esac


#----------------------------------------------------------#
#                       Vesta                              #
#----------------------------------------------------------#

exit