SQLite3 flask execute returning only one object when im expecting 2
I have a SQLite database where the table userProducts currently has 2 rows in it, 2|1 and 2|2. My expected output for my SQL query is 1 and 2, however im only getting 1. When i run the exact query in my database it returns exactly what i expect, however in my flask function it doesnt. Ive recently had to re-do my database handling due to switching libraries so im very new to this way of getting data. Its not the cleanest code since im actively debugging it
SQLite3 flask execute returning only one object when im expecting 2
I have a SQLite database where the table userProducts currently has 2 rows in it, 2|1 and 2|2. My expected output for my SQL query is 1 and 2, however im only getting 1. When i run the exact query in my database it returns exactly what i expect, however in my flask function it doesnt. Ive recently had to re-do my database handling due to switching libraries so im very new to this way of getting data. Its not the cleanest code since im actively debugging it
SQLite3 DB to front end in flask just creates empty tags for each row [duplicate]
This question already has answers here: How can I get dict from sqlite query? (16 answers) Closed 14 hours ago. I’ve read the docs and looked at 2 different tutorials all do it the same way but my front end renders with empty tags but it creates a tag for the expect items in the […]
How to add a new cafe (element) to database(SQLite) using Python Flask?
This is my code: