Support symmetrical ManyToMany relationships about tortoise-orm HOT 2 OPEN

Hi!

I am not sure, but if understand correct - we already support that:

You can see example at
https://github.com/tortoise/tortoise-orm/blob/develop/examples/relations_recursive.py#L24

Please write if I am wrong on what's issue

from tortoise-orm.

Hi, thanks for your response!

The example you linked shows recursdive relations, but they're not symmetrical. talks_to and gets_talked_to are two different sets despite being the same relation, if it's symmetrical then both sets should be identical.

Once again, I like the example of "If X is my friend, then I am the friend of X". If talks_to was symmetrical, this would work:

>>> await _1.talks_to.add(_2, _1_1_1, loose)
>>> await _1.talks_to.all()
[<Employee: 4>, <Employee: 6>, <Employee: 2>]
>>> await _2.talks_to.all()  # right now this returns an empty list
[<Employee: 3>]

from tortoise-orm.