Subversion Repositories SmartDukaan

#!/bin/bash

if [ $# -ne 3 ]
then
        echo "Usage: $0 <master_affiliate_name> <affiliate_name> <affiliate_url>"
        exit  1
fi

MASTER_AFF_NAME=$1
AFF_NAME=$2
AFF_URL=$3

mysql -uroot -pshop2020 -h192.168.190.114 user -e "insert into affiliate(master_affiliate_id, name, url, added_on) values((select id from masteraffiliate where name = '${MASTER_AFF_NAME}'), '${AFF_NAME}', '${AFF_URL}', now());" 
mysql -uroot -pshop2020 -h192.168.190.114 user -e "SELECT * FROM affiliate where name = '${AFF_NAME}';"