2007/11/6, lur ibargutxi <[EMAIL PROTECTED]>:
> 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)
I think this is wrong and I have to do like this:
groupgroup=GroupGroups(idgroupgroup=None,idindicatorgroupcontainer=indg,
idindicatorgroupcontained=indsg)
but now the error is the next one:
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 44, in insert
Module sqlalchemy.orm.session, line 681, in flush
Module sqlalchemy.orm.unitofwork, line 216, in flush
Module sqlalchemy.orm.unitofwork, line 432, in execute
Module sqlalchemy.orm.unitofwork, line 1051, in execute
Module sqlalchemy.orm.unitofwork, line 1068, in execute_save_steps
Module sqlalchemy.orm.unitofwork, line 1081, in execute_dependencies
Module sqlalchemy.orm.unitofwork, line 1062, in execute_dependency
Module sqlalchemy.orm.unitofwork, line 1017, in execute
Module sqlalchemy.orm.dependency, line 282, in process_dependencies
Module sqlalchemy.orm.dependency, line 317, in _synchronize
Module sqlalchemy.orm.sync, line 91, in execute
Module sqlalchemy.orm.sync, line 143, in execute
Module sqlalchemy.orm.mapper, line 936, in set_attr_by_column
Module sqlalchemy.orm.util, line 101, in __getitem__
KeyError: Column(u'idindicatorgroupcontained', MSInteger(length=11),
ForeignKey(u'indicatorgroups.idindicatorgroup'), nullable=False,
default=PassiveDefault(u'0'))
Someone knows how can I fix this?
Thanks a lot
> 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]
>
--
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
-~----------~----~----~----~------~----~------~--~---
