Skip to content

Instantly share code, notes, and snippets.

@seanburlington

seanburlington/search-skype-today.sh

Last active August 29, 2015 14:07
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save seanburlington/85e282537f6f2f631414 to your computer and use it in GitHub Desktop.
Save seanburlington/85e282537f6f2f631414 to your computer and use it in GitHub Desktop.
Download ZIP
Search across skype chats
Raw
search-skype-today.sh
export username=skype.name
export thedate=$(date +%Y-%m-%d)
sqlite3 ~/.Skype/${username}/main.db \
"SELECT displayname, datetime(Messages.timestamp, 'unixepoch') as date, body_xml
FROM Messages, Conversations
WHERE Conversations.id=Messages.convo_id and date(Messages.timestamp, 'unixepoch') == '${thedate}' and author='${username}'
ORDER BY Messages.timestamp;"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment