/** * If this collection has already been initialized with * an identical criteria, it returns the collection. * Otherwise if this Canon is new, it will return * an empty collection; or if this Canon has previously * been saved, it will retrieve related Works from storage. * * This method is protected by default in order to keep the public * api reasonable. You can provide public methods for those you * actually need in Canon. * * @param Criteria $criteria optional Criteria object to narrow the query * @param ConnectionInterface $con optional connection object * @param string $joinBehavior optional join type to use (defaults to Criteria::LEFT_JOIN) * @return ObjectCollection|ChildWork[] List of ChildWork objects */ public function getWorksJoinprimaryArtist(Criteria $criteria = null, ConnectionInterface $con = null, $joinBehavior = Criteria::LEFT_JOIN) { $query = ChildWorkQuery::create(null, $criteria); $query->joinWith('primaryArtist', $joinBehavior); return $this->getWorks($query, $con); }
/** * Get the associated ChildWork object * * @param ConnectionInterface $con Optional Connection object. * @return ChildWork The associated ChildWork object. * @throws PropelException */ public function getwork(ConnectionInterface $con = null) { if ($this->awork === null && $this->work_id !== null) { $this->awork = ChildWorkQuery::create()->findPk($this->work_id, $con); /* The following can be used additionally to guarantee the related object contains a reference to this object. This level of coupling may, however, be undesirable since it could result in an only partially populated collection in the referenced object. $this->awork->addMilestones($this); */ } return $this->awork; }
/** * Move the object to the bottom of the list * * @param ConnectionInterface $con optional connection * * @return integer the old object's rank */ public function moveToBottom(ConnectionInterface $con = null) { if ($this->isLast($con)) { return false; } if (null === $con) { $con = Propel::getServiceContainer()->getWriteConnection(WorkTableMap::DATABASE_NAME); } return $con->transaction(function () use($con) { $bottom = ChildWorkQuery::create()->getMaxRankArray($con); return $this->moveToRank($bottom, $con); }); }
/** * Performs an INSERT on the database, given a Work or Criteria object. * * @param mixed $criteria Criteria or Work object containing data that is used to create the INSERT statement. * @param ConnectionInterface $con the ConnectionInterface connection to use * @return mixed The new primary key. * @throws PropelException Any exceptions caught during processing will be * rethrown wrapped into a PropelException. */ public static function doInsert($criteria, ConnectionInterface $con = null) { if (null === $con) { $con = Propel::getServiceContainer()->getWriteConnection(WorkTableMap::DATABASE_NAME); } if ($criteria instanceof Criteria) { $criteria = clone $criteria; // rename for clarity } else { $criteria = $criteria->buildCriteria(); // build Criteria from Work object } if ($criteria->containsKey(WorkTableMap::COL_ID) && $criteria->keyContainsValue(WorkTableMap::COL_ID)) { throw new PropelException('Cannot insert a value for auto-increment primary key (' . WorkTableMap::COL_ID . ')'); } // Set the correct dbName $query = WorkQuery::create()->mergeWith($criteria); // use transaction because $criteria could contain info // for more than one table (I guess, conceivably) return $con->transaction(function () use($con, $query) { return $query->doInsert($con); }); }
/** * Return an array of sortable objects ordered by position * * @param Criteria $criteria optional criteria object * @param string $order sorting order, to be chosen between Criteria::ASC (default) and Criteria::DESC * @param ConnectionInterface $con optional connection * * @return array list of sortable objects */ public static function doSelectOrderByRank(Criteria $criteria = null, $order = Criteria::ASC, ConnectionInterface $con = null) { if (null === $con) { $con = Propel::getServiceContainer()->getReadConnection(WorkTableMap::DATABASE_NAME); } if (null === $criteria) { $criteria = new Criteria(); } elseif ($criteria instanceof Criteria) { $criteria = clone $criteria; } $criteria->clearOrderByColumns(); if (Criteria::ASC == $order) { $criteria->addAscendingOrderByColumn(WorkTableMap::RANK_COL); } else { $criteria->addDescendingOrderByColumn(WorkTableMap::RANK_COL); } return ChildWorkQuery::create(null, $criteria)->find($con); }