1 files changed, 19 insertions, 5 deletions
diff --git a/scripts/fix_fav_counts.py b/scripts/fix_fav_counts.py
index 00e8d0f..0472488 100644
--- a/scripts/fix_fav_counts.py
+++ b/scripts/fix_fav_counts.py
@@ -3,13 +3,23 @@
 
    before running this command, please run the following SQL, which tallies the faves per post:
 
-   COPY (SELECT messages.user_id, tags.message_id, COUNT(tags.message_id) AS mycount, TO_CHAR(messages.created_on, 'YYYYMMDD')
+   COPY (SELECT messages.user_id, tags.message_id, COUNT(tags.message_id)
+                AS mycount, TO_CHAR(messages.created_on, 'YYYYMMDD')
            FROM tags, messages
           WHERE tags.message_id = messages.message_id AND tags.tag = 'favorite'
        GROUP BY tags.message_id, messages.user_id, messages.created_on)
-   TO '/tmp/fav_counts2.csv' WITH CSV;
+   TO '/tmp/fav_counts69.csv' WITH CSV;
 
-   then run ./sort_faves.sh which will pre-sort the data for this script.
+   this file will be owned by the postgres user,
+   so change the 69 to some other number (janky i know)
+
+   then run ./sort_faves.sh /tmp/fav_counts69.csv
+   ...which will pre-sort the data for this script.
+
+   then run python3 fix_fav_counts.py
+   ...this script.
+
+   if you run this twice, don't worry, data will not be duplicated.
 """
 
 import re
@@ -33,6 +43,7 @@ def fetch_users():
 # field order: user_id, message_id, score, date
 
 def load_faves_by_user():
+  print("fixing favscores...")
   nicks = load_nicks()
   counter = 0
   user_counter = 0
@@ -59,6 +70,7 @@ def load_faves_by_user():
       counter += 1
 
 def load_faves_by_date():
+  print("fixing daily halls...")
   date_counter = 0
   counter = 0
   date = ""
@@ -79,6 +91,7 @@ def load_faves_by_date():
       counter += 1
 
 def load_hall():
+  print("fixing hall...")
   with open('faves/hall.csv', 'r') as csvfile:
     reader = csv.reader(csvfile)
     for row in reader:
@@ -93,7 +106,8 @@ def load_nicks():
   return nicks
 
 if __name__ == "__main__":
-  # load_hall()
-  # load_faves_by_user()
+  load_hall()
+  load_faves_by_user()
   load_faves_by_date()
+  print("done!")