Skip to main content

SQLAlchemy CRUD.

Project description

Build Status Coverage Status Stories in Progress PyPI

sacrud

SACRUD will solve your problem of CRUD interface for SQLAlchemy. Originally created for pyramid_sacrud , but then in a separate project

Look how easy it is to use:

CREATE

from .models import DBSession, Groups
from sacrud.action import CRUD

data = {'name': 'Electronics',
        'parent_id': '10',}
group_obj = CRUD(DBSession, Groups).create(data)
print(group_obj.name)

READ

from .models import DBSession, Groups
from sacrud.action import CRUD

group_obj = CRUD(DBSession, Groups).read()
print(group_obj.name)

UPDATE

from .models import DBSession, Groups
from sacrud.action import CRUD

group_obj = CRUD(DBSession, Groups).update(1, {'name': 'Chemistry'})
print(group_obj.name)

DELETE

from .models import DBSession, Groups
from sacrud.action import CRUD

CRUD(DBSession, Groups).delete(1)

Wraps your SQLAlchemy session

from sqlalchemy.orm import scoped_session, sessionmaker
from sacrud import crud_sessionmaker

DBSession = crud_sessionmaker(scoped_session(sessionmaker()))
help(DBSession.sacrud)

Now CRUD available from DBSession.

group_obj = DBSession.sacrud(Groups).create(data)
print(group_obj.name)

Installation

Install from github:

pip install git+http://github.com/ITCase/sacrud.git

PyPi:

pip install sacrud

Source:

python setup.py install

Contribute

Support

If you are having issues, please let me know. I have a mailing list located at sacrud@uralbash.ru and IRC channel #sacrud

License

The project is licensed under the MIT license.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

sacrud-0.2.2.tar.gz (13.6 kB view details)

Uploaded Source

File details

Details for the file sacrud-0.2.2.tar.gz.

File metadata

  • Download URL: sacrud-0.2.2.tar.gz
  • Upload date:
  • Size: 13.6 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No

File hashes

Hashes for sacrud-0.2.2.tar.gz
Algorithm Hash digest
SHA256 a741df62ffc57d46e32e77216ffd8d3f8760a4dc2a43c3d1bdfc5e5039f6412c
MD5 64392ce7bdde63ce9b0f703cb71b5e3e
BLAKE2b-256 691779cb5621d6cb4158aab610f68df64810c8a54c26c86cea2730329f9682be

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page