/** * GetTreatmentID * * @param Scenario_Experiment $exp * @param string $treatmentname * @return int primary key (int) of the treatment in question */ protected function GetTreatmentID(Scenario_Experiment $exp, $treatmentname) { $query = $this->getDbAdapter()->select()->from($this->treatmentsTable)->where('experiment_id = ?', $exp->getRowID())->where('name = ?', $treatmentname); $result = $this->getDbAdapter()->fetchRow($query); if ($result !== null) { return $result['id']; } return null; }
/** * Add a treatment * * @param Scenario_Experiment $exp * @param string $treatmentname * @return bool Whether the operation was successful */ protected function AddTreatment(Scenario_Experiment $exp, $treatmentname) { if (!is_string($treatmentname)) { /** * @see Scenario_Data_Exception */ require_once 'Scenario/Data/Exception.php'; throw new Scenario_Data_Exception('Treatment name must be a string.'); } $sql = 'INSERT INTO `' . $this->treatmentsTable . '` (name,experiment_id) VALUES (?,?)'; $result = $this->prepare($sql, array($treatmentname, $exp->getRowID())); return $result; }