Using different database users per model for read and write?

Question

Using different database users per model for read and write?

Bastian Klingen Jun '13

Created Jun '13	Last Reply Jun '13	Replies 2	Views 1456	Votes 1

Bastian Klingen 1.4k

Jun '13

Hi,

I just started with Phalcon and was trying to use different users for read and wirte access per model.

I'm trying this by using a connection per user (2 per model) and set those for read/write connection service.

But when accessing Model::find I'm receiving the error: "Service 'db' wasn't found in the dependency injection container"

Am I doing something wrong? Probably an easier method I am missing?

Thanks for any advice.

Kind regards.

1

Phalcon · Answer 1 · 2013-06-11T07:58:26-07:00

Hi Bastian, just set both connection services in the model's initializer:

<?php

class Robots extends Phalcon\Mvc\Model
{
    public function initialize()
    {
        $this->setReadConnectionService('dbRead');
        $this->setWriteConnectionService('dbWrite');
    }
}

Bastian Klingen · Answer 2 · 2013-06-11T08:08:34-07:00

Thanks for the reply.

That is what I'm doing, but for some reason I still have to set a connection as 'db' in the DI when trying to use Robots::find(...);

Is there some secret method or just some method I'm missing to call so that the standard 'db' connection is not needed?

Phalcon · Answer 3 · 2013-06-11T08:14:32-07:00

Try to check what method is currently requesting that service, in public/index.php print the exception's backtrace:

try {
 //...
} catch(Exception $e) {
 echo $e->getException(), '<br>';
 echo $e->getTraceAsString();
}

Bastian Klingen · Answer 4 · 2013-06-12T01:23:52-07:00

Thanks, I just found the error.

It was because my Model extends a Base class and calls it's initialize function at the start of it's own. But the Base class uses skipAttributes, which is the called before the Model sets the read/write connection service.

Thanks for the help.