Arguments = array(); } public function AddLabel($label) { if (!isset($this->Labels)) { $this->Labels = array(); } $this->Labels[] = $label; } // Add an argument to the buildfailure public function AddArgument($argument) { $this->Arguments[] = $argument; } public function InsertLabelAssociations($id) { if (empty($this->Labels)) { return; } if ($id) { foreach ($this->Labels as $label) { $label->BuildFailureId = $id; $label->Insert(); } } else { add_log('No BuildFailure id - cannot call $label->Insert...', 'BuildFailure::InsertLabelAssociations', LOG_ERR, 0, $this->BuildId); } } // Insert in the database (no update possible) public function Insert() { if (!$this->BuildId) { echo 'BuildFailure::Insert(): BuildId not set
'; return false; } $workingDirectory = pdo_real_escape_string($this->WorkingDirectory); $stdOutput = pdo_real_escape_string($this->StdOutput); $stdError = pdo_real_escape_string($this->StdError); $exitCondition = pdo_real_escape_string($this->ExitCondition); $language = pdo_real_escape_string($this->Language); $targetName = pdo_real_escape_string($this->TargetName); $outputFile = pdo_real_escape_string($this->OutputFile); $outputType = pdo_real_escape_string($this->OutputType); $sourceFile = pdo_real_escape_string($this->SourceFile); // Compute the crc32. $crc32 = crc32($outputFile . $stdOutput . $stdError . $sourceFile); // Get details ID if it already exists, otherwise insert a new row. $detailsResult = pdo_single_row_query( 'SELECT id FROM buildfailuredetails WHERE crc32=' . qnum($crc32)); if ($detailsResult && array_key_exists('id', $detailsResult)) { $detailsId = $detailsResult['id']; } else { $query = 'INSERT INTO buildfailuredetails (type, stdoutput, stderror, exitcondition, language, targetname, outputfile, outputtype, crc32) VALUES (' . qnum($this->Type) . ", '$stdOutput', '$stdError', '$exitCondition', '$language', '$targetName', '$outputFile', '$outputType'," . qnum($crc32) . ')'; if (!pdo_query($query)) { add_last_sql_error('BuildFailure InsertDetails', 0, $this->BuildId); } $detailsId = pdo_insert_id('buildfailuredetails'); } // Insert the buildfailure. $query = 'INSERT INTO buildfailure (buildid, detailsid, workingdirectory, sourcefile, newstatus) VALUES (' . qnum($this->BuildId) . ', ' . qnum($detailsId) . ", '$workingDirectory', '$sourceFile', 0)"; if (!pdo_query($query)) { add_last_sql_error('BuildFailure Insert', 0, $this->BuildId); return false; } $id = pdo_insert_id('buildfailure'); // Insert the arguments $argumentids = array(); foreach ($this->Arguments as $argument) { // Limit the argument to 255 $argumentescaped = pdo_real_escape_string(substr($argument, 0, 255)); // Check if the argument exists $query = pdo_query("SELECT id FROM buildfailureargument WHERE argument='" . $argumentescaped . "'"); if (!$query) { add_last_sql_error('BuildFailure Insert', 0, $this->BuildId); return false; } if (pdo_num_rows($query) > 0) { $argumentarray = pdo_fetch_array($query); $argumentids[] = $argumentarray['id']; } else { // insert the argument $query = "INSERT INTO buildfailureargument (argument) VALUES ('" . $argumentescaped . "')"; if (!pdo_query($query)) { add_last_sql_error('BuildFailure Insert', 0, $this->BuildId); return false; } $argumentids[] = pdo_insert_id('buildfailureargument'); } } // Insert the argument $query = 'INSERT INTO buildfailure2argument (buildfailureid,argumentid,place) VALUES '; $i = 0; foreach ($argumentids as $argumentid) { if ($i > 0) { $query .= ','; } $query .= '(' . qnum($id) . ',' . qnum($argumentid) . ',' . qnum($i) . ')'; $i++; } if ($i > 0) { if (!pdo_query($query)) { add_last_sql_error('BuildFailure Insert', 0, $this->BuildId); return false; } } $this->InsertLabelAssociations($id); return true; } /** * Retrieve the arguments from a build failure given its id. **/ public static function GetBuildFailureArguments($buildFailureId) { $response = array('argumentfirst' => null, 'arguments' => array()); $arguments = pdo_query( "SELECT bfa.argument FROM buildfailureargument AS bfa, buildfailure2argument AS bf2a WHERE bf2a.buildfailureid='$buildFailureId' AND bf2a.argumentid=bfa.id ORDER BY bf2a.place ASC"); $i = 0; while ($argument_array = pdo_fetch_array($arguments)) { if ($i == 0) { $response['argumentfirst'] = $argument_array['argument']; } else { $response['arguments'][] = $argument_array['argument']; } $i++; } return $response; } /** * Marshal a build failure, this includes the build failure arguments. **/ public static function marshal($data, $project, $revision, $linkifyOutput=false) { $marshaled = array_merge(array( 'language' => $data['language'], 'sourcefile' => $data['sourcefile'], 'targetname' => $data['targetname'], 'outputfile' => $data['outputfile'], 'outputtype' => $data['outputtype'], 'workingdirectory' => $data['workingdirectory'], 'exitcondition' => $data['exitcondition'] ), self::GetBuildFailureArguments($data['id'])); $marshaled['stderror'] = $data['stderror']; $marshaled['stdoutput'] = $data['stdoutput']; if (isset($data['sourcefile'])) { $file = basename($data['sourcefile']); $directory = dirname($data['sourcefile']); $marshaled['cvsurl'] = get_diff_url($project['id'], $project['cvsurl'], $directory, $file, $revision); $source_dir = get_source_dir($project['id'], $project['cvsurl'], $directory); if ($source_dir !== null && $linkifyOutput) { $marshaled['stderror'] = linkify_compiler_output($project['cvsurl'], $source_dir, $revision, $data['stderror']); $marshaled['stdoutput'] = linkify_compiler_output($project['cvsurl'], $source_dir, $revision, $data['stdoutput']); } } if (isset($data['subprojectid'])) { $marshaled['subprojectid'] = $data['subprojectid']; $marshaled['subprojectname'] = $data['subprojectname']; } return $marshaled; } }