3 Tips & tricks

Martin Zimmermann edited this page 2015-01-15 12:04:33 +01:00

The following bash function pretty-print the entire comments DB sorted by insertion date.

get_blog_comments () {
    ssh $host sqlite3 -line /path/to/isso/isso.db \
        "'SELECT t.uri,c.created,c.modified,c.text,c.author,c.email,c.website \
          FROM comments AS c, threads as t WHERE c.tid = t.id;'" \
        | perl -wpe '/(created|modified) = ./&&s/= (.*)/"= ".scalar(localtime($1))/e';
}

Example output:

     uri = /lucas/blog/2014/12/12/fr-la-tete-dans-le-guidon/
 created = Mon Dec 15 13:10:28 2014
modified =
    text = Merci ! Je suis très content d'apprendre que cette lecture a pu plaire à quelqu'un
N'hésitez pas à partager vos propres réflexions et astuces dans les commentaires.
  author = lucas
   email = lucas@chezsoi.org
 website = https://chezsoi.org/lucas/blog