Must have been a bug in the default constructor prior to 0.5.0 final.
I got the same error rerunning with earlier version. Strange, I don't
remember now how I had this running before. Maybe with my own
constructor, but not worth igging to find out, it works with final
release.
On Jan 11, 1:43 pm, Darren Govoni <dar...@ontrenet.com> wrote:
> Ahhh, looks like I'm on rc4. Let me try final and see.
>
> On Sun, 2009-01-11 at 13:10 -0500, Michael Bayer wrote:
> > 0.5.0 final ?
>
> > On Jan 11, 2009, at 12:21 PM, Darren Govoni wrote:
>
> > > Hi MikeCo,
> > > I tried your example, and got this error from SA 0.5.
>
> > > ValueError: need more than 0 values to unpack
>
> > > Darren
>
> > > On Fri, 2009-01-09 at 20:33 -0800, MikeCo wrote:
> > >> from sqlalchemy import *
> > >> from sqlalchemy.orm import *
> > >> from sqlalchemy.ext.declarative import declarative_base
>
> > >> dbname = ''
> > >> dburl = 'sqlite:///%s' % dbname
>
> > >> # set up environment
> > >> eng = create_engine(dburl, echo=False)
> > >> meta = MetaData(bind=eng)
> > >> Base = declarative_base(metadata=meta)
> > >> Session = sessionmaker()
>
> > >> # D self referential
> > >> class D(Base):
> > >> __tablename__ = 'D'
> > >> id = Column(Integer, primary_key=True)
> > >> id_d = Column(Integer, ForeignKey('D.id'))
> > >> name = Column(Text)
> > >> child = relation('D',
> > >> backref=backref('parent', remote_side='D.id'))
> > >> def __repr__(self):
> > >> return '--<D> (id:%s->id_d:%s) %s --' % (self.id, self.id_d,
> > >> self.name)
>
> > >> def initdb():
> > >> print '# create the database'
> > >> meta.drop_all(checkfirst=True)
> > >> meta.create_all()
> > >> sess = Session()
>
> > >> # insert some data for self-reference relationship
> > >> for ddata in ('d-one', 'd-two'):
> > >> dobj = D(name=ddata)
> > >> sess.add(dobj)
> > >> dobj2 = D(name=ddata+'-child1')
> > >> dobj.child.append(dobj2)
> > >> dobj2 = D(name=ddata+'-child2')
> > >> dobj.child.append(dobj2)
> > >> dobj3 = D(name=ddata+'-child2'+'-child3')
> > >> dobj2.child.append(dobj3)
> > >> sess.commit()
> > >> sess.close()
>
> > >> def printobj(obj, indent=''):
> > >> # recursive list
> > >> print '%s%s' % (indent, obj)
> > >> if hasattr(obj, 'child'):
> > >> for ch in obj.child:
> > >> printobj(ch, indent=indent+' ')
>
> > >> def listd():
> > >> # retrieve and list
> > >> sess = Session()
> > >> print '# D->D'
> > >> query = sess.query(D).filter(D.id_d==None).order_by(D.name)
> > >> for dobj in query:
> > >> printobj(dobj)
> > >> sess.close()
>
> > >> def tst3():
> > >> # do stuff with self referential class D
> > >> sess = Session()
> > >> print "#switch parentage of name 'd-two-child1' to 'd-one'"
> > >> print '# before'
> > >> listd()
> > >> child = sess.query(D).filter(D.name=='d-two-child1').one()
> > >> parent = sess.query(D).filter(D.name=='d-one').one()
> > >> eng.echo=True
> > >> child.parent = parent
> > >> child.name += ' MOVED'
> > >> sess.commit()
> > >> eng.echo=False
> > >> print '# after'
> > >> listd()
>
> > >> initdb()
> > >> tst3()
--~--~---------~--~----~------------~-------~--~----~
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
sqlalchemy+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
