Exemple #1
0
 /**
  * @param OnpubSAMap $samap The map to be updated.
  * @return int 1 if the map was updated. 0 if the map does not exist in the database.
  */
 public function update(OnpubSAMap $samap)
 {
     $stmt = $this->pdo->prepare("UPDATE OnpubSAMaps SET sectionID = :sectionID, articleID = :articleID, created = :created, modified = :modified WHERE ID = :ID");
     OnpubDatabase::verifyPrepare($this->pdo, $stmt, $this->enableTransactions);
     $ID = $samap->ID;
     $sectionID = $samap->sectionID;
     $articleID = $samap->articleID;
     $created = $samap->getCreated()->format('Y-m-d H:i:s');
     $modified = $samap->getModified()->format('Y-m-d H:i:s');
     $stmt->bindParam(':ID', $ID);
     $stmt->bindParam(':sectionID', $sectionID);
     $stmt->bindParam(':articleID', $articleID);
     $stmt->bindParam(':created', $created);
     $stmt->bindParam(':modified', $modified);
     $result = $stmt->execute();
     OnpubDatabase::verifyExecute($this->pdo, $result, $this->enableTransactions, $stmt->errorInfo());
     return $stmt->rowCount();
 }
Exemple #2
0
 /**
  * @param OnpubSection $section The section to be updated.
  * @return int 1 if the section was updated. 0 if the section was not updated or does not exist.
  */
 public function update(OnpubSection $section)
 {
     $oarticles = new OnpubArticles($this->pdo, FALSE);
     $osamaps = new OnpubSAMaps($this->pdo, FALSE);
     $now = new DateTime();
     $inTransaction = FALSE;
     if ($this->enableTransactions) {
         $status = $this->pdo->beginTransaction();
         OnpubDatabase::verifyTransaction($this->pdo, $status);
         $inTransaction = TRUE;
     }
     if ($section->ID == $section->parentID) {
         $section->parentID = NULL;
     }
     if ($section->parentID) {
         $this->enableTransactions = FALSE;
         $parentID = $section->parentID;
         while ($parentID) {
             try {
                 $parent = $this->get($parentID);
             } catch (PDOException $e) {
                 if ($inTransaction) {
                     $this->pdo->rollBack();
                 }
                 throw $e;
             }
             if (!$parent) {
                 $section->parentID = NULL;
                 break;
             }
             if ($section->ID == $parent->parentID) {
                 $section->parentID = NULL;
                 break;
             }
             $parentID = $parent->parentID;
         }
         $this->enableTransactions = TRUE;
     }
     $stmt = $this->pdo->prepare("UPDATE OnpubSections SET imageID = :imageID, parentID = :parentID, name = :name, url = :url, modified = :modified WHERE ID = :ID");
     OnpubDatabase::verifyPrepare($this->pdo, $stmt, $this->enableTransactions);
     $ID = $section->ID;
     $imageID = $section->imageID;
     $parentID = $section->parentID;
     $name = OnpubDatabase::utf8Decode(trim($section->name));
     $url = OnpubDatabase::utf8Decode(trim($section->url));
     $modified = $now->format('Y-m-d H:i:s');
     $stmt->bindParam(':ID', $ID);
     $stmt->bindParam(':imageID', $imageID);
     $stmt->bindParam(':parentID', $parentID);
     $stmt->bindParam(':name', $name);
     $stmt->bindParam(':url', $url);
     $stmt->bindParam(':modified', $modified);
     $result = $stmt->execute();
     OnpubDatabase::verifyExecute($this->pdo, $result, $this->enableTransactions, $stmt->errorInfo());
     try {
         $osamaps->delete($section->ID, NULL);
     } catch (PDOException $e) {
         if ($this->enableTransactions) {
             $this->pdo->rollBack();
         }
         throw $e;
     }
     $articles = $section->articles;
     $samaps = array();
     foreach ($articles as $article) {
         if ($article->ID) {
             try {
                 $article = $oarticles->get($article->ID, new OnpubQueryOptions());
             } catch (PDOException $e) {
                 if ($this->enableTransactions) {
                     $this->pdo->rollBack();
                 }
                 throw $e;
             }
             $samap = new OnpubSAMap();
             $samap->sectionID = $section->ID;
             $samap->articleID = $article->ID;
             $samap->setCreated($article->getCreated());
             $samap->setModified($article->getModified());
             $samaps[] = $samap;
         } else {
             try {
                 $articleID = $oarticles->insert($article);
             } catch (PDOException $e) {
                 if ($this->enableTransactions) {
                     $this->pdo->rollBack();
                 }
                 throw $e;
             }
             $samap = new OnpubSAMap();
             $samap->sectionID = $section->ID;
             $samap->articleID = $articleID;
             $samaps[] = $samap;
         }
     }
     try {
         $osamaps->insert($samaps);
     } catch (PDOException $e) {
         if ($this->enableTransactions) {
             $this->pdo->rollBack();
         }
         throw $e;
     }
     if ($this->enableTransactions) {
         $status = $this->pdo->commit();
         OnpubDatabase::verifyTransaction($this->pdo, $status);
     }
     return $stmt->rowCount();
 }
Exemple #3
0
 /**
  * Update an article already in the database.
  *
  * If you set the article's sectionIDs to NULL, it will be unmapped from
  * any sections it was previously mapped to.
  *
  * @param OnpubArticle $article The article to be updated.
  * @param bool $overwriteAAMaps False by default. If set to TRUE, the
  * article-author maps for this article will be deleted and recreated, if
  * applicable.
  * @return int 1 if the article was updated. 0 if the article does not exist in the database.
  */
 public function update(OnpubArticle $article, $overwriteAAMaps = FALSE)
 {
     $oaamaps = new OnpubAAMaps($this->pdo, FALSE);
     $oauthors = new OnpubAuthors($this->pdo, FALSE);
     $osamaps = new OnpubSAMaps($this->pdo, FALSE);
     $oimages = new OnpubImages($this->pdo, FALSE);
     $now = new DateTime();
     if ($this->enableTransactions) {
         $status = $this->pdo->beginTransaction();
         OnpubDatabase::verifyTransaction($this->pdo, $status);
     }
     $stmt = $this->pdo->prepare("UPDATE OnpubArticles SET imageID = :imageID, title = :title, content = :content, url = :url, created = :created, modified = :modified WHERE ID = :ID");
     OnpubDatabase::verifyPrepare($this->pdo, $stmt, $this->enableTransactions);
     if ($article->image) {
         try {
             $imageID = $oimages->insert($article->image);
             $article->imageID = $imageID;
         } catch (PDOException $e) {
             if ($this->enableTransactions) {
                 $this->pdo->rollBack();
             }
             throw $e;
         }
     }
     $ID = $article->ID;
     $imageID = $article->imageID;
     $title = OnpubDatabase::utf8Decode(trim($article->title));
     $content = OnpubDatabase::utf8Decode(trim($article->content));
     $url = OnpubDatabase::utf8Decode(trim($article->url));
     $created = $article->getCreated()->format('Y-m-d H:i:s');
     $modified = $now->format('Y-m-d H:i:s');
     $stmt->bindParam(':ID', $ID);
     $stmt->bindParam(':imageID', $imageID);
     $stmt->bindParam(':title', $title);
     $stmt->bindParam(':content', $content);
     $stmt->bindParam(':url', $url);
     $stmt->bindParam(':created', $created);
     $stmt->bindParam(':modified', $modified);
     $result = $stmt->execute();
     OnpubDatabase::verifyExecute($this->pdo, $result, $this->enableTransactions, $stmt->errorInfo());
     if ($overwriteAAMaps) {
         try {
             $oaamaps->delete($article->ID, NULL);
         } catch (PDOException $e) {
             if ($this->enableTransactions) {
                 $this->pdo->rollBack();
             }
             throw $e;
         }
     }
     $authors = $article->authors;
     foreach ($authors as $author) {
         if ($author->ID) {
             try {
                 $oauthors->update($author);
             } catch (PDOException $e) {
                 if ($this->enableTransactions) {
                     $this->pdo->rollBack();
                 }
                 throw $e;
             }
         } else {
             try {
                 $oauthors->insert($author);
             } catch (PDOException $e) {
                 if ($this->enableTransactions) {
                     $this->pdo->rollBack();
                 }
                 throw $e;
             }
         }
         try {
             $aamap = new OnpubAAMap();
             $aamap->articleID = $article->ID;
             $aamap->authorID = $author->ID;
             $oaamaps->insert($aamap);
         } catch (PDOException $e) {
             if ($this->enableTransactions) {
                 $this->pdo->rollBack();
             }
             throw $e;
         }
     }
     $sectionIDs = $article->sectionIDs;
     if ($sectionIDs === NULL) {
         try {
             $samaps = $osamaps->delete(NULL, $article->ID);
         } catch (PDOException $e) {
             if ($this->enableTransactions) {
                 $this->pdo->rollBack();
             }
             throw $e;
         }
     } elseif (sizeof($sectionIDs)) {
         $queryOptions = new OnpubQueryOptions();
         $queryOptions->orderBy = "ID";
         $queryOptions->order = "ASC";
         try {
             $samaps = $osamaps->select($queryOptions, NULL, $article->ID);
         } catch (PDOException $e) {
             if ($this->enableTransactions) {
                 $this->pdo->rollBack();
             }
             throw $e;
         }
         // Unmap sections not included in $sectionIDs.
         foreach ($samaps as $samap) {
             if (!in_array($samap->sectionID, $sectionIDs)) {
                 try {
                     $osamaps->delete($samap->sectionID, $article->ID);
                 } catch (PDOException $e) {
                     if ($this->enableTransactions) {
                         $this->pdo->rollBack();
                     }
                     throw $e;
                 }
             }
         }
         foreach ($sectionIDs as $sectionID) {
             $samap = new OnpubSAMap();
             $samap->sectionID = $sectionID;
             $samap->articleID = $article->ID;
             $samap->setCreated($article->getCreated());
             $samap->setModified($article->getModified());
             try {
                 $samapID = $osamaps->getID($samap);
             } catch (PDOException $e) {
                 if ($this->enableTransactions) {
                     $this->pdo->rollBack();
                 }
                 throw $e;
             }
             if ($samapID) {
                 $samap->ID = $samapID;
                 try {
                     $osamaps->update($samap);
                 } catch (PDOException $e) {
                     if ($this->enableTransactions) {
                         $this->pdo->rollBack();
                     }
                     throw $e;
                 }
             } else {
                 try {
                     $osamaps->insert($samap);
                 } catch (PDOException $e) {
                     if ($this->enableTransactions) {
                         $this->pdo->rollBack();
                     }
                     throw $e;
                 }
             }
         }
     }
     if ($this->enableTransactions) {
         $status = $this->pdo->commit();
         OnpubDatabase::verifyTransaction($this->pdo, $status);
     }
     return $stmt->rowCount();
 }