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;
preventing attributes from being expired after commit by default;
support different types of request handlers;
support nested applications.
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 datetime import datetime
import sqlalchemy as sa
from aiohttp import web
from sqlalchemy import orm
import aiohttp_sqlalchemy
from aiohttp_sqlalchemy import sa_session
metadata = sa.MetaData()
Base = orm.declarative_base(metadata=metadata)
class MyModel(Base):
__tablename__ = "my_table"
pk = 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.begin():
db_session.add(MyModel())
result = await db_session.execute(sa.select(MyModel))
result = result.scalars()
data = {
instance.pk: instance.timestamp.isoformat()
for instance in result
}
return web.json_response(data)
async def app_factory():
app = web.Application()
bind = aiohttp_sqlalchemy.bind("sqlite+aiosqlite:///")
aiohttp_sqlalchemy.setup(app, [bind])
await aiohttp_sqlalchemy.init_db(app, metadata)
app.add_routes([web.get("/", main)])
return app
if __name__ == "__main__":
web.run_app(app_factory())
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.17.3.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | d2f23c3c8414d1b7f910f79c9d6fa22ccb5079573a9409230e059f0f7c35aee3 |
|
MD5 | ae4008b876b8e3392fc0f5ab422db971 |
|
BLAKE2b-256 | 81b2c5387c2af9237f30a0d3302bc57018b51f6c36f9414a5159e2257bcb7a9d |
Close
Hashes for aiohttp_sqlalchemy-0.17.3-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 2797bf23de489fa1926f69f658fa5d0a0d952f326f7e8c29b6e1a2de1e1f3547 |
|
MD5 | 59fea11e0547c549638ee1be1d8d7f91 |
|
BLAKE2b-256 | 16151b3436ef7ba64ea254755b5da4de7e2449e4cd43274676d1950c395994eb |