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());
 }
Example #3
0
 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();
 }