Python-сообщество

wmic /output:wmicbuild.csv product get InstallDate,InstallLocation,Name,Vendor,Version /format:csv

import csv
import MySQLdb
filepath = r"wmicbuild.csv"
mydb = MySQLdb.connect(host='localhost',
    user='login',
    passwd='password',
    db='test')
cursor = mydb.cursor()
with open(filepath, encoding='utf-16') as csvfile:
    csv_data = csv.reader(csvfile)
    strSQL = r"INSERT INTO csv(node,installdate,installlocation,name,vendor,version) VALUES(%s, %s, %s, %s, %s, %s)"
    for row in csv_data:
        #print(row)
        cursor.execute(strSQL, row)
    
#close the connection to the database.
mydb.commit()
cursor.close()
print ("Done")

 query = query % args
TypeError: not enough arguments for format string

Node,InstallDate,InstallLocation,Name,Vendor,Version
User,20151221,,Python 3.2.7 Add to Path (32-bit),Python Software Foundation,3.2.7.0
User,20140624,C:\Program Files\OpenXML-ODF Translator\,ODF Add-in for Microsoft Office,OpenXML/ODF Translator Team,4.0.5309.0
User,20151221,,Python 3.2.7 Documentation (32-bit),Python Software Foundation,3.2.7.0

cursor.execute(r"INSERT INTO csv(node,installdate,installlocation,name,vendor,version) VALUES(%s, %s, %s, %s, %s, %s)", ('1', '2', '3', '4', '5', '6'))

[]
['Node', 'InstallDate', 'InstallLocation', 'Name', 'Vendor', 'Version']
['User', '20151221', '', 'Python 3.5.1 Add to Path (32-bit)', 'Python Software Foundation', '3.5.1150.0']
['User', '20140624', 'C:\\Program Files\\OpenXML-ODF Translator\\', 'ODF Add-in for Microsoft Office', 'OpenXML/ODF Translator Team', '4.0.5309.0']
['User', '20151221', '', 'Python 3.5.1 Documentation (32-bit)', 'Python Software Foundation', '3.5.1150.0']