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.

Files for AIOrqlite, version 0.2.3
Filename, size File type Python version Upload date Hashes
Filename, size AIOrqlite-0.2.3-py3-none-any.whl (13.7 kB) File type Wheel Python version py3 Upload date Hashes View
Filename, size AIOrqlite-0.2.3.tar.gz (10.0 kB) File type Source Python version None Upload date Hashes View

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring DigiCert DigiCert EV certificate Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page