Python SQL Query output with psycopg2

Question

I've sucessfully done a Select query on Python using psycopg2, but i have a problem with the output.

The output is as follows:

[('Porto',), ('Milan',), ('London',)]

The problem is when i try to pass it as a variable on an API string

cityList = records

for city in cityList:
    api = f"https://api.example.io/?city={city}"

I get an API error because the input it's been read as:

https://api.example.io/?city=('Porto',)

I know it's because it's a string, but how to i pass it to the API as a variable in a way that i can loop through the DB results as:

https://api.example.io/?city=Porto

Thank you for any help.

Booboo · Accepted Answer · 2022-10-26 19:06:38Z

1

You have a list of rows where each element is a tuple containing all the columns retrieved for each row, which in your case contains a single element. So what you should do instead is chose the one and only column from each row:

cityList = records

for city in cityList:
    api = f"https://api.example.io/?city={city[0]}"

What you were doing was converting the entire tuple to a string instead of the first and only element within the tuple.

answered Oct 26, 2022 at 19:06

Booboo

45.7k4 gold badges46 silver badges74 bronze badges

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

Collectives™ on Stack Overflow

Python SQL Query output with psycopg2

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related