Implement package states for easier reviews

[cheatdb.git] / app / querybuilder.py

diff --git a/app/querybuilder.py b/app/querybuilder.py
index 1d6b6f063c2368117d96ba1f789da503301cf838..57f5dbeb5e297fcdd89cb794673ad2eb87ad97c0 100644 (file)
--- a/app/querybuilder.py
+++ b/app/querybuilder.py
@@ -72,9 +72,9 @@ class QueryBuilder:
                query = None
                if self.order_by == "last_release":
                        query = db.session.query(Package).select_from(PackageRelease).join(Package) \
-                               .filter_by(soft_deleted=False, approved=True)
+                               .filter_by(state=PackageState.APPROVED)
                else:
-                       query = Package.query.filter_by(soft_deleted=False, approved=True)
+                       query = Package.query.filter_by(state=PackageState.APPROVED)
 
                return self.filterPackageQuery(self.orderPackageQuery(query))