I had a monitoring script running on an older server, and I'm now trying to get that script working on a new server. I'm going from 1.0.2 (via Debian package in Squeeze) to 2.0.0b1-dev-20130108 (via a virtualenv install by pip). I had to patch my script to make it work. Previously I would pass a dictionary to an execute(), and have a query like:
INSERT INTO exampletable (ID, Name) VALUES (%(id)d, %(name)s);
Now I have to do pass a list into the execute(), and use a query like:
INSERT INTO exampletable (ID, Name) VALUES (%d, %s);
Did the paramstyle really change between the pymssql verisons, or have I some how got completely confused?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I had a monitoring script running on an older server, and I'm now trying to get that script working on a new server. I'm going from 1.0.2 (via Debian package in Squeeze) to 2.0.0b1-dev-20130108 (via a virtualenv install by pip). I had to patch my script to make it work. Previously I would pass a dictionary to an execute(), and have a query like:
Now I have to do pass a list into the execute(), and use a query like:
Did the paramstyle really change between the pymssql verisons, or have I some how got completely confused?