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');
}
}
/**
* 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;
}
/**
* 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;
}
/**
* 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;
}
}