status.sh

#!/bin/bash

#  Description
#  -----------
#  ![Status](https://developer.run/pic/status.png)
#  
#  CLI web stats dashboard. Visualizes GitHub followers, top GitHub repos and last 500 blog hits
#  with top pages and refferers. Works well in addition to [headlines.sh](https://github.com/dmi3/bin/blob/master/headlines.sh) and `newsbeuter -x reload -x print-unread 2> /dev/null` [Read more](https://developer.run/51)

  
#  Requirements
#  ------------
#  * [spark](https://github.com/holman/spark) (the other spark, not the behemoth one)
#  * `sudo apt-get install jq`

#  Usage
#  ------------
   
#  * Set `URL`, `GITHUB_ID, `PARSE_APP_ID` and `PARSE_MASTER_KEY` variables
#  * `status.sh`

test "$URL"              == "" && echo '$URL not set!'
test "$GITHUB_ID" == ""        && echo '$GITHUB_ID not set!'
test "$PARSE_APP_ID" == ""     && echo '$PARSE_APP_ID not set!'
test "$PARSE_MASTER_KEY" == "" && echo '$PARSE_MASTER_KEY not set!'

echo -ne "\n ★ Github — "
curl -s "https://api.github.com/users/$GITHUB_ID" | jq -r .followers | awk '{print $0, "followers"}'
curl -s "https://api.github.com/users/$GITHUB_ID/repos" | jq -r "sort_by(.stargazers_count) | reverse [] | [.html_url, .stargazers_count, .forks] | @csv" | head -6 | column -s, -t

echo -ne "\n 📈 Blog "
BLOG_STATS=$(curl -s -H "X-Parse-Application-Id: $PARSE_APP_ID" -H "X-Parse-Master-Key: $PARSE_MASTER_KEY" -G --data-urlencode 'order=-createdAt' --data-urlencode 'limit=500' https://parseapi.back4app.com/classes/Visitor) 

# Visitors diagramm
echo "$BLOG_STATS" | jq -r ".results | group_by(.createdAt[0:10])[] | [group_by(.token)[]] | length " | spark
# Visitors over last 5 days
echo "$BLOG_STATS" | jq -r ".results | group_by(.createdAt[0:10])[] | [group_by(.token)[]] | [.[0][0].createdAt[0:10], length, (flatten | length), ([flatten | .[] | .country] | unique | join(\" \"))] | @csv" | tail -5 | column -s, -t 
# Top 5 pages
echo
echo "$BLOG_STATS" | jq -r '.results | [ group_by(.title)[] | {kw: .[0].title, count: length }] | sort_by(.count) | reverse [] | [.kw[0:50], .count] | @csv' | head -5 | column -s, -t
# Top 5 refferers
echo
echo "$BLOG_STATS" | jq -r ".results | [ .[] | select( .ref != \"\" ) | select( .ref | contains (\"$URL\") | not ) ] | [ group_by(.ref)[] | {kw: .[0].ref, count: length }] | sort_by(.count) | reverse [] | [.kw, .count] | @csv" | head -5 | column -s, -t