On May 11, 2014, at 3:05 AM, Alexander Luksidadi
<alexander.luksid...@gmail.com> wrote:
> Im just trying to empties a one to many records by doing this:
>
> load.commodities = []
>
> then what happens next is:
>
> IntegrityError: (IntegrityError) null value in column "load_id" violates
> not-null constraint
> DETAIL: Failing row contains (35d39bd9-ca61-43ef-a5c5-7590c82aca1d,
> 2014-05-11 06:48:27.028485-04, 2014-05-11 06:51:41.511231-04, Product 4, , 4,
> 4, 4, 4, , a637cc84-fd6e-417c-bb59-5a4e3a435696,
> a8fca522-3b5f-429f-b58b-c0de4c05d725, null, , inch, lbs).
> 'UPDATE load_commodities SET updated_at=%(updated_at)s, load_id=%(load_id)s
> WHERE load_commodities.id = %(load_commodities_id)s' {'load_commodities_id':
> '35d39bd9-ca61-43ef-a5c5-7590c82aca1d', 'load_id': None, 'updated_at':
> datetime.datetime(2014, 5, 11, 6, 51, 41, 511231)}
>
> it seems like it triggers update and set all the fields to None instead of
> delete.
>
>
> here're my classes:
>
> class Load(Base):
> __tablename__ = 'loads'
> id = Column(GUID, primary_key=True, default=uuid.uuid4)
> ....
> commodities = relationship("LoadCommodity", backref=backref("load",
> uselist=False))
>
> class LoadCommodity(Base):
> __tablename__ = 'load_commodities'
> id = Column(GUID, primary_key=True, default=uuid.uuid4)
> load_id = Column(GUID, ForeignKey('loads.id'), nullable=False)
> ....
you want items removed from "commodities" to be deleted so you set
cascade="all, delete-orphan":
commodities = relationship("LoadCommodity", cascade="all, delete-orphan")
http://docs.sqlalchemy.org/en/rel_0_9/orm/tutorial.html#configuring-delete-delete-orphan-cascade
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
