SQLAlchemy 1.4 / 2.0 support for aiohttp.
Project description
SQLAlchemy 1.4 / 2.0 support for aiohttp.
The library provides the next features:
initializing asynchronous sessions through a middlewares;
initializing asynchronous sessions through a decorators;
simple access to one asynchronous session by default key;
support for different types of request handlers.
Documentation
Installation
pip install aiohttp-sqlalchemy
Simple example
Install aiosqlite for work with sqlite3:
pip install aiosqlite
Copy and paste this code in a file and run:
from aiohttp import web
import aiohttp_sqlalchemy
from aiohttp_sqlalchemy import sa_bind, sa_session
from datetime import datetime
import sqlalchemy as sa
from sqlalchemy import orm
metadata = sa.MetaData()
Base = orm.declarative_base(metadata=metadata)
class MyModel(Base):
__tablename__ = 'my_table'
id = sa.Column(sa.Integer, primary_key=True)
timestamp = sa.Column(sa.DateTime(), default=datetime.now)
async def main(request):
db_session = sa_session(request)
async with db_session.bind.begin() as connection:
await connection.run_sync(Base.metadata.create_all)
async with db_session.begin():
db_session.add_all([MyModel()])
result = await db_session.execute(sa.select(MyModel))
data = {record.id: record.timestamp.isoformat()
for record in result.scalars()}
return web.json_response(data)
app = web.Application()
aiohttp_sqlalchemy.setup(app, [sa_bind('sqlite+aiosqlite:///')])
app.add_routes([web.get('/', main)])
if __name__ == '__main__':
web.run_app(app)
Project details
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
Built Distribution
Close
Hashes for aiohttp-sqlalchemy-0.13.0.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 10da6cd27b4c1d68bec7c2e384bb66ceb01a2324aa59624330a1e22433c587d3 |
|
MD5 | 56860fe303214595bf808bfae8f7f3e6 |
|
BLAKE2b-256 | 03688c3c758b697db3237c0ca63b0c2dc16367d581b2a79e53c00ae4c32fa47d |
Close
Hashes for aiohttp_sqlalchemy-0.13.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 35195436265de1954f7aeda91f5d472a699216f419e6b21172485c116b76f335 |
|
MD5 | fd8a52321b3a5ba04e6f1c7f1943902c |
|
BLAKE2b-256 | 19640aaad8b045c21fde16ce52a0c8b464d25191f009d5ea0a8f4e509936dc70 |