public function executeImportRestApi(sfWebRequest $request)
{
$qa_generic = sfConfig::get("app_table_qa_generic");
$qa_core = sfConfig::get("app_table_qa_core");
// Retrieve $_GET (main parameters)
$get_params['auth_token'] = $request->getGetParameter("auth_token");
$get_params['release_version'] = $request->getGetParameter("release_version");
$get_params['target'] = $request->getGetParameter("target");
$get_params['testtype'] = $request->getGetParameter("testtype");
$get_params['testset'] = $request->getGetParameter("testset");
$get_params['hwproduct'] = $request->getGetParameter("hwproduct");
$get_params['product'] = $request->getGetParameter("product");
$get_params['hardware'] = $request->getGetParameter("hardware");
$get_params['image'] = $request->getGetParameter("image");
$get_params['build_id'] = $request->getGetParameter("build_id");
// Retrieve $_GET (additional parameters)
$get_params['tested_at'] = $request->getGetParameter("tested_at");
$get_params['report_title'] = $request->getGetParameter("title");
$get_params['objective_txt'] = $request->getGetParameter("objective_txt");
$get_params['build_txt'] = $request->getGetParameter("build_txt");
$get_params['environment_txt'] = $request->getGetParameter("environment_txt");
$get_params['qa_summary_txt'] = $request->getGetParameter("qa_summary_txt");
$get_params['issue_summary_txt'] = $request->getGetParameter("issue_summary_txt");
$get_params['status'] = $request->getGetParameter("status");
// Retrieve $_GET (hwproduct additional fields)
$get_params['te_desc'] = $request->getGetParameter("te_desc");
$get_params['te_cpu'] = $request->getGetParameter("te_cpu");
$get_params['te_board'] = $request->getGetParameter("te_board");
$get_params['te_gpu'] = $request->getGetParameter("te_gpu");
$get_params['te_hw'] = $request->getGetParameter("te_hw");
// Retrieve $_GET (image additional fields)
$get_params['img_desc'] = $request->getGetParameter("img_desc");
$get_params['img_os'] = $request->getGetParameter("img_os");
$get_params['img_dist'] = $request->getGetParameter("img_dist");
$get_params['img_vers'] = $request->getGetParameter("img_vers");
$get_params['img_kernel'] = $request->getGetParameter("img_kernel");
$get_params['img_arch'] = $request->getGetParameter("img_arch");
$get_params['img_other'] = $request->getGetParameter("img_other");
$get_params['img_bin'] = $request->getGetParameter("img_bin");
$get_params['img_src'] = $request->getGetParameter("img_src");
// Old parameters support about test_environment (testtype)
if (!isset($get_params['testtype'])) {
$get_params['testtype'] = $get_params['testset'];
}
// Old parameters support about image (hwproduct)
if (!isset($get_params['hwproduct'])) {
if (!isset($get_params['product'])) {
$get_params['hwproduct'] = $get_params['hardware'];
} else {
$get_params['hwproduct'] = $get_params['product'];
}
}
// Check if auth_token parameter is empty
if (empty($get_params['auth_token'])) {
echo "{\"ok\":\"0\",\"errors\":{\"Parameters error\":\"Missing auth_token parameter\"}}\n";
exit;
}
// Check if release_version parameter is empty
if (empty($get_params['release_version'])) {
echo "{\"ok\":\"0\",\"errors\":{\"Parameters error\":\"Missing release_version parameter\"}}\n";
exit;
}
// Check if target parameter is empty
if (empty($get_params['target'])) {
echo "{\"ok\":\"0\",\"errors\":{\"Parameters error\":\"Missing target parameter\"}}\n";
exit;
}
// Check if hwproduct parameter is empty
if (empty($get_params['hwproduct'])) {
echo "{\"ok\":\"0\",\"errors\":{\"Parameters error\":\"Missing hwproduct parameter\"}}\n";
exit;
}
// Check if image parameter is empty
if (empty($get_params['image'])) {
$get_params['image'] = "Empty_image";
}
// Retrieve project_id relying on project name (if it doesn't exist, return an error)
$query = "SELECT proj.id AS project_id\n\t\t\t\t\tFROM " . $qa_generic . ".project proj\n\t\t\t\t\tWHERE proj.name = '" . $get_params['release_version'] . "'";
$result = Doctrine_Manager::getInstance()->getCurrentConnection()->execute($query)->fetch(PDO::FETCH_ASSOC);
if (empty($result["project_id"])) {
echo "{\"ok\":\"0\",\"errors\":{\"release_version\":\"Incorrect release_version '" . $get_params['release_version'] . "'\"}}\n";
exit;
}
$project_id = $result["project_id"];
// Retrieve project_group_id relying on project_group_name (if it doesn't exist, return an error)
$query = "SELECT pg.id AS project_group_id\n\t\t\t\t\tFROM " . $qa_core . ".sf_guard_group pg\n\t\t\t\t\tWHERE pg.name = '" . sfConfig::get("app_project_group") . "'";
$result = Doctrine_Manager::getInstance()->getCurrentConnection()->execute($query)->fetch(PDO::FETCH_ASSOC);
if (empty($result["project_group_id"])) {
echo "{\"ok\":\"0\",\"errors\":{\"project_group_name\":\"Incorrect project_group_name '" . sfConfig::get("app_project_group") . "'\"}}\n";
exit;
}
$project_group_id = $result["project_group_id"];
// Retrieve product_id relying on product formfactor (if it doesn't exist, return an error)
$query = "SELECT pt.id AS product_id\n\t\t\t\t\tFROM " . $qa_core . ".product_type pt\n\t\t\t\t\tWHERE pt.name = '" . $get_params['target'] . "'";
$result = Doctrine_Manager::getInstance()->getCurrentConnection()->execute($query)->fetch(PDO::FETCH_ASSOC);
if (empty($result["product_id"])) {
echo "{\"ok\":\"0\",\"errors\":{\"target\":\"Incorrect target '" . $get_params['target'] . "'\"}}\n";
exit;
}
$product_id = $result["product_id"];
// Retrieve project_to_product_id, relying on project_id, project_group_id, and product_id
$query = "SELECT ptp.id AS ptp_id\n\t\t\t\t\tFROM " . $qa_generic . ".project_to_product ptp\n\t\t\t\t\tWHERE ptp.project_id = " . $project_id . "\n\t\t\t\t\t\tAND ptp.project_group_id = " . $project_group_id . "\n\t\t\t\t\t\tAND ptp.product_id = " . $product_id;
$result = Doctrine_Manager::getInstance()->getCurrentConnection()->execute($query)->fetch(PDO::FETCH_ASSOC);
if (empty($result["ptp_id"])) {
echo "{\"ok\":\"0\",\"errors\":{\"project_to_product\":\"Cannot find project_to_product_id\"}}\n";
exit;
}
$project_to_product_id = $result["ptp_id"];
// Retrieve user_id, relying on auth_token
$query = "SELECT up.user_id\n\t\t\t\t\tFROM " . $qa_core . ".sf_guard_user_profile up\n\t\t\t\t\tWHERE up.token = '" . $get_params['auth_token'] . "'";
$result = Doctrine_Manager::getInstance()->getCurrentConnection()->execute($query)->fetch(PDO::FETCH_ASSOC);
if (empty($result["user_id"])) {
echo "{\"ok\":\"0\",\"errors\":{\"auth_token\":\"Authorized token is not valid\"}}\n";
exit;
}
$user_id = $result["user_id"];
// Customize database connection to begin a transactionnal query
$conn = Doctrine_Manager::getInstance()->getConnection("qa_generic");
$conn->setAttribute(Doctrine_Core::ATTR_AUTOCOMMIT, FALSE);
$conn->beginTransaction();
// If test_environment_name exists, retrieve id, else, create new entry and retrieve id
$query = "SELECT te.id AS test_environment_id\n\t\t\t\t\tFROM " . $qa_generic . ".test_environment te\n\t\t\t\t\tWHERE te.name = '" . $get_params['hwproduct'] . "'";
$result = Doctrine_Manager::getInstance()->getCurrentConnection()->execute($query)->fetch(PDO::FETCH_ASSOC);
if (empty($result["test_environment_id"])) {
// Check if creation of a new entry is allowed
if (sfConfig::get("app_rest_configuration_creation", false) == false) {
$conn->rollback();
$conn->setAttribute(Doctrine_Core::ATTR_AUTOCOMMIT, TRUE);
echo "{\"ok\":\"0\",\"errors\":{\"test_environment\":\"Creation of new test environment is forbidden\"}}\n";
exit;
} else {
// Add new environment
$environment = new TestEnvironment();
$environment->setName($get_params['hwproduct']);
$environment->setNameSlug(MiscUtils::slugify($get_params['hwproduct']));
// Add hwproduct additional fields if given as parameters
if (isset($get_params['te_desc'])) {
$environment->setDescription($get_params['te_desc']);
}
if (isset($get_params['te_cpu'])) {
$environment->setCpu($get_params['te_cpu']);
}
if (isset($get_params['te_board'])) {
$environment->setBoard($get_params['te_board']);
}
if (isset($get_params['te_gpu'])) {
$environment->setGpu($get_params['te_gpu']);
}
if (isset($get_params['te_hw'])) {
$environment->setOtherHardware($get_params['te_hw']);
}
// Save new environment
$environment->save($conn);
$environmentId = $environment->getId();
}
} else {
$environmentId = $result["test_environment_id"];
}
// If image_name exists, retrieve id, else, create new entry and retrieve id
$query = "SELECT i.id AS image_id\n\t\t\t\t\tFROM " . $qa_generic . ".image i\n\t\t\t\t\tWHERE i.name = '" . $get_params['image'] . "'";
$result = Doctrine_Manager::getInstance()->getCurrentConnection()->execute($query)->fetch(PDO::FETCH_ASSOC);
if (empty($result["image_id"])) {
// Check if creation of a new entry is allowed
if (sfConfig::get("app_rest_configuration_creation", false) == false) {
$conn->rollback();
$conn->setAttribute(Doctrine_Core::ATTR_AUTOCOMMIT, TRUE);
echo "{\"ok\":\"0\",\"errors\":{\"image\":\"Creation of new image is forbidden\"}}\n";
exit;
} else {
// Add new image
$image = new Image();
$image->setName($get_params['image']);
$image->setNameSlug(MiscUtils::slugify($get_params['image']));
// Add image additional fields if given as parameters
if (isset($get_params['img_desc'])) {
$image->setDescription($get_params['img_desc']);
}
if (isset($get_params['img_os'])) {
$image->setOs($get_params['img_os']);
}
if (isset($get_params['img_dist'])) {
$image->setDistribution($get_params['img_dist']);
}
if (isset($get_params['img_vers'])) {
$image->setVersion($get_params['img_vers']);
}
if (isset($get_params['img_kernel'])) {
$image->setKernel($get_params['img_kernel']);
}
if (isset($get_params['img_arch'])) {
$image->setArchitecture($get_params['img_arch']);
}
if (isset($get_params['img_other'])) {
$image->setOtherFw($get_params['img_other']);
}
if (isset($get_params['img_bin'])) {
$image->setBinaryLink($get_params['img_bin']);
}
if (isset($get_params['img_src'])) {
$image->setSourceLink($get_params['img_src']);
}
// Save new image
$image->save($conn);
$imageId = $image->getId();
}
} else {
$imageId = $result["image_id"];
}
// If configuration exists, retrieve id, else, create new entry and retrieve id
$query = "SELECT c.id AS configuration_id\n\t\t\t\t\tFROM " . $qa_generic . ".configuration c\n\t\t\t\t\tWHERE c.project_to_product_id = " . $project_to_product_id . "\n\t\t\t\t\t\tAND c.test_environment_id = " . $environmentId . "\n\t\t\t\t\t\tAND c.image_id = " . $imageId;
$result = Doctrine_Manager::getInstance()->getCurrentConnection()->execute($query)->fetch(PDO::FETCH_ASSOC);
if (empty($result["configuration_id"])) {
$configuration = new Configuration();
$configuration->setProjectToProductId($project_to_product_id);
$configuration->setTestEnvironmentId($environmentId);
$configuration->setImageId($imageId);
$configuration->save($conn);
$configurationId = $configuration->getId();
} else {
$configurationId = $result["configuration_id"];
}
$date_now = date("Y-m-d H:i:s");
$date_now_wo_sec = date("Y-m-d H:i");
$testSession = new TestSession();
$testSession->setName($get_params['target'] . " " . $get_params['testtype'] . " " . $get_params['hwproduct'] . " " . $date_now_wo_sec . " " . $get_params['build_id']);
$testSession->setUserId($user_id);
$testSession->setCreatedAt($date_now);
$testSession->setUpdatedAt($date_now);
$testSession->setStatus(2);
$testSession->setPublished(1);
$testSession->setConfigurationId($configurationId);
// Fill in the build_id if it is given
if (!empty($get_params['build_id'])) {
$testSession->setBuildId($get_params['build_id']);
$testSession->setBuildSlug(MiscUtils::slugify($get_params['build_id']));
}
// Fill in the testset if it is given
if (!empty($get_params['testtype'])) {
$testSession->setTestset($get_params['testtype']);
$testSession->setTestsetSlug(MiscUtils::slugify($get_params['testtype']));
}
if (isset($get_params['report_title'])) {
$testSession->setName($get_params['report_title']);
}
if (isset($get_params['objective_txt'])) {
$testSession->setTestObjective($get_params['objective_txt']);
}
if (isset($get_params['environment_txt'])) {
$testSession->setNotes($get_params['environment_txt']);
}
if (isset($get_params['qa_summary_txt'])) {
$testSession->setQaSummary($get_params['qa_summary_txt']);
}
if (isset($get_params['issue_summary_txt'])) {
$testSession->setIssueSummary($get_params['issue_summary_txt']);
}
if (isset($get_params['status'])) {
$testSession->setStatus($get_params['status']);
}
$testSession->save($conn);
$testSessionId = $testSession->getId();
// Retrieve table_name_test_session_id from table_name
$query = "SELECT tn.id AS table_name_id\n\t\t\t\t\tFROM " . $qa_generic . ".table_name tn\n\t\t\t\t\tWHERE tn.name = 'test_session'";
$result = Doctrine_Manager::getInstance()->getCurrentConnection()->execute($query)->fetch(PDO::FETCH_ASSOC);
$tableNameTestSessionId = $result["table_name_id"];
// Concatenate directory path
$dir_path = sfConfig::get('sf_upload_dir') . "/testsession_" . $testSessionId;
// Get all files sent
$files = $request->getFiles();
// Check if there is any report file to import
if (empty($files)) {
$conn->rollback();
$conn->setAttribute(Doctrine_Core::ATTR_AUTOCOMMIT, TRUE);
echo "{\"ok\":\"0\",\"errors\":\"Missing report file\"}\n";
exit;
}
// Import each report file and register attachment files
$report_file_found = false;
foreach ($files as $key => $file) {
$reportType = false;
$fileName = $file['name'];
$fileSize = $file['size'];
$fileType = $file['type'];
$fileError = $file['error'];
$fileChecksum = sha1_file($file["tmp_name"]);
// Check file error and file size
if (!$fileError and $fileSize <= sfConfig::get('app_max_file_size', '10000000')) {
if (!is_dir($dir_path)) {
mkdir($dir_path, 0777, true);
}
$dest_path = $dir_path . "/" . $fileName;
// Move file to uploads directory
move_uploaded_file($file['tmp_name'], $dest_path);
$web_path = "/uploads" . "/testsession_" . $testSessionId . "/" . $fileName;
$fileAttachment = new FileAttachment();
$fileAttachment->setName($fileName);
$fileAttachment->setUserId($user_id);
$fileAttachment->setUploadedAt(date("Y-m-d H:i:s"));
$fileAttachment->setFilename($fileName);
$fileAttachment->setFileSize($fileSize);
$fileAttachment->setFileMimeType($fileType);
$fileAttachment->setLink($web_path);
$fileAttachment->setChecksum($fileChecksum);
$fileAttachment->setTableNameId($tableNameTestSessionId);
$fileAttachment->setTableEntryId($testSessionId);
if ((preg_match("#\\.xml\$#i", $fileName) | preg_match("#\\.csv\$#i", $fileName)) & !preg_match("#attachment.?[0-9]*#i", $key)) {
$report_file_found = true;
$reportType = true;
$fileAttachment->setCategory(1);
} else {
if (preg_match("#attachment.?[0-9]*#i", $key)) {
$fileAttachment->setCategory(2);
} else {
$conn->rollback();
$conn->setAttribute(Doctrine_Core::ATTR_AUTOCOMMIT, TRUE);
echo "{\"ok\":\"0\",\"errors\":\"Only upload files with the extension .xml or .csv\"}\n";
exit;
}
}
$fileAttachment->save($conn);
// If it is an XML or CSV file, parse it and fill qa_generic database
if ($reportType) {
if ($err_code = Import::file($dest_path, $testSessionId, $configurationId, $conn)) {
$error_message = Import::getImportErrorMessage($err_code);
MiscUtils::deleteDir($dir_path);
$conn->rollback();
$conn->setAttribute(Doctrine_Core::ATTR_AUTOCOMMIT, TRUE);
echo "{\"ok\":\"0\",\"errors\":\"File " . $fileName . " is not valid = " . $error_message . "\"}\n";
exit;
}
}
} else {
MiscUtils::deleteDir($dir_path);
$conn->rollback();
$conn->setAttribute(Doctrine_Core::ATTR_AUTOCOMMIT, TRUE);
echo "{\"ok\":\"0\",\"errors\":\"File " . $fileName . " exceed maximum size\"}\n";
exit;
}
}
// If only attachment files have been found, cancel the new test session
if (!$report_file_found) {
$conn->rollback();
$conn->setAttribute(Doctrine_Core::ATTR_AUTOCOMMIT, TRUE);
echo "{\"ok\":\"0\",\"errors\":\"Missing report file\"}\n";
exit;
}
$conn->commit();
$conn->setAttribute(Doctrine_Core::ATTR_AUTOCOMMIT, TRUE);
// Retrieve project name_slug, product name_slug, test environment name_slug and image name_slug
$query = "SELECT i.name_slug image_name_slug, te.name_slug test_environment_name_slug, p.name_slug project_name_slug, pt.name_slug product_name_slug\n\t\t\t\t\tFROM " . $qa_generic . ".test_session ts\n\t\t\t\t\tJOIN " . $qa_generic . ".configuration c ON c.id = ts.configuration_id\n\t\t\t\t\tJOIN " . $qa_generic . ".image i ON i.id = c.image_id\n\t\t\t\t\tJOIN " . $qa_generic . ".test_environment te ON te.id = c.test_environment_id\n\t\t\t\t\tJOIN " . $qa_generic . ".project_to_product ptp ON ptp.id = c.project_to_product_id\n\t\t\t\t\tJOIN " . $qa_generic . ".project p ON p.id = ptp.project_id\n\t\t\t\t\tJOIN " . $qa_core . ".product_type pt ON pt.id = ptp.product_id\n\t\t\t\t\tWHERE ts.id = " . $testSessionId;
$configInfo = Doctrine_Manager::getInstance()->getCurrentConnection()->execute($query)->fetch(PDO::FETCH_ASSOC);
$projectNameSlug = $configInfo['project_name_slug'];
$productNameSlug = $configInfo['product_name_slug'];
$testEnvironmentNameSlug = $configInfo['test_environment_name_slug'];
$imageNameSlug = $configInfo['image_name_slug'];
// Return datas to CATS
$url_to_return = $request->getUriPrefix() . $this->generateUrl("test_session", array('project' => $projectNameSlug, 'product' => $productNameSlug, 'environment' => $testEnvironmentNameSlug, 'image' => $imageNameSlug, 'id' => $testSessionId));
echo "{\"ok\":\"1\",\"url\":\"" . $url_to_return . "\"}\n";
// Return is done (with echo) so make sure nothing else will be sent
exit;
}