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;
}
