Новичок в GNU/Linux’е - [3806] :: UNIX :: Компьютерный форум Ru.Board

#!/bin/bash

help() {
cat << EOF
Usage: sql [--type=TYPE] FILENAME [--suffix-curdate] [OPTIONS]
Execute sql query and output result to stdout or file (html/text)
    type      html, txt or stdout. Default stdout
    FILENAME filename to generate html or text
    --suffix-curdate add to name current date
    OPTIONS See in open-html-file-in-browser.sh
    --help            print this help

For html format:
    --delonexit delete generated html file on exit from script
    --openinbrowser open generated html in browser
EOF
}

if [[ "$@" == *"--help"* ]]; then
    help
    exit 0
fi

sql=$1

if [ -z "$sql" ]; then
    echo "Missing sql query"
    help
    exit 1
fi

shift 1
filename=
ext=
type=stdout
args=
openinbrowser=0
delonexit=0
withCarDate=0

for arg in "$@"; do
     case $arg in
     --type=*)
          type=${arg#*=}
          ;;
     --filename=*)
     filename=${arg#*=}
          ;;
     --openinbrowser)
        openinbrowser=1
          ;;
     --delonexit)
        delonexit=1
        ;;
     --suffix-curdate)
        withCarDate=1
        ;;
     *)
     echo "Unknown argument: $arg"
     help
     exit 1
     ;;
     esac
    done

isStdOut=0; [ "$type" == "stdout" ] && isStdOut=1
isHtml=0; [ "$type" == "html" ] && isHtml=1

if [ $isHtml == 1 ]; then
    ext="html"
    args=" -H"
elif [ "$type" == "txt" ] ; then
    ext="txt"
    args=" "
fi

if [ $isStdOut != 1 ] && [ -z "$ext" ]; then
    echo "Invalid TYPE"
    help
    exit 1
fi

if [ $isStdOut == 0 ] && [ -z "$filename" ]; then
    echo "Missing FILENAME"
    help
    exit 1
fi

if [ $withCarDate == 1 ]; then
    filename+=_$(date +"%Y.%m.%d_%H-%M-%S")
fi

echo "SQL: $sql"

if [ $isStdOut == 1 ] ; then
    mysql-car -e "$sql;"
else
    filename+=.$ext
    mysql-car -e "$sql;" $args > $filename
    echo "Query saved to $filename."

    if [ $isHtml == 1 ]; then
        args=""

        if [ $delonexit == 1 ]; then
            args+="--delonexit"
        fi

        args+=" "

        if [ $openinbrowser == 1 ]; then
            args+="--openinbrowser"
        fi

        $(dirname "$0")/open-html-file-in-browser.sh $filename $args
    fi
fi

Модерирует : ShriEkeR
articlebot (03-11-2017 08:01): Новичок в GNU/Linux’е.	Версия для печати • Подписаться • Добавить в закладки
На первую страницу • к этому сообщению • к последнему сообщению