½
½ÎÄ
PyPyODBC - A Pure Python ctypes ODBC module
Features
- *One pure Python script, runs on CPython /
IronPython<http://ironpython.codeplex.com/>
/ PyPy <http://pypy.org/> , Version 2.4 / 2.5 / 2.6 / 2.7 , Win / Linux
, 32 / 64 bit*
- *Almost totally same usage as pyodbc <http://code.google.com/p/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<http://code.google.com/p/pypyodbc/source/browse/trunk/pypyodbc/pypyodbc.py>
*
- *Built-in Access MDB file creation and compression functions on Windows
*
Simply try pypyodbc:
import pypyodbc
pypyodbc.win_create_mdb('D:\\database.mdb')
connection = pypyodbc.connect('Driver={Microsoft Access Driver
(*.mdb)};DBQ=D:\\database.mdb')
SQL = 'CREATE TABLE saleout (id COUNTER PRIMARY KEY,product_name VARCHAR(25))'
connection.cursor().execute(SQL)
Home Page <http://code.google.com/p/pypyodbc/>
Tutorial <http://blog.sina.com.cn/s/blog_6c64ac1501019ns8.html>
教程 <http://blog.sina.com.cn/s/blog_6c64ac1501019mx2.html>
Tutorial (Français) <http://blog.sina.com.cn/s/blog_6c64ac1501019ost.html>
Features
- *One pure Python script, runs on CPython /
IronPython<http://ironpython.codeplex.com/>
/ PyPy <http://pypy.org/> , Version 2.4 / 2.5 / 2.6 / 2.7 , Win / Linux
, 32 / 64 bit*
- *Almost totally same usage as pyodbc <http://code.google.com/p/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<http://code.google.com/p/pypyodbc/source/browse/trunk/pypyodbc/pypyodbc.py>
*
- *Built-in Access MDB file creation and compression functions on Windows
*
Simply try pypyodbc:
import pypyodbc
pypyodbc.win_create_mdb('D:\\database.mdb')
connection = pypyodbc.connect('Driver={Microsoft Access Driver
(*.mdb)};DBQ=D:\\database.mdb')
SQL = 'CREATE TABLE saleout (id COUNTER PRIMARY KEY,product_name VARCHAR(25))'
connection.cursor().execute(SQL)
Home Page <http://code.google.com/p/pypyodbc/>
Tutorial <http://blog.sina.com.cn/s/blog_6c64ac1501019ns8.html>
教程 <http://blog.sina.com.cn/s/blog_6c64ac1501019mx2.html>
Tutorial (Français) <http://blog.sina.com.cn/s/blog_6c64ac1501019ost.html>