Path: csiph.com!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!ecngs!feeder2.ecngs.de!newsfeed.freenet.ag!news2.euro.net!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail Return-Path: X-Original-To: python-list@python.org Delivered-To: python-list@mail.python.org X-Spam-Status: OK 0.001 X-Spam-Evidence: '*H*': 1.00; '*S*': 0.00; 'cpython': 0.05; 'pypy': 0.07; 'setup.py': 0.07; 'python': 0.09; 'compact': 0.09; 'pyodbc': 0.09; 'script,': 0.09; 'subject:module': 0.09; 'url:github': 0.09; 'url:pypy': 0.09; '2.7': 0.13; 'file,': 0.15; 'skip:p 40': 0.15; 'compress': 0.16; 'folder,': 0.16; 'subject:IronPython': 0.16; 'subject:PyPy': 0.16; 'subject:compatible': 0.16; 'url:py': 0.16; 'driver': 0.17; 'unicode': 0.17; 'windows': 0.19; 'module': 0.19; 'skip:p 30': 0.20; 'changes': 0.20; 'bit': 0.21; 'import': 0.21; '3.x': 0.22; 'runs': 0.22; 'programming': 0.23; 'linux': 0.24; 'script': 0.24; 'url:wiki': 0.26; 'bugs': 0.27; 'implemented': 0.27; '2.6': 0.27; 'message-id:@mail.gmail.com': 0.27; 'lines': 0.28; 'run': 0.28; 'ansi': 0.29; 'site)': 0.29; 'url:code': 0.29; 'install': 0.29; 'connection': 0.30; "skip:' 10": 0.30; 'mode': 0.30; 'primary': 0.30; '(and': 0.32; 'mac': 0.32; 'to:addr:python- list': 0.33; 'received:google.com': 0.34; 'built-in': 0.35; 'table': 0.35; 'add': 0.36; 'url:org': 0.36; 'totally': 0.36; 'subject:with': 0.36; 'skip:( 30': 0.38; 'files': 0.38; 'several': 0.39; 'to:addr:python.org': 0.39; '&': 0.61; 'latest': 0.61; 'url:p': 0.63; '3000': 0.71; 'click': 0.76; 'from:charset:gb2312': 0.78; '(id': 0.84; 'url:master': 0.84; 'available:': 0.91; '<>*': 0.95 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:x-received:date:message-id:subject:from:to :content-type; bh=0Ns1OIQk0xZqrD0aJX1eK60GcHj4NSjb19fWNcS16EU=; b=eysVmEoqbjo72T9y2qRk9TXbeuGvRzfUZUy5qwaSN2kV9G98H5hpLOwZr6RKXl5fnu dt8+12+kat48fbiaA9zIevUL4EpTCBLooUvWtUKt/JCQLFLh8/H0yrnfiVMy3/ihDbkP nEFRt6DMt7eBNRRsXSYFk0drxbbEanBgJaSmRX0VSRw4OYN/3ToJYQgKVsw9VNjInTQ8 6gN00Rr1WcJmCrwh34aOJwz0js0qbvI+bKo1YUpOiyRZwSFfn7i0FCstAKT8ZIrTZEiV DUowT51TcXtB8HSFi0PVKXOAFOPBaecKcRY0Fij0t3chqViYzdlLWaLinbAwrnln0Moz 13gQ== MIME-Version: 1.0 X-Received: by 10.50.7.242 with SMTP id m18mr4403143iga.53.1362910677607; Sun, 10 Mar 2013 03:17:57 -0700 (PDT) Date: Sun, 10 Mar 2013 18:17:57 +0800 Subject: PyPyODBC 1.0.5 released. (DBI 2.0 ODBC module compatible with PyPy, IronPython and SQLAlchemy) From: =?GB2312?B?va3OxA==?= To: python-list@python.org Content-Type: multipart/alternative; boundary=f46d04463036ccacc904d78f5e5d X-BeenThere: python-list@python.org X-Mailman-Version: 2.1.15 Precedence: list List-Id: General discussion list for the Python programming language List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Newsgroups: comp.lang.python Message-ID: Lines: 177 NNTP-Posting-Host: 2001:888:2000:d::a6 X-Trace: 1362910686 news.xs4all.nl 6878 [2001:888:2000:d::a6]:51928 X-Complaints-To: abuse@xs4all.nl Xref: csiph.com comp.lang.python:41009 --f46d04463036ccacc904d78f5e5d Content-Type: text/plain; charset=ISO-8859-1 Changes in Ver 1.0.5 (and 1.0.4, 1.0.3, 1.0.2, 1.0.1) - *Fix several bugs under Python 3.x* - *Add Mac / iODBC platform support* - *Improved ODBC ANSI / unicode mode support* Features - *One pure Python script, runs on CPython / IronPython / PyPy , Python 3.3 / 2.4 / 2.5 / 2.6 / 2.7 , Win / Linux / Mac , 32 / 64 bit* - *Almost totally same usage as pyodbc * ( can be seen as a re-implementation of pyodbc in pure Python ) - *Simple - the whole module is implemented in a single python script with less than 3000 lines * - *Built-in functions to create and compress Access MDB files on Windows* Simply try pypyodbc: import pypyodbc pypyodbc.win_create_mdb('D:\\database.mdb') connection_string = 'Driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\database.mdb' connection = pypyodbc.connect(connection_string) SQL = 'CREATE TABLE saleout (id COUNTER PRIMARY KEY,product_name VARCHAR(25));' connection.cursor().execute(SQL).commit() ... Samples*A HelloWorld sample of python database programming **Create & Compact Access MDB database *Install *Download the latest package * , unzip to a folder, *double click the setup.py file*, or run setup.py install Or if you have pip available: pip install pypyodbc Or get the latest pypyodbc.py script from *GitHub * (Main Development site) --f46d04463036ccacc904d78f5e5d Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable

Changes in Ver 1.0.5 (and 1.0.4, 1.0.3, 1.0.2, 1.0.1)

  • Fix= =A0several=A0bugs under Python 3.x
  • Add Mac / iODBC platform support
  • <= b>Improved ODBC ANSI / unicode mode support

Features=

  • One pure Python script, runs on C= Python /=A0IronPytho= n=A0/=A0PyPy=A0, Python 3.3 / 2.4 / 2.5 / 2.6 / 2.7 , Win / Linux /= Mac , 32 / 64 bit
  • Almost totally same usage as=A0pyodbc=A0( can be seen as a re-implementation of = pyodbc in pure Python )
  • Simple - the whole module is impl= emented in a single python script with less than=A03000 lines
  • Built-in functions=A0to create and compress Access M= DB files on Windows

Simply try pypyodbc:

import pypyodbc 
=A0 =A0 =A0 =A0 =A0 =A0 =A0
pypyodbc.win_create_mdb('D:\\database.mdb')


connection_string =3D 'Driver=3D{Microsoft Access Driver (*.mdb)};DBQ=3DD:\\database.=
mdb'


connection =3D pypyodbc.connect(connection_string)


SQL =3D 'C=
REATE TABLE saleout (id COUNTER PRIMARY KEY,product_name VARCHAR(25));'=



connection.cursor().execute(SQL).commit()


...
=

Samples

= A HelloWorld sample of python database programming

Create & Compact Access MDB database

Install

Download the latest package=A0, = unzip to a folder,=A0double click the setup.py file, or ru= n

setup.py install

Or if you have pip available:

pip install pypyodbc

Or get the latest pypyodbc.py script from=A0GitHub=A0(Main Development site)