26 - Listing Stored Database Entries

codingforentrepreneurs · codingforentrepreneurs · commit 8dca1c9bd10f · 2024-06-12T18:13:54.000-06:00
diff --git a/full_stack_python/contact/__init__.py b/full_stack_python/contact/__init__.py
@@ -1,9 +1,10 @@
 from .form import contact_form
 from .state import ContactState
-from .page import contact_page
+from .page import contact_page, contact_entries_list_page
 
 __all__ = [
     'contact_form',
     'ContactState',
-    'contact_page'
+    'contact_page',
+    'contact_entries_list_page'
 ]
diff --git a/full_stack_python/contact/page.py b/full_stack_python/contact/page.py
@@ -3,7 +3,29 @@
 from .. import navigation
 from ..ui.base import base_page
 
-from . import form, state
+from . import form, state, model
+
+def contact_entry_list_item(contact: model.ContactEntryModel):
+    return rx.box(
+        rx.heading(contact.first_name),
+        rx.text(contact.message),
+        padding='1em'
+    )
+
+# def foreach_callback(text):
+#     return rx.box(rx.text(text))
+
+def contact_entries_list_page() ->rx.Component:
+    return base_page(
+        rx.vstack(
+            rx.heading("Contact Entries", size="5"),
+            # rx.foreach(["abc", "abc", "cde"], foreach_callback),
+            rx.foreach(state.ContactState.entries, contact_entry_list_item),
+            spacing="5",
+            align="center",
+            min_height="85vh",
+        )
+    ) 
 
 def contact_page() -> rx.Component:
     my_child = rx.vstack(
diff --git a/full_stack_python/contact/state.py b/full_stack_python/contact/state.py
@@ -1,18 +1,14 @@
+from typing import List
 import asyncio
 import reflex as rx 
 
+from sqlmodel import select
 from .model import ContactEntryModel
 
 class ContactState(rx.State):
     form_data: dict = {}
+    entries: List['ContactEntryModel'] = []
     did_submit: bool = False
-    timeleft: int = 5
-
-    @rx.var
-    def timeleft_label(self):
-        if self.timeleft < 1:
-            return "No time left"
-        return f"{self.timeleft} seconds"
 
     @rx.var
     def thank_you(self):
@@ -38,4 +34,11 @@ async def handle_submit(self, form_data: dict):
             yield
         await asyncio.sleep(2)
         self.did_submit = False
-        yield
+        yield
+
+    def list_entries(self):
+        with rx.session() as session:
+            entries = session.exec(
+                select(ContactEntryModel)
+            ).all()
+            self.entries = entries
diff --git a/full_stack_python/full_stack_python.py b/full_stack_python/full_stack_python.py
@@ -50,5 +50,10 @@ def index() -> rx.Component:
              route=navigation.routes.ABOUT_US_ROUTE)
 app.add_page(contact.contact_page, 
              route=navigation.routes.CONTACT_US_ROUTE)
+app.add_page(
+    contact.contact_entries_list_page, 
+    route=navigation.routes.CONTACT_ENTRIES_ROUTE,
+    on_load=contact.ContactState.list_entries
+)
 app.add_page(pages.pricing_page, 
              route=navigation.routes.PRICING_ROUTE)
diff --git a/full_stack_python/navigation/routes.py b/full_stack_python/navigation/routes.py
@@ -1,4 +1,5 @@
 HOME_ROUTE="/"
 ABOUT_US_ROUTE="/about"
 CONTACT_US_ROUTE="/contact"
+CONTACT_ENTRIES_ROUTE="/contact/entries"
 PRICING_ROUTE="/pricing"
