asyncio sqlalchemy support
Project description
asyncnsq
asyncio sqlalchemy support,with async/await
add asyncio sqlalchemy support
Install
pip install asyncsa
Usage examples
import asyncio
from sqlalchemy import Integer, Column, String, ForeignKey
from asyncsa.manager.async_pg import PostgresManager
from asyncsa.model.mixin import Mixin
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import relationship
from sqlalchemy.sql import select
dsn = "postgres://postgres:test@localhost:2345/test"
conf = {'dsn': dsn}
Base = declarative_base()
Manager = PostgresManager(conf=conf)
class User(Mixin, Base):
_manager = Manager
__tablename__ = 'test'
id = Column(Integer, autoincrement=True, primary_key=True)
name = Column(String(50))
def __repr__(self):
return "<User(name='%s', id='%s')>" % (
self.name, self.id)
class Parent(Mixin, Base):
__tablename__ = 'parent'
_manager = Manager
id = Column(Integer, primary_key=True)
child = relationship("Child", lazy='joined')
class Child(Mixin, Base):
_manager = Manager
__tablename__ = 'child'
id = Column(Integer, primary_key=True)
parent_id = Column(Integer, ForeignKey('parent.id'))
parent = relationship("Parent", back_populates="child")
if __name__ == '__main__':
loop = asyncio.get_event_loop()
loop.run_until_complete(Manager.connect())
result = loop.run_until_complete(Manager.get(
User.objects([User.id]).join(
Parent.__table__,
Parent.id == User.id)))
print(result)
# result = loop.run_until_complete(Child.create_table())
# print(result)
# u = loop.run_until_complete(User.create(name='test'))
# print('create', u)
# print('get', loop.run_until_complete(User.get(name='test')))
# print('all', loop.run_until_complete(User.all()))
# u.name = 'aaa'
# print('save', loop.run_until_complete(u.save()))
License
The asyncnsq is offered under MIT license.
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 Distributions
No source distribution files available for this release.See tutorial on generating distribution archives.
Built Distribution
File details
Details for the file asyncsa-1.1.0-py3-none-any.whl
.
File metadata
- Download URL: asyncsa-1.1.0-py3-none-any.whl
- Upload date:
- Size: 7.9 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/1.13.0 pkginfo/1.5.0.1 requests/2.22.0 setuptools/41.0.1 requests-toolbelt/0.9.1 tqdm/4.32.1 CPython/3.6.6
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9fbf6acb29709c51522a301f492305987753084928116447f90a76e107e3ee6b |
|
MD5 | bfdc379b0829dc6f25a05711f2eaa51a |
|
BLAKE2b-256 | acfdb2d16a541d0831f4a85c06900bbeda41c5a79fe6a30fdf200931eae823da |