function getOrCreateTypeID($typeName)
{
    $itemType = ItemTypeQuery::create()->findOneByTitle($typeName);
    if ($itemType == null) {
        $maxItemTypes = ItemTypeQuery::create()->withColumn('MAX(id)', 'MAXid')->find();
        $itemType = new ItemType();
        $itemType->setId($maxItemTypes[0]->getMAXid() + 1);
        $itemType->setTitle($typeName);
        $itemType->save();
    }
    return $itemType->getId();
}
 /**
  * Filter the query by a related ItemType object
  *
  * @param   ItemType|PropelObjectCollection $itemType The related object(s) to use as filter
  * @param     string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  *
  * @return   ItemSubTypeQuery The current query, for fluid interface
  * @throws   PropelException - if the provided filter is invalid.
  */
 public function filterByMainType($itemType, $comparison = null)
 {
     if ($itemType instanceof ItemType) {
         return $this->addUsingAlias(ItemSubTypePeer::MAIN_TYPE_ID, $itemType->getId(), $comparison);
     } elseif ($itemType instanceof PropelObjectCollection) {
         if (null === $comparison) {
             $comparison = Criteria::IN;
         }
         return $this->addUsingAlias(ItemSubTypePeer::MAIN_TYPE_ID, $itemType->toKeyValue('PrimaryKey', 'Id'), $comparison);
     } else {
         throw new PropelException('filterByMainType() only accepts arguments of type ItemType or PropelCollection');
     }
 }
Example #3
0
 /**
  * Declares an association between this object and a ItemType object.
  *
  * @param                  ItemType $v
  * @return                 Item The current object (for fluent API support)
  * @throws PropelException
  */
 public function setItemType(ItemType $v = null)
 {
     if ($v === null) {
         $this->setItemTypeId(NULL);
     } else {
         $this->setItemTypeId($v->getId());
     }
     $this->aItemType = $v;
     // Add binding for other direction of this n:n relationship.
     // If this object has already been added to the ItemType object, it will not be re-added.
     if ($v !== null) {
         $v->addItem($this);
     }
     return $this;
 }
Example #4
0
 /**
  * Exclude object from result
  *
  * @param   ItemType $itemType Object to remove from the list of results
  *
  * @return ItemTypeQuery The current query, for fluid interface
  */
 public function prune($itemType = null)
 {
     if ($itemType) {
         $this->addUsingAlias(ItemTypePeer::ID, $itemType->getId(), Criteria::NOT_EQUAL);
     }
     return $this;
 }
Example #5
0
 /**
  * Adds an object to the instance pool.
  *
  * Propel keeps cached copies of objects in an instance pool when they are retrieved
  * from the database.  In some cases -- especially when you override doSelect*()
  * methods in your stub classes -- you may need to explicitly add objects
  * to the cache in order to ensure that the same objects are always returned by doSelect*()
  * and retrieveByPK*() calls.
  *
  * @param      ItemType $obj A ItemType object.
  * @param      string $key (optional) key to use for instance map (for performance boost if key was already calculated externally).
  */
 public static function addInstanceToPool($obj, $key = null)
 {
     if (Propel::isInstancePoolingEnabled()) {
         if ($key === null) {
             $key = (string) $obj->getId();
         }
         // if key === null
         ItemTypePeer::$instances[$key] = $obj;
     }
 }