Skip to content

Instantly share code, notes, and snippets.

@torarnv

torarnv/gist:1729796

Created February 3, 2012 11:41
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 torarnv/1729796 to your computer and use it in GitHub Desktop.
Save torarnv/1729796 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
tracker-sparql -q "select ?u ?ta ?d ?ptc COUNT(?d) AS ?count { ?u a nmo:SMSMessage; tracker:added ?ta; nmo:sentDate ?d; nie:plainTextContent ?ptc } GROUP BY ?d ORDER BY ?count" | grep "[23456789]$" | while read row; do id=$(echo $row | cut -d "
," -f1 | cut -d ":" -f2); echo Deleting $id ...; tracker-sparql -qu "delete { <message:$id> a rdfs:Resource }"; done
@torarnv
Copy link
Author

torarnv commented Feb 3, 2012

for safety, do 'tracker-control -b backup.db' first

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment