Skip to main content

IBM-DB2 Wrapper Class

Project description

Wrapper Class around ibm_db (IBM-DB2)
In IBM-DB2 after every read, the data needs to be fetched and after evey write, the data needs to be committed. But this class eliminates these requirements and make it simple to read and write to the database.
Files:
ibmdb2/__init__.py
Usage Examples:

import ibmdb2

db = ibmdb2.db(conn_str) ##-connect to the database using the connection string for example conn_str = “DATABASE=BLUDB; HOSTNAME=dashdb-txn-sbox-yp-dal09-04.services.dal.bluemix.net; PORT=50000; PROTOCOL=TCPIP; UID=username; PWD=password;”

Note: In the SQL statements all columns should be enclosed with ” double quotes and text be enclosed with ‘ single quotes.

db.read(‘select “column1”,”column2” from mytable where “column1” like 'myword' ‘) ##-returns column1 & 2 from table where column = myword

db.read(‘select “column” from table”, flat=False) ##-returns the raw read data

db.read(f’select “item” from table where “item” = '{Variable}'’) ##-read with string substitution

db.read1(‘sql statement’) ##-returns the first read data similar to fetchone

db.write(‘sql statement’) ##-writes the data and commits to the database

For other connection commands use the connection class
db.conn….

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for ibmdb2, version 0.3
Filename, size File type Python version Upload date Hashes
Filename, size ibmdb2-0.3.tar.gz (1.8 kB) File type Source Python version None Upload date Hashes View

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page