How to set up the seeds correctly?

[SequelONE]

My seeding file looks like this:

https://github.com/SequelONE/laravel-auth-backpack/blob/main/database/seeders/MenuItemsTableSeeder.php

I have tried different methods of forming an array:

[
                'name' => 'About us',
                'title' => [
                    'en' => 'About us',
                    'de' => 'Über uns',
                    'ru' => 'О нас'
                ],
                'type' => 'page_link',
                'link' => NULL,
                'page_id' => 2,
                'parent_id' => NULL,
                'status' => 1,
            ],

But when filling into the database, everything looks like this:

{
    "en": {
        "de": "Home",
        "en": "Home",
        "ru": "Главная"
    }
}

Field type in the JSON table.

How to correctly form a seed file so that all language versions are added to the database correctly, namely like this?

{
        "en": "Home",
        "de": "Home",
        "ru": "Главная"
}

[anibalealvarezs]

Hello.

I do it this way: https://github.com/anibalealvarezs/projectbuilder-package/blob/master/src/Database/Seeders/PbLanguagesSeeder.php

I use manual JSON encoding because this trait works just for models, and I'm using upsert which is an Eloquent's Builder class' method, not an Eloquent Model's.

If you want to use models, you'll have to create the instance (one for each record to be stored) and use any of the available methods por persisting the data, like save

[SequelONE]

Thanks. That's how it works!

https://github.com/SequelONE/laravel-auth-backpack/blob/main/database/seeders/MenuItemsTableSeeder.php