Include Virtual Columns in toArray() Call with PropelORM

Question

In a PropelORM object retrieved from a query with virtual columns from a join, is there a way/method to include virtual columns in the toArray() call?

For example:

$book = BookQuery::create()
  ->join('Book.Author')
  ->with('Author')
  ->where('Author.Name = ?', 'Jane Austen')
  ->findOne();

$aBook = $book->toArray();

In the above code, I would like the array generated in the toArray() call to have the fields from the Authors table as well, not just the Books table.

it was a propel bug. it is corrected now on github – geryjuhasz Jun 16 '13 at 20:26 — geryjuhasz, Jun 16 '13 at 20:26

score 2 · Answer 1 · answered Apr 12 '12 at 21:31

If you look at the toArray() method definition, you'll see that it accepts a $includeForeignObjects parameter. I think it's more or less what you are looking for.

$book = BookQuery::create()
  ->join('Book.Author')
  ->with('Author')
  ->where('Author.Name = ?', 'Jane Austen')
  ->findOne();

$aBook = $book->toArray($keyType = BasePeer::TYPE_PHPNAME, $includeLazyLoadColumns = true, $alreadyDumpedObjects = array(), $includeForeignObjects = true);

The arguments list isn't pretty, but it should work.

Could you please link to the docs where it states $includeForeignObjects, for me all the docs seem to end at $alreadyDumpedObjects = array() — Hard-Boiled Wonderland, Dec 12 '12 at 16:13

Include Virtual Columns in toArray() Call with PropelORM

1 Answers1