37 - Narrow Results with Database Queries"

codingforentrepreneurs · codingforentrepreneurs · commit 99d2770046d9 · 2024-06-13T16:17:41.000-06:00
diff --git a/full_stack_python/blog/state.py b/full_stack_python/blog/state.py
@@ -40,7 +40,7 @@ def get_post_detail(self):
                 return
             result = session.exec(
                 select(BlogPostModel).where(
-                    BlogPostModel.id == self.blog_post_id
+                    (BlogPostModel.id == self.blog_post_id)
                 )
             ).one_or_none()
             self.post = result
@@ -52,11 +52,18 @@ def get_post_detail(self):
         # return
 
 
-
-    def load_posts(self):
+    def load_posts(self, published_only=False):
+        lookup_args = ()
+        if published_only:
+            lookup_args = ( 
+                (BlogPostModel.publish_active == True) &
+                (BlogPostModel.publish_date < datetime.now())
+            )
         with rx.session() as session:
             result = session.exec(
-                select(BlogPostModel)
+                select(BlogPostModel).where(
+                   *lookup_args
+                )
             ).all()
             self.posts = result
         # return
