Hello. My name is Vernon, and I am a python-oholic. I needed a MS-SQL api which would return decimal data from a numeric (currency) column, so I made one. That may have been a bad decision, because it has resulted in me becoming the new admin for the adodbapi project on sourceforge. (Like I didn't have enough to do.) Here goes... adobpapi is a DB-API 2.0 compliant module, written in pure python, which uses Microsoft ADO to connect with data sources. Version 2.1 includes all of the patches and bug fixes I could locate, and incorporates all of the feature requests I could get in. My new work consists of modification of the method used to return values from currency and numeric columns. They are now returned as Decimal values, rather than floats. I also cleaned up the "execute helper" routine so that it is implemented in a more straight-forward manner. (Those of you who have looked at the source code will know what I mean.) The new version is available at http://www.sourceforge.net/projects/adodbapi . I have not updated the source code on the CVS, yet, (must learn that first) so just read the source from the zip file. There is limited documentation, a set of unit tests, and a small sample script in the zip.
This release has been tested against Python 2.3 and 2.5 on Windows 2000, Python 2.4 and 2.5 on XP, and Python 2.4 on Windows 2003 server -- all using Access and Microsoft SQL server -- and against mySQL with Python 2.5 and XP. My future goals for this project are: Inclusion in the release package of pywin32. (Thanks to Mark Hammond for this.) Inclusion in a future release of FePy (for Iron Python.) Better support for SQLalchemy. Full support of STORM. (Storm is the new object-relational mapper from Canonical, https://storm.canonical.com , which I want to use on Windows, which is why I need to support it ...) -- Vernon Cole kf7xm at users.sourceforge.net<http://sourceforge.net/sendmessage.php?touser=855661> Peppermill Casinos, Inc. http://wendoverfun.com
_______________________________________________ DB-SIG maillist - DB-SIG@python.org http://mail.python.org/mailman/listinfo/db-sig
