how to insert multiple rows from list with Python

Question

I am trying to figure out how to insert multiple rows into python but I get an error:

TypeError: ('Params must be in a list, tuple, or Row', 'HY000')

for folderName in os.listdir(parentDirectory):
    for fileName in os.listdir(parentDirectory+'/'+folderName+'/'+'people'):
        if os.path.splitext(fileName)[-1].lower()== '.xml':
            filePath = parentDirectory+'/'+folderName+'/'+'people'+'/'+fileName
            print(filePath)
            tree = ET.parse(filePath)

            valuesToInsert.append("('" + fileName + "','" +tree.find('PNumber').text+ "','" +tree.find('PNumber2').text+ "')")

            numberOfProcessedFiles += 1
            if numberOfProcessedFiles%1000 == 0:
                print(*valuesToInsert, sep = "\n")
                cursor.executemany('''
                    insert into t02.m.PNumbers
                    values
                    (?,?,?)
                    ''',valuesToInsert)

                conn.commit()
                valuesToInsert.clear()

Simon Crane · Accepted Answer · 2019-09-30 14:41:27Z

3

Don't append a string, just append a tuple:

valuesToInsert.append((fileName,tree.find('PNumber').text,tree.find('PNumber2').text))

answered Sep 30, 2019 at 14:41

Simon Crane

2,1822 gold badges13 silver badges22 bronze badges

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

1 Comment

donL Over a year ago

Thank you, it makes so much sense!

Collectives™ on Stack Overflow

how to insert multiple rows from list with Python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related