Blog: Propel 1.5.4 Released
Here comes our monthly bugfix release. KRavEN and ddalmais helped improving the MSSQL and Oracle adapters - PDO is really not doing things properly alone. In addition to a few other bugfixes, an important improvement made it trivial to hydrate Propel objects based on an arbitrary SQL statement:
// prepare and execute an arbitrary SQL statement $con = Propel::getConnection(BookPeer::DATABASE_NAME); $sql = "SELECT * FROM book WHERE id NOT IN " ."(SELECT book_review.book_id FROM book_review" ." INNER JOIN author ON (book_review.author_id=author.ID)" ." WHERE author.last_name = :name)"; $stmt = $con->prepare($sql); $stmt->execute(array(':name' => 'Austen')); // hydrate Book objects with the result $formatter = new PropelObjectFormatter(); $formatter->setClass('Book'); $books = $formatter->format($stmt);
You can find the full changelog in the Propel 1.5 documentation.
To upgrade, use your favorite distribution: