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

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

?????? ?? ??

?? ?????? ??? ???? ?? DB ???? ?? ??? ???? ? ??? ???? ? ????. ?? ??? ??? ??? config/database.php ?? ??? ??? ??? ?????:

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

?? ??

?????? ??? ??? ????. .env ?? ?? config/database.php? ???? ?? ??:

.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'),
],

??? ? ??????

??? ? ??????? ??? ??? ????? ??? ?? ??() ???? ?????.

Schema::connection('pgsql')->create('some_table', function ($table) {
    $table->increments('id');
});

?? ??? ???? ??? ??? ?? ????. :

protected $connection = 'pgsql';

?? Builder

?? ??? ?? ??? ?????:

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

Model

Laravel 5.0 ????? ??? ??? ? ????. $connection ??? ??????. ??:

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

Eloquent

Laravel 4.0 ????? ?? ??? $connection ??? ??? ? ????:

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

?? ??

?? ?? ?? ??????? ??:

DB::transaction(function () {
    DB::connection('mysql')->table('users')->update(['name' => 'John']);
    DB::connection('pgsql')->table('orders')->update(['status' => 'shipped']);
});

??

DB::connection('mysql')->beginTransaction();

try {
    DB::connection('mysql')->table('users')->update(['name' => 'John']);
    DB::connection('pgsql')->beginTransaction();
    DB::connection('pgsql')->table('orders')->update(['status' => 'shipped']);
    DB::connection('pgsql')->commit();
    DB::connection('mysql')->commit();
} catch (\Exception $e) {
    DB::connection('mysql')->rollBack();
    DB::connection('pgsql')->rollBack();
    throw $e;
}

??? ?? ??

setConnection ???? ???? ???? ??? ??? ?? ????. ??? ??:

class SomeController extends BaseController {
    public function someMethod()
    {
        $someModel = new SomeModel;
        $someModel->setConnection('pgsql'); // non-static method
        $something = $someModel->find(1);
        $something = SomeModel::on('pgsql')->find(1); // static method
        return $something;
    }
}

??

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

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