FlexDatabaseMigrate/migrate.php at main · FmiKL/FlexDatabaseMigrate · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
<?php

error_reporting(E_ALL);
ini_set('display_errors', 1);

require 'vendor/autoload.php';
require 'config.php';

use FlexDatabaseMigrate\Database\DatabaseConnector;
use FlexDatabaseMigrate\Migration\DataMigrator;

$sourceDb = new DatabaseConnector(DB_SOURCE);
$destinationDb = new DatabaseConnector(DB_TARGET);

$migrator = new DataMigrator($sourceDb, $destinationDb, 'id');

// This method updates the values of a column in the destination table using the values from a column in the source table, based on a common identifier.
$migrator->updateColumn('source_table.column1', 'destination_table.columna');
$migrator->updateColumn('source_table.column2', 'destination_table.columnb');

// This method migrates the data from an entire table to another, creating the destination table if it does not exist and updating the fields if it does.
// $migrator->migrateData([
//     'source_table.column1' => 'destination_table.columna',
//     'source_table.column2' => 'destination_table.columnb',
// ]);