How can I run migration on a connection

[thiagomeloo]

I have the following scenario where I create a connection using capsule and I want to perform one or more actions using this connection that was created at run time, for example:

<?php

use Illuminate\Database\Capsule\Manager as Capsule;

$config = [
  'driver' => 'mysql',
  'host' => 'localhost',
  'database' => 'example',
  'password'=> 'pass'
  'username' => 'root'
  #... other options
];

function createCon($name, $config):Connection
{
  $capsule = new Capsule;
  $capsule->addConnection($config, $name);
  $capsule->setAsGlobal();
  $capsule->bootEloquent();
  return $capsule->getConnection($name);
}


$con= createCon('con1', $config);

$con->transaction(function(){
  #execute migrations using con1
  Artisan::call(
    'migrate',
    [
      '--database' => 'con1',
      '--path' => 'database/migrations',
      '--seed' => true
    ]);

});

The problem I'm having is that this code above is being executed on my project's default connection. Would anyone know a way to do something in this context?

[chuckrincon]

Hey there.

You can achieve this using the config helper to create a new connection on the fly.
But first, you need to add an empty database name, like so:

    'sqlite' => [...],
    'mysql => [...],
+   'dynamic' => []

Then, using the config helper, you can assign the new connection to the empty one:

// The default connection
$default = config('database.connections.mysql');

// Merge the default connection values with the new connection values.
config([
  'database.connections.dynamic' => array_merge($default, [
      'username' => 'root',
      'database' => 'forge',
      #... other options
  ])
]);

// Now the framwork migrator will use the new database connection.
Artisan::call('migrate', [
    '--database' => 'dynamic',
    '--seed' => true
]);

[thiagomeloo]

Thank you, I will try to apply this example in my context.