public function testOrderBy()
{
$result = $this->connection->select('writers', 'name', null, 'name');
$this->assertInstanceOf(ResultInterface::class, $result);
$this->assertCount(3, $result);
$writers = [];
foreach ($result as $row) {
$writers[] = $row;
}
$this->assertCount(3, $writers);
$this->assertEquals('Alexander Pushkin', $writers[0]['name']);
$this->assertEquals('Fyodor Dostoyevsky', $writers[1]['name']);
$this->assertEquals('Leo Tolstoy', $writers[2]['name']);
}
