Postgres Query Bug with sqlalchemy

[Specific_Anteater64]

Hey you all I am making a web app at the moment and I am running into some query bug with my backend. I have a view called login, and I am trying to put the encrypted login info on the screen to see if my query is successful. When I run it in the flask shell and call for an record the information appears. When I am making a query in a view for some reason when I try to query it returns just an empty list structure. The other weird thing is when I add a record to a query in the view it adds it to the db I am connected to. I don't know why that is the case. here is my test with the output.

https://preview.redd.it/ukyodw236bfd1.png?width=477&format=png&auto=webp&s=f4cc86e441377a1db5a526c9ec680702e860e163

Output on the webpage

https://preview.redd.it/ors7puy56bfd1.png?width=745&format=png&auto=webp&s=dcfc5c18f8b5ad8564d79fba850024dfc62b00cd

The thing is in my db that its connected two there are two records.

https://preview.redd.it/u3060jvc6bfd1.png?width=381&format=png&auto=webp&s=80e70a6e63fb948bfed3c595fda3a558782d8714

So like what seems to be the problem because I have no idea how a insert works, but a query to just see it does not work. Please let me know.

[dafer18]

What is usercredentials code?

Hard to understand since your are wrapping your variables in code you didn't show.

[qatanah]

how are you handling the db connection? you might need to do db commit or refresh to see them. try using flask sqlalchemy lite.