SQLAlchemy integration with the marshmallow (de)serialization library
Project description
Homepage: https://marshmallow-sqlalchemy.readthedocs.io/
SQLAlchemy integration with the marshmallow (de)serialization library.
Declare your models
import sqlalchemy as sa
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import scoped_session, sessionmaker, relationship, backref
engine = sa.create_engine('sqlite:///:memory:')
session = scoped_session(sessionmaker(bind=engine))
Base = declarative_base()
class Author(Base):
__tablename__ = 'authors'
id = sa.Column(sa.Integer, primary_key=True)
name = sa.Column(sa.String)
def __repr__(self):
return '<Author(name={self.name!r})>'.format(self=self)
class Book(Base):
__tablename__ = 'books'
id = sa.Column(sa.Integer, primary_key=True)
title = sa.Column(sa.String)
author_id = sa.Column(sa.Integer, sa.ForeignKey('authors.id'))
author = relationship("Author", backref=backref('books'))
Base.metadata.create_all(engine)Generate marshmallow schemas
from marshmallow_sqlalchemy import ModelSchema
class AuthorSchema(ModelSchema):
class Meta:
model = Author
class BookSchema(ModelSchema):
class Meta:
model = Book
# optionally attach a Session
# to use for deserialization
sqla_session = session
author_schema = AuthorSchema()(De)serialize your data
author = Author(name='Chuck Paluhniuk')
book = Book(title='Fight Club', author=author)
session.add(author)
session.add(book)
session.commit()
author_schema.dump(author).data
# {'books': [123], 'id': 321, 'name': 'Chuck Paluhniuk'}
author_schema.load(dump_data, session=session).data
# <Author(name='Chuck Paluhniuk')>Get it now
pip install -U marshmallow-sqlalchemy
Documentation
Documentation is available at https://marshmallow-sqlalchemy.readthedocs.io/ .
Project Links
License
MIT licensed. See the bundled LICENSE file for more 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
File details
Details for the file marshmallow-sqlalchemy-0.12.0.tar.gz.
File metadata
- Download URL: marshmallow-sqlalchemy-0.12.0.tar.gz
- Upload date:
- Size: 38.2 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 8a7e56dcf95a27287359812e3285ed72d333f72a50d8ca760fb1c1527ea2c52b |
|
| MD5 | 6c9e2ea5d1de8771aef29223ec4f3aca |
|
| BLAKE2b-256 | 3496e270eac1816ca5855c388c16bbfe8fde8e09234106e206050e062cf46ef1 |
Provenance
File details
Details for the file marshmallow_sqlalchemy-0.12.0-py2.py3-none-any.whl.
File metadata
- Download URL: marshmallow_sqlalchemy-0.12.0-py2.py3-none-any.whl
- Upload date:
- Size: 12.8 kB
- Tags: Python 2, Python 3
- Uploaded using Trusted Publishing? No
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 60e09242925aeaca39394b1a6672e9f12ab67fc3ea9d9aec57135297e4306128 |
|
| MD5 | 10db7fde61ec8b4173be23267b9f8d36 |
|
| BLAKE2b-256 | 156943b9e93ef60d443132ab2d6023c06f9bea1db3dbf0cf579c07d37e792eed |
