/**
* Returns a new BookQuery object.
*
* @param string $modelAlias The alias of a model in the query
* @param BookQuery|Criteria $criteria Optional Criteria to build the query from
*
* @return BookQuery
*/
public static function create($modelAlias = null, $criteria = null)
{
if ($criteria instanceof BookQuery) {
return $criteria;
}
$query = new BookQuery(null, null, $modelAlias);
if ($criteria instanceof Criteria) {
$query->mergeWith($criteria);
}
return $query;
}
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);
}
