summaryrefslogtreecommitdiffstats
path: root/scripts/popupdate.py
diff options
context:
space:
mode:
Diffstat (limited to 'scripts/popupdate.py')
-rwxr-xr-xscripts/popupdate.py26
1 files changed, 0 insertions, 26 deletions
diff --git a/scripts/popupdate.py b/scripts/popupdate.py
deleted file mode 100755
index 58cd0185..00000000
--- a/scripts/popupdate.py
+++ /dev/null
@@ -1,26 +0,0 @@
-#!/usr/bin/python3
-
-import time
-
-import aurweb.db
-
-
-def main():
- conn = aurweb.db.Connection()
-
- conn.execute("UPDATE PackageBases SET NumVotes = (" +
- "SELECT COUNT(*) FROM PackageVotes " +
- "WHERE PackageVotes.PackageBaseID = PackageBases.ID)")
-
- now = int(time.time())
- conn.execute("UPDATE PackageBases SET Popularity = (" +
- "SELECT COALESCE(SUM(POWER(0.98, (? - VoteTS) / 86400)), 0.0) " +
- "FROM PackageVotes WHERE PackageVotes.PackageBaseID = " +
- "PackageBases.ID AND NOT VoteTS IS NULL)", [now])
-
- conn.commit()
- conn.close()
-
-
-if __name__ == '__main__':
- main()