shell脚本模板

来源：互联网发布：python gnu getopt 编辑：程序博客网时间：2024/06/05 17:17
#!/bin/shDATABASE="dpi_audit_db"SQL_TABLE="`pwd`/dpi_audit.sqlite"create_db(){sqlite3 $DATABASE  <<EOF.read $SQL_TABLE.head onselect * from access_log;select * from audit_log;.quitEOF}insert_db(){sqlite3 $DATABASE  <<EOFinsert into access_log(t_start,t_stop,src_ip,src_port,dst_ip,dst_port,proto,up_pkts,up_bytes,down_pkts,down_bytes,app_name,detail,id) values(1502003304,1502003352,'10.8.4.9',58101,'10.8.4.3',22,6,138,13916,0,0,'SSH','',NULL);insert into access_log(t_start,t_stop,src_ip,src_port,dst_ip,dst_port,proto,up_pkts,up_bytes,down_pkts,down_bytes,app_name,detail,id) values(1502003304,1502003352,'10.8.4.9',58101,'10.8.4.3',80,17,138,13916,0,0,'http','',NULL);insert into audit_log(t_start,t_stop,src_ip,src_port,dst_ip,dst_port,proto,app_name,detail,id) values(1502003304,1502003352,'10.8.4.9',58101,'10.8.4.3',22,6,'SSH','',NULL);.head onselect * from access_log;select * from audit_log;.quitEOF}show_db(){sqlite3 $DATABASE  <<EOF.head onselect * from access_log;select * from audit_log;.quitEOF}delete_db(){    rm -rvf $DATABASE}if [ $# == 0 ] ; then    echo "-------------------------------------------------------------"    echo "usage: $0 create|show|insert|delete"    exit 0;fiif [ $# == 1 ] ; then  case "$1" in    'create')        create_db    ;;    'show')        show_db    ;;    'insert')        insert_db    ;;    'delete')        delete_db    ;;  *)  echo "usage: $0 create|show|insert|delete"  exit 0;  esacfi
阅读全文
0 0