On gists

Nette - multiple db connections

Nette Nette-Database

connetionsModel.php Raw #

<?php

namespace Model;

use Nette;

class Connections
{

	/** @var Nette\Di\Container */
	private $container;


	public function __construct(Nette\Di\Container $container)
	{
		$this->container = $container;
	}


	public function getOld()
	{
		return $this->container->getService('nette.database.main');
	}


	public function getNew()
	{
		return $this->container->getService('nette.database.msp22');
	}

}

database.neon Raw #

	nette:
		database:
			main:
				dsn: 'mysql:host=somehost;dbname=somedbname;port=3307'
				user: someuser
				password: ***
				reflection: Andweb\Database\Reflection\Reflection
			msp22:
				dsn: 'mysql:host=somehost;dbname=somedbname'
				user: someuser
				password: ***
				reflection: Andweb\Database\Reflection\Reflection

presenter.php Raw #

<?php

class AnyPresenter extends BasePresenter
{
	/**
	 * @var Model\Connections
	 */
	protected $conn;

	public function __construct(Model\Connections $conn)
	{
		$this->conn = $conn;
	}


  // later
  //  $this->conn->getNew()->query()   ...
  // $this->conn->getOld()->table() ...