code_junkie

Symfony Propel criteria

Nov 13th, 2011
182
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.58 KB | None | 0 0
  1. $con = Propel::getConnection(DATABASE_NAME);
  2. $sql = "SELECT books.* FROM books
  3. WHERE NOT EXISTS (SELECT id FROM review WHERE book_id = book.id)";
  4. $stmt = $con->createStatement();
  5. $rs = $stmt->executeQuery($sql, ResultSet::FETCHMODE_NUM);
  6. $books = BookPeer::populateObjects($rs);
  7.  
  8. $c = new Criteria();
  9. $c->add(DiscussreplyPeer::ID, $myId);
  10. $pager = new sfPropelPager();
  11. $pager->setCriteria($c);
  12. $pager->setPeerMethod('getReplies');
  13.  
  14. public static function getReplies(Criteria $c) {
  15. $map = $c->getMap();
  16. $replyId = $map[DiscussreplyPeer::ID]->getValue();
  17.  
  18. $con = Propel::getConnection(DATABASE_NAME);
  19. $sql = "select p.disrepid, p.subject, p.body, c.disrepid as disrepid1, c.subject as subject1, c.body as body1 from discusreply as p, discusreply as c where p.distopid=? and (c.disrepid = p.parentid or c.parentid = p.distopid) order by p.disrepid ASC";
  20.  
  21. $stmt = $con->prepareStatement($sql);
  22. $stmt->setString(1, $replyId);
  23.  
  24. $rs = $stmt->executeQuery();
  25.  
  26. $results = array();
  27. while ($rs->next()) {
  28. // for example
  29. $results['disrepid'] = $rs->getInt('disrepid');
  30. }
  31.  
  32. return $results;
  33. }
  34.  
  35. $c = new Criteria();
  36. $c->addJoin(discusreply::DISREPID, discusreply::PARENTID, Criteria::INNER_JOIN);
  37. $c->clearSelectColumns();
  38. $c->addSelectColumn(discusreplyPeer::Disrepid);
  39. ...
  40. $c->add(discusreplyPeer::DISTOPID, $this->id, Criteria::EQUAL);
  41. ...
  42. $c->addAscendingOrderByColumn(discusreply::DISREPID);
  43.  
  44. $sql = "SELECT ...";
  45. $dbh = Propel::getConnection([DB]);
  46. $sth = $dbh->createStatement();
  47. $res = $sth->executeQuery($sql, ResultSet::FETCHMODE_NUM);
Add Comment
Please, Sign In to add comment