Subversion Repositories SmartDukaan

Rev

Rev 13498 | Rev 13502 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 13498 Rev 13501
Line 65... Line 65...
65 
 
 65 
 
66 
if [ -z $a1 ]
 66 
if [ -z $a1 ]
67 
then
 67 
then
68 
	echo "a1 is empty"
 68 
	echo "a1 is empty"
69 
else
 69 
else
- 
 
 70 
	echo "All ites - $a1"
70 
	mysqldump -uroot -pshop2020 catalog item --replace --no-create-info --where="id in ($a1)" >> ${MYSQL_DUMP}
 71 
	mysqldump -uroot -pshop2020 catalog item --replace --no-create-info --where="id in ($a1)" >> ${MYSQL_DUMP}
71 
	if [ "$1" == "PROD" ]
 72 
	if [ "$1" == "PROD" ]
72 
	then
 73 
	then
73 
		mysql -uroot -pshop2020 catalog -e "truncate tmpitem;insert into tmpitem AS (SELECT * FROM item)"
 74 
		mysql -uroot -pshop2020 catalog -e "truncate tmpitem;insert into tmpitem SELECT * FROM item"
74 
	else
 75 
	else
75 
		mysql -uroot -pshop2020 catalog -e "delete from tmpitem where id not in ($a1);insert ignore into tmpitem SELECT * FROM item"
 76 
		mysql -uroot -pshop2020 catalog -e "delete from tmpitem where id not in ($a1);insert ignore into tmpitem SELECT * FROM item"
76 
	fi
 77 
	fi
77 
fi
 78 
fi
78 
 
 79 
 
Line 219... Line 220...
219 
ssh ${STAGING_SERVER} "echo ${DATE}>/catalog-dumps/latest.timestamp"
 220 
ssh ${STAGING_SERVER} "echo ${DATE}>/catalog-dumps/latest.timestamp"
220 
ssh ${STORE_SERVER} "echo ${DATE}>/catalog-dumps/latest.timestamp"
 221 
ssh ${STORE_SERVER} "echo ${DATE}>/catalog-dumps/latest.timestamp"
221 
ssh ${SUPPORT_SERVER} "echo ${DATE}>/catalog-dumps/latest.timestamp"
 222 
ssh ${SUPPORT_SERVER} "echo ${DATE}>/catalog-dumps/latest.timestamp"
222 
for PROD_SERVER in ${PROD_SERVERS}
 223 
for PROD_SERVER in ${PROD_SERVERS}
223 
do
 224 
do
224 
	ssh ${PROD_SERVER} "echo ${DATE}>/catalog-dumps/latest.timestamp;echo ${a1}>/catalog-dumps/catalog-items"
 225 
	ssh ${PROD_SERVER} "echo ${DATE}>/catalog-dumps/latest.timestamp;echo ${a1}>/catalog-dumps/catalog.items"
225 
done
 226 
done
226 
 
 227 
 
227 
for STATIC_SERVER in ${STATIC_SERVERS}
 228 
for STATIC_SERVER in ${STATIC_SERVERS}
228 
do
 229 
do
229 
	ssh ${STATIC_SERVER} "echo ${DATE}>/catalog-dumps/latest.timestamp"
 230 
	ssh ${STATIC_SERVER} "echo ${DATE}>/catalog-dumps/latest.timestamp"