Subversion Repositories SmartDukaan

#!/bin/bash

mysql -u root -pshop2020 -h 192.168.190.113 user -e "SET SESSION group_concat_max_len = 100000;select CONCAT('{',GROUP_CONCAT(a.itemId,':',a.c),'}') from (select itemId, floor(count(*)/greatest(1,datediff(now(), min(addedOn)))*100) 'c' from userwidgetitem where addedOn > DATE_SUB(now(),INTERVAL 30 DAY) group by itemId) as a;" > /tmp/popularity.json

sleep 2

cp /tmp/popularity.json /tmp/popularity_bk.json

sleep 2

sed -i '1d' /tmp/popularity.json

sleep 2

scp /tmp/popularity.json root@staging:/var/lib/tomcat6/webapps/export/