/**
* @test
*/
public function shouldGetValuesInModelCollectionInAcceptableTime_PDO()
{
// given
for ($i = 0; $i < 500; $i++) {
$person = new Person();
$person->setFirstname('John');
$person->setLastname('Wayne');
$person->setAddress('Somewhere');
$person->setZip(4330);
$person->commit();
}
$this->startTimer();
// when
$people = new People(4330);
$values = $people->getValues();
$time = $this->getElapsed(__FUNCTION__);
// then
$this->assertEquals(500, count($values));
$this->assertLessThan(0.5, $time);
}
/**
* @test
*/
public function shouldBeAbleToUseLimitQuery()
{
// given
LudoDB::enableSqlLogging();
$this->createPeople();
$people = new People(4330);
$values = $people->getValues(0, 10);
// then
$this->assertEquals(10, count($values));
}
/**
* @test
*/
public function shouldGetValuesFromExternalTablesWhenUsingModel()
{
// given
$city = new City();
$city->deleteTableData();
$person = new Person();
$person->deleteTableData();
$city->setZip(4330);
$city->setCity('Aalgaard');
$city->commit();
$this->assertEquals(1, $this->getDb()->countRows("select zip from city where zip=?", array(4330)));
$this->createPersons();
// when
$people = new People(4330);
$values = $people->getValues();
$first = $values[0];
$this->log($values);
$this->log($first);
// then
$this->assertEquals('John', $first['firstname']);
$this->assertEquals('4330', $first['zip']);
$this->assertEquals('Aalgaard', $first['city']);
}
