Unable to pass a generator to executemany

[svieira]

I'm using Pyodbc 3.0.3.

Attempting to use the following code:

connection.cursor().executemany("INSERT INTO my_table (AN_INT) VALUES(?)",
     ((id_, ) for id_ in xrange(1000)))

results in a ProgrammingError - pyodbc is checking the the result is a sequence of the type Tuple, List or Row. Would it be possible to also add generators to the list of valid sequences that can be passed to this method?

[mkleehammer]

In the generator branch. Waiting for testing on Windows.

[svieira]

@mkleehammer - I have confirmed that it is now working on Windows. Thank you very much!

[mkleehammer]

Wow. Thanks. I meant that I was going to test on Windows, as soon as my new Windows VirtualBox VM is setup. Thanks, though!

[mkleehammer]

My last comment didn't come out right: I was going to test on Windows, but thanks for beating me too it!

[svieira]

😁 - Glad I could help!