'reusable' flag in Many-to-Many relation does not work!?

Question

'reusable' flag in Many-to-Many relation does not work!?

Vastly Jun '14

Created Jun '14	Last Reply Jun '14	Replies 1	Views 968	Votes 0

Vastly 2.3k

Jun '14

Hello all, i noticed that 'reusable' flag works fine for one-to-one and many-to-one relations, but does not for many-to-many ((. It looks like another sad point in many-to-many land, along with this https://forum.phalcon.io/discussion/2190/many-to-many-expected-behaviour#C8434

Let's imagine we have an obvious many-to-many relation between Posts and Tags:

// Posts
 $this->hasManyToMany(
                "id",
                "PostsTags",
                "postref", "tagref",
                "Tags",
                "id", ['reusable' => true]
            );

// PostsTags
    public function initialize()
    {
        $this->belongsTo("tagref", "Tags", "id", ['reusable' => true]);
        $this->belongsTo("postref", "Posts", "id", ['reusable' => true]);
    }

// Tags
 $this->hasManyToMany(
            "id",
            "PostsTags",
             "tagref", "postref",
            "Posts",
            "id", ['reusable' => true]
        );

and this queries the database again and again:

$post->Tags; // 'reusable' does not work at all

Any ideas?

Ak-Army · Answer 1 · 2014-06-10T01:08:40-07:00

Its wrong:

// Tags
 $this->hasManyToMany(
            "id",
            "PostsTags",
             "tagref", "postref",
            "Posts",
            "id", ['reusable' => true]
        );

maybe this way:

// Tags
 $this->hasManyToMany(
            "id",
            "Tags",
             "tagref", "postref",
            "PostsTags",
            "id", ['reusable' => true]
        );

Vastly · Answer 2 · 2014-06-10T11:40:53-07:00

it does not work the way you suggested. But my version works like a charm, but just 'reusable' functionality does not. Look at this sample from the official docs

class Robots extends \Phalcon\Mvc\Model
{
    public $id;

    public $name;

    public function initialize()
    {
        $this->hasManyToMany(
            "id",
            "RobotsParts",
            "robots_id", "parts_id",
            "Parts",
            "id"
        );
    }

}