PHPUNIT Testing orderby? Can it be done?

@inventsimple I'm sorry but I don't understand the question. Are you referring to the results of database queries, Eloquent collections or some other data object? Perhaps you can elaborate with an example of the data you are playing with, and we can try to see what can be done...

No problem, something like the code below. I know it's best to use mockery but I'm still fairly new to phpunit testing so feel free to criticize away :)

  public function retrieve_all_rows_from_watchdog_table_and_sort_by_datecreated_desc()
  {
    // get all rows from database table order by DESC
    $results = Watchdog::orderBy('dateCreated', 'DESC')->get();
    $countRows = $results->count();
    
    // Test for order by

    // Test for more rows than 0
    $this->assertGreaterThan(0, $countRows);
  }

So I want to make sure that I'm always getting data that's ordered by the dateCreated column in descending order.

and thank you for the advice @ifpingram in advance

@inventsimple as @spekkionu says, the thing to do is to seed the database then test against it, but as he also says, you are only testing Eloquent and thus this test is redundant.

Testing should be for the code / objects which you are writing. What is it that you actually wish to do with these rows when you retrieve them? That's the code which you want to be testing...

Thanks to both of you @ifpingram and @spekkionu. It's a great point to make. I'll make sure to update the tests to reflect my application code.

@inventsimple Hi,have you finished it? I am in trouble of the question.

As your trying to test the behaviour of the framework whether it sorts in ascending or descending order.

I have read and seen many of them commenting that we need to focus on Testing Our Code rather than testing the framework.

But the following should be a good start for testing that usecase

Watchdog::factory()->create(["dateCreated" => "2021-09-01 00:00:00"]);
Watchdog::factory()->create(["dateCreated" => "2021-09-02 00:00:00"]);
$results = Watchdog::orderBy('dateCreated', 'DESC')->get();

$this->assertCount(2, $results->toArray());

$this->assertEquals("2021-09-02 00:00:00", $results[0]->dateCreated);
$this->assertEquals("2021-09-01 00:00:00", $results[1]->dateCreated);

I learnt this trick from the test-driven laravel course. You might want to try something like this:

public function testGetLatestCustomerOrders()
{
    $customer = Customer::factory()->hasOrders(4)->create();

    $response = $this->get("/api/customers/{$customer->id}/orders");

    $this->assertEquals(
        $customer->orders()->latest()->pluck('id')->toArray(),
        collect($response['orders'])->pluck('id')->toArray()
    );
}

You can also use the getData() method on the response

public function test_get_latest_customer_orders()
{
    $customer = Customer::factory()->hasOrders(4)->create();
    $response = $this->get("/api/customers/$customer->id/orders");
    $data = $response->getData()->data;

    $this->assertTrue($data[0]->id > $data[1]->id);
}

In this case you can actually test from the response. This example assumes you have a data wrapper on your response