/**
* Reloads this object from datastore based on primary key and (optionally) resets all associated objects.
*
* This will only work if the object has been saved and has a valid primary key set.
*
* @param boolean $deep (optional) Whether to also de-associated any related objects.
* @param PropelPDO $con (optional) The PropelPDO connection to use.
* @return void
* @throws PropelException - if this object is deleted, unsaved or doesn't have pk match in db
*/
public function reload($deep = false, PropelPDO $con = null)
{
if ($this->isDeleted()) {
throw new PropelException("Cannot reload a deleted object.");
}
if ($this->isNew()) {
throw new PropelException("Cannot reload an unsaved object.");
}
if ($con === null) {
$con = Propel::getConnection(CmsCategoryPeer::DATABASE_NAME, Propel::CONNECTION_READ);
}
// We don't need to alter the object instance pool; we're just modifying this instance
// already in the pool.
$stmt = CmsCategoryPeer::doSelectStmt($this->buildPkeyCriteria(), $con);
$row = $stmt->fetch(PDO::FETCH_NUM);
$stmt->closeCursor();
if (!$row) {
throw new PropelException('Cannot find matching row in the database to reload object values.');
}
$this->hydrate($row, 0, true);
// rehydrate
if ($deep) {
// also de-associate any related objects?
$this->collCmsContents = null;
}
// if (deep)
}
/**
* Get the highest rank
*
* @param PropelPDO optional connection
*
* @return integer highest position
*/
public static function getMaxRank(PropelPDO $con = null)
{
if ($con === null) {
$con = Propel::getConnection(CmsCategoryPeer::DATABASE_NAME);
}
// shift the objects with a position lower than the one of object
$c = new Criteria();
$c->addSelectColumn('MAX(' . CmsCategoryPeer::RANK_COL . ')');
$stmt = CmsCategoryPeer::doSelectStmt($c, $con);
return $stmt->fetchColumn();
}