mcguirepr89
32 lines
892 B
Bash
Executable File
32 lines
892 B
Bash
Executable File
#!/usr/bin/env bash
|
|
OLDIFS=$IFS
|
|
IFS=\|
|
|
most_recent_results=($(sqlite3 ~/BirdNET-Pi/scripts/birds.db \
|
|
'SELECT Com_Name, Time, Date FROM detections
|
|
ORDER BY Date DESC, Time DESC
|
|
LIMIT 1'))
|
|
today=$(date +%F)
|
|
yesterday=$(date --date="yesterday" +%F)
|
|
two_days_ago=$(date --date="2 days ago" +%F)
|
|
|
|
echo -n The most recent detection was
|
|
|
|
if [[ "${most_recent_results[0]}" =~ ^[AEIOU].* ]];then
|
|
echo -n " an ${most_recent_results[0]} at "
|
|
else
|
|
echo -n " a ${most_recent_results[0]} at "
|
|
fi
|
|
most_recent_results[1]=$(date --date="${most_recent_results[1]}" +%l:%M%p)
|
|
echo -n ${most_recent_results[1]}
|
|
if [[ ${most_recent_results[2]} == $today ]];then
|
|
echo " today."
|
|
elif [[ ${most_recent_results[2]} == $yesterday ]];then
|
|
echo " yesterday."
|
|
elif [[ ${most_recent_results[2]} == $two_days_ago ]];then
|
|
echo " two days ago."
|
|
else
|
|
echo " on ${most_recent_results[2]}."
|
|
fi
|
|
|
|
IFS=$OLDIFS
|