[IronPython] Announcing adodbapi version 2.4.0 -- with COLUMN NAME data access

Lukas Cenovsky cenovsky at bakalari.cz
Sun Aug 1 01:08:38 PDT 2010


  Hi all,
I have developed my internal tool for accessing SQL server and FoxPro 
.dbf files. It is inspired by PEP 249 too but it uses  
System.Data.SqlClient.SqlConnection respectively 
System.Data.OleDb.OleDbConnection (vfpoledb.dll). It's main goal is to 
cover differences between SQL server and FoxPro.

If anybody is interested, let me know and I will try to make it public.

--
-- Lukás(


On 31.7.2010 9:42, Vernon Cole wrote:
> Announcing a new version of adodbapi...
>
> [ for those who may not know...
> [ adodbapi is a pure Python package which fully implements the PEP-249 
> db-api
> [ using Microsoft ADO/db.
> [ It runs on CPython versions 2.3 and later, IronPython 2.6 and later,
> [ or Python 3.0 and later.
>
> I have often been frustrated by the need to count '?' marks for input 
> parameters
> and remembering column numbers to get my SQL output.
> This release fixes that by allowing the use of 'named' parameters as 
> an option,
> and by returning 'SQLrow' objects which allow the use of column names.
>
> This version includes a distutils setup.py file, so installation is easy.
> Just
>   1) unzip
>   2) "cd" to the directory you just unzipped.
>   2) Execute the command:
>           python setup.py install
>       using the python distribution of your choice.
> It even runs 2to3 automatically if you run it using a 3.n Python.
> (Why didn't I do this years ago?)
>
> NOTE:  on Vista (and 7?) you must run setup.py using the administrator 
> account to install on IronPython,
> because setup.py does not elevate privileges for the source installer.
> (Distutils can create a stand-alone binary installer which does 
> elevate privileges, but that feature is not yet supported by 
> IronPython because it has no zip library.)
>
> ALSO NOTE: I have _used_ this package with IronPython 2.7.A1, but not 
> _tested_ it, because 2.7's unittest package is broken.
>
> Here's what's new............................
>
> * adodbapi version 2.4.0 -- in this version,
>    "fetchall()" and "fetchmany()" return an SQLrows object
>    ...which emulates a sequence of SQLrow objects.
>    "fetchone()" or the cursor's "next()" method return an SQLrow object.
>    An SQLrow object emulates a tuple of data fields.
>    An SQLrow object also appears to have an attribute for each column 
> of data.
>    therefore...
> >>> import adodbapi
> >>> myConnection = adodbapi.connection('someDSN')
> >>> cur = myConnection.cursor()
> >>> cur.execute("select name, rank, serialNumber from soldiers")
> >>> row = cur.fetchone()
> >>> assert row[0] == row['name']
> >>> assert row[1] == row.rank
> >>> rows = cur.fecthall()
> >>> assert rows[4,'serialNumber'] == rows[4][2]
>
> * adodbapi version 2.3.0 -- this is includes major refactoring and
>    specifically adds features for django support, including the 
> ability for the
>    programmer to change ado's SQL "paramstyle" at run time to select 
> between
>    'qmark', 'format' and 'named' methods of passing SQL parameters.
> ** also, in response to user requests, adodbapi will now use client-side
>    cursors by default.  This will make rowcount and stored procedure 
> return
>    parameter values more readily available.
>
>
> _______________________________________________
> Users mailing list
> Users at lists.ironpython.com
> http://lists.ironpython.com/listinfo.cgi/users-ironpython.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ironpython.com/pipermail/users-ironpython.com/attachments/20100801/d569976b/attachment-0001.htm>


More information about the Users mailing list