Skip to content
TheChatArchiveThe Chat Archive
gpt-3.5-turbo-0613· OpenAIAi2 WildChat-4.8M (AI2)

crea un database seeder para esta db Tabla 1: "technicians" - id (pk) - name - lastname…

  1. User

    crea un database seeder para esta db Tabla 1: "technicians"

    • id (pk)
    • name
    • last_name
    • address
    • phone
    • email

    Tabla 2: “services”

    • id (pk)
    • description
    • price
    • category_id(fk)

    Tabla 3: categories

    • id (pk)
    • name
    • description

    Tabla 4: “services_technicians”

    • id (pk)
    • technical_id(fk)
    • service_id (fk)

    Tabla 5: "users

    • id (pk)
    • name
    • last_name
    • address
    • phone
    • email

    Tabla 6: "demands"

    • id (pk)
    • user_id (Clave foránea)
    • service_technical_id
    • date
    • status (acepted, pending, rejected)

    table 7 "scores"

    • id
    • user_id
    • service_technical_id
    • date
    • score (1-5)
    • comment

    Tabla 8: ubications

    • id
    • name
    • ubicable_id
    • ubicable_type
  2. Assistant

    Aquí tienes un ejemplo de un seeder para la base de datos proporcionada:

    use Illuminate\Database\Seeder;
    use Illuminate\Support\Facades\DB;
    
    class DatabaseSeeder extends Seeder
    {
        /**
         * Run the database seeds.
         *
         * @return void
         */
        public function run()
        {
            // Seeder para la tabla "technicians"
            DB::table('technicians')->insert([
                'name' => 'John',
                'last_name' => 'Doe',
                'address' => '123 Main St',
                'phone' => '555-1234',
                'email' => 'john.doe@example.com',
            ]);
    
            // Seeder para la tabla "services"
            DB::table('services')->insert([
                'description' => 'Service 1',
                'price' => 50.00,
                'category_id' => 1,
            ]);
    
            // Seeder para la tabla "categories"
            DB::table('categories')->insert([
                'name' => 'Category 1',
                'description' => 'Category description',
            ]);
    
            // Seeder para la tabla "services_technicians"
            DB::table('services_technicians')->insert([
                'technical_id' => 1,
                'service_id' => 1,
            ]);
    
            // Seeder para la tabla "users"
            DB::table('users')->insert([
                'name' => 'Jane',
                'last_name' => 'Smith',
                'address' => '456 Elm St',
                'phone' => '555-4321',
                'email' => 'jane.smith@example.com',
            ]);
    
            // Seeder para la tabla "demands"
            DB::table('demands')->insert([
                'user_id' => 1,
                'service_technical_id' => 1,
                'date' => '2022-01-01',
                'status' => 'pending',
            ]);
    
            // Seeder para la tabla "scores"
            DB::table('scores')->insert([
                'user_id' => 1,
                'service_technical_id' => 1,
                'date' => '2022-01-05',
                'score' => 4,
                'comment' => 'Good service',
            ]);
    
            // Seeder para la tabla "ubications"
            DB::table('ubications')->insert([
                'name' => 'Location 1',
                'ubicable_id' => 1,
                'ubicable_type' => 'technician',
            ]);
        }
    }
    

    Recuerda que este es solo un ejemplo y que los valores de los seeders pueden ser personalizados según tus necesidades. Además, asegúrate de haber configurado correctamente las migraciones y los modelos antes de ejecutar el seeder.

  3. User

    refactorizalo para generar data aleatoria

  4. Assistant

    Aquí tienes el código refactorizado para generar datos aleatorios utilizando la biblioteca Faker en el seeder:

    use Illuminate\Database\Seeder;
    use Illuminate\Support\Facades\DB;
    use Faker\Factory as Faker;
    
    class DatabaseSeeder extends Seeder
    {
        /**
         * Run the database seeds.
         *
         * @return void
         */
        public function run()
        {
            $faker = Faker::create();
    
            // Seeder para la tabla "technicians"
            for ($i = 0; $i < 10; $i++) {
                DB::table('technicians')->insert([
                    'name' => $faker->firstName,
                    'last_name' => $faker->lastName,
                    'address' => $faker->address,
                    'phone' => $faker->phoneNumber,
                    'email' => $faker->email,
                ]);
            }
    
            // Seeder para la tabla "services"
            for ($i = 0; $i < 10; $i++) {
                DB::table('services')->insert([
                    'description' => $faker->sentence,
                    'price' => $faker->randomFloat(2, 10, 100),
                    'category_id' => $faker->numberBetween(1, 5),
                ]);
            }
    
            // Seeder para la tabla "categories"
            for ($i = 0; $i < 5; $i++) {
                DB::table('categories')->insert([
                    'name' => $faker->word,
                    'description' => $faker->sentence,
                ]);
            }
    
            // Seeder para la tabla "services_technicians"
            $technicians = DB::table('technicians')->pluck('id')->all();
            $services = DB::table('services')->pluck('id')->all();
    
            foreach ($technicians as $technician) {
                shuffle($services);
                $take = $faker->numberBetween(1, 5);
                $servicesTaken = array_slice($services, 0, $take);
    
                foreach ($servicesTaken as $service) {
                    DB::table('services_technicians')->insert([
                        'technical_id' => $technician,
                        'service_id' => $service,
                    ]);
                }
            }
    
            // Seeder para la tabla "users"
            for ($i = 0; $i < 10; $i++) {
                DB::table('users')->insert([
                    'name' => $faker->firstName,
                    'last_name' => $faker->lastName,
                    'address' => $faker->address,
                    'phone' => $faker->phoneNumber,
                    'email' => $faker->email,
                ]);
            }
    
            // Seeder para la tabla "demands"
            $users = DB::table('users')->pluck('id')->all();
            $servicesTechnicians = DB::table('services_technicians')->pluck('id')->all();
    
            for ($i = 0; $i < 10; $i++) {
                $user = $faker->randomElement($users);
                $serviceTechnical = $faker->randomElement($servicesTechnicians);
    
                DB::table('demands')->insert([
                    'user_id' => $user,
                    'service_technical_id' => $serviceTechnical,
                    'date' => $faker->date,
                    'status' => $faker->randomElement(['accepted', 'pending', 'rejected']),
                ]);
            }
    
            // Seeder para la tabla "scores"
            for ($i = 0; $i < 10; $i++) {
                $user = $faker->randomElement($users);
                $serviceTechnical = $faker->randomElement($servicesTechnicians);
    
                DB::table('scores')->insert([
                    'user_id' => $user,
                    'service_technical_id' => $serviceTechnical,
                    'date' => $faker->date,
                    'score' => $faker->numberBetween(1, 5),
                    'comment' => $faker->sentence,
                ]);
            }
    
            // Seeder para la tabla "ubications"
            for ($i = 0; $i < 10; $i++) {
                $name = $faker->word;
                $ubicable_id = $faker->numberBetween(1, 10);
                $ubicable_type = $faker->randomElement(['technician', 'user']);
    
                DB::table('ubications')->insert([
                    'name' => $name,
                    'ubicable_id' => $ubicable_id,
                    'ubicable_type' => $ubicable_type,
                ]);
            }
        }
    }
    

    Este código utilizará la biblioteca Faker para generar datos aleatorios para cada columna de cada tabla. Asegúrate de haber instalado Faker en tu proyecto antes de ejecutar el seeder.