Example #1
0
 /**
  * @param mixed $sections A single {@link OnpubSection} object or an array of {@link OnpubSection} objects (to insert multiple sections at a time).
  * @return mixed The ID(s) of the new section(s). An int will be returned if a single section was inserted. An array of ints will be returned if multiple sections were inserted.
  * @throws PDOException if there's a database error.
  */
 public function insert($sections, $insertWSMaps = FALSE)
 {
     $oimages = new OnpubImages($this->pdo, FALSE);
     $owsmaps = new OnpubWSMaps($this->pdo, FALSE);
     $IDs = array();
     $isArray = TRUE;
     $wsmaps = array();
     if (!is_array($sections)) {
         $sections = array($sections);
         $isArray = FALSE;
     }
     if ($this->enableTransactions) {
         $status = $this->pdo->beginTransaction();
         OnpubDatabase::verifyTransaction($this->pdo, $status);
     }
     $stmt = $this->pdo->prepare("INSERT INTO OnpubSections (ID, imageID, websiteID, parentID, name, url, created, modified) VALUES (:ID, :imageID, :websiteID, :parentID, :name, :url, :created, :modified)");
     OnpubDatabase::verifyPrepare($this->pdo, $stmt, $this->enableTransactions);
     foreach ($sections as $section) {
         if ($section->image) {
             try {
                 $imageID = $oimages->insert($section->image);
                 $section->imageID = $imageID;
             } catch (PDOException $e) {
                 if ($this->enableTransactions) {
                     $this->pdo->rollBack();
                 }
                 throw $e;
             }
         }
         try {
             $ID = $this->getID($section);
         } catch (PDOException $e) {
             if ($this->enableTransactions) {
                 $this->pdo->rollBack();
             }
             throw $e;
         }
         if ($ID) {
             $IDs[] = $ID;
             $section->ID = $ID;
         } else {
             $ID = $section->ID;
             $imageID = $section->imageID;
             $websiteID = $section->websiteID;
             $parentID = $section->parentID;
             $name = OnpubDatabase::utf8Decode(trim($section->name));
             $url = OnpubDatabase::utf8Decode(trim($section->url));
             $created = $section->getCreated()->format('Y-m-d H:i:s');
             $modified = $section->getModified()->format('Y-m-d H:i:s');
             $stmt->bindParam(':ID', $ID);
             $stmt->bindParam(':imageID', $imageID);
             $stmt->bindParam(':websiteID', $websiteID);
             $stmt->bindParam(':parentID', $parentID);
             $stmt->bindParam(':name', $name);
             $stmt->bindParam(':url', $url);
             $stmt->bindParam(':created', $created);
             $stmt->bindParam(':modified', $modified);
             $result = $stmt->execute();
             OnpubDatabase::verifyExecute($this->pdo, $result, $this->enableTransactions, $stmt->errorInfo());
             $IDs[] = $this->pdo->lastInsertId();
             $section->ID = $this->pdo->lastInsertId();
         }
         $wsmap = new OnpubWSMap();
         $wsmap->websiteID = $section->websiteID;
         $wsmap->sectionID = $section->ID;
         $wsmap->setCreated($section->getCreated());
         $wsmap->setModified($section->getModified());
         $wsmaps[] = $wsmap;
     }
     if ($insertWSMaps) {
         try {
             $owsmaps->insert($wsmaps);
         } catch (PDOException $e) {
             if ($this->enableTransactions) {
                 $this->pdo->rollBack();
             }
             throw $e;
         }
     }
     if ($this->enableTransactions) {
         $status = $this->pdo->commit();
         OnpubDatabase::verifyTransaction($this->pdo, $status);
     }
     if ($isArray) {
         return $IDs;
     } else {
         return end($IDs);
     }
 }
Example #2
0
 /**
  * @param OnpubQueryOptions $queryOptions Database query options.
  * @return array An array of {@link OnpubWSMap} objects.
  */
 public function select(OnpubQueryOptions $queryOptions = NULL, $websiteID = NULL, $sectionID = NULL)
 {
     if ($queryOptions === NULL) {
         $queryOptions = new OnpubQueryOptions();
     }
     $query = $this->selectQuery($queryOptions, $websiteID, $sectionID);
     $result = $this->pdo->query($query);
     OnpubDatabase::verifyQuery($this->pdo, $result, FALSE);
     $rows = $result->fetchAll(PDO::FETCH_ASSOC);
     $wsmaps = array();
     if ($rows) {
         foreach ($rows as $row) {
             $wsmap = new OnpubWSMap();
             $wsmap->ID = $row["ID"];
             $wsmap->websiteID = $row["websiteID"];
             $wsmap->sectionID = $row["sectionID"];
             $wsmap->setCreated(new DateTime($row["created"]));
             $wsmap->setModified(new DateTime($row["modified"]));
             $wsmaps[] = $wsmap;
         }
     }
     $result->closeCursor();
     return $wsmaps;
 }