RESTGrid | simple Workflow\ETL system | BPM library

I am using BeautifulSoup to retrieve some information from a website. I used a for loop to get all the elements of that website that fulfill a criteria.

However, when I call the function outside the for loop, I am only getting the last item retrieved by the for loop.

I know I can create an empty list outside the loop and append all the items. The problem with this is that I am inserting this information into MySQL using PyMySQL and MySQL does not take in a list.

I know I can also transform a list into a string using " ".join(list) The problem with this is that MySQL takes this new object and sends it to one single cell in the database.

I am using BeautifulSoup to retrieve some data from a website. Then I am using PyMySQL to store that data in MySQL. However, I am getting the following error: TypeError: execute( ) takes from 2 to 3 positional arguments but 7 were given

This error is pointing to the "cur.execute" command.

Here is my code: