private function Update(Page $page) { // Assert that page has id assert(!is_null($page->GetPageId())); try { // Prepare db statement $statement = self::$db->prepare('UPDATE ' . self::$DB_TABLE_NAME . ' SET ' . '`header` = :header, ' . '`content` = :content, ' . '`author_name` = :author_name, ' . '`slug` = :slug, ' . '`modified` = NOW() ' . ' WHERE page_id = :pageId' . ' LIMIT 1'); // Prepare input array $inputArray = ['pageId' => $page->GetPageId(), 'header' => $page->GetHeader(), 'content' => $page->GetContent(), 'author_name' => $page->GetAuthorName(), 'slug' => $page->GetSlug()]; // Execute db statement $statement->execute($inputArray); // Check if db deletion was successful return $statement->rowCount() == 1; } catch (\Exception $exception) { throw new \Exception(self::$DB_UPDATE_ERROR); } }
public function testConstructor() { // Clear validations \model\ValidationService::Clear(); $dateTimeObj1 = new \DateTime("now"); $dateTimeObj2 = new \DateTime("2000-01-01"); $page = new Page(12, 'header', 'content', 'authorName', 'slug', $dateTimeObj1, $dateTimeObj2); $this->assertTrue(\model\ValidationService::IsValid()); // Check values $this->assertEquals(12, $page->GetPageId()); $this->assertEquals("header", $page->GetHeader()); $this->assertEquals("content", $page->GetContent()); $this->assertEquals("authorName", $page->GetAuthorName()); $this->assertEquals("slug", $page->GetSlug()); $this->assertEquals($dateTimeObj1, $page->GetCreated()); $this->assertEquals($dateTimeObj2, $page->GetModified()); }
private function Update(Page $page) { $stmt = $this->conn->prepare("UPDATE page SET name=?, slug=?, project=?, content=?, template=?, module=? WHERE id = ?"); $stmt->execute(array($page->GetName(), $page->GenerateSlug(), $page->GetProject(), $page->GetContent(), $page->GetTemplate(), $page->GetModule(), $page->GetID())); return $page->GetID(); }