public function getAllBooks($isbn = '', $title = '') { $books = \Acme\StoreBundle\Model\BookQuery::create()->orderByTitle()->find(); return $books; }
/** * Removes this object from datastore and sets delete attribute. * * @param PropelPDO $con * @return void * @throws PropelException * @throws Exception * @see BaseObject::setDeleted() * @see BaseObject::isDeleted() */ public function delete(PropelPDO $con = null) { if ($this->isDeleted()) { throw new PropelException("This object has already been deleted."); } if ($con === null) { $con = Propel::getConnection(BookPeer::DATABASE_NAME, Propel::CONNECTION_WRITE); } $con->beginTransaction(); try { $deleteQuery = BookQuery::create()->filterByPrimaryKey($this->getPrimaryKey()); $ret = $this->preDelete($con); if ($ret) { $deleteQuery->delete($con); $this->postDelete($con); $con->commit(); $this->setDeleted(true); } else { $con->commit(); } } catch (Exception $e) { $con->rollBack(); throw $e; } }
public function getAllBooks($isbn = '', $title = '', $author = '') { $booksQuery = BookQuery::create(); $booksQuery->innerJoinAuthor(); if ($isbn != '') { $booksQuery->filterByIsbn($isbn); } if ($title != '') { $booksQuery->filterByTitle($title); } if ($author != '') { $author = AuthorQuery::create()->filterByName($author)->findOne(); $booksQuery->filterByAuthor($author); } $bookList = array(); foreach ($booksQuery->find() as $book) { $bookList[] = $this->serilizeORM($book); } return $bookList; }
/** * Returns the number of related Book objects. * * @param Criteria $criteria * @param boolean $distinct * @param PropelPDO $con * @return int Count of related Book objects. * @throws PropelException */ public function countBooks(Criteria $criteria = null, $distinct = false, PropelPDO $con = null) { $partial = $this->collBooksPartial && !$this->isNew(); if (null === $this->collBooks || null !== $criteria || $partial) { if ($this->isNew() && null === $this->collBooks) { return 0; } if ($partial && !$criteria) { return count($this->getBooks()); } $query = BookQuery::create(null, $criteria); if ($distinct) { $query->distinct(); } return $query->filterByAuthor($this)->count($con); } return count($this->collBooks); }