use Carbon\Carbon;
use YformSeeder\Table;
use YformSeeder\Seeder;

/**
    available value types:
    ($name, $label, $attributes = [])
    ---
    $seeder->beLink('name', 'Name');
    $seeder->beManagerRelation('name', 'Name');
    $seeder->beMedia('name', 'Name');
    $seeder->beTable('name', 'Name');
    $seeder->beUser('name', 'Name');
    $seeder->checkbox('name', 'Name');
    $seeder->choice('name', 'Name');
    $seeder->date('name', 'Name');
    $seeder->datestamp('name', 'Name');
    $seeder->dateTime('name', 'Name');
    $seeder->email('name', 'Name');
    $seeder->imagelist('name', 'Name');
    $seeder->integer('name', 'Name');
    $seeder->ip('name', 'Name');
    $seeder->number('name', 'Name');
    $seeder->prio('name', 'Name');
    $seeder->showvalue('name', 'Name');
    $seeder->text('name', 'Name');
    $seeder->textarea('name', 'Name');
    $seeder->time('name', 'Name');
    $seeder->upload('name', 'Name');
    $seeder->uuid('name', 'Name');
*/

/**
    available validate types:
    ($label, $attributes = [])
    ---
    $seeder->validateCompare('Name');
    $seeder->validateCompareValue('Name');
    $seeder->validateEmpty('Name');
    $seeder->validateIntFromTo('Name');
    $seeder->validatePasswordPolicy('Name');
    $seeder->validatePregMatch('Name');
    $seeder->validateSize('Name');
    $seeder->validateSizeRange('Name');
    $seeder->validateType('Name');
    $seeder->validateUnique('Name');
*/

$tableName = 'rex_blubb';
$tableLabel = 'Meine Demo Tabelle';

/** create table */
/** $tableName, $label/$name, $tableAttributes = [] */

Table::create($tableName, $tableLabel);


/** create value factory */
/** $tableName */

$seeder = Seeder::factory($tableName);

/** prepare values */
/** $name, $label, $additionalAttributes = [] */

$seeder->text('name', 'Name');
$seeder->integer('count', 'Anzahl');
$seeder->textarea('text', 'Freitext');

/** create values */

$seeder->create();


/** create a faker instance */
$faker = Faker\Factory::create();

/** register REDAXO provider if needed */
//$faker->addProvider(new \YformSeeder\Faker\Redaxo($faker));

/**
 * to get a random image name from the media pool use:
 * $faker->beMedia(int $categoryId = null, string $type = 'image/jpeg')
 */

/**
 * to get a random article ID use:
 * $faker->beLink()
 */

/** add values */
//mehrere Datensätze einfügen
for ($i = 0; $i < 10; $i++) {
    $sql = rex_sql::factory();
    $sql->setTable($tableName);

    $sql->setValue('name', $faker->name());
    $sql->setValue('count', $faker->randomNumber(2, false));
    $sql->setValue('text', $faker->text(100));

    $sql->insert();
}