#!/bin/sh
user=nl_ul_dev
port=4000
host=10.160.15.38
database=nl_ul_dev
basepath=/app/dcits/pers/test
dateFile=`date +%s%N`
dateDir=`date +%Y%m%d`
path=$basepath/$dateDir
pageSize=100000
tmpfile=/tmp/tmp_result.txt
export MYSQL_PWD=nl_ul_dev
count=-1
if [ $# -ne 1 ]
then
  echo "the argument is not ok!"
  exit -1
fi
if [ ! -d $path ]; then
    mkdir $path
fi
> $path/$dateFile.txt
> $tmpfile
while true 
do
  let "count++"
  let pageIndex=($count)*$pageSize
  mysql -u $user -P $port  -D $database -h $host -Ns -e "$1 limit $pageIndex, $pageSize"|sed "s/\t/|/g" > $tmpfile 
  if [ ! -s $tmpfile ]
  then
        echo 'All data loaded'
        break
  fi
  echo "$1 limit $pageIndex, $pageSize"
  cat $tmpfile >> $path/$dateFile.txt
done

echo "path:"$path\/$dateFile.txt