public function testCreateNewAuthor() { $mapper = new AuthorMapper($this->connection->getConnection()); $data = ['name' => 'Rob Allen', 'biography' => 'Lorem ipsum']; $author = new Author($data); $this->assertEmpty($author->getId()); $result = $mapper->save($author); $this->assertTrue($result); $this->assertNotEmpty($author->getId()); // read database to check we now have three records $authors = $mapper->fetchAll(); $this->assertSame(3, count($authors)); // Rob Allen will be at index 1 as he's after Anne and before Suzanne $this->assertSame('Rob Allen', $authors[1]->getName()); $this->assertSame('Lorem ipsum', $authors[1]->getBiography()); }
public function testThatAnEmptyIdOrBiographyBecomesNull() { $author = new Author(['id' => '', 'name' => 'Rob', 'biography' => '']); $this->assertNull($author->getId()); $this->assertNull($author->getBiography()); }
/** * Update a record in the database * * @param Author $author * @return boolean */ protected function update(Author $author) { $sql = 'UPDATE author SET name =:name, biography = :biography WHERE id = :id'; $params = ['name' => $author->getName(), 'biography' => $author->getBiography(), 'id' => $author->getId()]; $statement = $this->dbAdapter->prepare($sql); return $statement->execute($params); }