what to test when doing an eloquent select query?

When testing an Eloquent select query, you should test for the following:

1. Test that the query returns a collection of results.
2. Test that the query returns an empty collection if no records are found.
3. Test that the model is associated with a table.

To test for these conditions, you can use PHPUnit and Laravel's testing helpers. Here's an example:

public function testSelectQuery()
{
    // Test that the query returns a collection of results.
    $result = ModelName::where('whatever', 'value')->get();
    $this->assertInstanceOf(\Illuminate\Database\Eloquent\Collection::class, $result);

    // Test that the query returns an empty collection if no records are found.
    $result = ModelName::where('whatever', 'non-existent-value')->get();
    $this->assertEmpty($result);

    // Test that the model is associated with a table.
    $this->assertEquals('table_name', (new ModelName)->getTable());
}

In the first test, we use assertInstanceOf to check that the result is an instance of Illuminate\Database\Eloquent\Collection.

In the second test, we use assertEmpty to check that the result is an empty collection.

In the third test, we use assertEquals to check that the model is associated with the correct table.