#!/bin/bash
#
source /home/oracle/.bash_profile
NOW_DAY=`date +%Y-%m-%d`
date_from=`date +%Y%m%d000000 --date "-1 day"`
date_to=`date +%Y%m%d000000`
run_time=`date +%Y%m%d%H%M%S`
thisweek=`date '+%Y-%m-%d 00:00:00'`
lastweek=`date '+%Y-%m-%d 00:00:00' --date "-7 day"`
thisweek1=`date '+%m%d'`
lastweek1=`date '+%m%d' --date "-7 day"`
HOST_BINDIR="/data/scripts"
HOST_DATADIR="/data/scripts/data"
HOST_LOGDIR="/data/scripts/log"
db_info=$HOST_BINDIR/db.info
time1="$1"
time2="$2"
func_1()
{
$HOST_BINDIR/ociuldr_linux user=$db_name/$db_passwd@$db_host query="
select *
from TableA
where XXX" field=0x09 record=0x0a file=$HOST_DATADIR/$DATAFILE
}
while read db_name db_passwd db_host
do
thisdate=`date +%Y%m%d`
DATAFILE=""$thisdate"/"$name"_"
LOGFILE=$DATAFILE".log"
#func writelog
writelog() {
NOW=$(date +"%Y-%m-%d %H:%M:%S")
#echo "[$NOW] $@" >> $HOST_LOGDIR/$LOGFILE
}
runsql() {
TIME1=`date +%s`
writelog "start execute $_SQL"
#
#
#
func_1
#
TIME2=`date +%s`
TIME_EXPEND=$(($TIME2 - $TIME1))
writelog "end execute $_SQL"
writelog "cost $TIME_EXPEND seconds"
}
runsql
done < $db_info
#
source /home/oracle/.bash_profile
NOW_DAY=`date +%Y-%m-%d`
date_from=`date +%Y%m%d000000 --date "-1 day"`
date_to=`date +%Y%m%d000000`
run_time=`date +%Y%m%d%H%M%S`
thisweek=`date '+%Y-%m-%d 00:00:00'`
lastweek=`date '+%Y-%m-%d 00:00:00' --date "-7 day"`
thisweek1=`date '+%m%d'`
lastweek1=`date '+%m%d' --date "-7 day"`
HOST_BINDIR="/data/scripts"
HOST_DATADIR="/data/scripts/data"
HOST_LOGDIR="/data/scripts/log"
db_info=$HOST_BINDIR/db.info
time1="$1"
time2="$2"
func_1()
{
$HOST_BINDIR/ociuldr_linux user=$db_name/$db_passwd@$db_host query="
select *
from TableA
where XXX" field=0x09 record=0x0a file=$HOST_DATADIR/$DATAFILE
}
while read db_name db_passwd db_host
do
thisdate=`date +%Y%m%d`
DATAFILE=""$thisdate"/"$name"_"
LOGFILE=$DATAFILE".log"
#func writelog
writelog() {
NOW=$(date +"%Y-%m-%d %H:%M:%S")
#echo "[$NOW] $@" >> $HOST_LOGDIR/$LOGFILE
}
runsql() {
TIME1=`date +%s`
writelog "start execute $_SQL"
#
#
#
func_1
#
TIME2=`date +%s`
TIME_EXPEND=$(($TIME2 - $TIME1))
writelog "end execute $_SQL"
writelog "cost $TIME_EXPEND seconds"
}
runsql
done < $db_info