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,
                        ]);*/
            $dir = new Directory();
            $dir->id = $row->ID;
            $dir->directory_id = $row->Father;
            $dir->name = $row->Name;
            $dir->status = $row->status;
            $dir->kennung = $row->Kennung;
            $dir->description = $row->Beschreibung;
            $dir->short_line_1 = $row->short_line_1;
            $dir->url = $row->url;
            $dir->created_at = $row->erstellt_am;
            $dir->updated_at = $row->letzte_Aenderung_am;
            $dir->save();
        }
    }
}