How to Begin a transaction inside a model with a Database set in the DI with the phalcon bootstrap

Question

How to Begin a transaction inside a model with a Database set in the DI with the phalcon bootstrap

Daniel Jesús Muñoz Guerra May '15

Created May '15	Last Reply May '15	Replies 1	Views 594	Votes 0

Daniel Jesús Muñoz Guerra 9.2k

May '15

I'm trying to do $this->db->begin(); But anyway I try I get or undefined function or No active transaction errors.

Andres Gutierrez · Answer 1 · 2015-05-13T07:13:08-07:00

Just use the service associated to the model:

$di = \Phalcon\Di::getDefault();

$di->get('dbServiceName')->begin();

$di->get('dbServiceName')->commit();

Daniel Jesús Muñoz Guerra · Answer 2 · 2015-05-13T07:27:21-07:00

It gives me There is no active transaction, i just have between begin and commit 3 lines of this->getModelsManager()->executeQuery("INSERT INTO ....");

The servicename if im not wrong is "db":

$di->set('db', function () use ($config) {
return new DbAdapter(array(
        'host' => $config->database->host,
        'username' => $config->database->username,
        'password' => $config->database->password,
        'dbname' => $config->database->dbname,
        'charset' => $config->database->charset,
    ));
});