Getting Started Error about home-assistant-notebooks

[Vitani]

I think this is the fix

from sqlalchemy import text
...

for event in db.perform_query(text("SELECT * FROM events JOIN event_data ON events.data_id = event_data.data_id WHERE event_type = 'call_service' ORDER BY time_fired")):

[yozh]

I think this is the fix

from sqlalchemy import text
...

for event in db.perform_query(text("SELECT * FROM events JOIN event_data ON events.data_id = event_data.data_id WHERE event_type = 'call_service' ORDER BY time_fired")):

Tried it....

for event in db.perform_query(text("SELECT * FROM events JOIN event_data ON events.data_id = event_data.data_id WHERE event_type = 'call_service' ORDER BY time_fired")):

and got this.

---

NameError Traceback (most recent call last)
Cell In[5], line 13
9 # We keep track of contexts that we processed so that we will only process
10 # the first service call in a context, and not subsequent calls.
11 context_processed = set()
---> 13 for event in db.perform_query(text("SELECT * FROM events JOIN event_data ON events.data_id = event_data.data_id WHERE event_type = 'call_service' ORDER BY time_fired")):
14 entity_ids = None
16 # Skip if we have already processed an event that was part of this context

NameError: name 'text' is not defined