Laravel?? ?? ?????? ??

Laravel ???????? ??? ? ?? ??????? ??? ??? ???? ?? ??????. ??? ?? Laravel ?????? ??? ??? ??????? ????? ???? ?? ???? ??? ???? ?? ?????.

Laravel? Database Facade

Laravel? DB Facade? ?????. ?? ?????? ??? ??????. DB Facade?? ???? ?? ??? ???? ???? ?? ??????? ?? ??? ???? ??? ? ????. ?? ???? config/database.php ?? ??? ??? ?? ??? ???? ????? ?????.

$users = DB::connection('foo')->select(...);

?????? ?? ??

.env ??:

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=mysql_database
DB_USERNAME=root
DB_PASSWORD=secret

DB_CONNECTION_PGSQL=pgsql
DB_HOST_PGSQL=127.0.0.1
DB_PORT_PGSQL=5432
DB_DATABASE_PGSQL=pgsql_database
DB_USERNAME_PGSQL=root
DB_PASSWORD_PGSQL=secret

?? config/database.php:

'mysql' => [
    'driver' => env('DB_CONNECTION'),
    'host' => env('DB_HOST'),
    'port' => env('DB_PORT'),
    'database' => env('DB_DATABASE'),
    'username' => env('DB_USERNAME'),
    'password' => env('DB_PASSWORD'),
],

'pgsql' => [
    'driver' => env('DB_CONNECTION_PGSQL'),
    'host' => env('DB_HOST_PGSQL'),
    'port' => env('DB_PORT_PGSQL'),
    'database' => env('DB_DATABASE_PGSQL'),
    'username' => env('DB_USERNAME_PGSQL'),
    'password' => env('DB_PASSWORD_PGSQL'),
],

.env ??(Laravel <= 4.0):

return array(
    'default' => 'mysql',
    'connections' => array(
        'mysql' => array(
            'driver' => 'mysql',
            'host' => '127.0.0.1',
            'database' => 'mysql_database',
            'username' => 'root',
            'password' => 'secret',
            'charset' => 'utf8',
            'collation' => 'utf8_unicode_ci',
            'prefix' => '',
        ),

        'pgsql' => [
            'driver' => 'pgsql',
            'host' => 'localhost',
            'port' => '5432',
            'database' => 'pgsql_database',
            'username' => 'root',
            'password' => 'secret',
            'charset' => 'utf8',
            'prefix' => '',
            'schema' => 'public',
        ]
    ),
);<h3>?? ? ?? ??</h3>
<p><strong>???</strong>:</p>
<p>?? ??? ???? ??? ??? ?? ??????? ??? ? ????.</p>
<pre class="brush:php;toolbar:false">Schema::connection('pgsql')->create('some_table', function($table){ ... });

?? Builder:

$users = DB::connection('pgsql')->select(...);

??:

???? ??? ????? ??? ? ????. class:

class ModelName extends Model {
    protected $connection = 'pgsql';
}

Eloquent:

class SomeModel extends Eloquent {
    protected $connection = 'pgsql';
}

????

????? ?? ???????? ??? ?? ????.

DB::transaction(function () {
    DB::connection('mysql')->table('users')->update(...);
    DB::connection('pgsql')->table('orders')->update(...);
});

??? ?? ??

?? ???? ??? ? ????.

$someModel = new SomeModel;
$someModel->setConnection('pgsql'); // non-static
$something = $someModel->find(1);
$something = SomeModel::on('pgsql')->find(1); // static

?? ? ?? ??

??? ?????? ?? ??? ??? ?? ?????. ????? ?????? ?? ? ??? ???? ???? ? ?? ????.

? ??? Laravel?? ?? ?????? ??? ???? ??? ??????? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!