/** * @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']); }