Linux自定义sp命令

bash脚本：查询GP与MySQL数据库中的场景SP映射数据

最新推荐文章于 2023-07-07 15:45:01 发布

原创最新推荐文章于 2023-07-07 15:45:01 发布 · 907 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#linux #自定义命令

Shell 同时被 2 个专栏收录

25 篇文章

订阅专栏

Linux

21 篇文章

订阅专栏

#!/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