modelsCache not working for hasManyToMany #15374

gdluck · 2021-04-04T17:00:16Z

gdluck
Apr 4, 2021

Hello!

I tried to cache related results using cache option and simply fail. I have modelsCache which is working on model query, getRelated works only with hasMany, not hasManyToMany.
Is this a known bug? (Phalcon 4.1.0 / PHP 7.4.13)

        $this->hasManyToMany(
            'id',
            __NAMESPACE__ . '\VideoCategories',
            'video_id',
            'category_id',
            __NAMESPACE__ . '\Categories',
            'id',
            [
                'alias' => 'Categories',
                'reusable' => true
            ]
        );
        $this->hasMany('id', __NAMESPACE__ . '\VideoCategories', 'video_id', [
            'foreignKey' => [
                'action' => Relation::ACTION_CASCADE,
            ],
            'alias' => 'VideoCategories',
            'reusable' => true
        ]);

        //not caching
        $categories = $video->getRelated('Categories', [
            'cache' => [
                'key'      => $video->id.'-categories',
                'lifetime' => 86000,
            ]
        ]);
        //working
        $categories = $video->getRelated('VideoCategories', [
            'cache' => [
                'key'      => $video->id.'-video-categories',
                'lifetime' => 86000,
            ]
        ]);

Thanks!