Save()/Update()/Create() fails on models with relations using composite primary keys

Question

Save()/Update()/Create() fails on models with relations using composite primary keys

Stefan Crnjaković Oct '14

Created Oct '14	Last Reply Dec '15	Replies 3	Views 1071	Votes 0

Stefan Crnjaković 5.5k

Oct '14

Hello everyone, 'Not Implemented' Exception is being thrown at me when I try to update/create a model which has a relation using composite primary keys. Naturally, I thought that this is yet to be implemented, however while I was searching the web, I came across some thread answers by @phalcon which imply that this is actually possible to pull out, but it just keeps throwing those exceptions :)

So my question is: can you create()/update()/save() related models using composite keys?

Phalcon · Answer 1 · 2014-10-26T16:37:20-07:00

I think only many-to-many relations with composite keys could throw that exception, create()/update()/save() must work on composite keys without problem

Trenton Craig · Answer 2 · 2015-03-27T12:33:07-07:00

I can confirm this is still an issue. I found the culprit in the source code.

My two related models:

class TestingJobEndpoint extends \Phalcon\Mvc\Model

    public function initialize()
    {
        $this->belongsTo("job_id", "TestingJob", "id");
        $this->belongsTo("endpoint_id", "TestingEndpoint", "id");
        $this->hasMany(array('job_id', 'endpoint_id'), 'TestingJobEndpointSla', array('jobId', 'endpointId'), array('alias' => 'Slas'));
    }
}

class TestingJobEndpointSla extends \Phalcon\Mvc\Model
...
    public function initialize()
    {
        $this->belongsTo(array('jobId', 'endpointId'), 'TestingJobEndpoint', array('job_id', 'endpoint_id'), array('alias' => 'JobEndpoint'));
        $this->belongsTo('endpointId', 'TestingEndpoint', 'id', array('alias' => 'LocalEndpoint'));
    }

Source Code

static PHP_METHOD(Phalcon_Mvc_Model, _postSaveRelatedRecords){
...
            if (Z_TYPE_P(columns) == IS_ARRAY) { 
                PHALCON_CALL_METHOD(NULL, connection, "rollback", nesting);
                PHALCON_THROW_EXCEPTION_STR(phalcon_mvc_model_exception_ce, "Not implemented");
                return;
            }
...
}

Stefan Crnjaković · Answer 3 · 2015-03-29T15:43:19-07:00

At least there should be something in the docs about it, because the way the things are now, this is expected to be implemented and work.

Storebuddy · Answer 4 · 2015-12-15T06:35:21-07:00

Has anyone found a solution to this problem, I get the exception below when i try to save a model.

"Not implemented" File = phalcon/mvc/model.zep Line = 2640

My model relations are defined like this

$this->hasMany(array('id','company_id'), 'Multiple\Backend\Models\Subscription', array('store_id','company_id'), array('alias' => 'Subscription'));

$this->belongsTo(array('store_id','company_id'), 'Multiple\Backend\Models\Store', array('id','company_id'), array('alias' => 'Store'));