markzz/aurweb.git/scripts/popupdate.py, branch puaurweb working repositoryhttps://git.markzz.net/markzz/aurweb.git/atom/scripts/popupdate.py?h=pu2016-03-01T17:27:23Zpopupdate: Avoid NULL entries in the popularity field2016-03-01T17:27:23ZLukas Fleischerlfleischer@archlinux.org2016-03-01T07:45:46Zurn:sha1:4c15f02ecb01e5d31ee575ead72c5b33db731032
The popularity field is declared as "NOT NULL" in the database schema.
Fix the popularity update query such that it uses a popularity of 0.0
instead of NULL for packages with no votes.
Signed-off-by: Lukas Fleischer <lfleischer@archlinux.org>
popupdate: Drop unused variable2015-06-27T19:31:33ZLukas Fleischerlfleischer@archlinux.org2015-06-27T19:31:21Zurn:sha1:1e9cc370c2cafa592bf0bc199f2c819fd9cc8949
Signed-off-by: Lukas Fleischer <lfleischer@archlinux.org>
Add a field for package base popularity2015-06-11T16:59:52ZLukas Fleischerlfleischer@archlinux.org2015-06-11T16:41:58Zurn:sha1:824744f1d20614c25e972dda7a0b7ac9506dd46f
Create a new field Popularity in the PackageBases table. The field is
updated by the popupdate script and reflects the popularity of a
package. Popularity is the sum of all votes with each vote being
weighted with a factor of 0.98 per day since its creation.
Signed-off-by: Lukas Fleischer <lfleischer@archlinux.org>
Add popupdate script2015-06-11T16:59:46ZLukas Fleischerlfleischer@archlinux.org2015-06-11T16:33:32Zurn:sha1:0345914c5ce5e8ecafe3e90280bd58c0255fd9e0
This adds a simple script that can be used to recalculate the number of
votes per package. It can be used in a cronjob.
Signed-off-by: Lukas Fleischer <lfleischer@archlinux.org>