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