{ "info": { "author": "IBM Streams @ github.com", "author_email": "hegermar@de.ibm.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 5 - Production/Stable", "License :: OSI Approved :: Apache Software License", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.5", "Programming Language :: Python :: 3.6" ], "description": "Overview\n========\n\nProvides functions to run SQL statements to a database, for example IBM Db2 Warehouse.\n\nThis package exposes the `com.ibm.streamsx.jdbc `_ toolkit as Python methods for use with Streaming Analytics service on\nIBM Cloud and IBM Streams including IBM Cloud Pak for Data.\n\n* `Streaming Analytics service `_\n* `IBM Streams developer community `_\n* `IBM Db2 Warehouse `_\n\n\nSample\n======\n\nA simple example of a Streams application that creates a table, inserts a row and deletes the table::\n\n from streamsx.topology.topology import *\n from streamsx.topology.schema import CommonSchema, StreamSchema\n from streamsx.topology.context import submit\n import streamsx.database as db\n\n topo = Topology()\n sql_create = 'CREATE TABLE RUN_SAMPLE (A CHAR(10), B CHAR(10))'\n sql_insert = 'INSERT INTO RUN_SAMPLE (A, B) VALUES (\\'hello\\', \\'world\\')'\n sql_drop = 'DROP TABLE RUN_SAMPLE'\n s = topo.source([sql_create, sql_insert, sql_drop]).as_string()\n res_sql = db.run_statement(s, credentials)\n res_sql.print()\n submit('STREAMING_ANALYTICS_SERVICE', topo)\n # Use for IBM Streams including IBM Cloud Private for Data\n # submit ('DISTRIBUTED', topo)\n\nDocumentation\n=============\n\n* `streamsx.database package documentation `_\n", "description_content_type": "", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/IBMStreams/streamsx.database", "keywords": "streams", "license": "Apache License - Version 2.0", "maintainer": "", "maintainer_email": "", "name": "streamsx.database", "package_url": "https://pypi.org/project/streamsx.database/", "platform": "", "project_url": "https://pypi.org/project/streamsx.database/", "project_urls": { "Homepage": "https://github.com/IBMStreams/streamsx.database" }, "release_url": "https://pypi.org/project/streamsx.database/1.4.0/", "requires_dist": null, "requires_python": "", "summary": "IBM Streams Database integration", "version": "1.4.0" }, "last_serial": 5774902, "releases": { "0.1.0": [ { "comment_text": "", "digests": { "md5": "dc39b8da5aded7d4299dcd4900b196d6", "sha256": "c90dbbad2faf16a581e7c55c03bdf1954f712cf1d398a4fae452466f4406c8cd" }, "downloads": -1, "filename": "streamsx.database-0.1.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "dc39b8da5aded7d4299dcd4900b196d6", "packagetype": "bdist_wheel", "python_version": "3.5", "requires_python": null, "size": 10866, "upload_time": "2018-12-12T14:54:50", "url": "https://files.pythonhosted.org/packages/ea/c0/224c5fda3ff087d65aba9ff9df31bfd9bd8d1ad2408814211287efd9cf94/streamsx.database-0.1.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "5f1a9212366da21502ad0b6527bd9155", "sha256": "ed72f7f1f9fa905633d436d3408bcc45a3241bea40f02566b30d8cf3575773df" }, "downloads": -1, "filename": "streamsx.database-0.1.0.tar.gz", "has_sig": false, "md5_digest": "5f1a9212366da21502ad0b6527bd9155", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4166, "upload_time": "2018-12-12T14:54:47", "url": "https://files.pythonhosted.org/packages/f3/49/ad0ad9a32b31b931b6769407ca668ca1ea27797ed5bd7b7f95ef441620a1/streamsx.database-0.1.0.tar.gz" } ], "0.1.1": [ { "comment_text": "", "digests": { "md5": "06c95972ada1cbbab6a27f5bd9973018", "sha256": "d3718efab2e489aff644f423c8f6124528a335fb90a7be29fbd13f4f2c1540d0" }, "downloads": -1, "filename": "streamsx.database-0.1.1-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "06c95972ada1cbbab6a27f5bd9973018", "packagetype": "bdist_wheel", "python_version": "3.5", "requires_python": null, "size": 10888, "upload_time": "2018-12-13T11:24:30", "url": "https://files.pythonhosted.org/packages/d0/85/4929e6e1881d540e245d6ec8dc8d774b77329f64decd0cfa62317733b82a/streamsx.database-0.1.1-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "9ba19a16689199189d8e991ca592e9a6", "sha256": "a88f153d634094afc0f886e594396331f5bcb1792114fa5e1206befd372bb412" }, "downloads": -1, "filename": "streamsx.database-0.1.1.tar.gz", "has_sig": false, "md5_digest": "9ba19a16689199189d8e991ca592e9a6", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4187, "upload_time": "2018-12-13T11:24:29", "url": "https://files.pythonhosted.org/packages/e9/e8/ac69b901af6a820484becad2ff7c036b894b4b148a4e083d4c935ea70d55/streamsx.database-0.1.1.tar.gz" } ], "0.2.0": [ { "comment_text": "", "digests": { "md5": "34c922b95bc3f4ec036bfb7c1f454332", "sha256": "ffbb90f31a12e0d8e3afdbb2a578716a99de7c34b30f69c0267ffb0d3a3465fd" }, "downloads": -1, "filename": "streamsx.database-0.2.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "34c922b95bc3f4ec036bfb7c1f454332", "packagetype": "bdist_wheel", "python_version": "3.5", "requires_python": null, "size": 10899, "upload_time": "2019-01-15T10:50:57", "url": "https://files.pythonhosted.org/packages/a7/60/50ec3ce3a9f79f2b0cfbe0093a98d9d89f760bbac7da5f1fddbab60b9dfd/streamsx.database-0.2.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "b64f8afdc74272abcb8d6653a1527032", "sha256": "def0226856e83bba285a0df5b49ad9708af56770a0920212a59faec4a3a8a649" }, "downloads": -1, "filename": "streamsx.database-0.2.0.tar.gz", "has_sig": false, "md5_digest": "b64f8afdc74272abcb8d6653a1527032", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4207, "upload_time": "2019-01-15T10:50:55", "url": "https://files.pythonhosted.org/packages/ef/8a/46df29ecfea3a5272056748342984b5a282041bb920d7c307684572218e4/streamsx.database-0.2.0.tar.gz" } ], "0.3.0": [ { "comment_text": "", "digests": { "md5": "13d984d5d50cedf02f17703b9f2feb1a", "sha256": "e25c4288ff228221f5ed04cd36bab5fff3b0969e83f7f3f60d4d0482e5f31ec2" }, "downloads": -1, "filename": "streamsx.database-0.3.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "13d984d5d50cedf02f17703b9f2feb1a", "packagetype": "bdist_wheel", "python_version": "3.5", "requires_python": null, "size": 11204, "upload_time": "2019-01-23T13:28:02", "url": "https://files.pythonhosted.org/packages/a5/3a/5bb02e0ffd9a52f8525115d6184c8ffba578cd43b0c1c2a05b490bc38ba2/streamsx.database-0.3.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "06e0c323c9a72ce12342cc0b0d079d96", "sha256": "f9d30bcb19526d3e9835e5f05d0957d25592a094d8f0af8908752e30a2ebef3c" }, "downloads": -1, "filename": "streamsx.database-0.3.0.tar.gz", "has_sig": false, "md5_digest": "06e0c323c9a72ce12342cc0b0d079d96", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4497, "upload_time": "2019-01-23T13:28:00", "url": "https://files.pythonhosted.org/packages/53/74/1a16198e2fc84871e38cd16eadd228b9bb7502dd129fabade7904016696b/streamsx.database-0.3.0.tar.gz" } ], "0.3.1": [ { "comment_text": "", "digests": { "md5": "9cc002e7323d8ed4bea723b7c87f8939", "sha256": "6fe7cbccf9122aee5ab326d8286a30af881927af267c8449c0eeab2a60c08a30" }, "downloads": -1, "filename": "streamsx.database-0.3.1-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "9cc002e7323d8ed4bea723b7c87f8939", "packagetype": "bdist_wheel", "python_version": "3.5", "requires_python": null, "size": 11299, "upload_time": "2019-01-23T15:22:07", "url": "https://files.pythonhosted.org/packages/12/15/28c005b9d647423c3e2e76834fe48c6c1e50a9ac495f8dfd6390ec78d421/streamsx.database-0.3.1-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "9a5065bafa95c41d7afe1ca7b6973736", "sha256": "94b3b1a36a97c14d2e3674fa1da3c689c4ebfe7d1348f4cb8551c6f8140c01ae" }, "downloads": -1, "filename": "streamsx.database-0.3.1.tar.gz", "has_sig": false, "md5_digest": "9a5065bafa95c41d7afe1ca7b6973736", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4585, "upload_time": "2019-01-23T15:22:05", "url": "https://files.pythonhosted.org/packages/d8/e9/a4b8c14ef2f944d26fdb1e21f72316ff0e5149222fe0fea1b30ff9fad5e4/streamsx.database-0.3.1.tar.gz" } ], "1.0.0": [ { "comment_text": "", "digests": { "md5": "c38bdb17befc10eeff959795c7bdcf1d", "sha256": "f3db554f8eec6f73bd7ac39d3c39dec0581f2c3b531cc451b6d1badcee33fcea" }, "downloads": -1, "filename": "streamsx.database-1.0.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "c38bdb17befc10eeff959795c7bdcf1d", "packagetype": "bdist_wheel", "python_version": "3.5", "requires_python": null, "size": 11293, "upload_time": "2019-02-05T10:16:09", "url": "https://files.pythonhosted.org/packages/69/fc/78385186d72b418e492b63e1b24488f0b97d8da80ae67c03bfa7598e431f/streamsx.database-1.0.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "2e4cb95bb7de684d6aac723f721251b5", "sha256": "e90ee23f56a5e4ad16340a3a31e65b26097a61449714e96e7a33f815d4e0ce06" }, "downloads": -1, "filename": "streamsx.database-1.0.0.tar.gz", "has_sig": false, "md5_digest": "2e4cb95bb7de684d6aac723f721251b5", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4577, "upload_time": "2019-02-05T10:16:07", "url": "https://files.pythonhosted.org/packages/d8/ef/075e4f093d7f2d3816b7ff6d5ac663419e971284cba5962dbfdbe69945b2/streamsx.database-1.0.0.tar.gz" } ], "1.0.1": [ { "comment_text": "", "digests": { "md5": "6c7e07ee72339ab0efca31a923f6d139", "sha256": "c39394603abcc61dabdceea916d8e43f0ff4dd35634782cdb0e9b6344a871720" }, "downloads": -1, "filename": "streamsx.database-1.0.1-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "6c7e07ee72339ab0efca31a923f6d139", "packagetype": "bdist_wheel", "python_version": "3.5", "requires_python": null, "size": 11489, "upload_time": "2019-03-05T11:46:11", "url": "https://files.pythonhosted.org/packages/40/33/2fdb5e0fbf960417737bbdef28c8346e7beb0fc10ffea0133e365b847a0e/streamsx.database-1.0.1-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "1475b1df20cff08b68d2531daaf36300", "sha256": "0682ebea48367e0bdfb46f6a58f36fae3e56783da64e542246d84c56a165ea8c" }, "downloads": -1, "filename": "streamsx.database-1.0.1.tar.gz", "has_sig": false, "md5_digest": "1475b1df20cff08b68d2531daaf36300", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4654, "upload_time": "2019-03-05T11:46:09", "url": "https://files.pythonhosted.org/packages/fb/91/98ad4b41363f048b255cb111363c21a0ac6ef7fc97e13bb61e956a589485/streamsx.database-1.0.1.tar.gz" } ], "1.1.0": [ { "comment_text": "", "digests": { "md5": "a392fff0c17166ffc2cf1d77f40d5568", "sha256": "e4c825de04b09b969b498c1b829b1060e09f97468f88a5119868380bd0f3e873" }, "downloads": -1, "filename": "streamsx.database-1.1.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "a392fff0c17166ffc2cf1d77f40d5568", "packagetype": "bdist_wheel", "python_version": "3.5", "requires_python": null, "size": 11736, "upload_time": "2019-05-08T12:07:22", "url": "https://files.pythonhosted.org/packages/03/a0/4f60ba850ca0c4198bb005577aa9fa4340aafb252957a960961e2f8bf49e/streamsx.database-1.1.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "98a5025faff54fb1da8451fd937bfced", "sha256": "5a8bcb2aa01608f4cd784b9f398fbecc9be324be2eabe1efd3be6979238323e2" }, "downloads": -1, "filename": "streamsx.database-1.1.0.tar.gz", "has_sig": false, "md5_digest": "98a5025faff54fb1da8451fd937bfced", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4904, "upload_time": "2019-05-08T12:07:20", "url": "https://files.pythonhosted.org/packages/26/dc/c67baa371a064b4e9ed1cedf18be00cc0b5f54f283ec915eb9ffdfbe5410/streamsx.database-1.1.0.tar.gz" } ], "1.2.0": [ { "comment_text": "", "digests": { "md5": "3066c02d8ca60a0f8f1d49b10a988cb2", "sha256": "ddad75f9ab921e3706cbbe949472738b180879fa7aabe3ed14e750574b087103" }, "downloads": -1, "filename": "streamsx.database-1.2.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "3066c02d8ca60a0f8f1d49b10a988cb2", "packagetype": "bdist_wheel", "python_version": "3.5", "requires_python": null, "size": 12589, "upload_time": "2019-05-15T11:14:24", "url": "https://files.pythonhosted.org/packages/4a/c1/b5eb7a4981be2abe01d41a4d3ad003daa3af19e46292897bd1e7ac5d1c49/streamsx.database-1.2.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "ee32349b3356bd5574fc3995ee907e3a", "sha256": "56b5ca1579acdc47b285d4c7e3f7e1ffeb0ed2c7f5f60a1f1cbd1ac71a095187" }, "downloads": -1, "filename": "streamsx.database-1.2.0.tar.gz", "has_sig": false, "md5_digest": "ee32349b3356bd5574fc3995ee907e3a", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5751, "upload_time": "2019-05-15T11:14:22", "url": "https://files.pythonhosted.org/packages/6d/3e/96346359cfa32425da90848de9bb3c66dd578c8b901278ace6556bc8cd58/streamsx.database-1.2.0.tar.gz" } ], "1.3.0": [ { "comment_text": "", "digests": { "md5": "7e2730df6d2b029ffec9d060c525aac6", "sha256": "d54cd308aef935b9ebb22b1a96ede23a74de95521c4110d22242f9c95257f1bf" }, "downloads": -1, "filename": "streamsx.database-1.3.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "7e2730df6d2b029ffec9d060c525aac6", "packagetype": "bdist_wheel", "python_version": "3.5", "requires_python": null, "size": 12671, "upload_time": "2019-06-05T11:26:51", "url": "https://files.pythonhosted.org/packages/ea/b9/b8a76a0026bdfe2d85b46708fa2d4186f10c8146a5640a024e457cf933dd/streamsx.database-1.3.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "aa8c6af0f53de7a2a2f54ab51ff27ddf", "sha256": "309b0b44fe898a90c87602fd25d1d15bae2c7eb795b31dcf34f819fef0a46efb" }, "downloads": -1, "filename": "streamsx.database-1.3.0.tar.gz", "has_sig": false, "md5_digest": "aa8c6af0f53de7a2a2f54ab51ff27ddf", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5827, "upload_time": "2019-06-05T11:26:49", "url": "https://files.pythonhosted.org/packages/d3/00/7efb0219b91caac1b71fe47cab16477ffb96d6a2b6dcb3369e9257957482/streamsx.database-1.3.0.tar.gz" } ], "1.4.0": [ { "comment_text": "", "digests": { "md5": "0187f7f0359a77c2ed5f67eb857f1cce", "sha256": "c8ec5dffb13e6a9f73546e01fae593321c745933fe04ecd125dc63d5c4c11b4b" }, "downloads": -1, "filename": "streamsx.database-1.4.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "0187f7f0359a77c2ed5f67eb857f1cce", "packagetype": "bdist_wheel", "python_version": "3.6", "requires_python": null, "size": 13637, "upload_time": "2019-09-03T09:29:48", "url": "https://files.pythonhosted.org/packages/23/be/3ec9c307cccdb19209303463bfe64fbc1c724ed91499009d861c68ff7835/streamsx.database-1.4.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "dc8baf7674a269ecaad8c361bb17a7a0", "sha256": "50f2420e108d27b026cf4439fbe0ea2e7beaac52f4b5710fc337d37fd9b300c4" }, "downloads": -1, "filename": "streamsx.database-1.4.0.tar.gz", "has_sig": false, "md5_digest": "dc8baf7674a269ecaad8c361bb17a7a0", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6720, "upload_time": "2019-09-03T09:29:46", "url": "https://files.pythonhosted.org/packages/0e/43/9fdfe543dd11dfafeece6bdc6e2c7b804e95fa8515e63483b19db9ffbbc9/streamsx.database-1.4.0.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "0187f7f0359a77c2ed5f67eb857f1cce", "sha256": "c8ec5dffb13e6a9f73546e01fae593321c745933fe04ecd125dc63d5c4c11b4b" }, "downloads": -1, "filename": "streamsx.database-1.4.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "0187f7f0359a77c2ed5f67eb857f1cce", "packagetype": "bdist_wheel", "python_version": "3.6", "requires_python": null, "size": 13637, "upload_time": "2019-09-03T09:29:48", "url": "https://files.pythonhosted.org/packages/23/be/3ec9c307cccdb19209303463bfe64fbc1c724ed91499009d861c68ff7835/streamsx.database-1.4.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "dc8baf7674a269ecaad8c361bb17a7a0", "sha256": "50f2420e108d27b026cf4439fbe0ea2e7beaac52f4b5710fc337d37fd9b300c4" }, "downloads": -1, "filename": "streamsx.database-1.4.0.tar.gz", "has_sig": false, "md5_digest": "dc8baf7674a269ecaad8c361bb17a7a0", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6720, "upload_time": "2019-09-03T09:29:46", "url": "https://files.pythonhosted.org/packages/0e/43/9fdfe543dd11dfafeece6bdc6e2c7b804e95fa8515e63483b19db9ffbbc9/streamsx.database-1.4.0.tar.gz" } ] }