/** * Run the database seeds. * * @return void */ public function run() { DB::table('project_members')->delete(); for ($i = 1;; $i++) { if ($i > 50) { break; } for (;;) { $projectId = \CodeProject\Entities\Project::all()->lists('id')->random(1); $userId = \CodeProject\Entities\User::all()->lists('id')->random(1); if (\CodeProject\Entities\ProjectMember::where('project_id', $projectId)->where('member_id', $userId)->count() == 0) { \CodeProject\Entities\ProjectMember::create(['project_id' => $projectId, 'member_id' => $userId]); break; } } } }
<?php /* |-------------------------------------------------------------------------- | Model Factories |-------------------------------------------------------------------------- | | Here you may define all of your model factories. Model factories give | you a convenient way to create models for testing and seeding your | database. Just tell the factory how a default model should look. | */ $factory->define(CodeProject\Entities\User::class, function (Faker\Generator $faker) { return ['name' => $faker->name, 'email' => strtolower($faker->email), 'password' => bcrypt('123456'), 'remember_token' => str_random(10)]; }); $factory->define(CodeProject\Entities\Client::class, function (Faker\Generator $faker) { return ['name' => $faker->name, 'responsible' => $faker->name, 'email' => strtolower($faker->email), 'phone' => $faker->phoneNumber, 'address' => $faker->address, 'obs' => $faker->sentence]; }); $factory->define(CodeProject\Entities\Project::class, function (Faker\Generator $faker) { return ['owner_id' => \CodeProject\Entities\User::all()->lists('id')->random(1), 'client_id' => \CodeProject\Entities\Client::all()->lists('id')->random(1), 'name' => $faker->sentence, 'description' => $faker->text(400), 'progress' => $faker->numberBetween(0, 100), 'status' => $faker->numberBetween(0, 2), 'due_date' => $faker->dateTimeAD($min = 'now')]; }); $factory->define(CodeProject\Entities\ProjectNote::class, function (Faker\Generator $faker) { return ['project_id' => \CodeProject\Entities\Project::all()->lists('id')->random(1), 'title' => $faker->sentence, 'note' => $faker->text(400)]; }); $factory->define(CodeProject\Entities\ProjectTask::class, function (Faker\Generator $faker) { return ['project_id' => \CodeProject\Entities\Project::all()->lists('id')->random(1), 'name' => $faker->sentence, 'start_date' => $faker->dateTimeAD($max = 'now'), 'due_date' => $faker->dateTimeAD($min = 'now'), 'status' => $faker->numberBetween(0, 2)]; });
<?php /* |-------------------------------------------------------------------------- | Model Factories |-------------------------------------------------------------------------- | | Here you may define all of your model factories. Model factories give | you a convenient way to create models for testing and seeding your | database. Just tell the factory how a default model should look. | */ $factory->define(CodeProject\Entities\User::class, function (Faker\Generator $faker) { return ['name' => $faker->name, 'email' => $faker->email, 'password' => bcrypt(str_random(10)), 'remember_token' => str_random(10)]; }); $factory->define(CodeProject\Entities\Client::class, function (Faker\Generator $faker) { return ['name' => $faker->name, 'responsible' => $faker->name, 'email' => $faker->email, 'phone' => $faker->phoneNumber, 'address' => $faker->address, 'obs' => $faker->sentence]; }); $factory->define(CodeProject\Entities\Project::class, function (Faker\Generator $faker) { return ['owner_id' => \CodeProject\Entities\User::all()->lists('id')->random(1), 'client_id' => \CodeProject\Entities\Client::all()->lists('id')->random(1), 'name' => $faker->name, 'description' => $faker->sentence, 'progress' => $faker->NumberBetween(0, 100), 'status' => $faker->numberBetween(1, 3), 'due_date' => $faker->dateTime]; }); $factory->define(CodeProject\Entities\ProjectNote::class, function (Faker\Generator $faker) { return ['project_id' => \CodeProject\Entities\Project::all()->lists('id')->random(1), 'title' => $faker->word, 'note' => $faker->paragraph]; }); $factory->define(CodeProject\Entities\ProjectTask::class, function (Faker\Generator $faker) { return ['project_id' => \CodeProject\Entities\Project::all()->lists('id')->random(1), 'name' => $faker->word, 'start_date' => $faker->dateTime, 'due_date' => $faker->dateTime, 'status' => $faker->numberBetween(1, 2)]; }); $factory->define(CodeProject\Entities\ProjectMember::class, function (Faker\Generator $faker) { return ['project_id' => \CodeProject\Entities\Project::all()->lists('id')->random(1), 'user_id' => \CodeProject\Entities\User::all()->lists('id')->random(1)]; });
} return ['owner_id' => $faker->randomElement($o), 'client_id' => $faker->randomElement($c), 'name' => $faker->word, 'description' => $faker->sentence, 'progress' => rand(1, 100), 'status' => rand(1, 3), 'due_date' => $faker->dateTime('now')]; }); $factory->define(ProjectNote::class, function (Generator $faker) { $project = Project::all()->lists('id'); foreach ($project as $value) { $p[] = $value; } return ['project_id' => $faker->randomElement($p), 'title' => $faker->title, 'note' => $faker->paragraph]; }); $factory->define(ProjectTask::class, function (Generator $faker) { $project = Project::all()->lists('id'); foreach ($project as $value) { $p[] = $value; } return ['project_id' => $faker->randomElement($p), 'name' => $faker->word, 'start_date' => $faker->dateTime('now'), 'due_date' => $faker->dateTime('now'), 'status' => rand(1, 3)]; }); $factory->define(ProjectMembers::class, function (Generator $faker) { $project = Project::all()->lists('id'); foreach ($project as $value) { $p[] = $value; } $user = User::all()->lists('id'); foreach ($user as $value) { $u[] = $value; } return ['project_id' => $faker->randomElement($p), 'user_id' => $faker->randomElement($u)]; }); $factory->define(OauthClients::class, function (Generator $faker) { return ['id' => $faker->md5, 'secret' => $faker->text(10), 'name' => $faker->name]; });