HEX
Server: Apache
System: Linux WWW 6.1.0-40-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.153-1 (2025-09-20) x86_64
User: web11 (1011)
PHP: 8.2.29
Disabled: NONE
Upload Files
File: //var/www/apklausos/application/commands/DbSeederCommand.php
<?php

use \tebazil\yii1seeder\Seeder;

class IdValidator
{
    private $bag;
    private $original;
    public function __construct($bag)
    {
        $this->bag = $bag;
        $this->original = $bag;
    }
    public function __invoke($nr)
    {
        if (!isset($this->bag[$nr - 1])) {
            return false;
        } else {
            unset($this->bag[$nr - 1]);
            return true;
        }
    }
}

class DbSeederCommand extends CConsoleCommand
{
    /**
     * @return void
     */
    public function run($args)
    {
        $seeder = new Seeder();
        $generator = $seeder->getGeneratorConfigurator();
        $faker = $generator->getFakerConfigurator();

        // Generate surveys
        $sids = [1, 2, 3];
        $sidValidator = new IdValidator($sids);
        $seeder->table('{{surveys}}')->columns(
            [
                'sid' => $faker->unique()->numberBetween(1, 3),
                'owner_id' => 1,
                'language' => 'en'
            ]
        )->rowQuantity(3);

        // Generate survey text
        $sidValidator = new IdValidator($sids);
        $seeder->table('{{surveys_languagesettings}}')->columns(
            [
                'surveyls_survey_id' => $faker->unique(true)->numberBetween(1, 4),
                'surveyls_language' => 'en',
                'surveyls_title' => 'mo'
            ]
        )->rowQuantity(3);

        // Generate groups
        $gids = [1, 2, 3, 4, 5];
        $gidValidator = new IdValidator($gids);
        $seeder->table('{{groups}}')->columns(
            [
                'gid' => $faker->unique(true)->numberBetween(1, 10),
                'sid' => $faker->numberBetween(1, 3),
            ]
        )->rowQuantity(10);
        $seeder->refill();
        return;

        // Generate questions
        $qids = [1, 2, 3, 4, 5, 6, 7];
        $qidValidator = new IdValidator($qids);
        $seeder->table('{{questions}}')->columns(
            [
                'qid' => $faker->valid($qidValidator)->randomElement($qids),
                'sid' => $faker->randomElement($sids),
                'gid' => $faker->randomElement($gids),
            ]
        )->rowQuantity(count($qids));

        $i = 0;
        $seeder->table('{{answers}}')->columns(
            [
                'aid',
                'qid' => function () use (&$i) {
                    return $i++;
                },
                'code' => $faker->uuid,
                'sortorder' => function () use (&$i) {
                    return $i++;
                },
                'assessment_value' => function () { return rand(1, 10); }
            ]
        )->rowQuantity(30);

        $seeder->refill();
    }
}