Search Skype history for given terms

skype-search

#!/bin/bash

usage() {
  echo "usage: skype-search username term [...]"
}

join() {
  local params=""

  while [ ! -z $1 ]; do
    params="${params}%$1"
    shift
  done

  echo "${params}%"
}

search() {
  username=$1
  shift
  query=$(join $@)
  sqlite3 $HOME/Library/Application\ Support/Skype/${username}/main.db "SELECT from_dispname, datetime(timestamp, 'unixepoch') AS date, body_xml FROM Messages WHERE body_xml LIKE '$query' ORDER BY timestamp;"
}

if [ $# -lt 2 ]; then
  usage
  exit 1
else
  search $@
fi

join function is a lazy implementation of something awk would be better at.