Figured it out, I was being retarded. Thanks!
On Apr 19, 7:33 pm, Aviv Giladi <avivgil...@gmail.com> wrote:
> Hey guys,
> I am playing around with SQLAlchemy (over Pylons) and encountering a
> strange problem. I am using the adjacency list relationship concept to
> represent nodes and their parents in a single table. I copied exactly
> this code from the examples:
>
> class Node(Base):
> __tablename__ = 'nodes'
> id = Column(Integer, primary_key=True)
> parent_id = Column(Integer, ForeignKey('nodes.id'))
> data = Column(Unicode(50))
>
> children = relationship('Node',
> cascade="all",
> backref=backref("parent", remote_side='Node.id'),
> # tried with and without this:
> collection_class=attribute_mapped_collection('data'),
> )
>
> My test is basically adding two nodes, like so:
>
> n = Node()
> n.id = 1
> n.parent_id = 0
> n.data = 'parent'
> n2 = Node()
> n2.id = 2
> n2.parent_id = 1
> n2.data = 'child'
> Session.add(n)
> Session.add(n2)
> Session.commit()
>
> When I run my test, I get the following exception raised from
> connections.py:
> sqlalchemy.exc.IntegrityError: (IntegrityError) (1452, 'Cannot add or
> update a child row: a foreign key constraint fails (`db`.`nodes`,
> CONSTRAINT `nodes_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `nodes`
> (`id`))') 'INSERT INTO nodes (id, parent_id, data) VALUES (%s, %s,
> %s)' (1, 0, 'parent')
>
> Please, what am I missing here?
>
> Thanks!
--
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.
