Lazer\Classes\DatabaseTest::testOrderBy PHP Method

    public function testOrderBy()
    {
        $table = $this->object->table('order');
        $query = array();
        $query[] = $table->orderBy('id')->findAll()->asArray();
        $query[] = $table->orderBy('id', 'DESC')->findAll()->asArray();
        $query[] = $table->orderBy('name')->findAll()->asArray();
        $query[] = $table->orderBy('name', 'DESC')->findAll()->asArray();
        $query[] = $table->orderBy('category')->orderBy('name')->findAll()->asArray();
        $query[] = $table->orderBy('category')->orderBy('name', 'DESC')->findAll()->asArray();
        $query[] = $table->orderBy('category')->orderBy('name')->orderBy('number')->findAll()->asArray();
        $this->assertSame(1, reset($query[0])['id']);
        $this->assertSame(9, end($query[0])['id']);
        $this->assertSame(9, reset($query[1])['id']);
        $this->assertSame(1, end($query[1])['id']);
        $this->assertSame(6, reset($query[2])['id']);
        $this->assertSame(4, end($query[2])['id']);
        $this->assertSame(4, reset($query[3])['id']);
        $this->assertSame(6, end($query[3])['id']);
        $this->assertSame(1, reset($query[4])['id']);
        $this->assertSame(7, end($query[4])['id']);
        $this->assertSame(4, reset($query[5])['id']);
        $this->assertSame(6, end($query[5])['id']);
        $this->assertSame(9, reset($query[6])['id']);
        $this->assertSame(7, end($query[6])['id']);
    }