aboutsummaryrefslogtreecommitdiff
path: root/app/querybuilder.py
diff options
context:
space:
mode:
authorrubenwardy <rw@rubenwardy.com>2020-07-10 22:32:52 +0100
committerrubenwardy <rw@rubenwardy.com>2020-07-10 22:32:54 +0100
commitc3d96c745924f458846f08d90f48be0c1a4cc0ed (patch)
tree502d8c2cf583aacf440ac2f62b19b40cb3489ef9 /app/querybuilder.py
parentb9386d5a47aace49afa99d4f3a36a895bea40697 (diff)
downloadcheatdb-c3d96c745924f458846f08d90f48be0c1a4cc0ed.tar.xz
Add more sort options to package API, correct documentation
Fixes #204
Diffstat (limited to 'app/querybuilder.py')
-rw-r--r--app/querybuilder.py10
1 files changed, 8 insertions, 2 deletions
diff --git a/app/querybuilder.py b/app/querybuilder.py
index 5b75b4c..d511836 100644
--- a/app/querybuilder.py
+++ b/app/querybuilder.py
@@ -79,7 +79,13 @@ class QueryBuilder:
to_order = None
if self.order_by is None or self.order_by == "score":
to_order = Package.score
- elif self.order_by == "created_at":
+ elif self.order_by == "name":
+ to_order = Package.name
+ elif self.order_by == "title":
+ to_order = Package.title
+ elif self.order_by == "downloads":
+ to_order = Package.downloads
+ elif self.order_by == "created_at" or self.order_by == "date":
to_order = Package.created_at
else:
abort(400)
@@ -134,7 +140,7 @@ class QueryBuilder:
query = query.order_by(db.asc(ForumTopic.wip), db.asc(ForumTopic.name), db.asc(ForumTopic.title))
elif self.order_by == "views":
query = query.order_by(db.desc(ForumTopic.views))
- elif self.order_by == "date":
+ elif self.order_by == "created_at" or self.order_by == "date":
query = query.order_by(db.asc(ForumTopic.created_at))
if self.search: