/** * If this collection has already been initialized with * an identical criteria, it returns the collection. * Otherwise if this User is new, it will return * an empty collection; or if this User has previously * been saved, it will retrieve related Posts from storage. * * This method is protected by default in order to keep the public * api reasonable. You can provide public methods for those you * actually need in User. * * @param Criteria $criteria optional Criteria object to narrow the query * @param PropelPDO $con optional connection object * @param string $join_behavior optional join type to use (defaults to Criteria::LEFT_JOIN) * @return PropelCollection|array Post[] List of Post objects */ public function getPostsJoinCategory($criteria = null, $con = null, $join_behavior = Criteria::LEFT_JOIN) { $query = PostQuery::create(null, $criteria); $query->joinWith('Category', $join_behavior); return $this->getPosts($query, $con); }
/** * Returns a new PostQuery object. * * @param string $modelAlias The alias of a model in the query * @param Criteria $criteria Optional Criteria to build the query from * * @return PostQuery */ public static function create($modelAlias = null, $criteria = null) { if ($criteria instanceof PostQuery) { return $criteria; } $query = new PostQuery(); if (null !== $modelAlias) { $query->setModelAlias($modelAlias); } if ($criteria instanceof Criteria) { $query->mergeWith($criteria); } return $query; }
public function getObjectQuery($id) { return PostQuery::create()->findPk($id); }
$app['activity_streams.data_resolver_chain']->addDataResolver(new PostResolver()); $app['activity_streams.data_resolver_chain']->addDataResolver(new UserResolver()); $app['activity_streams.action_manager'] = $app->share(function () use($app) { return new ActionManager($app['activity_streams.data_resolver_chain']); }); $app->get('/', function () use($app) { $actions = $app['activity_streams.action_manager']->findAll(); return $app['twig']->render('index.twig', array('actions' => $actions)); }); $app->get('/activities.json', function () use($app) { $actions = $app['activity_streams.action_manager']->findAll(); $renderer = new JsonRenderer(); $res = array(); foreach ($actions as $action) { $res['items'][] = json_decode($renderer->render($action)); } return json_encode($res); }); $app->get('/user/{id}', function ($id) use($app) { $user = UserQuery::create()->findPk($id); return $app['twig']->render('user_show.twig', array('user' => $user)); }); $app->get('/category/{id}', function ($id) use($app) { $category = CategoryQuery::create()->findPk($id); return $app['twig']->render('category_show.twig', array('category' => $category)); }); $app->get('/post/{id}', function ($id) use($app) { $post = PostQuery::create()->findPk($id); return $app['twig']->render('post_show.twig', array('post' => $post)); }); $app->run();
/** * Removes this object from datastore and sets delete attribute. * * @param PropelPDO $con * @return void * @throws PropelException * @see BaseObject::setDeleted() * @see BaseObject::isDeleted() */ public function delete(PropelPDO $con = null) { if ($this->isDeleted()) { throw new PropelException("This object has already been deleted."); } if ($con === null) { $con = Propel::getConnection(PostPeer::DATABASE_NAME, Propel::CONNECTION_WRITE); } $con->beginTransaction(); try { $deleteQuery = PostQuery::create()->filterByPrimaryKey($this->getPrimaryKey()); $ret = $this->preDelete($con); if ($ret) { $deleteQuery->delete($con); $this->postDelete($con); $con->commit(); $this->setDeleted(true); } else { $con->commit(); } } catch (Exception $e) { $con->rollBack(); throw $e; } }