Possible typo with Chapter 5 code sample

[cosmicpython]

Possible typo with Chapter 5 code sample

[hjwp]

it's definitely a bit of a head-scratcher. session.execute returns the results of your SELECT query, which the set of rows that match the query. each row is made up of columns. so the return type is a list of tuples. in this case i know it's exactly one row containing a tuple with exactly one item (the id of the row in the order_lines table), which is why the tuple unpacking works.

i could add a footnote maybe? i didn't want the focus of the book to be teaching people how to use sqlalchemy, but i don't want code listings to be so weird as to be obscure and cause people to wonder how on earth they work!

[adrienbrunet]

I had to read it twice and give it a few seconds of thoughts. A footnote should help !

Also for me, it would be a bit less confusing with

[(orderlineid, )] = ...

[hjwp]

fixed here, thanks for the feedback everyone. cosmicpython/book@609d5a2