for row in rows:
    itemBank.append((tempRow2['Item_Name'], tempRow1['Item_Price'],
        tempRow3['Item_In_Stock'], tempRow4['Item_Max'], getTimeExtra))
q = """ insert ignore into TABLE1 (
        Item_Name, Item_Price, Item_In_Stock, Item_Max, Observation_Date ) 
        values (%s,%s,%s,%s,%s)           
    """
How can I use executemany to instert into mysql a list of dictionaries in python