import mysql.connector
conn=mysql.connector.connect(user='jump',password='secret',host='localhost',database='accidents')
cursor=conn.cursor()
cursor.execute("SELECT vtype FROM vehicle_type WHERE vtype LIKE '%otorcycle%';")
cycleList = cursor.fetchall()
selectSQL = ('''
                SELECT t.vtype, a.accident_severity
                FROM accidents_2016 AS a
                JOIN vehicles_2016 AS v ON  a.accident_index = v.accident_index
                JOIN vehicle_type AS t ON  v.vehicle_type = t.vcode
                WHERE t.vtype LIKE '%otorcycle%'
                ORDER BY  a.accident_severity;''')
insertSQL = ("INSERT INTO accident_medians VALUES (%s, %s);")

for cycle in cycleList:
                cursor.execute(selectSQL, (cycle[0],))
                accidents = cursor.fetchall()
                quotient, remainder =  divmod(len(accidents),2)
                if  remainder:
                    med_sev =  accidents[quotient][1]
                else:
                    med_sev =  (accidents[quotient][1] + accidents[quotient+2][1])/2
                print('Finding median for',cycle[0])
                cursor.execute(insertSQL,(cycle[0],med_sev))
conn.commit()
conn.close()



#This yields the following errors:
Traceback (most recent call last):
  File "\\CATTERY-DC1\UserData\Macavity\Desktop\final script.py", line 16, in <module>
    cursor.execute(selectSQL, cycle[0])
  File "C:\Users\Macavity\AppData\Local\Programs\Python\Python36\lib\site-packages\mysql\connector\cursor_cext.py", line 246, in execute
    prepared = self._cnx.prepare_for_mysql(params)
  File "C:\Users\Macavity\AppData\Local\Programs\Python\Python36\lib\site-packages\mysql\connector\connection_cext.py", line 520, in prepare_for_mysql
    raise ValueError("Could not process parameters")
ValueError: Could not process parameters
>>>