Plugin for xbarapp.com to display total time spent using your computer today

workinghours.sh

#!/usr/bin/env bash

# This query adds up the lengths of all the /app/usage events in ZOBJECT.
# This gives an approximation of how long the machine has been used for today, assuming
# the display goes to sleep fairly quickly when the machine is not used (eg 1 minute).

# You'll need to give xbar "Full Disk Access"
# (System Preferences -> Security and Privacy -> Privacy) for this to work.

DBPATH=~/Library/Application\ Support/Knowledge/knowledgeC.db

SQL=$(cat <<EOF
select
  sum(ZENDDATE - ZSTARTDATE) as total
from
  ZOBJECT
where
  ZSTREAMNAME = '/app/usage'
  and date(
    ZCREATIONDATE + 978307200,
    'UNIXEPOCH'
  ) = date()
EOF
)

seconds=$(echo ${SQL} | sqlite3 "${DBPATH}")

printf '%dh%dm\n' $((seconds/3600)) $((seconds%3600/60))