public function testTimestamp() { $timestamp = new \DateTime(); $paste = new Paste(); $paste->setTimestamp($timestamp); $this->assertEquals($timestamp, $paste->getTimestamp()); }
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 testGetLatest() { $paste = new Entity\Paste(); $paste->setContent('This is a test.'); $paste->setTimestamp(new \DateTime()); $paste->setFilename('test.txt'); $paste->setIp('127.0.0.1'); $storage = $this->app['storage']; $id = $storage->save($paste); $this->assertEquals($id, $storage->getLatest()); }