/**
  * Returns a new SkillQuery object.
  *
  * @param     string $modelAlias The alias of a model in the query
  * @param   SkillQuery|Criteria $criteria Optional Criteria to build the query from
  *
  * @return SkillQuery
  */
 public static function create($modelAlias = null, $criteria = null)
 {
     if ($criteria instanceof SkillQuery) {
         return $criteria;
     }
     $query = new SkillQuery(null, null, $modelAlias);
     if ($criteria instanceof Criteria) {
         $query->mergeWith($criteria);
     }
     return $query;
 }
示例#2
0
function update_skills($netid, $data)
{
    $user = get_user($netid);
    $temp_allSkills = SkillQuery::create()->find();
    $allSkills = array();
    // Key all the skills by their id
    foreach ($temp_allSkills as $skill) {
        $allSkills[$skill->getId()] = $skill;
    }
    //Loop through the data given
    foreach ($data as $skill) {
        // Add a relationship if the skill is known (propel will take care of the case if the relationship already exists)
        if ($skill['known']) {
            $allSkills[$skill['Id']]->addUser($user);
        } else {
            $allSkills[$skill['Id']]->removeUser($user);
        }
        $allSkills[$skill['Id']]->save();
    }
}
示例#3
0
 /**
  * Removes this object from datastore and sets delete attribute.
  *
  * @param PropelPDO $con
  * @return void
  * @throws PropelException
  * @throws Exception
  * @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(SkillPeer::DATABASE_NAME, Propel::CONNECTION_WRITE);
     }
     $con->beginTransaction();
     try {
         $deleteQuery = SkillQuery::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;
     }
 }
 /**
  * Get the associated Skill object
  *
  * @param PropelPDO $con Optional Connection object.
  * @param $doQuery Executes a query to get the object if required
  * @return Skill The associated Skill object.
  * @throws PropelException
  */
 public function getSkill(PropelPDO $con = null, $doQuery = true)
 {
     if ($this->aSkill === null && $this->skill_id !== null && $doQuery) {
         $this->aSkill = SkillQuery::create()->findPk($this->skill_id, $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->aSkill->addUserSkills($this);
            */
     }
     return $this->aSkill;
 }