1

I'm trying to create multiple relationship from the same nodes, in my case, my user needs to be able to comment more than one time in my Post. I did that by creating an relationship between User and Post. But when I try to create it, it actually updates the old relationship. Have I done anything wrong? Is there an better way to do this?

graph.schema.create_uniqueness_constraint('COMMENTS', 'uuid')

def comment(self, post_uuid, comment):
    post = self.graph.find_one('Post','uuid', post_uuid)
    user = self.graph.find_one('User','uuid', self.uuid)
    r_comment = Relationship(user, "COMMENTS", post, comment=comment, uuid=uuid4().hex, date=str(datetime.utcnow()))
    self.graph.create(r_comment)
    return True
Felipe Santiago
  • 414
  • 6
  • 16

1 Answers1

2

This type of model is not supported by the higher level py2neo API. You'll have to drop down into Cypher to work with this.

Consider though whether your model is extensible in its current form. The reason for this design decision in py2neo is that this kind of model is often non-optimal and could generally be improved by adding another node. In your case a node would represent a comment.

So instead of having:

(:User)-[:COMMENTS_ON]->(:Post)

You would have:

(:User)-[:WRITES_COMMENT]->(:Comment)-[:RELATES_TO_POST]->(:Post)

This extracts another "noun" in your model into a new node type. Consequently you can now make links to the comment itself, which is not possible if you model it as a relationship.

Hope this helps.

Nigel Small
  • 4,475
  • 1
  • 17
  • 15
  • Hey, thanks for the help! I will do as you said, it makes sense to change comment to a node type since it also enables an operation where User can like or hate Comments. – Felipe Santiago Dec 09 '16 at 14:31