aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorLouis Burda <quent.burda@gmail.com>2022-11-06 12:45:43 +0100
committerLouis Burda <quent.burda@gmail.com>2022-11-06 12:45:43 +0100
commit912f3b2cc15cd48b2d3dc3e488f587929fee6af4 (patch)
tree92b1e6672ead158cdf151696e59462814135cf50
parentfd724461424bcc9bcdbe12da70782d3e0993e9cc (diff)
downloadbambi7-service-catchbox-912f3b2cc15cd48b2d3dc3e488f587929fee6af4.tar.gz
bambi7-service-catchbox-912f3b2cc15cd48b2d3dc3e488f587929fee6af4.zip
Use deletion time in cleanup scriptHEADmaster
-rwxr-xr-xservice/www/cleaner6
1 files changed, 3 insertions, 3 deletions
diff --git a/service/www/cleaner b/service/www/cleaner
index 9667951..e50b200 100755
--- a/service/www/cleaner
+++ b/service/www/cleaner
@@ -6,7 +6,7 @@ while IFS= read -r row; do
rm -rf "$path"
fi
done < <(sqlite3 /service/db.sqlite \
- "SELECT dir FROM files WHERE creat < strftime('%s', 'now') - 10")
+ "SELECT dir FROM files WHERE delet < strftime('%s', 'now')")
while IFS= read -r row; do
path=$(realpath "/service/reports/$row")
@@ -14,8 +14,8 @@ while IFS= read -r row; do
rm -rf "$path"
fi
done < <(sqlite3 /service/db.sqlite \
- "SELECT file FROM reports WHERE creat < strftime('%s', 'now') - 10")
+ "SELECT file FROM reports WHERE delet < strftime('%s', 'now')")
sqlite3 /service/db.sqlite "PRAGMA foreign_keys = ON; \
- DELETE FROM users WHERE creat < strftime('%s', 'now') - 10"
+ DELETE FROM users WHERE delet < strftime('%s', 'now')"