{ "info": { "author": "Pal", "author_email": "ipal00@outlook.com", "bugtrack_url": null, "classifiers": [], "description": "Wrapper Class around ibm_db (IBM-DB2)\n\tIn 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.\n\n\nFiles:\n\tibmdb2/__init__.py\n\n\nUsage Examples:\n\timport ibmdb2\n\t\n\tdb = 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;\"\n\n\tNote: In the SQL statements all columns should be enclosed with \" double quotes and text be enclosed with ' single quotes.\n\n\tdb.read('select \"column1\",\"column2\" from mytable where \"column1\" like \\'myword\\' ') ##-returns column1 & 2 from table where column = myword\n\n\tdb.read('select \"column\" from table\", flat=False) ##-returns the raw read data \n\t\n\tdb.read(f'select \"item\" from table where \"item\" = \\'{Variable}\\'') ##-read with string substitution\n\t\n\tdb.read1('sql statement') ##-returns the first read data similar to fetchone\n\t\n\tdb.write('sql statement') ##-writes the data and commits to the database\n\t\n\nFor other connection commands use the connection class\n\tdb.conn....\n", "description_content_type": "", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/ipal0/ibmdb2", "keywords": "", "license": "GPL", "maintainer": "", "maintainer_email": "", "name": "ibmdb2", "package_url": "https://pypi.org/project/ibmdb2/", "platform": "", "project_url": "https://pypi.org/project/ibmdb2/", "project_urls": { "Homepage": "https://github.com/ipal0/ibmdb2" }, "release_url": "https://pypi.org/project/ibmdb2/0.3/", "requires_dist": null, "requires_python": "", "summary": "IBM-DB2 Wrapper Class", "version": "0.3" }, "last_serial": 5254553, "releases": { "0.1": [ { "comment_text": "", "digests": { "md5": "a0665d13b24b88825e40c9dfda4de9ac", "sha256": "5ec51e2cfa15bc9df316fcb4214edfc4a73ca61f347eb78f5eb26a6639732e44" }, "downloads": -1, "filename": "ibmdb2-0.1.tar.gz", "has_sig": false, "md5_digest": "a0665d13b24b88825e40c9dfda4de9ac", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 1795, "upload_time": "2019-05-10T22:49:37", "url": "https://files.pythonhosted.org/packages/8b/86/024117a3404295c03139d22aa89d876b465e93d64e8ed88fc20892865d4c/ibmdb2-0.1.tar.gz" } ], "0.2": [ { "comment_text": "", "digests": { "md5": "e51215b0344ecfb953a2dbb3d483600d", "sha256": "a88959a4ef67423eaf05a1b73b69bfd46f6329f02a794d2a15bbbd8bf990e7f9" }, "downloads": -1, "filename": "ibmdb2-0.2.tar.gz", "has_sig": false, "md5_digest": "e51215b0344ecfb953a2dbb3d483600d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 1800, "upload_time": "2019-05-10T22:55:02", "url": "https://files.pythonhosted.org/packages/cc/b0/b74ad2451d245df4f05f5408dbd0500299f2727b84a4ecb7fc77c8b8eac5/ibmdb2-0.2.tar.gz" } ], "0.3": [ { "comment_text": "", "digests": { "md5": "1d3f9950aa13ae1dcf11494731664357", "sha256": "d168fd9cf53bd87476d5f79ef52db01be6f41da32a61d461baf10d79490c650a" }, "downloads": -1, "filename": "ibmdb2-0.3.tar.gz", "has_sig": false, "md5_digest": "1d3f9950aa13ae1dcf11494731664357", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 1826, "upload_time": "2019-05-10T23:18:25", "url": "https://files.pythonhosted.org/packages/a8/13/0fefb91e2d1f32ef6f50d8074c2e2ac9869a2eaecf62ecc138c8f9d52946/ibmdb2-0.3.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "1d3f9950aa13ae1dcf11494731664357", "sha256": "d168fd9cf53bd87476d5f79ef52db01be6f41da32a61d461baf10d79490c650a" }, "downloads": -1, "filename": "ibmdb2-0.3.tar.gz", "has_sig": false, "md5_digest": "1d3f9950aa13ae1dcf11494731664357", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 1826, "upload_time": "2019-05-10T23:18:25", "url": "https://files.pythonhosted.org/packages/a8/13/0fefb91e2d1f32ef6f50d8074c2e2ac9869a2eaecf62ecc138c8f9d52946/ibmdb2-0.3.tar.gz" } ] }