Python/Flask query returning empty table with correct number of cells

Question

I'm doing this python flask project.

When I'm executing a query, the resulting webpage shows the resulting table with the correct number of rows and columns and cells but all the cells are empty.

[removed code]

1) SELECT * ... is not a good idea. The output of * can change under you. 2) What does pymysql.cursors.DictCursor actually return? Is it like in psycopg2 where it can be accessed via indexing or via keys? 3) Is cursor.fetchall() actually returning anything? — Adrian Klaver
– Adrian Klaver, Commented May 2, 2022 at 23:06

gwelter · Accepted Answer · 2022-05-03 03:36:55Z

1

By requesting DictCursor as you are, it seems the results should be coming as dicts keyed by table column names, as in the test cases at the top of the file here: https://github.com/PyMySQL/PyMySQL/blob/main/pymysql/tests/test_DictCursor.py

In that case you need to change your accessors from indexes to column names, e.g. {{item[0]}} to {{item['colname']}}.

answered May 3, 2022 at 3:36

gwelter

1,1932 gold badges11 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sesame Over a year ago

Thank you! I used some starter code without realizing exactly what it was doing

Collectives™ on Stack Overflow

Python/Flask query returning empty table with correct number of cells

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related