Skip to main content

Ayncio-based Python client for rqlite.

Project description

This package contains an asynchronous, pure-Python rqlite client library. (based on the official pyrqlite library)

Requirements

  • Python – one of the following:

    • CPython >= 3.6 recommended (>= 3.4 will work, probably)

  • rqlite Server

Example

The following code creates a connection and executes some statements:

import aiorqlite

@aiorqlite.arun
async def main():
        # Connect to the database
        async with aiorqlite.connect(':memory:') as db:
                async with db.cursor() as cursor:
                        await cursor.execute('CREATE TABLE foo (id integer not null primary key, name text)')
                        await cursor.executemany('INSERT INTO foo(name) VALUES(?)', seq_of_parameters=(('a',), ('b',)))

                async with db.cursor() as cursor:
                        # Read a single record with qmark parameter style
                        sql = "SELECT `id`, `name` FROM `foo` WHERE `name`=?"
                        await cursor.execute(sql, ('a',))
                        result = await cursor.fetchone()
                        print(result)
                        # Read a single record with named parameter style
                        sql = "SELECT `id`, `name` FROM `foo` WHERE `name`=:name"
                        await cursor.execute(sql, {'name': 'b'})
                        result = await cursor.fetchone()
                        print(result)

main()

This example will print:

{'id': 1, 'name': 'a'}
{'id': 2, 'name': 'b'}

Paramstyle

Only qmark and named paramstyles (as defined in PEP 249) are supported.

Limitations

Transactions are not supported.

License

pyrqlite (and subsequently aiorqlite) is released under the MIT License. See LICENSE for more information.

Project details


Download files

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

Source Distribution

AIOrqlite-0.2.3.tar.gz (10.0 kB view hashes)

Uploaded source

Built Distribution

AIOrqlite-0.2.3-py3-none-any.whl (13.7 kB view hashes)

Uploaded py3

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 NVIDIA NVIDIA PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page