offerids="1954,1955"
while
select concat('"',group_concat(campaign_id separator ' '),'"') from tab_campaign where offer_id in (${offerids})
mlog "${campids}" conver "$(anyseqtr 1 30)" 11 0 campaign_id,s1,n_id,type
mlogold "${campids}" conver "$(anyseqtr 1 30)" 11 0 campaign_id,s1,n_id,type
for id in ${campids}
do
cat 12offer_old/${id}*all 12offer_new/${id}*all > 12offer_total/${id}_total
done
for file in $(ls)
do
linenum=$(lines ${file})
echo ${file/_total/} : ${linenum} >> ../12offer_sums/allCampidSumConversions
done
for file in $(ls)
do
linenum=$(lines ${file})
echo "total " ${file/_total/} : ${linenum} >> ../12offer_sums/allCampidSumConversions_s1_total_ok
awk '{match($0,/("_id":"[^_]*?)_/,id);match($0,/("s1":"[^"]*?")/,a);x[a[1]]++}END{for(i in x){print id[1],",",i,",",x[i]}}' ${file} >> ../12offer_sums/allCampidSumConversions_s1_total_ok
done
for file in $(ls)
do
awk '/"type":"normal"/' ${file} >> ../12offer_normal/${file/_total/}_normal
done
for file in $(ls)
do
linenum=$(lines ${file})
echo "total " ${file/_normal/} : ${linenum} >> ../12offer_sums/allCampidSumConversions_s1_normal
awk '{match($0,/("_id":"[^_]*?)_/,id);match($0,/("s1":"[^"]*?")/,a);x[a[1]]++}END{for(i in x){print id[1],",",i,",",x[i]}}' ${file} >> ../12offer_sums/allCampidSumConversions_s1_normal
done
2018-01-15 bash s1 report note
最后编辑于 ：
©著作权归作者所有,转载或内容合作请联系作者
- 文/潘晓璐 我一进店门，熙熙楼的掌柜王于贵愁眉苦脸地迎上来，“玉大人，你说我怎么就摊上这事。” “怎么了？”我有些...
- 文/花漫 我一把揭开白布。 她就那样静静地躺着，像睡着了一般。 火红的嫁衣衬着肌肤如雪。 梳的纹丝不乱的头发上，一...
- 文/苍兰香墨 我猛地睁开眼，长吁一口气：“原来是场噩梦啊……” “哼！你这毒妇竟也来了？” 一声冷哼从身侧响起，我...
推荐阅读更多精彩内容
- offerids="1954,1955"select concat('"',group_concat(campai...
- /drives/f/cygwin64/bin/date -d "$((0-(-1))) months ago" +...
- 文章脉络分析 Student: So, Professor Baker, about our next assig...
- 最近在看performance的问题，然后吸收了点oracle相关的知识。就是下面这本书。不知哪位前辈留下的，拿来...
