Linux自定义sp命令

#!/bin/bash
# alias sp='sh /home/work/.sp-gp' # 查gp库
. ~/.bashrc

re="[[:digit:]]+"

fields="F_sp_id, F_sp_user_id, F_sp_company, F_sp_display_name, F_create_time"

if [[ $1 =~ $re ]]; then
    sql="SELECT $fields FROM fn.t_scenario_sp_map WHERE F_sp_id = '$1'"
    data=`echo -e ${sql} |gp_rd -t -A`
    echo ${data}
    exit 0
elif [ "$1" = "-u" ]; then
    if [[ $2 =~ $re ]]; then
        sql="SELECT $fields FROM fn.t_scenario_sp_map WHERE F_sp_user_id = '$2'"
        data=`echo -e ${sql} |gp_rd -t -A`
        echo ${data}
        exit 0
    else
        echo "F_sp_user_id is required" >&2
    fi
else
    echo "F_sp_id is required" >&2
fi

exit 255

#!/bin/sh
# alias sp='sh /home/work/.sp' # 查mysql库
. ~/.bashrc

re="[[:digit:]]+"

fields="F_sp_id, F_sp_user_id, F_sp_company, F_sp_display_name, F_create_time"

if [[ $1 =~ $re ]]; then
    fndb -e "SELECT $fields FROM bfb_db_finance.t_scenario_sp_map WHERE F_sp_id = '$1'\G"
    exit 0
elif [ "$1" = "-u" ]; then
    if [[ $2 =~ $re ]]; then
        fndb -e "SELECT $fields FROM bfb_db_finance.t_scenario_sp_map WHERE F_sp_user_id = '$2'\G"
        exit 0
    else
        echo "F_sp_user_id is required" >&2
    fi
else
    echo "F_sp_id is required" >&2
fi

exit 255