php - In Laravel, how do I retrieve a random user_id from the Users table for Model Factory seeding data generation?

Solution:

Try the below.

use App\User; // Assuming this is your User Model class with namespace.

$factory->define(App\Reply::class, function (Faker\Generator $faker) {
  return [
    'thread_id' => 1,
    'user_id' => User::all()->random()->id,
    'body' => $faker->paragraph
  ];
});
Copy code

Remember that this gets all the user data from your table and then choses an id randomly. So if your table has huge amount of data, it is not recommended. Instead, in your Test Case, you can create a new User (via its own factory) and assign the id to the Reply object generated from the above factory.

Alternately, you can query for a specific user in the above factory definition.

'user_id' => User::where('username', 'like', '[email protected]')->get()->random()->id
Copy code

If you have a test user set up in your DB this will avoid pulling all the user data.

Solution:

Any class that extendsIlluminate\Database\Eloquent\Model will be able to do this:

User::inRandomOrder()->first()
Copy code

Or to get a Collection of 3 items:

User::inRandomOrder()->limit(3)->get()
Copy code

This might be more efficient than usingUser::all()->first(), which ought to first query all Users.

Your IDE (like PhpStorm) will probably be wildly confused that this is an option though.

Also see: Laravel - Eloquent or Fluent random row

Solution:

It does not work like that 'user_id':

User::all()->random()->user_id
Copy code

But that's how it works:

User::all()->random()->id
Copy code

Solution:

I personally like to use.

App\User::pluck('id')->random()
Copy code

Change the model name which model you want

Solution:

It may not be that efficient but you can use it:

User::all('id')->random();

or

rand(1,User::count());

or

User::inRandomOrder()->limit(1)->get();

First one will be more faster thanUser::all()->random()->id; because that all function by default gets '*' as column name parameter. So, it will get all the columns for all the rows.

Solution:

If Anyone wants a unique User_id you can try this.

'user_id' => User::all()->unique()->random()->id,
Copy code

Or either it's

'user_id' => User::all()->random()->id,
Copy code

Model name can change as your wants.