port=3128
BUILD="PROTO_2"
DOCUMENT="./index/"
DOCUMENT_PATH="$DOCUMENT$BUILD"
CSV_PATH="./CSV/"
TITLE="Script:"

# csv file define:
PANTHER="PANTHER.csv"
PANTHER_SKU="PANTHER_SKU.csv"

# python path define:
crawler="./crawler/craw_Nimbus.py"
transfer="./PDBOM/BOM_PD.py"
compare="./PDBOM/PD_CK.py"

function python_exec(){
  sudo python $path
  if [ $? -eq 254 ]; then
     echo "$TITLE The BM VERSION is the same with server record.(Errorlevel = $?)"
     echo -e "\n"
     exit
  fi  

  if [ $? -ne 0 ]; then
     echo "$TITLE error execute $path Script stop.(ErrorLevel = $?)"
     echo -e "\n"
     exit
  fi
}

ckport=$(netstat -tuln | grep ":$port ")
if [ "$ckport" == "" ]; then
    echo "$TITLE Enable Automatically Proxy 'cntlm -v."
    sudo cntlm -v & 
    sleep 1
else
    echo "$TITLE Automatically Proxy is in running."
fi

echo "$TITLE Start Download and Transfer Nimbus .xlsx file."
path=$crawler
python_exec

path=$transfer
python_exec

test -d $DOCUMENT_PATH && echo "$TITLE exist $DOCUMENT_PATH" && ret_d=1 || echo "$TITLE Not exist $DOCUMENT_PATH"
if [ "$ret_d" -eq 1 ]; then
    test -f $PANTHER -a -f $PANTHER_SKU && echo "$TITLE exist $PANTHER and $PANTHER_SKU" && ret_f=1 || echo "$TITLE not exist $PANTHER and $PANTHER_SKU"
        if [ "$ret_f" -eq 1 ]; then
	          echo "$TITLE Compare new and old files."
	          path=$compare
            python_exec
	      else
	          echo "$TITLE Script stop."
            echo -e "\n"
            exit
	      fi
else
    echo "$TITLE test command return code ret_d variable = $ret_d"
    echo "$TITLE create new build document $BUILD at $DOCUMENT"
    mkdir -p $DOCUMENT_PATH
    test -f $PANTHER -a -f $PANTHER_SKU && echo "$TITLE exist $PANTHER and $PANTHER_SKU" && ret_f=1 || echo "$TITLE not exist $PANTHER and $PANTHER_SKU"
        if [ "$ret_f" -eq 1 ]; then
            echo "$TITLE Compare new and old files."
            path=$compare
            python_exec
        else
            echo "$TITLE Script stop."
            echo -e "\n"
            exit
        fi
fi

echo "$TITLE copy $PANTHER and $PANTHER_SKU to $DOCUMENT_PATH"
sudo cp $PANTHER $PANTHER_SKU $DOCUMENT_PATH
echo "$TITLE move $PANTHER and $PANTHER_SKU to $CSV_PATH"
sudo mv $PANTHER $PANTHER_SKU $CSV_PATH

echo "$TITLE ok"
echo -e "\n"
exit

@property
def get_version(self):
    """
    get version
    """
    driver = self._nimbus_login
    wait = WebDriverWait(driver, 3600)
    try:
        self.version = self.logged_status(driver=driver, wait=wait)
    except Exception as e:
        raise e
    finally:
        driver.close()
        if self.virtual: self.display.stop()
    return self.version

def download_file(self, version):
    """process:
        1. Check document empty(clean)
        2. Download
        3. After finish, check file exist
        4. close browser
    ret: OrderedDict()
    """
    try:
        self.remove_file()  # clean .xlsx file.
    except Exception as e:
        raise e

    driver = self._nimbus_login
    wait = WebDriverWait(driver, 60)
    
    try:
        self.version = self.logged_status(driver=driver, wait=wait)
        if self.version == version:
            logger.info('version not change')
            ret = OrderedDict((('ret', 255), ('status', 'version not change.'), ('version', self.version)))
        elif self.version == None:
            logger.info('version is None, maybe Build matrix not online.')
            ret = OrderedDict((('ret', 255), \
                               ('status', 'version is None, \
                                 maybe Build matrix not online.'), \
                               ('version', self.version)))
        if self.virtual:
            self.display.stop()
        driver.close()
        driver.quit()
        return ret
    except Exception as e:
        raise e

from django_q.tasks import async, result, Async

from math import copysign

# create the task
async('math.copysign', 2, -2)

# or with import and storing the id
task_id = async(copysign, 2, -2)

# get the result
task_result = result(task_id)

# result returns None if the task has not been executed yet
# you can wait for it
task_result = result(task_id, 200)

# but in most cases you will want to use a hook:
async('math.modf', 2.5, hook='radars.hooks.print_result')

from django_q.tasks import async, result, Async

from math import copysign

# instantiate an async task
a = Async('math.floor', 1.5, group='math')

# you can set or change keywords afterwards
a.cached = True

# run it
a.run()

# change the args
a.args = (2.5,)

# run it again
a.run()

# wait max 10 seconds for the result and print it
print(a.result(wait=10))