scripts to fix redis when it crashes

1 files changed, 20 insertions, 0 deletions

diff --git a/scripts/sort_faves.sh b/scripts/sort_faves.sh
new file mode 100755
index 0000000..eb28a39
--- /dev/null
+++ b/scripts/sort_faves.sh
@@ -0,0 +1,20 @@
+#!/bin/bash
+
+if [ ! -n "$1" ]
+then
+  echo "Usage: `basename $0` fav_scores.csv"
+  exit
+fi
+
+mkdir -p faves
+
+echo "Get the top 50 faves for the Hall of Fame"
+sort -t, -k3,3 -rn $1 | head -50 > faves/hall.csv
+
+echo "Group faves by user for popular pages, total fave scores"
+sort -t, -k1,1 -r -k3,3 -n faves/counts_sorted.csv > faves/by_user.csv
+
+echo "Group faves by date for daily tallies"
+sort -t, -k4,4 -r -k3,3 -n faves/counts_sorted.csv > faves/by_date.csv
+
+