PHP code example of marcinkozak / databasemigrator

1. Go to this page and download the library: Download marcinkozak/databasemigrator library. Choose the download type require.

2. Extract the ZIP file and open the index.php.

3. Add this code to the index.php. 
    
        
<?php
require_once('vendor/autoload.php');

/* Start to develop here. Best regards https://php-download.com/ */

marcinkozak / databasemigrator example snippets


'providers' => array(

    // Other service providers entries
    
    MarcinKozak\DatabaseMigrator\DatabaseMigratorServiceProvider::class,
);


php artisan vendor:publish --provider="MarcinKozak\DatabaseMigrator\DatabaseMigratorServiceProvider"




return [
    [
        'source'    => 'mysql2',
        'target'    => 'mysql',
        'enabled'   => true,
        'schema'    => ExampleSchema::class,
    ],
];


$table = new Table('table_name');


$table = new Table('source_table_name', 'target_table_name');


$column = new Column('column_name');
$table->addColumn($column);


$column = new Column('source_column_name', 'target_column_name');
$table->addColumn($column);


$table->schema([
    'column_1',
    'column_2',
    //...
]);


$table->schema([
    'source_column_1' => 'target_column_1',
    'source_column_2' => 'target_column_2',
    //...
]);


$column = new Column('column_name');
$column->map(function($value) {
    return $value . '_some_stupid_word';
});


$data = DB::table('some_table')->pluck('id', 'some_column_name');

$column = new Column('column_name');
$column->map(function($value) use($data) {
    return array_get($data, $value);
});

 artisan database-migrator:populate
 artisan database-migrator:clear
config/app.php
config/marcinkozak/databasemigrator/connections.php
database/schemas/ExampleSchema.php
$value
array_get