PHP code example of yukazakiri / laravel-database-sync

1. Go to this page and download the library: Download yukazakiri/laravel-database-sync 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/ */

yukazakiri / laravel-database-sync example snippets


'postgres' => [
    'dump_action_flags' => '--no-owner --no-privileges --data-only --column-inserts --on-conflict-do-nothing',
],


'file_transfer_mode' => 'batch', // or 'individual'


'tables' => [
    'ignore' => [
        'action_events',
        'jobs',
        'telescope_entries',
        'password_resets',
    ],
],


// Set timeout in seconds (default: 300 seconds / 5 minutes)
'process_timeout' => 600, // 10 minutes

// Or set to null to disable timeout entirely for very large databases
'process_timeout' => null,


'suites' => [
    'orders' => [
        'orders',
        'order_items',
    ],
],


'multi_tenant' => [
    'landlord' => [
        'database_name' => 'yukazakiri_landord',
        'tables' => [
            'ignore' => [
                'action_events',
            ],
        ],
    ],
    'tenants' => [
        'database_names' => [
            'yukazakiri_nl' => [
                'tables' => [
                    'ignore' => [
                        'users',
                    ],
                ],
            ],
            'yukazakiri_dev',
            'yukazakiri_io',
        ],
        'tables' => [
            'ignore' => [
                'logs',
            ],
        ],
    ],
],


test('your test description', function () {
    // Your test code
    expect($result)->toBe($expected);
});

bash
php artisan vendor:publish --tag="database-sync-config"

bash
php artisan db-sync

bash
php artisan db-sync [options]

bash
php artisan db-sync --status

bash
php artisan db-sync --suite=orders

bash
php artisan db-sync --tenant="yukazakiri_nl" --skip-landlord
php artisan db-sync --tenant="yukazakiri_nl" --skip-landlord --suite=orders