Subversion-Projekte lars-tiefland.laravel_shop

<?php

namespace Database\Seeders;

use App\Models\Directory;
use Illuminate\Database\Console\Seeds\WithoutModelEvents;
use Illuminate\Database\Seeder;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Str;

class DirectorySeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run(): void
    {
        /*Directory::factory()->create([
            "id" => -5,
            "name" => "Gutschein",
            "directory_id" => NULL,
        ]);
        Directory::factory()->create([
            "id" => -3,
            "name" => "Versand",
            "directory_id" => NULL,
        ]);
        Directory::factory()->create([
            "id" => -2,
            "name" => "Papierkorb",
            "directory_id" => NULL,
        ]);
        Directory::factory()->create([
            "id" => -1,
            "name" => "Root",
            "directory_id" => NULL,
        ]);
        Directory::factory()->create([
            "id" => 1,
            "name" => "Nach Zoll",
            "directory_id" => -1
        ]);
        Directory::factory()->create([
            "id" => 2,
            "name" => "Pedelecs",
            "directory_id" => -1
        ]);
        Directory::factory()->create([
            "id" => 3,
            "name" => "E-Lastenräder",
            "directory_id" => -1
        ]);
        Directory::factory()->create([
            "id" => 4,
            "name" => "Zubehör",
            "directory_id" => -1
        ]);
        Directory::factory()->create([
            "id" => 5,
            "name" => "16-18 Zoll",
            "directory_id" => 1
        ]);
        Directory::factory()->create([
            "id" => 6,
            "name" => "20-22 Zoll",
            "directory_id" => 1
        ]);
        Directory::factory()->Create([
            "name" => "24-26 Zoll",
            "directory_id" => 1
        ]);
        Directory::factory()->Create([
            "name" => "27,5-29,5 Zoll",
            "directory_id" => 1
        ]);*/
        $sql = '
            SELECT 
                *
            FROM
                directory
        ';
        $dirs = DB::connection('old')->select($sql);
        foreach ($dirs as $row)
        {
            //var_dump($row);
            Directory::factory()->createQuietly([
                "id"           => $row->ID,
                "directory_id" => $row->Father,
                "name"         => $row->Name,
                "status"       => $row->status,
                "kennung"      => $row->Kennung,
                "description"  => $row->Beschreibung,
                "short_line_1" => $row->short_line_1,
                "url"          => $row->url,
                "created_at"   => $row->erstellt_am,
                "updated_at"   => $row->letzte_Aenderung_am,
            ]);
        }
    }
}