Metadata-Version: 2.1
Name: pynuodb
Version: 4.1.0
Summary: NuoDB Python driver
Home-page: https://github.com/nuodb/nuodb-python
Author: NuoDB
Author-email: drivers@nuodb.com
License: BSD License
Description: ==============
        NuoDB - Python
        ==============
        
        .. image:: https://dl.circleci.com/status-badge/img/gh/nuodb/nuodb-python/tree/master.svg?style=svg
            :target: https://dl.circleci.com/status-badge/redirect/gh/nuodb/nuodb-python/tree/master
        
        .. contents::
        
        This package contains the community driven pure-Python NuoDB_ client library
        that provides a standard `PEP 249`_ SQL API. This is a community driven driver
        with limited support and testing from NuoDB.
        
        Requirements
        ------------
        
        * Python >= 2.7
        
          - Recommended Python version >= 3.8
        
          - Tested with CPython_ 2.7 and 3.6
        
        * NuoDB_ >= 6.0.2
        
        | If you don't have a NuoDB domain available you can create one using the Docker
          image on DockerHub.
        | See `Quick Start Guides / Docker`_.
        
        Installation
        ------------
        
        The current stable release is available on PyPI and can be installed with
        ``pip``::
        
            $ pip install pynuodb
        
        Alternatively (e.g. if ``pip`` is not available), a tarball can be downloaded
        from GitHub and installed with Setuptools::
        
            $ curl -L https://github.com/nuodb/nuodb-python/archive/master.tar.gz | tar xz
            $ cd nuodb-python*
            $ python setup.py install
            # The folder nuodb-python* can be safely removed now.
        
        Example
        -------
        
        Here is an example using the `PEP 249`_ API that creates some tables, inserts
        some data, runs a query, and cleans up after itself:
        
        .. code:: python
        
            import pynuodb
        
            options = {"schema": "test"}
            connect_kw_args = {'database': "test", 'host': "localhost", 'user': "dba", 'password': "dba", 'options': options}
        
            connection = pynuodb.connect(**connect_kw_args)
            cursor = connection.cursor()
            try:
                stmt_drop = "DROP TABLE IF EXISTS names"
                cursor.execute(stmt_drop)
        
                stmt_create = """
                CREATE TABLE names (
                    id BIGINT NOT NULL GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
                    name VARCHAR(30) DEFAULT '' NOT NULL,
                    age INTEGER DEFAULT 0
                )"""
                cursor.execute(stmt_create)
        
                names = (('Greg', 17,), ('Marsha', 16,), ('Jan', 14,))
                stmt_insert = "INSERT INTO names (name, age) VALUES (?, ?)"
                cursor.executemany(stmt_insert, names)
        
                connection.commit()
        
                age_limit = 15
                stmt_select = "SELECT id, name FROM names where age > ? ORDER BY id"
                cursor.execute(stmt_select, (age_limit,))
                print("Results:")
                for row in cursor.fetchall():
                    print("%d | %s" % (row[0], row[1]))
        
            finally:
                cursor.execute(stmt_drop)
                cursor.close()
                connection.close()
        
        For further information on getting started with NuoDB, please refer to the Documentation_.
        
        Resources
        ---------
        
        DB-API 2.0: https://www.python.org/dev/peps/pep-0249/
        
        NuoDB Documentation: https://doc.nuodb.com/nuodb/latest/introduction-to-nuodb/
        
        License
        -------
        
        PyNuoDB is licensed under a `BSD 3-Clause License`_.
        
        .. _Documentation: https://doc.nuodb.com/nuodb/latest/introduction-to-nuodb/
        .. _NuoDB: https://www.nuodb.com/
        .. _CPython: https://www.python.org/
        .. _PEP 249: https://www.python.org/dev/peps/pep-0249/
        .. _Quick Start Guides / Docker: https://doc.nuodb.com/nuodb/latest/quick-start-guide/docker/
        .. _BSD 3-Clause License: https://github.com/nuodb/nuodb-python/blob/master/LICENSE
        
Keywords: nuodb scalable cloud database
Platform: UNKNOWN
Classifier: Development Status :: 5 - Production/Stable
Classifier: Environment :: Console
Classifier: Intended Audience :: Developers
Classifier: License :: OSI Approved :: BSD License
Classifier: Operating System :: OS Independent
Classifier: Programming Language :: Python
Classifier: Programming Language :: Python :: 2
Classifier: Programming Language :: Python :: 2.7
Classifier: Programming Language :: Python :: 3
Classifier: Programming Language :: Python :: 3.6
Classifier: Programming Language :: SQL
Classifier: Topic :: Database :: Front-Ends
Provides-Extra: crypto
