Metadata-Version: 1.1
Name: streamsx.database
Version: 1.4.0
Summary: IBM Streams Database integration
Home-page: https://github.com/IBMStreams/streamsx.database
Author: IBM Streams @ github.com
Author-email: hegermar@de.ibm.com
License: Apache License - Version 2.0
Description-Content-Type: UNKNOWN
Description: Overview
        ========
        
        Provides functions to run SQL statements to a database, for example IBM Db2 Warehouse.
        
        This package exposes the `com.ibm.streamsx.jdbc <https://ibmstreams.github.io/streamsx.jdbc/>`_ toolkit as Python methods for use with Streaming Analytics service on
        IBM Cloud and IBM Streams including IBM Cloud Pak for Data.
        
        * `Streaming Analytics service <https://console.ng.bluemix.net/catalog/services/streaming-analytics>`_
        * `IBM Streams developer community <https://developer.ibm.com/streamsdev/>`_
        * `IBM Db2 Warehouse <https://www.ibm.com/cloud/db2-warehouse-on-cloud>`_
        
        
        Sample
        ======
        
        A simple example of a Streams application that creates a table, inserts a row and deletes the table::
        
            from streamsx.topology.topology import *
            from streamsx.topology.schema import CommonSchema, StreamSchema
            from streamsx.topology.context import submit
            import streamsx.database as db
        
            topo = Topology()
            sql_create = 'CREATE TABLE RUN_SAMPLE (A CHAR(10), B CHAR(10))'
            sql_insert = 'INSERT INTO RUN_SAMPLE (A, B) VALUES (\'hello\', \'world\')'
            sql_drop = 'DROP TABLE RUN_SAMPLE'
            s = topo.source([sql_create, sql_insert, sql_drop]).as_string()
            res_sql = db.run_statement(s, credentials)
            res_sql.print()
            submit('STREAMING_ANALYTICS_SERVICE', topo)
            # Use for IBM Streams including IBM Cloud Private for Data
            # submit ('DISTRIBUTED', topo)
        
        Documentation
        =============
        
        * `streamsx.database package documentation <http://streamsxdatabase.readthedocs.io>`_
        
Keywords: streams,ibmstreams,streaming,analytics,streaming-analytics,db2,database
Platform: UNKNOWN
Classifier: Development Status :: 5 - Production/Stable
Classifier: License :: OSI Approved :: Apache Software License
Classifier: Programming Language :: Python :: 3
Classifier: Programming Language :: Python :: 3.5
Classifier: Programming Language :: Python :: 3.6
