Propel to Doctrine Code Snippet

Question

I am using symfony 1.4 with Doctrine ORM. I am editing some of the actions, and I need to rewrite a Propel query into Doctrine. Here's the snippet:

  $c = new Criteria();
  $c->add(BlogCommentPeer::BLOG_POST_ID, $request->getParameter('id'));
  $c->addAscendingOrderByColumn(BlogCommentPeer::CREATED_AT);
  $this->comments = BlogCommentPeer::doSelect($c);

Can anyone help with the conversion? Thanks.

j0k · Accepted Answer · 2012-05-01 07:38:44Z

1

In your BlogCommentTable.php file, put this method :

public functoion retrieveByPostId($post_id)
{
  $q = $this->createQuery('c')
    ->where('c.blog_post_id = ?', array($post_id))
    ->orderBy('c.created_at ASC');

  return $q->execute();
}

And in your action:

$this->comments = Doctrine_Core::getTable('BlogComment')->retrieveByPostId($request->getParameter('id'));

edited May 1, 2012 at 7:38

answered May 1, 2012 at 7:01

j0k

22.8k28 gold badges81 silver badges90 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Martin Fall Over a year ago

oops. sorry. kinda new to this and still figuring out the rules of engagement.

Collectives™ on Stack Overflow

Propel to Doctrine Code Snippet

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related