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 )
            {
                $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();
            }
        }
    }