SHELL
# 下载kibana6.2.2 镜像
docker pull docker.elastic.co/kibana/kibana:6.2.2
# 高亮
tail -f xls2csv.sh |perl -pe 's/(csv)/e[1;31m$1e[0m/g'
# grep 零宽断言
echo $x | ggrep -P "(?<=<id>)d+(?=</id>)"
# 统计bug,并根据计数排序
# $NF最后一列为创建时间 $NF-1为处理人
awk -F "," '/^(1|2|3)/{++time[$NF]} END {for(i in time) print time[i]," ",i}' bugs.csv | sort -t " " -k 2
## 查看 uat分支有提交 但是在测试上没有提交的内容
## grep -- 解决 grep: invalid option -- > 报错
## grep -Ri '->someFunction' 重现
for i in `git log --oneline |sed -E 's/^.{9}//g' | sed -e 's/^s+//'`
do
if [[ `glol release/dice | grep -- "$i" | wc -l` -eq 0 ]]; then
glol | grep -- "$i"
fi
done
# 查找测试es地址
kubectl get pod --all-namespaces -o wide | grep 'elasticsearch'
kubectl get pod terminus-elasticsearch-1 -n addon-elasticsearch--c812dbe51b02b47eaa2cea5e2ed7e8acb -o yaml | grep 'value: mobil-es-test'
# 启动es kibana
docker run -d -it -e ELASTICSEARCH_URL="http://9.166.228.212:9200" -p 5601:5601 --name es_test2 006eb7921543
## spark查询
[root@node-010005241032 ~]# kubectl get pod --all-namespaces -o wide | grep -i 'spark'
统计天数
#/bin/bash
file=$1
path=`echo $file |sed -E 's#(.*)/(.*)#1#'`
filename=`echo $file | sed -E 's#(.*)/(.*)#2#'`
if [ -z $file ]; then
echo "should input csv file path"
exit 1
fi
result=""
for i in `grep -E '^(d)' $file | sed -E 's/( )+//g'`
do
# echo "$i"
id=`echo $i | cut -d "," -f 1`
etime=`echo $i | awk -F "," '{print $(NF-2)}'`
stime=`echo $i | awk -F "," '{print $NF}'`
if [[ -z `echo $etime | grep -E '^(d)'` ]]; then
continue
fi
# echo "id = $id"
# echo "stime = $stime"
# echo "etime = $etime"
# s_y
# s_m
# s_d
time_s=`date -j -f "%Y-%m-%d" "$stime" "+%s"`
time_e=`date -j -f "%Y-%m-%d" "$etime" "+%s"`
# if [ "180315"="$id" ]; then
# echo "id = $id"
# echo "stime = $stime"
# echo "etime = $etime"
# break
# fi
use=$((($time_e-$time_s)/60/60/24))
result="$result
$id $use"
# echo "$id, $use"
# time_s=""
# time_e=""
done
echo $result > $path/tmp
grep -E '^(d)' $path/tmp > $path/tmp2
awk -F " " 'BEGIN {t0="<3";t3=">=3";t5=">=5";t10=">=10"} {if($2<3){s[t0]++} else if($2<5){s[t3]++}else if($2<10){s[t5]++}else s[t10]++} END {for (i in s) print i," ",s[i]} ' $path/tmp2