Laravel fill database table column from array using factory

Question

I have a database table look like this

|id |col2|col3|col4|
-------------------
| 1 |elm0|....|....|
| 2 |elm1|....|....|
| 3 |elm2|....|....|
|...|....|....|....|
|N+1|elmN|....|....|

I want to fill the col2 with data from array (not in random way). Example array:

$dataArray = array(elm0, elm1, elm2,...)

I created this factory:

<?php

use Faker\Generator as Faker;

$factory->define(App\Unit::class, function (Faker $faker) {

    $dataArray = array(elm0, elm1, elm2,...,elmN);

    return [
        'col2' => $dataArray[$index];
        'col3' => $faker->'whatever';
        'col4' => $faker->'whatever';
    ];

});

How I can do this?

I've answered. Please check and let me know if it is work for you. — Jinandra Gupta, Apr 27 '18 at 11:51

score 1 · Answer 1 · answered Apr 27 '18 at 12:41

1

you can build like that:

<?php
use Faker\Generator as Faker;

$factory->define(App\Unit::class, function(Faker $faker) {

    $data = array(elm0, elm1, elm2,...,elmN);

    foreach($data as $kye=>$value) {
        $result['id'] = $key;
        $result['col2'] = $value;
        $result['col3'] = $faker->'whatever';
        $result['col4'] = $faker->'whatever';
    }

    return $result;
});

When you need to run an array, often foreach() solve your problem.

Hope that help you.

Cheers.

answered Apr 27 '18 at 12:41

vicentimartins

46
5

This will add/return the last element in the array elmN. Cheers – Yamona Apr 27 '18 at 13:36
Isn't true. This will return a array with all interaction in foreach statement that going to save all data inside it. – vicentimartins Apr 28 '18 at 21:49

score 1 · Answer 2 · answered Nov 15 '18 at 15:13

Had a similar problem and decided to skip the factory part and use only seeder. I got to the solution while reading this: Seed multiple rows at once laravel 5 answer by lukasgeiter.

First you make a seeder with:php artisan make:seeder UnitsTableSeeder

Then you will have in your seeder something like this:

<?php

use Faker\Generator as Faker;
use Illuminate\Database\Seeder;

class UnitsTableSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
      $faker = new Faker;
      $data = ['elm0', 'elm1', 'elm2',...,'elmN'];
      $rows = [];

      foreach ($data as $element) {
        $rows[] = ['col2' => $element, 'col3' => $faker->'whatever', 'col4' => $faker->'whatever'];
      }

      App\Unit::insert($rows);
    }
}

After this you can seed your Units table like a sir :)

php artisan db:seed --class=UnitsTableSeeder

score 0 · Answer 3 · answered Apr 27 '18 at 11:50

<?php

use Faker\Generator as Faker;

$factory->define(App\Unit::class, function(Faker $faker) {

        // Grab a random unit
        $unit = App\Unit::orderByRaw('RAND()')->first();

        // Or create a new unit
        $unit = factory(App\Unit::class)->create();

        return [
            'id' => $unit->id,
            'col2' => $faker->'whatever',
            'col3' => $faker->'whatever',
            'col4' => $faker->'whatever',
        ];
    });

Please check if it is work for you.

score 0 · Answer 4 · answered Jul 01 '20 at 17:20

If you want to get a random element from an array and fake it then you can do something as below:

$factory->define(Rule::class, function (Faker $faker) {

    $data = [
        'age' => [
            'borrower_age_min'  => 'min:21',
            'borrower_age_max'  => 'max:75'
        ],
        'affordability' => [
            'annual_income' => 'integer|min:40000',
            'loan_amount'   => 'integer|max:3*',
        ],
        'finance' => [
            'loan_length'   => 'integer|max:12',
            'loan_amount'   => 'integer|max:500000',
        ]
    ];

    return [
        'rule'     => json_encode([
            $faker->randomElement(
                [
                    $data['age']['borrower_age_min'],
                    $data['age']['borrower_age_max'],
                    $data['affordability']['annual_income'],
                    $data['affordability']['loan_amount'],
                    $data['finance']['loan_length'],
                    $data['finance']['loan_amount']
                ]
            )
        ])
    ];
});

Laravel fill database table column from array using factory

4 Answers4