public function get($id) { $sql = "SELECT p.id, c.content, p.filename, p.token, datetime(p.timestamp, 'unixepoch') AS timestamp, p.ip, p.highlight " . "FROM pastes p, paste_content c " . "WHERE p.content_id = c.id AND p.token = :token"; $this->logger->addDebug($sql); $stmt = $this->db->prepare($sql); $stmt->bindValue(':token', $id); $stmt->execute(); $result = $stmt->fetch(); // The statement failed to execute. if (false === $stmt->execute()) { // @codeCoverageIgnoreStart throw new \RuntimeException('SQL statement failed to execute.'); // @codeCoverageIgnoreEnd } // There are no results. if (false === ($result = $stmt->fetch())) { return false; } // Assemble a paste model. $paste = new Paste(); $paste->setId($result['id']); $paste->setContent($result['content']); $paste->setTimestamp(new \DateTime($result['timestamp'])); $paste->setToken($result['token']); $paste->setFilename($result['filename']); $paste->setBinaryIp($result['ip']); $paste->setHighlight($result['highlight']); return $paste; }
public function testFluentInterface() { $now = new \DateTime(); $paste = new Paste(); $paste->setId(1)->setContent('Hello :)')->setTimestamp($now)->setToken('1')->setFilename('test.txt')->setIp('127.0.0.1')->setBinaryIp(inet_pton('127.0.0.1'))->setConvertTabs(true)->setHighlight(true); $this->assertInstanceOf('Paste\\Entity\\Paste', $paste); $this->assertEquals(1, $paste->getId()); $this->assertEquals('Hello :)', $paste->getContent()); $this->assertEquals($now, $paste->getTimestamp()); $this->assertEquals('1', $paste->getToken()); $this->assertEquals('test.txt', $paste->getFilename()); $this->assertEquals('127.0.0.1', $paste->getIp()); $this->assertEquals(inet_pton('127.0.0.1'), $paste->getBinaryIp()); $this->assertTrue($paste->getConvertTabs()); $this->assertTrue($paste->getHighlight()); }
private function getPaste() { $now = new \DateTime(); $paste = new Paste(); $paste->setId(1)->setContent('Hello :)')->setTimestamp($now)->setToken('1')->setFilename('test.txt')->setIp('127.0.0.1')->setBinaryIp(inet_pton('127.0.0.1'))->setConvertTabs(true)->setHighlight(true); return $paste; }