Would you write a failing test for this condition? I looked at the
unit tests but wasn't able to make a failing test. So that is why I
modified the example.
I also tried to formulate a work around. And failed at that as well.
On 6/12/07, Michael Bayer <[EMAIL PROTECTED]> wrote:
>
> Ive added ticket #597 for this.
>
> On Jun 12, 2:22 am, "Paul Kippes" <[EMAIL PROTECTED]>
> wrote:
> > Starting with r2598, I'm seeing some failures with how I'm using the
> > association proxy. I've modified the
> > examples/association/proxied_association.py file which duplicates the
> > problem.
> >
> > It is possible that I'm not suppose to remove associations like I am.
> > But it did work before (in 0.3.7 and 0.3.6).
> >
> > It looks like if I read in part of the association into the current
> > session and then delete it, things don't go so well.
> >
> > Index: examples/association/proxied_association.py
> > ===================================================================
> > --- examples/association/proxied_association.py (revision 2723)
> > +++ examples/association/proxied_association.py (working copy)
> > @@ -106,8 +106,18 @@
> >
> > +# new additions to proxied_association.py
> >
> > +#engine.echo = True
> >
> > +new_item = Item('new item', 100)
> > +session.clear()
> > +order = session.query(Order).get_by(customer_name='john smith')
> > +bogus = order.items[0].item_id # comment out and it works on 0.3.8
> > +order.itemassociations = None
> > +session.flush()
> > +order.items.append(new_item)
> > +session.flush()
> >
> > It fails with:
> > sqlalchemy.exceptions.SQLError: (IntegrityError) orderitems.order_id
> > may not be NULL u'INSERT INTO orderitems (item_id, price) VALUES (?,
> > ?)' [5, 100]
> >
> > Thanks,
> > Paul
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
