Once i did what you said, I'm trying to insert values to the db:
indg=IndicatorGroups(idindicatorgroup=None, name=group)
session.save(indg)
session.flush()
indsg=IndicatorGroups(idindicatorgroup=None, name=subgroup)
session.save(indsg)
session.flush()
I create two IndicatorGroups but when I want to create a GroupGroups:
groupgroup=GroupGroups(idgroupgroup=None,idindicatorgroupcontainer=indg.idindicatorgroup,
idindicatorgroupcontained=indsg.idindicatorgroup)
session.save(groupgroup)
session.flush()
I have this problem:
Traceback (innermost last):
Module ZPublisher.Publish, line 115, in publish
Module ZPublisher.mapply, line 88, in mapply
Module ZPublisher.Publish, line 41, in call_object
Module Products.odr.lugabe_db.browser.csv_insert, line 26, in __call__
Module Products.odr.lugabe_db.insert, line 42, in insert
Module sqlalchemy.orm.attributes, line 1025, in init
Module Products.odr.lugabe_db.groupgroups, line 18, in __init__
Module sqlalchemy.orm.attributes, line 32, in __set__
Module sqlalchemy.orm.attributes, line 363, in set
Module sqlalchemy.orm.attributes, line 304, in fire_replace_event
AttributeError: 'long' object has no attribute '_state'
2007/11/6, lur ibargutxi <[EMAIL PROTECTED]>:
> thanks a lot. That's the solution.
>
> 2007/11/6, Marco Mariani <[EMAIL PROTECTED]>:
> >
> > lur ibargutxi wrote:
> >
> > I forgot. Try using tables instead of classes that are not mapped yet..
> >
> > mappers['groupgroups'] = mapper(GroupGroups, tables['groupgroups'],
> > properties = {
> >
> > 'idindicatorgroupcontainer' : relation(IndicatorGroups,
> > primaryjoin=sql.and_(tables['indicatorgroups'].c.idindicatorgroup==tables['groupgroups'].c.idindicatorgroupcontainer)),'idindicatorgroupcontained'
> > : relation(IndicatorGroups,
> > primaryjoin=sql.and_(tables['indicatorgroups'].c.idindicatorgroup==tables['groupgroups'].c.idindicatorgroupcontained)),
> > },allow_column_override=True)
> >
> >
> >
> >
> > > >
> >
>
>
> --
> Lur Ibargutxi
> [EMAIL PROTECTED]
>
--
Lur Ibargutxi
[EMAIL PROTECTED]
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
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
-~----------~----~----~----~------~----~------~--~---
