brmbarSAP/userlog.sh
2017-12-29 18:53:46 +01:00

5 lines
207 B
Bash
Executable file

#!/bin/bash
# Print out the log for specified user from last midnight
echo ".headers on
SELECT * FROM transhuman WHERE strftime('%Y-%m-%d',age)=date('now','localtime') AND user='$1';" | sqlite3 ./brmbar.db