Subversion Repositories SmartDukaan

Rev

Rev 8858 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 8858 Rev 20404
Line 1... Line 1...
1 
#!/bin/bash
 1 
#!/bin/bash
2 
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
 2 
mysql -u root -pshop2020 -h 192.168.190.114 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
3 
sleep 2
 3 
sleep 2
4 
cp /tmp/popularity.json /tmp/popularity_bk.json
 4 
cp /tmp/popularity.json /tmp/popularity_bk.json
5 
sleep 2
 5 
sleep 2
6 
sed -i '1d' /tmp/popularity.json
 6 
sed -i '1d' /tmp/popularity.json
7 
sleep 2
 7 
sleep 2
8 
mysql -u root -pshop2020 -h 192.168.190.113 catalog -e "SET SESSION group_concat_max_len = 100000;select CONCAT('[', GROUP_CONCAT(id),']') from item where status=6;" > /tmp/availability.json
 8 
mysql -u root -pshop2020 -h 192.168.190.114 catalog -e "SET SESSION group_concat_max_len = 100000;select CONCAT('[', GROUP_CONCAT(id),']') from item where status=6;" > /tmp/availability.json
9 
sleep 2
 9 
sleep 2
10 
cp /tmp/availability.json /tmp/availability_bk.json
 10 
cp /tmp/availability.json /tmp/availability_bk.json
11 
sleep 2
 11 
sleep 2
12 
sed -i '1d' /tmp/availability.json
 12 
sed -i '1d' /tmp/availability.json
13 
sleep 2
 13 
sleep 2