Subversion Repositories SmartDukaan

#!/bin/bash
if [ $# -ne 1 ]
then
    echo "Error - Invalid Arguments. Please enter itemid of ITEM table, which needs to be phased out"
    exit
fi
ITEM_ID=$1
echo $ITEM_ID

# resolve links - $0 may be a softlink
PRG="$0"
while [ -h "$PRG" ]; do
  ls=`ls -ld "$PRG"`
  link=`expr "$ls" : '.*-> \(.*\)$'`
  if expr "$link" : '/.*' > /dev/null; then
    PRG="$link"
  else
    PRG=`dirname "$PRG"`/"$link"
  fi
done

# Get standard environment variables
PRGDIR=`dirname $(readlink -f "$PRG")`

SOLR_DIR=/root/solr/example/exampledocs
CONTENT_EXPORT_PATH="/var/lib/tomcat6/webapps/export/html/"

echo "Updating mysql database for id $ITEM_ID"
echo "======================================================="
mysql -uroot -pshop2020 catalog -e"update item set status=0, status_description=\"This item has been phased out\" where id = ${ITEM_ID}"

CATALOG_ID=`mysql -uroot -pshop2020 catalog -e"select catalog_item_id from item where id = ${ITEM_ID}" | tail -1`
#echo $CATALOG_ID

COUNT=`mysql -uroot -pshop2020 catalog -e"select count(*) from item where catalog_item_id = ${CATALOG_ID} and status <> 0" | tail -1`
#echo $COUNT
if [ -z $COUNT ]
then
        echo "Not a single item is active or out of stock. Removing content from solr and removing item from website."

        echo "Deleting data from solr for entity id $CATALOG_ID"
        echo "======================================================="
        ${SOLR_DIR}/deleteOne.sh $CATALOG_ID
        echo "Done deleting data from solr for entity id $CATALOG_ID"


        echo "======================================================="
        echo "Removing content snippets for entity id $CATALOG_ID "
        echo "======================================================="
        cd ${CONTENT_EXPORT_PATH}
        rm -rf entities/$CATALOG_ID
        echo "Done removing content for entity id $CATALOG_ID"
        echo "======================================================="
fi
#TODO If there are still some items active, we should remove color from content. Solution is to regenerate content and update it.