StatisticalReinforcementLearningLab / SARAv2

SARA V2
BSD 3-Clause "New" or "Revised" License
5 stars 2 forks source link

unlocked-inspirational-quotes component not working #220

Open sarahrathnam opened 3 years ago

sarahrathnam commented 3 years ago

The quotes component in the app is not displaying past inspirational quotes. I looked in the front end code, and in src/app/incentive/unlocked-inspirational-quotes/unlocked-inspirational-quotes.component.ts, it calls the endpoint '/get-inspirational-quote' from flaskServerForIncentives, as specified in the environments file. This comes from the user registration microservice, GetInspirationalQuote.

I'm running into the issue that this endpoint gives a "502 Bad Gateway" error since the associated mySQL query does not work.

"SELECT author_image, author_name, quote_text, date FROM 4PMNotifications where user_id='" + user_id +"' and is_sent = 1 order by whenSentTs DESC"

As far as I can see, is_sent is not a column in the 4PMNotifications table.

I don't know if the behavioral health team will end up wanting to use inspirational quotes, so I don't think we should spend a ton of time on the component, but I'd like to understand what is supposed to be happening to generate the content in the Quotes component. Could you let me know how that should be working? Thanks!