xixaoly/randomizer

There is no license information available for the latest version (1.0.0) of this package.

Randomize DB columns

1.0.0 2018-04-08 17:54 UTC

Requires

• php: >=5.6
• symfony/yaml: ^3.4

Requires (Dev)

• tracy/tracy: 2.4.*

Unknown License

README

Simply DB data randomize.

Install

• git clone [e-mail]:xixaoly/Randomizer.git
• cd Randomizer
• composer update

CLI example

Create example.yml file with schema declaration and run php cli/randomizer.php example.yml

PHP example

Include composer autoload (like require 'vendor/autoload.php'), create Job and handle it

<?php
use Randomizer\Randomizer;

$randomizer = new Randomizer;
$job = $randomizer->createJobFromFile($path);

try {
	$randomizer->install($job);
	$randomizer->run($job);
	$randomizer->uninstall($job);
} catch (Exception $e) {
	$randomizer->uninstall($job);
}

Schema example

connection:
    dns: mysql:dbname=randomizer;host=127.0.0.1
    name: root
    password: example
options:
    defaultClass:
        class: Randomizer\Database\Mysql\Method\RandomString
schema:
    table1:
        colm1:
            class: Randomizer\Database\Mysql\Method\RandomNumber
            arguments:
                min: 10
                max: 20
        colm2:
            class: Randomizer\Database\Mysql\Method\RandomString
        colm3: