SQLAlchemy 1.4 / 2.0 support for aiohttp.
Project description
SQLAlchemy 1.4 / 2.0 support for aiohttp.
By default, library forwards:
sqlalchemy.ext.asyncio.AsyncSession object as request['sa_main'] or SAView.sa_main_session
sqlalchemy.ext.asyncio.AsyncEngine object as request.app['sa_main']
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_engine, sa_middleware
from datetime import datetime
import sqlalchemy as sa
from sqlalchemy import orm
from sqlalchemy.ext.asyncio import create_async_engine
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):
async with request.app['sa_main'].begin() as conn:
await conn.run_sync(Base.metadata.create_all)
async with request['sa_main'].begin():
request['sa_main'].add_all([MyModel()])
result = await request['sa_main'].execute(sa.select(MyModel))
data = {r.id: r.timestamp.isoformat() for r in result.scalars()}
return web.json_response(data)
app = web.Application()
engine = create_async_engine('sqlite+aiosqlite:///')
aiohttp_sqlalchemy.setup(app, [sa_engine(engine)])
app.add_routes([web.get('/', 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.2.post0.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | c315afa1760c4cc180efbb004c7a713ed1c09dbc2ab39bc26a4df63365753643 |
|
MD5 | 4cfb1acaec0482de49d732938eb8d72a |
|
BLAKE2b-256 | be5d58b92c90275805e1bfdb872f7f29f7070894f22dd9a91387caf860ae9657 |
Close
Hashes for aiohttp_sqlalchemy-0.2.post0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | d21c0ea95aa6026b0d615f2bd079f1251c23ddba6955b7d1f5a851699759688e |
|
MD5 | a5a87e24d17ca46e10b22df42ed473c1 |
|
BLAKE2b-256 | 91d9b383cd568c721ebb2dbafb66761f1b590c7d6c87f6b21aa8b4d55bfe7db9 |