Kohana 3.0.x ORM: Read additional columns in pivot tables

Question

I'm using Kohana v3 and ORM, I have two models, Model_A and Model_B related by "has_many" through a pivot table, which has an additional column. I can save data in that column in the pivot table using the third parameter of the add() function, but I can't figure out how to read that column using ORM.

Any ideas? Thanks in advance.

score 9 · Accepted Answer · answered Dec 23 '09 at 01:45

9

You need to create a Model that is based on that pivot table if you want to access that additional column, let say we name it Model_A_B.

class Model_A_B extends ORM {

    protected $_belongs_to = array(
        'A' => array(),
        'B' => array()
    );

}

Then, if $a is an instance of Model_A and $b is an instance of Model_B, we get the Model_A_B instance by calling:

$ab = ORM::factory('A_B', array('A_id' => $a, 'B_id' => $b));

if ($ab->loaded()) {
    // do stuff
}

answered Dec 23 '09 at 01:45

Lukman

18,462
6
56
66

You're showing to retrieve a value from a pivot but can you also show a way to initially set the value in the pivot? – Luke Feb 07 '11 at 02:47
where would you store that model? ...models/a/b.php ? – Brenden Jan 26 '12 at 18:24
@Brenden: Yes, models/a/b.php – dusan Jul 20 '12 at 15:10

Kohana 3.0.x ORM: Read additional columns in pivot tables

1 Answers1

Linked