Script to move watched videos in Kodi to a git annex remote

archive_kodi_videos_to_git_annex.sh

#!/bin/bash
SQL=$(cat <<EOF
select p.strPath || f.strFilename
from files f
join path p
    on p.idPath = f.idPath
where f.playCount > 0;
EOF
)

IFS="
"

for file in `sqlite3 /home/$USER/.kodi/userdata/Database/MyVideos116.db < <(echo "$SQL")`; do
  if [[ -f "$file" ]] && [[ -L "$file" ]]; then
    cd /archive/
    git annex move --force --to RemoteDrive "$file"
  fi
done