Skip to content

Instantly share code, notes, and snippets.

@seanburlington

seanburlington/search-skype.sh

Created October 22, 2014 11:11
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/740d136e58d8b87d057f to your computer and use it in GitHub Desktop.
Save seanburlington/740d136e58d8b87d057f to your computer and use it in GitHub Desktop.
Download ZIP
search skype chats
Raw
search-skype.sh
#!/bin/bash
export username=skype.name
sqlite3 -column ~/.Skype/$username/main.db \
"SELECT displayname, from_dispname, datetime(Messages.timestamp, 'unixepoch') as date, body_xml
FROM Messages, Conversations
WHERE Conversations.id=Messages.convo_id and body_xml like '%$searchterm%'
ORDER BY Messages.timestamp;"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment