/** * Get the associated Author object * * @param PropelPDO $con Optional Connection object. * @param $doQuery Executes a query to get the object if required * @return Author The associated Author object. * @throws PropelException */ public function getAuthor(PropelPDO $con = null, $doQuery = true) { if ($this->aAuthor === null && $this->author_id !== null && $doQuery) { $this->aAuthor = AuthorQuery::create()->findPk($this->author_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->aAuthor->addBooks($this); */ } return $this->aAuthor; }
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; }
/** * 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(AuthorPeer::DATABASE_NAME, Propel::CONNECTION_WRITE); } $con->beginTransaction(); try { $deleteQuery = AuthorQuery::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; } }