scripts/popupdate.py

   1 #!/usr/bin/python3
   2
   3 import time
   4
   5 import aurweb.db
   6
   7
   8 def main():
   9     conn = aurweb.db.Connection()
  10
  11     conn.execute("UPDATE PackageBases SET NumVotes = (" +
  12                  "SELECT COUNT(*) FROM PackageVotes " +
  13                  "WHERE PackageVotes.PackageBaseID = PackageBases.ID)")
  14
  15     now = int(time.time())
  16     conn.execute("UPDATE PackageBases SET Popularity = (" +
  17                  "SELECT COALESCE(SUM(POWER(0.98, (? - VoteTS) / 86400)), 0.0) " +
  18                  "FROM PackageVotes WHERE PackageVotes.PackageBaseID = " +
  19                  "PackageBases.ID AND NOT VoteTS IS NULL)", [now])
  20
  21     conn.commit()
  22     conn.close()
  23
  24
  25 if __name__ == '__main__':
  26     main()