Subversion Repositories SmartDukaan

Rev

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

Rev 2175 Rev 2474
Line 49... Line 49...
49 
echo "======================================================="
 49 
echo "======================================================="
50 
/etc/init.d/tomcat6 stop
 50 
/etc/init.d/tomcat6 stop
51 
 
 51 
 
52 
echo "Generating the icons and thumbnails for all Entitites"
 52 
echo "Generating the icons and thumbnails for all Entitites"
53 
echo "======================================================="
 53 
echo "======================================================="
54 
cd /var/lib/tomcat6/webapps/db/media/
 54 
#cd /var/lib/tomcat6/webapps/db/media/
55 
python2.6 ImageConverter.py default.jpg icon.jpg 120 120
 55 
#python2.6 ImageConverter.py default.jpg icon.jpg 120 120
56 
python2.6 ImageConverter.py default.jpg thumbnail.jpg 60 60
 56 
#python2.6 ImageConverter.py default.jpg thumbnail.jpg 60 60
57 
echo "Icons and thumbnails generated"
 57 
echo "Icons and thumbnails generated"
58 
echo "======================================================="
 58 
echo "======================================================="
59 
 
 59 
 
60 
 
 60 
 
61 
echo "Generating content for one entities ${PROJECT_DIR}"
 61 
echo "Generating content for one entities ${PROJECT_DIR}"
Line 70... Line 70...
70 
echo "Tomcat restarted at `date +%c`"
 70 
echo "Tomcat restarted at `date +%c`"
71 
 
 71 
 
72 
echo "Dumping item, vendoritemmapping and vendoritempricing tables to be imported on staging and production servers"
 72 
echo "Dumping item, vendoritemmapping and vendoritempricing tables to be imported on staging and production servers"
73 
echo "======================================================="
 73 
echo "======================================================="
74 
cd ${PRGDIR}
 74 
cd ${PRGDIR}
75 
mysql -uroot -pshop2020 catalog -e "SELECT CONCAT('UPDATE item SET id=',id,',product_group=',product_group,',brand=',brand,',model_number=',model_number,',model_name=',model_name,',color=',color,',category=',category,',comments=',comments,',catalog_item_id=',catalog_item_id,',feature_id=',feature_id,',feature_description=',feature_description,',mrp=',mrp,',mop=',mop,',sellingPrice=',sellingPrice,',dealerPrice=',dealerPrice,',transfer_price=',transfer_price,',weight=',weight,',addedOn=',addedOn,',updatedOn=',updatedOn,',startDate=',startDate,',retireDate=',retireDate,',status=',status,',status_description=',status_description,',bestDealText=',bestDealText,',bestDealValue=',bestDealValue,',bestSellingRank=',bestSellingRank,',hotspotCategory=',hotspotCategory,',defaultForEntity=',defaultForEntity,',preferredWarehouse=',preferredWarehouse,' WHERE ID=', id) FROM item WHERE catalog_item_id = ${ENTITY_ID}" | tail -n+2 > ${MYSQL_DUMP}
 75 
#mysql -uroot -pshop2020 catalog -e "SELECT CONCAT('UPDATE item SET id=',id,',product_group=',product_group,',brand=',brand,',model_number=',model_number,',model_name=',model_name,',color=',color,',category=',category,',comments=',comments,',catalog_item_id=',catalog_item_id,',feature_id=',feature_id,',feature_description=',feature_description,',mrp=',mrp,',mop=',mop,',sellingPrice=',sellingPrice,',dealerPrice=',dealerPrice,',transfer_price=',transfer_price,',weight=',weight,',addedOn=',addedOn,',updatedOn=',updatedOn,',startDate=',startDate,',retireDate=',retireDate,',status=',status,',status_description=',status_description,',bestDealText=',bestDealText,',bestDealValue=',bestDealValue,',bestSellingRank=',bestSellingRank,',hotspotCategory=',hotspotCategory,',defaultForEntity=',defaultForEntity,',preferredWarehouse=',preferredWarehouse,' WHERE ID=', id) FROM item WHERE catalog_item_id = ${ENTITY_ID}" | tail -n+2 > ${MYSQL_DUMP}
76 
cat ${MYSQL_DUMP}
 76 
cat ${MYSQL_DUMP}
77 
#mysqldump -uroot -pshop2020 catalog --tables item vendoritemmapping vendoritempricing > ${MYSQL_DUMP}
 77 
#mysqldump -uroot -pshop2020 catalog --tables item vendoritemmapping vendoritempricing > ${MYSQL_DUMP}
78 
#TODO Read data of only this catalog id and prepare some UPDATE statements. These statements should be executed on production  server
 78 
#TODO Read data of only this catalog id and prepare some UPDATE statements. These statements should be executed on production  server
79 
 
 79 
 
80 
echo "Copying generated content to staging and production servers"
 80 
echo "Copying generated content to staging and production servers"
81 
echo "======================================================="
 81 
echo "======================================================="
82 
#Update media content on both staging and production
 82 
#Update media content on both staging and production
83 
cd /var/lib/tomcat6/webapps/export
 83 
cd /var/lib/tomcat6/webapps/export
84 
rm -f media.tgz
 84 
#rm -f media.tgz
85 
mkdir media-${DATE}
 85 
#mkdir media-${DATE}
86 
cp -r media/${ENTITY_ID} media-${DATE}/; tar -zcf media.tgz media-${DATE}; rm -rf media-${DATE}
 86 
#cp -r media/${ENTITY_ID} media-${DATE}/; tar -zcf media.tgz media-${DATE}; rm -rf media-${DATE}
87 
scp media.tgz ${STAGING_SERVER}:/var/lib/tomcat6/webapps/export/
 87 
#scp media.tgz ${STAGING_SERVER}:/var/lib/tomcat6/webapps/export/
88 
scp media.tgz ${PROD_SERVER}:/var/lib/tomcat6/webapps/export/
 88 
#scp media.tgz ${PROD_SERVER}:/var/lib/tomcat6/webapps/export/
89 
scp media.tgz ${STATIC_SERVER}:/var/www/
 89 
#scp media.tgz ${STATIC_SERVER}:/var/www/
90 
 
 90 
 
91 
#Update entities on staging using the entities-shop2020 direcotry
 91 
#Update entities on staging using the entities-shop2020 direcotry
92 
#Update entities on production using the entities-saholic directory
 92 
#Update entities on production using the entities-saholic directory
93 
cd /var/lib/tomcat6/webapps/export/html
 93 
#cd /var/lib/tomcat6/webapps/export/html
94 
mkdir entities-${DATE}
 94 
#mkdir entities-${DATE}
95 
rm -f ${STAGING_ENTITIES_EXPORT_PATH}.tgz ${PROD_ENTITIES_EXPORT_PATH}.tgz
 95 
#rm -f ${STAGING_ENTITIES_EXPORT_PATH}.tgz ${PROD_ENTITIES_EXPORT_PATH}.tgz
96 
cp -r ${STAGING_ENTITIES_EXPORT_PATH}/${ENTITY_ID} entities-${DATE}/
 96 
#cp -r ${STAGING_ENTITIES_EXPORT_PATH}/${ENTITY_ID} entities-${DATE}/
97 
tar -zcf ${STAGING_ENTITIES_EXPORT_PATH}.tgz entities-${DATE}
 97 
#tar -zcf ${STAGING_ENTITIES_EXPORT_PATH}.tgz entities-${DATE}
98 
rm -rf entities-${DATE}
98 
#rm -rf entities-${DATE}
99 
 
 99 
 
100 
mkdir entities-${DATE}
 100 
#mkdir entities-${DATE}
101 
cp -r ${PROD_ENTITIES_EXPORT_PATH}/${ENTITY_ID} entities-${DATE}
 101 
#cp -r ${PROD_ENTITIES_EXPORT_PATH}/${ENTITY_ID} entities-${DATE}
102 
tar -zcf ${PROD_ENTITIES_EXPORT_PATH}.tgz entities-${DATE}
 102 
#tar -zcf ${PROD_ENTITIES_EXPORT_PATH}.tgz entities-${DATE}
103 
rm -rf entities-${DATE}
103 
#rm -rf entities-${DATE}
104 
 
 104 
 
105 
scp ${STAGING_ENTITIES_EXPORT_PATH}.tgz ${STAGING_SERVER}:${ENTITIES_DEST_PATH}
 105 
#scp ${STAGING_ENTITIES_EXPORT_PATH}.tgz ${STAGING_SERVER}:${ENTITIES_DEST_PATH}
106 
scp ${PROD_ENTITIES_EXPORT_PATH}.tgz ${PROD_SERVER}:${ENTITIES_DEST_PATH}
 106 
#scp ${PROD_ENTITIES_EXPORT_PATH}.tgz ${PROD_SERVER}:${ENTITIES_DEST_PATH}
107 
 
 107 
 
108 
#Update solr data on staging and production servers
 108 
#Update solr data on staging and production servers
109 
scp ${SOLR_IRDATA}.xml ${STAGING_SERVER}:${SOLR_IRDATA}-${DATE}.xml
 109 
#scp ${SOLR_IRDATA}.xml ${STAGING_SERVER}:${SOLR_IRDATA}-${DATE}.xml
110 
scp ${SOLR_IRDATA}.xml ${PROD_SERVER}:${SOLR_IRDATA}-${DATE}.xml
 110 
#scp ${SOLR_IRDATA}.xml ${PROD_SERVER}:${SOLR_IRDATA}-${DATE}.xml
111 
 
 111 
 
112 
#Put mysql dump on staging and production servers
 112 
#Put mysql dump on staging and production servers
113 
scp ${MYSQL_DUMP} ${STAGING_SERVER}:/catalog-dumps
 113 
#scp ${MYSQL_DUMP} ${STAGING_SERVER}:/catalog-dumps
114 
scp ${MYSQL_DUMP} ${PROD_SERVER}:/catalog-dumps
 114 
#scp ${MYSQL_DUMP} ${PROD_SERVER}:/catalog-dumps
115 
 
 115 
 
116 
ssh ${STAGING_SERVER} "echo ${DATE}>/catalog-dumps/latest.timestamp"
 116 
#ssh ${STAGING_SERVER} "echo ${DATE}>/catalog-dumps/latest.timestamp"
117 
ssh ${PROD_SERVER} "echo ${DATE}>/catalog-dumps/latest.timestamp"
 117 
#ssh ${PROD_SERVER} "echo ${DATE}>/catalog-dumps/latest.timestamp"
118 
ssh ${STATIC_SERVER} "echo ${DATE}>/catalog-dumps/latest.timestamp"
 118 
#ssh ${STATIC_SERVER} "echo ${DATE}>/catalog-dumps/latest.timestamp"
119 
 
 119 
 
120 
echo "Done copying content to staging and production servers"
 120 
echo "Done copying content to staging and production servers"
121 
echo "======================================================="
 121 
echo "======================================================="