crea un database seeder para esta db Tabla 1: "technicians" - id (pk) - name - lastname…
- User
crea un database seeder para esta db Tabla 1: "technicians"
- id (pk)
- name
- last_name
- address
- phone
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
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
- 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.
- User
refactorizalo para generar data aleatoria
- 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.