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 testToken()
{
$paste = new Paste();
$paste->setToken('1A');
$this->assertEquals('1A', $paste->getToken());
}
