Blog: Propel 1.5.4 Released

The Propel Team – 14 September 2010

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: