Diffrent databases rest

Question

Diffrent databases rest

Bruno May '15

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

Bruno 6.3k

May '15

Hey everbody,

I'm developing a Rest application with a micro setup plus collections to structure the logic. In every Rest Uri I get the database plus the id or whatever is needed for the function. Example:

GET /api/search/exampleModel/id+exampleDB

How should I handle the connection to the diffrent databases?

Idea:

1 Set the dbs:

$di->set('dbExample', function(){ return new PdoMysql(array( "host" => "localhost", "username" => "", "password" => "", "dbname" => "" )); });

2 Create function in model:

public function changeDb($db) { $this->setConnectionService($db); }

3 Create object of the model inside the controller and change db:

$myModell = new ExampleModell(); $myModell->changeDb("dbExample");

Is there a better way to handle this situation?

Bruno

Eakkapat Pattarathamrong · Answer 1 · 2015-05-31T08:57:29-07:00

I use phalcon dev tools to generate model in own directory, Database cms in directory ../app/models/cms
In model files add namespace Cms; and

    public function initialize()
    {
        // By default "db" is choose for phalcon, you may specify other connection in your
        $this->setConnectionService("dbCms");
    }

index.php add

    $config = new Phalcon\Config\Adapter\Ini(__DIR__ . "/../app/config/config.ini");

    $di = new Phalcon\DI\FactoryDefault;
    $di->set('dbCms', function () use ($config) {
        return new Phalcon\Db\Adapter\Pdo\Mysql(
            [
                "host" => $config->dbCms->host,
                "username" => $config->dbCms->username,
                "password" => $config->dbCms->password,
                "dbname" => $config->dbCms->dbname,
                "options" => [
                    PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'UTF8'",
                    PDO::ATTR_CASE => PDO::CASE_LOWER,
                    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_OBJ,
                ],
            ]);
    });

    $loader = new Phalcon\Loader;
    $loader->registerNamespaces([
        'Cms' => $config->phalcon->modelsCmsDir,
    ]);

now your code is something like $myModell = new Cms\ExampleModell(); Hope this help.