mirror of
https://github.com/GRFreire/nthmail.git
synced 2026-01-08 12:29:38 +00:00
17 lines
306 B
Bash
Executable File
17 lines
306 B
Bash
Executable File
#!/bin/sh
|
|
|
|
if [ -z "$DB_PATH" ]; then
|
|
DB_PATH="db.db"
|
|
fi
|
|
|
|
min_date="$(date -d '-1 day' +%s)"
|
|
sql="DELETE FROM mails WHERE mails.arrived_at < $min_date"
|
|
|
|
if [ -n "$EXCLUDE_IGNORE_ADDR" ]; then
|
|
sql="$sql AND not (rcpt_addr = '$EXCLUDE_IGNORE_ADDR')"
|
|
fi
|
|
sql="$sql;"
|
|
|
|
echo "$sql" | sqlite3 "$DB_PATH"
|
|
|