#!/bin/bash

FROM=$(date +%Y-%m-%d --date='-1 month')
echo "remove data before $FROM"

CMD="docker exec -t rtls_postgres_1 psql -U postgres -c \"delete from rtls_pu.rtls_tag_blink where time < '$FROM';\""
echo "$CMD"
eval $CMD

CMD="docker exec -t rtls_postgres_1 psql -U postgres -c \"delete from rtls_pu.rtls_mileage where time < '$FROM';\""
echo "$CMD"
eval $CMD

CMD="docker exec -t rtls_postgres_1 psql -U postgres -c \"delete from rtls_pu.rtls_tag_sensor where time < '$FROM';\""
echo "$CMD"
eval $CMD

CMD="docker exec -t rtls_postgres_1 psql -U postgres -c \"delete from rtls_pu.rtls_event where time < '$FROM';\""
echo "$CMD"
eval $CMD

CMD="docker exec -t rtls_postgres_1 psql -U postgres -c \"delete from rtls_pu.rtls_area_log where start_time < '$FROM';\""
echo "$CMD"
eval $CMD

echo "vacuum..."
docker exec -t rtls_postgres_1 psql -U postgres -c "vacuum full;"