Relations with composite keys on Models

Question

Relations with composite keys on Models

Álef Miranda Oct '13

Created Oct '13	Last Reply Feb '16	Replies 4	Views 1788	Votes 1

Álef Miranda 1.7k

Oct '13

Hi guys, I am new at Phalcon and I have a question.

How can I create a model relation with a composite primary key? I have tables in my schema with composite primary keys. The relations BelongsTo and HasMany seems not to have this feature.

I am doing this way:

public function initialize() { $this->belongsTo('idUser', 'Fortec\Models\Form', 'idUser', array ('alias' => 'FormUsers')); $this->belongsTo('idForm', 'Fortec\Models\Form', 'id', array ('alias' => 'Forms')); $this->hasMany('idForm', 'Fortec\Models\BrFormImage', 'idForm', array ('alias' => 'BrFormImages')); $this->hasMany('idUser', 'Fortec\Models\BrFormImage', 'idUser', array ('alias' => 'BrFormImageUsers')); $this->hasMany('idForm', 'Fortec\Models\BrFormCorrection', 'idForm', array ('alias' => 'BrFormCorrections')); $this->hasMany('idUser', 'Fortec\Models\BrFormCorrection', 'idUser', array ('alias' => 'BrFormCorrectionUsers'));
}

Thanks.

1

Phalcon · Answer 1 · 2013-10-14T10:34:11-07:00

You can pass an array of fields instead of a single field:

$this->belongsTo(array('field1', 'field2'), 'Model', array('field1', 'field2'));

Álef Miranda · Answer 2 · 2013-10-14T11:57:00-07:00

Álef Miranda
1.7k

Oct '13

Thanks.

Gianks · Answer 3 · 2014-01-05T18:03:00-07:00

Hi Phalcon,

while trying to use an array as you suggested in a hasMany relation i get a "Not Implemented Exception" while trying to set the related Object via relation alias. The approch you suggested works fine in reading since i can count the elements, but i can't update the value of the relation.

A sample code here: baggages table has a composite PK so array of cols has been used in Person Model relation initialization. $Person->Baggages = $passengerBags; //array of Baggages This causes an exception with the message "Not Implemented". How can i deal with this? Is this a bug?

Thanks

GBraL · Answer 4 · 2015-03-06T07:01:15-07:00

$this->hasMany(array('field1','field2'), 'Model', array('field1','field2'), array(
    'foreignKey' => array(
        'message' => 'this field can\'t be deleted because have relation with another object.'
    )
));

ZStelmo · Answer 5 · 2016-02-22T05:15:25-07:00

Hi Phalcon, This code is working , but the result is incorrect. The result of this relation:

$this->belongsTo(array('field1', 'field2'), 'Model', array('field1', 'field2'))

Is diferente of this :

$this->belongsTo('field1', 'Model', 'field1'); $this->belongsTo('field2', 'Model', 'field2');

In my case the seconde is what give the right result .