Subversion Repositories SmartDukaan

#!/bin/bash

# resolve links - $0 may be a softlink

PRG="$0"

if [ $# -ne 1 ]

then

    echo "Error - Invalid Arguments. Please enter itemid of ITEM table, which needs to be phased ot"

    exit

fi

ITEM_ID=$1

echo $ITEM_ID

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/apache-solr-1.4.0/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}"`

CATALOG_ID=`echo $CATALOG_ID | cut -c17-23`

#echo $CATALOG_ID

COUNT=`mysql -uroot -pshop2020 catalog -e"select count(*) from item where catalog_item_id = ${CATALOG_ID} and status not in(0)"`

COUNT=`echo $COUNT | cut -c9-20`

#echo $COUNT

if [ $COUNT -le 0 ]

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 "======================================================="

cd ${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