|
Size: 843
Comment:
|
← Revision 11 as of 2013-08-11 12:31:35 ⇥
Size: 2368
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 2: | Line 2: |
| [[TableOfContents]] | |
| Line 4: | Line 3: |
| == Masthead == | = SAP DB (MaxDB) = |
| Line 6: | Line 5: |
| URL:: http://www.sapdb.org/ licence:: GPL |
URL for 7.6 and later:: http://www.sdn.sap.com/irj/sdn/maxdb URL for 7.5:: (was http://www.mysql.org/products/maxdb/, but is no longer available) URL for 7.3 and 7.4:: http://www.sapdb.org/ licence:: 7.3 and 7.4 (GPL + LGPL), 7.5 (GPL), 7.6 and later (Commercial and free community edition) |
| Line 10: | Line 11: |
| ---- |
|
| Line 11: | Line 14: |
=== sdb.dbapi === URL:: http://maxdb.sap.com/doc/7_7/46/71b2a516ae0284e10000000a1553f6/frameset.htm licence:: (?) SAP now releases MaxDB for free, but no longer as open-source software platforms:: see SAP DB Python versions:: |
|
| Line 19: | Line 29: |
| ==== Extensions to DB API ==== | This is for the older SAP DB releases 7.3 and 7.4. |
| Line 21: | Line 31: |
| ==== Comments ==== | === mxODBC === URL:: http://www.egenix.com/products/python/mxODBC/ Licence:: eGenix.com Commercial License Platforms:: Windows, Linux, MacOS X, FreeBSD, Solaris, AIX Python versions:: 2.4 - 2.7 SAP DB's native CLI is ODBC compatible and mxODBC can link directly against these libraries on Unix. It also supports the SAPDB ODBC driver on Windows. Supports all SAP DB versions. |
| Line 24: | Line 43: |
=== sdb.sql === URL:: http://maxdb.sap.com/doc/7_7/46/71b2a516ae0284e10000000a1553f6/frameset.htm licence:: (?) SAP now releases MaxDB for free, but no longer as open-source software platforms:: see SAP DB Python versions:: |
|
| Line 32: | Line 58: |
| This is for the older SAP DB releases 7.3 and 7.4. |
|
| Line 34: | Line 62: |
| * session.sql (...) -> Result''''''Set * session.prepare (...) -> Prepared''''''Statement * prepared.execute ([...]) -> Result''''''Set |
{{{ cursor = session.sql ("select * from messages") for msgno, lang, text in cursor: print msgno, text |
| Line 38: | Line 67: |
| ==== Comments ==== | insert = session.prepare ("insert into sometable values (?, ?)") print insert.getDescription () insert.execute (["string", 1]) select = session.prepare ("select * from messages where msgno < :msgno") cursor = select.execute ([200]) print cursor.next () print cursor.relative (100) print cursor.absolute (4) print cursor.absolute (-4) }}} ---- |
| Line 42: | Line 83: |
| == Pros == == Cons == |
* a sapdb driver exists for [[PyDO]] (Python Data Objects) |
SAP DB (MaxDB)
- URL for 7.6 and later
- URL for 7.5
(was http://www.mysql.org/products/maxdb/, but is no longer available)
- URL for 7.3 and 7.4
- licence
- 7.3 and 7.4 (GPL + LGPL), 7.5 (GPL), 7.6 and later (Commercial and free community edition)
- platforms
- Linux/i386, Solaris, HP-UX, AIX, Dec, Windows
DB API 2.0 Drivers
sdb.dbapi
- URL
http://maxdb.sap.com/doc/7_7/46/71b2a516ae0284e10000000a1553f6/frameset.htm
- licence
- (?) SAP now releases MaxDB for free, but no longer as open-source software
- platforms
- see SAP DB
- Python versions
sapdbapi
- URL
- licence
- LGPL
- platforms
- see SAP DB
- Python versions
- 1.5.2 - 2.2
This is for the older SAP DB releases 7.3 and 7.4.
mxODBC
- URL
- Licence
- eGenix.com Commercial License
- Platforms
- Windows, Linux, MacOS X, FreeBSD, Solaris, AIX
- Python versions
- 2.4 - 2.7
SAP DB's native CLI is ODBC compatible and mxODBC can link directly against these libraries on Unix. It also supports the SAPDB ODBC driver on Windows.
Supports all SAP DB versions.
Other Drivers
sdb.sql
- URL
http://maxdb.sap.com/doc/7_7/46/71b2a516ae0284e10000000a1553f6/frameset.htm
- licence
- (?) SAP now releases MaxDB for free, but no longer as open-source software
- platforms
- see SAP DB
- Python versions
sapdb
- URL
- licence
- LGPL
- platforms
- see SAP DB
- Python versions
- 1.5.2 - 2.2
This is for the older SAP DB releases 7.3 and 7.4.
Programming Model
cursor = session.sql ("select * from messages")
for msgno, lang, text in cursor:
print msgno, text
insert = session.prepare ("insert into sometable values (?, ?)")
print insert.getDescription ()
insert.execute (["string", 1])
select = session.prepare ("select * from messages where msgno < :msgno")
cursor = select.execute ([200])
print cursor.next ()
print cursor.relative (100)
print cursor.absolute (4)
print cursor.absolute (-4)
Supported Python Applications
a sapdb driver exists for PyDO (Python Data Objects)