SAP HANA Database Client for Python
A pure Python client for the SAP HANA Database based on the SAP HANA Database SQL Command Network Protocol.
pyhdb supports Python 2.6, 2.7, 3.3, 3.4 and also PyPy on Linux, OSX and Windows. It implements a large part of the DBAPI Specification v2.0 (PEP 249).
Table of contents
Install from Python Package Index:
$ pip install pyhdb
You can also install the latest version direct from a cloned git repository.
$ git clone https://github.com/SAP/pyhdb.git $ cd pyhdb $ python setup.py install
The basic pyhdb usage is common to database adapters implementing the DBAPI 2.0 interface (PEP 249). The following example shows how easy it’s to use the pyhdb module.
>>> import pyhdb >>> connection = pyhdb.connect( host="example.com", port=30015, user="user", password="secret" ) >>> cursor = connection.cursor() >>> cursor.execute("SELECT 'Hello Python World' FROM DUMMY") >>> cursor.fetchone() (u"Hello Python World",) >>> connection.close()
Establish a database connection
The function pyhdb.connect creates a new database session and returns a new Connection instance. Please note that port isn’t the instance number of you SAP HANA database. The SQL port of your SAP HANA is made up of 3<instance-number>15 for example the port of the default instance number 00 is 30015.
Currently pyhdb only supports the user and password authentication method. If you need another authentication method like SAML or Kerberos than please open a GitHub issue. Also there is currently no support of encrypted network communication between client and database.
With the method cursor of your Connection object you create a new Cursor object. This object is able to execute SQL statements and fetch one or multiple rows of the resultset from the database.
>>> cursor = connection.cursor() >>> cursor.execute("SELECT SCHEMA_NAME, TABLE_NAME FROM TABLES")
After you executed a statement you can fetch one or multiple rows from the resultset.
>>> cursor.fetchone() (u'SYS', u'DUMMY') >>> cursor.fetchmany(3) [(u'SYS', u'DUMMY'), (u'SYS', u'PROCEDURE_DATAFLOWS'), (u'SYS', u'PROCEDURE_MAPPING')]
You can also fetch all rows from your resultset.
>>> cursor.fetchall() [(u'SYS', u'DUMMY'), (u'SYS', u'PROCEDURE_DATAFLOWS'), (u'SYS', u'PROCEDURE_MAPPING'), ...]
Example Create table
With the execute method you can also execute DDL statements like CREATE TABLE.
>>> cursor.execute('CREATE TABLE PYHDB_TEST("NAMES" VARCHAR (255) null)')
You can also execute DML Statements with the execute method like INSERT or DELETE. The Cursor attribute rowcount contains the number of affected rows by the last statement.
>>> cursor.execute("INSERT INTO PYHDB_TEST VALUES('Hello Python World')") >>> cursor.rowcount 1
Please note that all cursors created from the same connection are not isolated. Any change done by one cursor is immediately visible to all other cursors from same connection. Cursors created from different connections are isolated as the connection based on the normal transaction handling.
The connection objects provides to method commit which commit any pending transaction of the connection. The method rollback undo all changes since the last commit.
pyhdb provides a test suite which covers the most use-cases and protocol parts. To run the test suite you need the pytest and mock package. Afterwards just run py.test inside of the root directory of the repository.
$ pip install pytest mock $ py.test
You can also test different python version with tox.
$ pip install tox $ tox
- BLOB, LOB and NLOB Support
- Allow execution of stored database procedure
- Support of SELECT FOR UPDATE
- Authentication methods
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
|Filename, size||File type||Python version||Upload date||Hashes|
|Filename, size pyhdb-0.1.0.tar.gz (21.9 kB)||File type Source||Python version None||Upload date||Hashes View|