/** * Stores code coverage information. * * @param PHPUnit_Framework_TestResult $result * @param integer $revision * @access public */ public function storeCodeCoverage(PHPUnit_Framework_TestResult $result, $revision) { $codeCoverage = $result->getCodeCoverageInformation(FALSE, TRUE); $summary = PHPUnit_Util_CodeCoverage::getSummary($codeCoverage); $files = array_keys($summary); $commonPath = PHPUnit_Util_Filesystem::getCommonPath($files); $this->dbh->beginTransaction(); foreach ($files as $file) { $filename = str_replace($commonPath, '', $file); $fileId = FALSE; $lines = file($file); $numLines = count($lines); $stmt = $this->dbh->query(sprintf('SELECT code_file_id FROM code_file WHERE code_file_name = "%s" AND revision = %d;', $filename, $revision)); if ($stmt) { $fileId = (int) $stmt->fetchColumn(); } unset($stmt); if ($fileId == 0) { $this->dbh->exec(sprintf('INSERT INTO code_file (code_file_name, code_file_md5, revision) VALUES("%s", "%s", %d);', $filename, md5_file($file), $revision)); $fileId = $this->dbh->lastInsertId(); $classes = PHPUnit_Util_Class::getClassesInFile($file, $commonPath); foreach ($classes as $class) { $this->dbh->exec(sprintf('INSERT INTO code_class (code_file_id, code_class_name, code_class_start_line, code_class_end_line) VALUES(%d, "%s", %d, %d);', $fileId, $class->getName(), $class->getStartLine(), $class->getEndLine())); $classId = $this->dbh->lastInsertId(); foreach ($class->getMethods() as $method) { if ($class->getName() != $method->getDeclaringClass()->getName()) { continue; } $this->dbh->exec(sprintf('INSERT INTO code_method (code_class_id, code_method_name, code_method_start_line, code_method_end_line) VALUES(%d, "%s", %d, %d);', $classId, $method->getName(), $method->getStartLine(), $method->getEndLine())); } } $i = 1; foreach ($lines as $line) { $this->dbh->exec(sprintf('INSERT INTO code_line (code_file_id, code_line_number, code_line, code_line_covered) VALUES(%d, %d, "%s", %d);', $fileId, $i, trim($line), isset($summary[$file][$i]) ? $summary[$file][$i] : 0)); $i++; } } for ($lineNumber = 1; $lineNumber <= $numLines; $lineNumber++) { $coveringTests = PHPUnit_Util_CodeCoverage::getCoveringTests($codeCoverage, $file, $lineNumber); if (is_array($coveringTests)) { $stmt = $this->dbh->query(sprintf('SELECT code_line_id, code_line_covered FROM code_line WHERE code_file_id = %d AND code_line_number = %d;', $fileId, $lineNumber)); $codeLineId = (int) $stmt->fetchColumn(0); $oldCoverageFlag = (int) $stmt->fetchColumn(1); unset($stmt); $newCoverageFlag = $summary[$file][$lineNumber]; if ($oldCoverageFlag == 0 && $newCoverageFlag != 0 || $oldCoverageFlag < 0 && $newCoverageFlag > 0) { $this->dbh->exec(sprintf('UPDATE code_line SET code_line_covered = %d WHERE code_line_id = %d;', $newCoverageFlag, $codeLineId)); } foreach ($coveringTests as $test) { $this->dbh->exec(sprintf('INSERT INTO code_coverage (test_id, code_line_id) VALUES(%d, %d);', $test->__db_id, $codeLineId)); } } } } foreach ($result->topTestSuite() as $test) { if ($test instanceof PHPUnit_Framework_TestCase) { $stmt = $this->dbh->query(sprintf('SELECT code_method.code_method_id FROM code_class, code_method WHERE code_class.code_class_id = code_method.code_class_id AND code_class.code_class_name = "%s" AND code_method.code_method_name = "%s";', get_class($test), $test->getName())); $methodId = (int) $stmt->fetchColumn(); unset($stmt); $this->dbh->exec(sprintf('UPDATE test SET code_method_id = %d WHERE test_id = %d;', $methodId, $test->__db_id)); } } $this->dbh->commit(); }
/** * Stores code coverage information. * * @param PHPUnit_Framework_TestResult $result * @param integer $runId * @param integer $revision * @param string $commonPath */ public function storeCodeCoverage(PHPUnit_Framework_TestResult $result, $runId, $revision, $commonPath = '') { $codeCoverage = $result->getCodeCoverageInformation(FALSE); $summary = PHPUnit_Util_CodeCoverage::getSummary($codeCoverage); $files = array_keys($summary); $projectMetrics = new PHPUnit_Util_Metrics_Project($files, $summary); $storedClasses = array(); if (empty($commonPath)) { $commonPath = PHPUnit_Util_Filesystem::getCommonPath($files); } $this->dbh->beginTransaction(); foreach ($files as $fileName) { $shortenedFileName = str_replace($commonPath, '', $fileName); $fileId = FALSE; $fileMetrics = $projectMetrics->getFile($fileName); $lines = $fileMetrics->getLines(); $hash = md5_file($fileName); $stmt = $this->dbh->prepare('SELECT code_file_id FROM code_file WHERE code_file_name = :shortenedFileName AND revision = :revision;'); $stmt->bindParam(':shortenedFileName', $shortenedFileName, PDO::PARAM_STR); $stmt->bindParam(':revision', $revision, PDO::PARAM_INT); $stmt->execute(); if ($stmt) { $fileId = (int) $stmt->fetchColumn(); } unset($stmt); if ($fileId == 0) { $stmt = $this->dbh->prepare('INSERT INTO code_file (code_file_name, code_full_file_name, code_file_md5, revision) VALUES(:shortenedFileName, :fullFileName, :hash, :revision);'); $stmt->bindParam(':shortenedFileName', $shortenedFileName, PDO::PARAM_STR); $stmt->bindParam(':fullFileName', $fileName, PDO::PARAM_STR); $stmt->bindParam(':hash', $hash, PDO::PARAM_STR); $stmt->bindParam(':revision', $revision, PDO::PARAM_INT); $stmt->execute(); $fileId = $this->dbh->lastInsertId(); $stmt = $this->dbh->prepare('INSERT INTO code_class (code_file_id, code_class_name, code_class_start_line, code_class_end_line) VALUES(:fileId, :className, :startLine, :endLine);'); foreach ($fileMetrics->getClasses() as $classMetrics) { $className = $classMetrics->getClass()->getName(); $classStartLine = $classMetrics->getClass()->getStartLine(); $classEndLine = $classMetrics->getClass()->getEndLine(); $stmt->bindParam(':fileId', $fileId, PDO::PARAM_INT); $stmt->bindParam(':className', $className, PDO::PARAM_STR); $stmt->bindParam(':startLine', $classStartLine, PDO::PARAM_INT); $stmt->bindParam(':endLine', $classEndLine, PDO::PARAM_INT); $stmt->execute(); $classId = $this->dbh->lastInsertId(); $storedClasses[$className] = $classId; $stmt2 = $this->dbh->prepare('INSERT INTO code_method (code_class_id, code_method_name, code_method_start_line, code_method_end_line) VALUES(:classId, :methodName, :startLine, :endLine);'); foreach ($classMetrics->getMethods() as $methodMetrics) { $methodName = $methodMetrics->getMethod()->getName(); $methodStartLine = $methodMetrics->getMethod()->getStartLine(); $methodEndLine = $methodMetrics->getMethod()->getEndLine(); $stmt2->bindParam(':classId', $classId, PDO::PARAM_INT); $stmt2->bindParam(':methodName', $methodName, PDO::PARAM_STR); $stmt2->bindParam(':startLine', $methodStartLine, PDO::PARAM_INT); $stmt2->bindParam(':endLine', $methodEndLine, PDO::PARAM_INT); $stmt2->execute(); } unset($stmt2); } $stmt = $this->dbh->prepare('INSERT INTO code_line (code_file_id, code_line_number, code_line, code_line_covered) VALUES(:fileId, :lineNumber, :line, :covered);'); $i = 1; foreach ($lines as $line) { $covered = 0; if (isset($summary[$fileName][$i])) { if (is_int($summary[$fileName][$i])) { $covered = $summary[$fileName][$i]; } else { $covered = 1; } } $stmt->bindParam(':fileId', $fileId, PDO::PARAM_INT); $stmt->bindParam(':lineNumber', $i, PDO::PARAM_INT); $stmt->bindParam(':line', $line, PDO::PARAM_STR); $stmt->bindParam(':covered', $covered, PDO::PARAM_INT); $stmt->execute(); $i++; } } $stmt = $this->dbh->prepare('INSERT INTO metrics_file (run_id, code_file_id, metrics_file_coverage, metrics_file_loc, metrics_file_cloc, metrics_file_ncloc, metrics_file_loc_executable, metrics_file_loc_executed) VALUES(:runId, :fileId, :coverage, :loc, :cloc, :ncloc, :locExecutable, :locExecuted);'); $fileCoverage = $fileMetrics->getCoverage(); $fileLoc = $fileMetrics->getLoc(); $fileCloc = $fileMetrics->getCloc(); $fileNcloc = $fileMetrics->getNcloc(); $fileLocExecutable = $fileMetrics->getLocExecutable(); $fileLocExecuted = $fileMetrics->getLocExecuted(); $stmt->bindParam(':runId', $runId, PDO::PARAM_INT); $stmt->bindParam(':fileId', $fileId, PDO::PARAM_INT); $stmt->bindParam(':coverage', $fileCoverage); $stmt->bindParam(':loc', $fileLoc, PDO::PARAM_INT); $stmt->bindParam(':cloc', $fileCloc, PDO::PARAM_INT); $stmt->bindParam(':ncloc', $fileNcloc, PDO::PARAM_INT); $stmt->bindParam(':locExecutable', $fileLocExecutable, PDO::PARAM_INT); $stmt->bindParam(':locExecuted', $fileLocExecuted, PDO::PARAM_INT); $stmt->execute(); $stmtSelectFunctionId = $this->dbh->prepare('SELECT code_function_id FROM code_file, code_function WHERE code_function.code_file_id = code_file.code_file_id AND code_file.revision = :revision AND code_function.code_function_name = :functionName;'); $stmtInsertFunction = $this->dbh->prepare('INSERT INTO metrics_function (run_id, code_function_id, metrics_function_coverage, metrics_function_loc, metrics_function_loc_executable, metrics_function_loc_executed, metrics_function_ccn, metrics_function_crap, metrics_function_npath) VALUES(:runId, :functionId, :coverage, :loc, :locExecutable, :locExecuted, :ccn, :crap, :npath);'); $stmtSelectClassId = $this->dbh->prepare('SELECT code_class_id FROM code_file, code_class WHERE code_class.code_file_id = code_file.code_file_id AND code_file.revision = :revision AND code_class.code_class_name = :className;'); $stmtInsertClass = $this->dbh->prepare('INSERT INTO metrics_class (run_id, code_class_id, metrics_class_coverage, metrics_class_loc, metrics_class_loc_executable, metrics_class_loc_executed, metrics_class_aif, metrics_class_ahf, metrics_class_cis, metrics_class_csz, metrics_class_dit, metrics_class_impl, metrics_class_mif, metrics_class_mhf, metrics_class_noc, metrics_class_pf, metrics_class_vars, metrics_class_varsnp, metrics_class_varsi, metrics_class_wmc, metrics_class_wmcnp, metrics_class_wmci) VALUES(:runId, :classId, :coverage, :loc, :locExecutable, :locExecuted, :aif, :ahf, :cis, :csz, :dit, :impl, :mif, :mhf, :noc, :pf, :vars, :varsnp, :varsi, :wmc, :wmcnp, :wmci);'); $stmtSelectMethodId = $this->dbh->prepare('SELECT code_method_id FROM code_file, code_class, code_method WHERE code_class.code_file_id = code_file.code_file_id AND code_class.code_class_id = code_method.code_class_id AND code_file.revision = :revision AND code_class.code_class_name = :className AND code_method.code_method_name = :methodName;'); $stmtInsertMethod = $this->dbh->prepare('INSERT INTO metrics_method (run_id, code_method_id, metrics_method_coverage, metrics_method_loc, metrics_method_loc_executable, metrics_method_loc_executed, metrics_method_ccn, metrics_method_crap, metrics_method_npath) VALUES(:runId, :methodId, :coverage, :loc, :locExecutable, :locExecuted, :ccn, :crap, :npath);'); foreach ($fileMetrics->getFunctions() as $functionMetrics) { $functionName = $functionMetrics->getFunction()->getName(); $stmtSelectFunctionId->bindParam(':functionName', $functionName, PDO::PARAM_STR); $stmtSelectFunctionId->bindParam(':revision', $revision, PDO::PARAM_INT); $stmtSelectFunctionId->execute(); $functionId = (int) $stmtSelectFunctionId->fetchColumn(); $stmtSelectFunctionId->closeCursor(); $functionCoverage = $functionMetrics->getCoverage(); $functionLoc = $functionMetrics->getLoc(); $functionLocExecutable = $functionMetrics->getLocExecutable(); $functionLocExecuted = $functionMetrics->getLocExecuted(); $functionCcn = $functionMetrics->getCCN(); $functionCrap = $functionMetrics->getCrapIndex(); $functionNpath = $functionMetrics->getNPath(); $stmtInsertFunction->bindParam(':runId', $runId, PDO::PARAM_INT); $stmtInsertFunction->bindParam(':functionId', $functionId, PDO::PARAM_INT); $stmtInsertFunction->bindParam(':coverage', $functionCoverage); $stmtInsertFunction->bindParam(':loc', $functionLoc, PDO::PARAM_INT); $stmtInsertFunction->bindParam(':locExecutable', $functionLocExecutable, PDO::PARAM_INT); $stmtInsertFunction->bindParam(':locExecuted', $functionLocExecuted, PDO::PARAM_INT); $stmtInsertFunction->bindParam(':ccn', $functionCcn, PDO::PARAM_INT); $stmtInsertFunction->bindParam(':crap', $functionCrap); $stmtInsertFunction->bindParam(':npath', $functionNpath, PDO::PARAM_INT); $stmtInsertFunction->execute(); } foreach ($fileMetrics->getClasses() as $classMetrics) { $className = $classMetrics->getClass()->getName(); $stmtSelectClassId->bindParam(':className', $className, PDO::PARAM_STR); $stmtSelectClassId->bindParam(':revision', $revision, PDO::PARAM_INT); $stmtSelectClassId->execute(); $classId = (int) $stmtSelectClassId->fetchColumn(); $stmtSelectClassId->closeCursor(); $classCoverage = $classMetrics->getCoverage(); $classLoc = $classMetrics->getLoc(); $classLocExecutable = $classMetrics->getLocExecutable(); $classLocExecuted = $classMetrics->getLocExecuted(); $classAif = $classMetrics->getAIF(); $classAhf = $classMetrics->getAHF(); $classCis = $classMetrics->getCIS(); $classCsz = $classMetrics->getCSZ(); $classDit = $classMetrics->getDIT(); $classImpl = $classMetrics->getIMPL(); $classMif = $classMetrics->getMIF(); $classMhf = $classMetrics->getMHF(); $classNoc = $classMetrics->getNOC(); $classPf = $classMetrics->getPF(); $classVars = $classMetrics->getVARS(); $classVarsnp = $classMetrics->getVARSnp(); $classVarsi = $classMetrics->getVARSi(); $classWmc = $classMetrics->getWMC(); $classWmcnp = $classMetrics->getWMCnp(); $classWmci = $classMetrics->getWMCi(); $stmtInsertClass->bindParam(':runId', $runId, PDO::PARAM_INT); $stmtInsertClass->bindParam(':classId', $classId, PDO::PARAM_INT); $stmtInsertClass->bindParam(':coverage', $classCoverage); $stmtInsertClass->bindParam(':loc', $classLoc, PDO::PARAM_INT); $stmtInsertClass->bindParam(':locExecutable', $classLocExecutable, PDO::PARAM_INT); $stmtInsertClass->bindParam(':locExecuted', $classLocExecuted, PDO::PARAM_INT); $stmtInsertClass->bindParam(':aif', $classAif); $stmtInsertClass->bindParam(':ahf', $classAhf); $stmtInsertClass->bindParam(':cis', $classCis, PDO::PARAM_INT); $stmtInsertClass->bindParam(':csz', $classCsz, PDO::PARAM_INT); $stmtInsertClass->bindParam(':dit', $classDit, PDO::PARAM_INT); $stmtInsertClass->bindParam(':impl', $classImpl, PDO::PARAM_INT); $stmtInsertClass->bindParam(':mif', $classMif); $stmtInsertClass->bindParam(':mhf', $classMhf); $stmtInsertClass->bindParam(':noc', $classNoc, PDO::PARAM_INT); $stmtInsertClass->bindParam(':pf', $classPf); $stmtInsertClass->bindParam(':vars', $classVars, PDO::PARAM_INT); $stmtInsertClass->bindParam(':varsnp', $classVarsnp, PDO::PARAM_INT); $stmtInsertClass->bindParam(':varsi', $classVarsi, PDO::PARAM_INT); $stmtInsertClass->bindParam(':wmc', $classWmc, PDO::PARAM_INT); $stmtInsertClass->bindParam(':wmcnp', $classWmcnp, PDO::PARAM_INT); $stmtInsertClass->bindParam(':wmci', $classWmci, PDO::PARAM_INT); $stmtInsertClass->execute(); foreach ($classMetrics->getMethods() as $methodMetrics) { $methodName = $methodMetrics->getMethod()->getName(); $stmtSelectMethodId->bindParam(':className', $className, PDO::PARAM_STR); $stmtSelectMethodId->bindParam(':methodName', $methodName, PDO::PARAM_STR); $stmtSelectMethodId->bindParam(':revision', $revision, PDO::PARAM_INT); $stmtSelectMethodId->execute(); $methodId = (int) $stmtSelectMethodId->fetchColumn(); $stmtSelectMethodId->closeCursor(); $methodCoverage = $methodMetrics->getCoverage(); $methodLoc = $methodMetrics->getLoc(); $methodLocExecutable = $methodMetrics->getLocExecutable(); $methodLocExecuted = $methodMetrics->getLocExecuted(); $methodCcn = $methodMetrics->getCCN(); $methodCrap = $methodMetrics->getCrapIndex(); $methodNpath = $methodMetrics->getNPath(); $stmtInsertMethod->bindParam(':runId', $runId, PDO::PARAM_INT); $stmtInsertMethod->bindParam(':methodId', $methodId, PDO::PARAM_INT); $stmtInsertMethod->bindParam(':coverage', $methodCoverage); $stmtInsertMethod->bindParam(':loc', $methodLoc, PDO::PARAM_INT); $stmtInsertMethod->bindParam(':locExecutable', $methodLocExecutable, PDO::PARAM_INT); $stmtInsertMethod->bindParam(':locExecuted', $methodLocExecuted, PDO::PARAM_INT); $stmtInsertMethod->bindParam(':ccn', $methodCcn, PDO::PARAM_INT); $stmtInsertMethod->bindParam(':crap', $methodCrap); $stmtInsertMethod->bindParam(':npath', $methodNpath, PDO::PARAM_INT); $stmtInsertMethod->execute(); } } unset($stmtSelectFunctionId); unset($stmtInsertFunction); unset($stmtSelectClassId); unset($stmtInsertClass); unset($stmtSelectMethodId); unset($stmtInsertMethod); $stmt = $this->dbh->prepare('SELECT code_line_id, code_line_covered FROM code_line WHERE code_file_id = :fileId AND code_line_number = :lineNumber;'); $stmt2 = $this->dbh->prepare('UPDATE code_line SET code_line_covered = :lineCovered WHERE code_line_id = :lineId;'); $stmt3 = $this->dbh->prepare('INSERT INTO code_coverage (test_id, code_line_id) VALUES(:testId, :lineId);'); for ($lineNumber = 1; $lineNumber <= $fileLoc; $lineNumber++) { $coveringTests = PHPUnit_Util_CodeCoverage::getCoveringTests($codeCoverage, $fileName, $lineNumber); if (is_array($coveringTests)) { $stmt->bindParam(':fileId', $fileId, PDO::PARAM_INT); $stmt->bindParam(':lineNumber', $lineNumber, PDO::PARAM_INT); $stmt->execute(); $codeLineId = (int) $stmt->fetchColumn(0); $oldCoverageFlag = (int) $stmt->fetchColumn(1); $newCoverageFlag = isset($summary[$fileName][$lineNumber]) ? 1 : 0; if ($oldCoverageFlag == 0 && $newCoverageFlag != 0 || $oldCoverageFlag < 0 && $newCoverageFlag > 0) { $stmt2->bindParam(':lineCovered', $newCoverageFlag, PDO::PARAM_INT); $stmt2->bindParam(':lineId', $codeLineId, PDO::PARAM_INT); $stmt2->execute(); } foreach ($coveringTests as $test) { $stmt3->bindParam(':testId', $test->__db_id, PDO::PARAM_INT); $stmt3->bindParam(':lineId', $codeLineId, PDO::PARAM_INT); $stmt3->execute(); } } } } unset($stmt); unset($stmt2); unset($stmt3); $stmt = $this->dbh->prepare('SELECT code_method.code_method_id FROM code_class, code_method WHERE code_class.code_class_id = code_method.code_class_id AND code_class.code_class_name = :className AND code_method.code_method_name = :methodName;'); $stmt2 = $this->dbh->prepare('UPDATE test SET code_method_id = :methodId WHERE test_id = :testId;'); foreach ($result->topTestSuite() as $test) { if ($test instanceof PHPUnit_Framework_TestCase) { $className = get_class($test); $methodName = $test->getName(); $stmt->bindParam(':className', $className, PDO::PARAM_STR); $stmt->bindParam(':methodName', $methodName, PDO::PARAM_STR); $stmt->execute(); $methodId = (int) $stmt->fetchColumn(); $stmt->closeCursor(); $stmt2->bindParam(':methodId', $methodId, PDO::PARAM_INT); $stmt2->bindParam(':testId', $test->__db_id, PDO::PARAM_INT); $stmt2->execute(); } } unset($stmt); unset($stmt2); $stmt = $this->dbh->prepare('INSERT INTO metrics_project (run_id, metrics_project_cls, metrics_project_clsa, metrics_project_clsc, metrics_project_roots, metrics_project_leafs, metrics_project_interfs, metrics_project_maxdit) VALUES(:runId, :cls, :clsa, :clsc, :roots, :leafs, :interfs, :maxdit);'); $cls = $projectMetrics->getCLS(); $clsa = $projectMetrics->getCLSa(); $clsc = $projectMetrics->getCLSc(); $interfs = $projectMetrics->getInterfs(); $roots = $projectMetrics->getRoots(); $leafs = $projectMetrics->getLeafs(); $maxDit = $projectMetrics->getMaxDit(); $stmt->bindParam(':runId', $runId, PDO::PARAM_INT); $stmt->bindParam(':cls', $cls, PDO::PARAM_INT); $stmt->bindParam(':clsa', $clsa, PDO::PARAM_INT); $stmt->bindParam(':clsc', $clsc, PDO::PARAM_INT); $stmt->bindParam(':roots', $roots, PDO::PARAM_INT); $stmt->bindParam(':leafs', $leafs, PDO::PARAM_INT); $stmt->bindParam(':interfs', $interfs, PDO::PARAM_INT); $stmt->bindParam(':maxdit', $maxDit, PDO::PARAM_INT); $stmt->execute(); unset($stmt); $stmt = $this->dbh->prepare('UPDATE code_class SET code_class_parent_id = :parentClassId WHERE code_class_id = :classId;'); $stmt2 = $this->dbh->prepare('SELECT code_class.code_class_id as code_class_id FROM code_class, code_file WHERE code_class.code_file_id = code_file.code_file_id AND code_file.revision = :revision AND code_class.code_class_name = :parentClassName;'); foreach ($storedClasses as $className => $classId) { $class = new ReflectionClass($className); $parentClass = $class->getParentClass(); if ($parentClass !== FALSE) { $parentClassName = $parentClass->getName(); $parentClassId = 0; if (isset($storedClasses[$parentClassName])) { $parentClassId = $storedClasses[$parentClassName]; } else { $stmt2->bindParam(':parentClassName', $parentClassName, PDO::PARAM_STR); $stmt2->bindParam(':revision', $revision, PDO::PARAM_INT); $stmt2->execute(); $parentClassId = (int) $stmt2->fetchColumn(); $stmt2->closeCursor(); } if ($parentClassId > 0) { $stmt->bindParam(':classId', $classId, PDO::PARAM_INT); $stmt->bindParam(':parentClassId', $parentClassId, PDO::PARAM_INT); $stmt->execute(); } } } unset($stmt); unset($stmt2); $this->dbh->commit(); }