marshmallow-sqlalchemy
marshmallow-sqlalchemy copied to clipboard
SQLAlchemy integration with marshmallow
Hi Folks, I'm trying to figure out how you should work with sqlalchemy and marshmallow to serialize and deserialize the values of a field which links to a key/value store...
I have a SQLA model: ``` python class Model(db.Model): __tablename__ = "table" id = Column(Integer, primary_key=True data = Column(PickleType, nullable=False) ``` Then auto create a Marshmallow Schema: ``` python class...
When model, schema, and resource is declared in the [app.py][1] everything works fine, but when I change the folder structure to this: ``` ├───models │ AuthorModel.py │ BookModel.py │ ├───resources...
enable SQLAlogging ``` user = User.query.first() db.session.expunge(user) UserSchema().dump(user) ... 2021-02-05 18:31:48,622 INFO sqlalchemy.engine.base.Engine SELECT "user".id AS user_id, ....... ``` What to do in order to prevent Schema refreshing of an...
I have the following code that defines some geographic entities, `City`, `State` and `Country`. `City` is foreign keyed to a `State`, and a `State` is foreign keyed to a `Country`....
Is this a sane pattern to follow to make use of `SQLAlchemyAutoSchema` with a non-orm (SQL Expression Language) table definition? ```python from sqlalchemy import Table, Column, Integer, String, MetaData from...
Hey, it seems custom hybrid property setters arent called when deserializing data: ```python from marshmallow_sqlalchemy import SQLAlchemyAutoSchema from sqlalchemy import Column, String, Integer from sqlalchemy.ext.declarative import declarative_base from sqlalchemy.ext.hybrid import...
When calling `schema.__filter_fields` with a collection, marshmallow tries to use the first item as a prototype to figure out the fields. In case of an empty collection, there is an...
When I am using a RelatedList with an `attribute=` loading the relationship seems to cause an error about unknown attributes. For example, if the Models are: ```python class School(Base): __tablename__...
In this case, there is an error that is thrown because the relationship seems to be using the field-name and not the attribute name. Related to https://github.com/marshmallow-code/marshmallow-sqlalchemy/issues/340