常用到的几个shell方法

最新推荐文章于 2024-09-27 15:36:37 发布

weixin_33961829

最新推荐文章于 2024-09-27 15:36:37 发布

阅读量84

点赞数

文章标签： shell awk python

原文链接：https://my.oschina.net/heartdong/blog/124092

版权

2019独角兽企业重金招聘Python工程师标准>>>

在公司经常用到的几个方法，做个备份

1:执行sql语句

function executeSql()
{
  sql="$1"  
  if [ "$sql" = "" ]
  then
    cat | mysql -uroot test --local-infile  -N -f
  else
    echo "$sql" | mysql -uroot test --local-infile  -N -f
  fi
}

2：产生序号

function range(){
  n="$1"
  if [ "$n" = "" ]
  then
    n=100
  fi
  len=`expr length $n - 1`
  echo "" | awk -F"\t" '{
    for(i=0;i<num;i++){
      printf("%0'${len}'d\n",i);
    }
  }' num=${n}
}

3：去掉字符串头尾空格

#示例：trim "abc "
function trim()
{
    echo "$1" | grep -o "[^ ]\+\( \+[^ ]\+\)*"
}

function initMethod()
{
  theDay="$1"
  if [ "$theDay" = "" ]
  then 
    theDay=`date +%Y%m%d -d "1 days ago "` 
  fi
  theDay2=`date +%Y-%m-%d -d "$theDay"` 
  theDayYesterday=`date +%Y%m%d -d "$theDay 1 days ago "`
  theDayNextDay=`date +%Y%m%d -d "$theDay 1 days"`
  theDayNextNextDay=`date +%Y%m%d -d "$theDay 2 days"`
  echo -e "\n\n `date +\"[ %F %T ] \"` `basename $0`" 
}

##分表联合
function createUnionSql()
{ 
  baseTableName="$1"
  range | while read num
  do
     echo "${baseTableName}_${num},"
  done
}


function createUnionTable()
{
  baseTableName="$1"
  unionSql=`createUnionSql "$1"`;
  unionSql=`echo $unionSql | awk '{print substr($0,0,length($0)-1)}'`
  sql="drop table if exists ${baseTableName};
       create table ${baseTableName} like ${baseTableName}_00;
       alter table ${baseTableName} engine=MRG_MyISAM DEFAULT CHARSET=gbk union=(${unionSql});"
  executeSql "$sql"
}

转载于:https://my.oschina.net/heartdong/blog/124092