manyi/script/db/dump/dumpdata.sh

#!/bin/bash

year=

while getopts ":y:m:" opt
do
    case $opt in 
        y)
        year=$OPTARG
        ;;
        m)
        month=$OPTARG
        ;;
        ?)
        echo "usage: dumpdata -y=2019 -m=2"
        exit 1;;
    esac
done

if [ ! -n "$year" ]; then
    echo "no year paramerter"
    exit 1
fi

if [ ! -n "$month" ]; then
    output="`pwd`/dump/${year}"
    rm -rf $output
    mkdir -p $output

    start_day="${year}-01-01"
    start_ts=`date -u -d ${start_day} +%s`000
    start_month="${year}-01"

    next_year=`expr ${year} + 1`

    end_day="${next_year}-01-01"
    end_ts=`date -u -d ${end_day} +%s`000
    end_month="${next_year}-01"

    echo $start_day
    echo $start_ts
    echo $start_month
    echo $year

    echo $end_day
    echo $end_ts
    echo $end_month
    echo $next_year
else
    start_month=`printf "%02d" ${month}`
    start_year=${year}

    next_month=`expr ${month} + 1`
    if [ $next_month -gt 12 ]; then
        end_month="01"
        end_year=`expr ${year} + 1`
    else
        end_month=`printf "%02d" ${next_month}`
        end_year=${year}
    fi

    start_day="${start_year}-${start_month}-01"
    start_ts=`date -u -d ${start_day} +%s`000

    end_day="${end_year}-${end_month}-01"
    end_ts=`date -u -d ${end_day} +%s`000

    echo $start_day
    echo $start_ts
    echo $start_month
    echo $start_year

    echo $end_day
    echo $end_ts
    echo $end_month
    echo $end_year

    echo "`pwd`/dump/${start_year}_${start_month}_01-${end_year}_${end_month}_01"
    
    output="`pwd`/dump/${start_year}_${start_month}_01-${end_year}_${end_month}_01"
    rm -rf $output
    mkdir -p $output
fi

mongodump --authenticationMechanism=SCRAM-SHA-1 --authenticationDatabase=admin --host 172.16.69.131 --port 27228 -u guanli -p 75558195de6ac016bb15c05d07e08024 -d report -c dealer_income_proxies -q='{"$and": [{"dateTimeAdded": {"$gte":{"$date": {"$numberLong": "'${start_ts}'"}}}}, {"dateTimeAdded": {"$lt": {"$date": {"$numberLong": "'${end_ts}'"}}}}]}' --gzip -o ${output}
mongodump --authenticationMechanism=SCRAM-SHA-1 --authenticationDatabase=admin --host 172.16.69.131 --port 27228 -u guanli -p 75558195de6ac016bb15c05d07e08024 -d report -c dealer_daily_stats -q='{"$and": [{"date": {"$gte": "'${start_day}'"}}, {"date": {"$lt": "'${end_day}'"}}]}' --gzip -o ${output}
mongodump --authenticationMechanism=SCRAM-SHA-1 --authenticationDatabase=admin --host 172.16.69.131 --port 27228 -u guanli -p 75558195de6ac016bb15c05d07e08024 -d report -c device_daily_stats -q='{"$and": [{"date": {"$gte": "'${start_day}'"}}, {"date": {"$lt": "'${end_day}'"}}]}' --gzip -o ${output}
mongodump --authenticationMechanism=SCRAM-SHA-1 --authenticationDatabase=admin --host 172.16.69.131 --port 27228 -u guanli -p 75558195de6ac016bb15c05d07e08024 -d report -c group_daily_stats -q='{"$and": [{"date": {"$gte": "'${start_day}'"}}, {"date": {"$lt": "'${end_day}'"}}]}' --gzip -o ${output}

mongodump --authenticationMechanism=SCRAM-SHA-1 --authenticationDatabase=admin --host 172.16.69.131 --port  27228 -u guanli -p 75558195de6ac016bb15c05d07e08024  -d report -c DealerReport -q='{"$and": [{"date": {"$gte": "'${start_day}'"}}, {"date": {"$lt": "'${end_day}'"}}]}' --gzip -o ${output}
mongodump --authenticationMechanism=SCRAM-SHA-1 --authenticationDatabase=admin --host 172.16.69.131 --port  27228 -u guanli -p 75558195de6ac016bb15c05d07e08024  -d report -c DevReport -q='{"$and": [{"date": {"$gte": "'${start_day}'"}}, {"date": {"$lt": "'${end_day}'"}}]}' --gzip -o ${output}
mongodump --authenticationMechanism=SCRAM-SHA-1 --authenticationDatabase=admin --host 172.16.69.131 --port  27228 -u guanli -p 75558195de6ac016bb15c05d07e08024  -d report -c GroupReport -q='{"$and": [{"date": {"$gte": "'${start_day}'"}}, {"date": {"$lt": "'${end_day}'"}}]}' --gzip -o ${output}

mongodump --authenticationMechanism=SCRAM-SHA-1 --authenticationDatabase=admin --host 172.16.69.131 --port 27228 -u guanli -p 75558195de6ac016bb15c05d07e08024 -d washpay -c RechargeRecord -q='{"$and": [{"dateTimeAdded": {"$gte":{"$date": {"$numberLong": "'${start_ts}'"}}}}, {"dateTimeAdded": {"$lt": {"$date": {"$numberLong": "'${end_ts}'"}}}}]}' --gzip -o ${output}
mongodump --authenticationMechanism=SCRAM-SHA-1 --authenticationDatabase=admin --host 172.16.69.131 --port 27228 -u guanli -p 75558195de6ac016bb15c05d07e08024 -d washpay -c ConsumeRecord -q='{"$and": [{"dateTimeAdded": {"$gte":{"$date": {"$numberLong": "'${start_ts}'"}}}}, {"dateTimeAdded": {"$lt": {"$date": {"$numberLong": "'${end_ts}'"}}}}]}' --gzip -o ${output}