public function getRankedWines(Request $request, Application $app) { $wines = WineQuery::create()->find(); $dtos = []; foreach ($wines as $wine) { $dtos[] = $this->createWineDto($wine); } usort($dtos, [$this, 'compareWine']); return $this->json($dtos); }
public function removeTasted($id, $idWine, Application $app) { $user = UserQuery::create()->findOneByIdUser($id); if ($user === null) { return new Response('Error', 404); } $wine = WineQuery::create()->findOneByIdWine($idWine); if ($wine === null) { return new Response('Error', 404); } $user->removeWine($wine); $user->save(); return new SuccessResponse(); }
/** * Gets the number of Wine objects related by a many-to-many relationship * to the current object by way of the tasted_wine cross-reference table. * * @param Criteria $criteria Optional query object to filter the query * @param boolean $distinct Set to true to force count distinct * @param ConnectionInterface $con Optional connection object * * @return int the number of related Wine objects */ public function countWines(Criteria $criteria = null, $distinct = false, ConnectionInterface $con = null) { $partial = $this->collWinesPartial && !$this->isNew(); if (null === $this->collWines || null !== $criteria || $partial) { if ($this->isNew() && null === $this->collWines) { return 0; } else { if ($partial && !$criteria) { return count($this->getWines()); } $query = ChildWineQuery::create(null, $criteria); if ($distinct) { $query->distinct(); } return $query->filterByUser($this)->count($con); } } else { return count($this->collWines); } }
/** * Get the associated ChildWine object * * @param ConnectionInterface $con Optional Connection object. * @return ChildWine The associated ChildWine object. * @throws PropelException */ public function getWine(ConnectionInterface $con = null) { if ($this->aWine === null && $this->idwine !== null) { $this->aWine = ChildWineQuery::create()->findPk($this->idwine, $con); /* The following can be used additionally to guarantee the related object contains a reference to this object. This level of coupling may, however, be undesirable since it could result in an only partially populated collection in the referenced object. $this->aWine->addTastedWines($this); */ } return $this->aWine; }
/** * Builds a Criteria object containing the primary key for this object. * * Unlike buildCriteria() this method includes the primary key values regardless * of whether or not they have been modified. * * @throws LogicException if no primary key is defined * * @return Criteria The Criteria object containing value(s) for primary key(s). */ public function buildPkeyCriteria() { $criteria = ChildWineQuery::create(); $criteria->add(WineTableMap::COL_IDWINE, $this->idwine); return $criteria; }
/** * Performs an INSERT on the database, given a Wine or Criteria object. * * @param mixed $criteria Criteria or Wine object containing data that is used to create the INSERT statement. * @param ConnectionInterface $con the ConnectionInterface connection to use * @return mixed The new primary key. * @throws PropelException Any exceptions caught during processing will be * rethrown wrapped into a PropelException. */ public static function doInsert($criteria, ConnectionInterface $con = null) { if (null === $con) { $con = Propel::getServiceContainer()->getWriteConnection(WineTableMap::DATABASE_NAME); } if ($criteria instanceof Criteria) { $criteria = clone $criteria; // rename for clarity } else { $criteria = $criteria->buildCriteria(); // build Criteria from Wine object } if ($criteria->containsKey(WineTableMap::COL_IDWINE) && $criteria->keyContainsValue(WineTableMap::COL_IDWINE)) { throw new PropelException('Cannot insert a value for auto-increment primary key (' . WineTableMap::COL_IDWINE . ')'); } // Set the correct dbName $query = WineQuery::create()->mergeWith($criteria); // use transaction because $criteria could contain info // for more than one table (I guess, conceivably) return $con->transaction(function () use($con, $query) { return $query->doInsert($con); }); }
/** * Returns a new ChildWineQuery object. * * @param string $modelAlias The alias of a model in the query * @param Criteria $criteria Optional Criteria to build the query from * * @return ChildWineQuery */ public static function create($modelAlias = null, Criteria $criteria = null) { if ($criteria instanceof ChildWineQuery) { return $criteria; } $query = new ChildWineQuery(); if (null !== $modelAlias) { $query->setModelAlias($modelAlias); } if ($criteria instanceof Criteria) { $query->mergeWith($criteria); } return $query; }