45 lines
1.2 KiB
Bash
Executable file
45 lines
1.2 KiB
Bash
Executable file
#!/bin/bash
|
|
|
|
set -eu
|
|
umask 007
|
|
source kiffa.conf
|
|
|
|
DB=${1?No hay arg1: nombre BDD}
|
|
TABLELIST=${2?No hay arg2: lista tablas}
|
|
|
|
#TF se pasa por el entorno y es 'now' o el timeframe para iniciar la lectura en el formato de $(date)
|
|
#DB=db_trebol_recabarren
|
|
# DB es el primer argumento
|
|
#TABLELIST es el segundo argumento
|
|
|
|
TF=${TF:-TF}
|
|
echo 0 ${TF}
|
|
FECHA=$(date -d "${TF}" '+%Y-%m-%d')
|
|
echo 1 ${FECHA}
|
|
|
|
# produccion
|
|
INICIO=$(date -d '${TF} - 1 hour' '+%Y-%m-%d %H:00:00')
|
|
FIN=$(date -d '${TF} - 1 hour' '+%Y-%m-%d %H:59:59')
|
|
SUFF=$(date -d '{TF} - 1 hour' '+%Y%m%d-%H')
|
|
W="bof_fecha = CURRENT_DATE AND (creado BETWEEN '${INICIO}' AND '${FIN}') ORDER BY creado ASC"
|
|
|
|
# pruebas
|
|
#INICIO=$(date -d "${TF} - 1 hour" '+%H:00:00')
|
|
#FIN=$(date -d "${TF} - 1 hour" '+%H:59:59')
|
|
#SUFF=$(date -d "${TF} - 1 hour" '+%Y%m%d-%H')
|
|
#W="bof_fecha = '${FECHA}' AND (bof_hora BETWEEN '${INICIO}' AND '${FIN}') ORDER BY bof_hora ASC"
|
|
|
|
# --
|
|
|
|
DB=${1}
|
|
mkdir -p ${DESTDIR}/${DB}
|
|
echo $W
|
|
while read -r TABLENAME; do
|
|
#echo $HORARIO
|
|
mysqldump -h ${HOST} --port ${PORT} -u ${USER} -p${PASS} \
|
|
--compact -t --disable-extended-insert --skip-tz-utc \
|
|
--where="${W}" \
|
|
${DB} ${TABLENAME} > ${DESTDIR}/${DB}/${TABLENAME}.${SUFF}.sql;
|
|
echo ${DESTDIR}.${DB}.${TABLENAME};
|
|
done < ${TABLELIST}
|
|
|