/** * Create association between Os and OsGroup */ public function assignOsToOsGroup(Os &$os, OsGroup &$osGroup) { if ($os == null || $os->getId() == -1 || $osGroup == null) { Utils::log(LOG_DEBUG, "Exception", __FILE__, __LINE__); throw new Exception("Os or OsGroup object is not valid or Os.id|OsGroup.id is not set"); } Utils::log(LOG_DEBUG, "Assigning the os to the os group [os=" . $os->getName() . ",osGroupName=" . $osGroup->getName() . "]", __FILE__, __LINE__); # Check if the tag already exists $isAssigned = $this->getPakiti()->getManager("DbManager")->queryToSingleValue("select 1 from OsOsGroup where\n \t \t\tosId=" . $this->getPakiti()->getManager("DbManager")->escape($os->getId()) . ""); if ($isAssigned == null) { # Association between os and osGroup doesn't exist, so create it $this->getPakiti()->getManager("DbManager")->query("insert into OsOsGroup set\n osId=" . $this->getPakiti()->getManager("DbManager")->escape($os->getId()) . ",\n \t \t\tosGroupId=" . $this->getPakiti()->getManager("DbManager")->escape($osGroup->getId())); } else { # Update $this->getPakiti()->getManager("DbManager")->query("update OsOsGroup set\n osId=" . $this->getPakiti()->getManager("DbManager")->escape($os->getId()) . ",\n \t \t\tosGroupId=" . $this->getPakiti()->getManager("DbManager")->escape($osGroup->getId()) . " where\n \t \t\tosId=" . $this->getPakiti()->getManager("DbManager")->escape($os->getId()) . ""); } }
public function update(OsGroup &$osGroup) { $this->db->query("update OsGroup set\n \tname='" . $this->db->escape($osGroup->getName()) . "\n where id=" . $osGroup->getId()); }