Async Support for various databases
Project description
AIO-Databases
The package gives you asycio support for a range of databases (SQLite, PostgreSQL, MySQL).
Requirements
- python >= 3.7
Installation
aio-databases should be installed using pip:
$ pip install aio-databases
You can install the required database drivers with:
$ pip install aio-databases[sqlite]
$ pip install aio-databases[postgresql]
$ pip install aio-databases[mysql]
Usage
- Init a database
from aio_databases import Database
db = Database('sqlite:///:memory:')
- Prepare the database to work
async def my_app_starts():
# Initialize a database's pool
await db.connect()
async def my_app_ends():
# Close pool/connections
await db.disconnect()
# As an alternative users are able to use the database
# as an async context manager
async with db:
await my_main_coroutine()
- Run SQL queries
await db.execute('select $1', '1')
await db.executemany('select $1', '1', '2', '3')
records = await db.fetchall('select (2 * $1) res', 2)
assert records == [(4,)]
record = await db.fetchone('select (2 * $1) res', 2)
assert record == (4,)
assert record['res'] == 4
result = await db.fetchval('select 2 * $1', 2)
assert result == 4
- Use transactions
async with db.transaction() as trans1:
# do some work ...
async with db.transaction() as trans2:
# do some work ...
await trans2.rollback()
Bug tracker
If you have any suggestions, bug reports or annoyances please report them to the issue tracker at https://github.com/klen/aio-databases/issues
Contributing
Development of the project happens at: https://github.com/klen/aio-databases
License
Licensed under a MIT License
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
aio-databases-0.0.14.tar.gz
(7.5 kB
view details)
Built Distribution
File details
Details for the file aio-databases-0.0.14.tar.gz.
File metadata
- Download URL: aio-databases-0.0.14.tar.gz
- Upload date:
- Size: 7.5 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.4.2 importlib_metadata/4.7.1 pkginfo/1.7.1 requests/2.26.0 requests-toolbelt/0.9.1 tqdm/4.62.2 CPython/3.9.6
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 70f8d1e9be92d29f295a1a3f38f91a431c48e2ef9cfc2bedf983a9f61314f5dd |
|
| MD5 | 25d4e92ba3a2083c5d1ccfc2bf7ae67c |
|
| BLAKE2b-256 | 15ef1af21bc2e36037549758f87819bc31d8e517b70fb7f2c5e15c2b5d0acbc4 |
File details
Details for the file aio_databases-0.0.14-py3-none-any.whl.
File metadata
- Download URL: aio_databases-0.0.14-py3-none-any.whl
- Upload date:
- Size: 8.5 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.4.2 importlib_metadata/4.7.1 pkginfo/1.7.1 requests/2.26.0 requests-toolbelt/0.9.1 tqdm/4.62.2 CPython/3.9.6
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 79012427ca59c9afb0fd313b861d8fb00e2b195779774d4e08110d8e1f4d66a2 |
|
| MD5 | 10e53b724d1514962424a68b610254e9 |
|
| BLAKE2b-256 | 18528e31746b164fdca404b5c865b6435889f7e817664bbcfea505f81f65844b |
