public function run() { $config = new Configuration(); $config->name = 'beer_of_the_day_modification_date'; $config->value = Carbon::now()->format('Y-m-d'); $config->save(); }
public function add($key, $value, $ns = 'conf') { $config = new Configuration(); $config->setKey($ns . ':' . $key); $config->setValue($value); $config->save(); $this->confTab[$ns][$key] = $value; unset($_SESSION['configuration']); }
/** * @static * @param $name * @param $value * @return void */ public static function set($name, $value = null) { $configuration = ConfigurationPeer::retrieveByName($name); if (!$configuration) { $configuration = new Configuration(); $configuration->setName($name); } $configuration->setValue($value); $configuration->save(); }
/** * Creates a new model. * If creation is successful, the browser will be redirected to the 'view' page. */ public function actionCreate() { $model = new Configuration(); // Uncomment the following line if AJAX validation is needed // $this->performAjaxValidation($model); if (isset($_POST['Configuration'])) { $model->attributes = $_POST['Configuration']; if ($model->save()) { $this->redirect(array('view', 'id' => $model->_id)); } } $this->render('create', array('model' => $model)); }
/** * Store a newly created resource in storage. * * @return Response */ public function store() { $data = Input::all(); // validate the info, create rules for the inputs $rules = array('name' => 'required', 'value' => 'required'); // run the validation rules on the inputs from the form $validator = Validator::make($data, $rules); // if the validator fails, redirect back to the form if ($validator->fails()) { return Redirect::back()->withErrors($validator)->withInput(Input::except('password')); // send back the input (not the password) so that we can repopulate the form } else { $config = new Configuration(); $config->name = $data['name']; $config->value = $data['value']; $config->save(); return Redirect::back()->with('message', 'New configuration parameter added succesfully !'); } }
public function beerOfTheDay() { $dateInDatabase = Configuration::where('name', '=', 'beer_of_the_day_modification_date')->first(); $date = Carbon::createFromFormat("Y-m-d", "{$dateInDatabase->value}"); $now = Carbon::now(); $difference = $now->diffInDays($date); if ($difference >= 1) { $dateInDatabase->value = $now->format('Y-m-d'); $dateInDatabase->save(); $beer = $this->generateRandomBeer(); $selectedBeer = new Configuration(); $selectedBeer->name = "beer_id"; $selectedBeer->value = $beer->beer_id; $selectedBeer->save(); } else { $beer = Beer::find(Configuration::where('name', '=', 'beer_id')->orderBy('id', 'desc')->first()->value); } return View::make('beers.beer-of-the-day')->with(['beer' => $beer]); }
public function save() { if ($this->perm->can_create == 'y') { $data = new Configuration(); $data->public_status = @$_POST['public_status'] == '' ? 'n' : $_POST['public_status']; $data->internal_status = @$_POST['internal_status'] == '' ? 'n' : $_POST['internal_status']; if ($_POST['id'] == '') { $_POST['created_by'] = $this->current_user->id; $_POST['created'] = date("Y-m-d H:i:s"); } else { $_POST['updated_by'] = $this->current_user->id; $_POST['updated'] = date("Y-m-d H:i:s"); } $data->from_array($_POST); $data->save(); save_logs($this->menu_id, 'Update', $this->session->userdata("id"), ' Update Configurations '); } redirect($_SERVER['HTTP_REFERER']); }
protected function processCreate(sfWebRequest $request, ConfigurationForm $form) { $form->bind($request->getParameter($form->getName())); if ($form->isValid()) { // Get POST values $values = $form->getValues(); // Create new entry into Project table $configurationObject = new Configuration(); $configurationObject->setImageId($values['image_id']); $configurationObject->setTestEnvironmentId($values['test_environment_id']); $configurationObject->setProjectToProductId($values['project_to_product_id']); $configurationObject->save(); if ($request->hasParameter('_save_and_add')) { $this->getUser()->setFlash('notice', $notice . ' You can add another one below.'); $this->redirect('@configuration_new'); } else { $this->getUser()->setFlash('notice', $notice); $this->redirect(array('sf_route' => 'configuration_edit', 'sf_subject' => $configurationObject)); } } else { $this->getUser()->setFlash('error', 'The item has not been saved due to some errors.', false); } }
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; }
/** * Process the form to edit an existing test session. * * @param sfWebRequest $request * @param SessionForm $form */ protected function processEdit(sfWebRequest $request, SessionForm $form) { $form->bind($request->getParameter($form->getName()), $request->getFiles($form->getName())); if ($form->isValid()) { $qa_generic = sfConfig::get("app_table_qa_generic"); // Get sent values and uploaded files $values = $form->getValues(); $files = $request->getFiles(); // Retrieve values from form $projectGroupId = $values["project_group_id"]; $projectId = $values["project"]; $productId = $values["product"]; // Get test environment and image names $environmentForm = $form->getValue("environmentForm"); $imageForm = $form->getValue("imageForm"); // Create a new relationship between project group, project and product if needed $projectToProductId = Doctrine_Core::getTable("ProjectToProduct")->getProjectToProductId($projectGroupId, $projectId, $productId); if ($projectToProductId == null) { $projectToProduct = new ProjectToProduct(); $projectToProduct->setProjectGroupId($projectGroupId); $projectToProduct->setProjectId($projectId); $projectToProduct->setProductId($productId); $projectToProduct->save($conn); $projectToProductId = $projectToProduct->getId(); } // Create a new environment if needed $environment = Doctrine_Core::getTable("TestEnvironment")->findByArray($environmentForm); if ($environment == null) { // Add new environment $environment = new TestEnvironment(); $environment->setName($environmentForm["name"]); $environment->setDescription($environmentForm["description"]); $environment->setCpu($environmentForm["cpu"]); $environment->setBoard($environmentForm["board"]); $environment->setGpu($environmentForm["gpu"]); $environment->setOtherHardware($environmentForm["other_hardware"]); // Check if its slug does not already exist and generate a new one if needed $slug = MiscUtils::slugify($environmentForm["name"]); $size = 1; while (Doctrine_Core::getTable("TestEnvironment")->checkSlug($slug)) { $slug = MiscUtils::slugify($environmentForm["name"]) . substr(microtime(), -$size); $size++; } $environment->setNameSlug($slug); $environment->save($conn); // Convert object into associative array $environment = $environment->toArray(); } // Create a new image if needed $image = Doctrine_Core::getTable("Image")->findByArray($imageForm); if ($image == null) { // Add new image $image = new Image(); $image->setName($imageForm["name"]); $image->setDescription($imageForm["description"]); $image->setOs($imageForm["os"]); $image->setDistribution($imageForm["distribution"]); $image->setVersion($imageForm["version"]); $image->setKernel($imageForm["kernel"]); $image->setArchitecture($imageForm["architecture"]); $image->setOtherFw($imageForm["other_fw"]); $image->setBinaryLink($imageForm["binary_link"]); $image->setSourceLink($imageForm["source_link"]); // Check if its slug does not already exist and generate a new one if needed $slug = MiscUtils::slugify($imageForm["name"]); $size = 1; while (Doctrine_Core::getTable("Image")->checkSlug($slug)) { $slug = MiscUtils::slugify($imageForm["name"]) . substr(microtime(), -$size); $size++; } $image->setNameSlug(MiscUtils::slugify($slug)); $image->save($conn); // Convert object into associative array $image = $image->toArray(); } // Create a new configuration relationship if needed $configurationId = Doctrine_Core::getTable("Configuration")->getConfigurationId($projectToProductId, $environment["id"], $image["id"]); if ($configurationId == null) { $configuration = new Configuration(); $configuration->setProjectToProductId($projectToProductId); $configuration->setTestEnvironmentId($environment["id"]); $configuration->setImageId($image["id"]); $configuration->save($conn); $configurationId = $configuration->getId(); } // Edit the session into DB $testSession = Doctrine_Core::getTable("TestSession")->find($values["id"]); $testSession->setId($values["id"]); $testSession->setBuildId($values["build_id"]); $testSession->setTestset($values["testset"]); $testSession->setName($values["name"]); $testSession->setTestObjective($values["test_objective"]); $testSession->setQaSummary($values["qa_summary"]); $testSession->setUserId($values["user_id"]); $testSession->setCreatedAt($values["created_at"]); $testSession->setEditorId($values["editor_id"]); $testSession->setUpdatedAt($values["updated_at"]); $testSession->setProjectRelease($values["project_release"]); $testSession->setProjectMilestone($values["project_milestone"]); $testSession->setIssueSummary($values["issue_summary"]); $testSession->setStatus($values["status"]); $testSession->setPublished($values["published"]); $testSession->setConfigurationId(intval($configurationId)); $testSession->setCampaignChecksum($values["campaign_checksum"]); $testSession->setBuildSlug(MiscUtils::slugify($values["build_id"])); $testSession->setTestsetSlug(MiscUtils::slugify($values["testset"])); $testSession->setNotes($values["notes"]); $testSession->save(); $testSessionId = $values["id"]; // Get all results (and add associative key for each result) $array = array(); foreach (Doctrine_Core::getTable("TestSession")->getSessionResults($this->currentSession["id"]) as $key => $value) { $array[MiscUtils::slugify($value["label"]) . $value["id"]] = $value; } $results = $array; // Get all measures (and add associative key for each measure) $array = array(); foreach (Doctrine_Core::getTable("TestSession")->getSessionMeasures($this->currentSession["id"]) as $key => $value) { $array[MiscUtils::slugify($value["label"]) . $value["id"]] = $value; } $measures = $array; // Save test results foreach ($results as $key => $result) { if (array_key_exists($key, $values)) { $resultForm = Doctrine_Core::getTable("TestResult")->find($result["id"]); $resultForm->setId($result["id"]); $resultForm->setDecisionCriteriaId($values[$key]["decision_criteria_id"]); $resultForm->setComment($values[$key]["comment"]); $resultForm->save(); } } // Save measures foreach ($measures as $key => $measure) { if (array_key_exists($key, $values)) { $resultForm = Doctrine_Core::getTable("TestResult")->find($measure["id"]); $resultForm->setId($measure["id"]); $resultForm->setDecisionCriteriaId($values[$key]["decision_criteria_id"]); $resultForm->setComment($values[$key]["comment"]); $resultForm->save(); } } // Get project and product name slug $projectSlug = Doctrine_Core::getTable("Project")->getSlugById($projectId); $productSlug = Doctrine_Core::getTable("ProductType")->getSlugById($productId); // Retrieve table_name_test_session_id from table_name $tableName = Doctrine_Core::getTable("TableName")->findOneByName("test_session"); $tableNameTestSessionId = $tableName->getId(); // Import attachments and result files foreach ($files["attachments"] as $key => $file) { if ($file["error"] != UPLOAD_ERR_NO_FILE) { $fileName = $file['name']; $fileSize = $file['size']; $fileType = $file['type']; $fileError = $file['error']; $fileChecksum = sha1_file($file["tmp_name"]); // Check file error and file size (5Mo max) if (!$fileError and $fileSize <= 5000000) { // Concatenate destination path $dest_path = sfConfig::get('sf_upload_dir') . "/testsession_" . $testSessionId; if (!is_dir($dest_path)) { mkdir($dest_path, 0777, true); } $dest_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($this->getUser()->getGuardUser()->getId()); $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); $fileAttachment->setCategory(2); $fileAttachment->save(); } } } // Customize database connection to begin a transactionnal query $conn = Doctrine_Manager::getInstance()->getConnection("qa_generic"); $conn->setAttribute(Doctrine_Core::ATTR_AUTOCOMMIT, FALSE); $conn->beginTransaction(); // Get file attachments id into an array $fileAttachmentIdList = array(); $query = "SELECT fa.id\n\t\t\t\t\tFROM " . $qa_generic . ".file_attachment fa\n\t\t\t\t\tWHERE fa.table_entry_id = " . $testSessionId . "\n\t\t\t\t\t\tAND fa.table_name_id = " . $tableNameTestSessionId; $results = Doctrine_Manager::getInstance()->getCurrentConnection()->execute($query)->fetchAll(PDO::FETCH_ASSOC); foreach ($results as $result) { $fileAttachmentIdList[] = $result["id"]; } $fileAttachmentIdStringList = implode(",", $fileAttachmentIdList); // Concatenate directory path $dir_path = sfConfig::get('sf_upload_dir') . "/testsession_" . $testSessionId; $fileAttachmentResultIds = array(); $similarFileFound = false; foreach ($files["result_files"] as $key => $file) { if ($file["error"] != UPLOAD_ERR_NO_FILE) { $reportType = false; $fileName = $file['name']; $fileSize = $file['size']; $fileType = $file['type']; $fileError = $file['error']; $fileChecksum = sha1_file($file["tmp_name"]); $query = "SELECT fa.id\n\t\t\t\t\t\t\tFROM " . $qa_generic . ".file_attachment fa\n\t\t\t\t\t\t\tWHERE fa.table_entry_id = " . $testSessionId . "\n\t\t\t\t\t\t\t\tAND fa.table_name_id = " . $tableNameTestSessionId . "\n\t\t\t\t\t\t\t\tAND fa.checksum = '" . $fileChecksum . "'"; $result = Doctrine_Manager::getInstance()->getCurrentConnection()->execute($query)->fetch(PDO::FETCH_ASSOC); if (!empty($result["id"])) { $fileAttachmentResultIds[] = $result["id"]; $similarFileFound = true; } // 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; $idx = 0; while (is_file($dest_path)) { $idx++; $dest_path = $dir_path . "/" . "(" . $idx . ")" . $fileName; } // Move file to uploads directory move_uploaded_file($file['tmp_name'], $dest_path); if ($idx == 0) { $web_path = "/uploads" . "/testsession_" . $testSessionId . "/" . $fileName; } else { $web_path = "/uploads" . "/testsession_" . $testSessionId . "/" . "(" . $idx . ")" . $fileName; } $fileAttachment = new FileAttachment(); $fileAttachment->setName($fileName); $fileAttachment->setUserId($this->getUser()->getGuardUser()->getId()); $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)) { $reportType = true; $fileAttachment->setCategory(1); } else { $fileAttachment->setCategory(2); } $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, true)) { // Delete new files $query = "SELECT fa.link\n\t\t\t\t\t\t\t\t\t\tFROM " . $qa_generic . ".file_attachment fa\n\t\t\t\t\t\t\t\t\t\tWHERE fa.table_entry_id = " . $testSessionId . "\n\t\t\t\t\t\t\t\t\t\t\tAND fa.table_name_id = " . $tableNameTestSessionId . "\n\t\t\t\t\t\t\t\t\t\t\tAND fa.id NOT IN (" . $fileAttachmentIdStringList . ")"; $results = Doctrine_Manager::getInstance()->getCurrentConnection()->execute($query)->fetchAll(PDO::FETCH_ASSOC); foreach ($results as $result) { unlink(sfConfig::get('sf_web_dir') . $result["link"]); } $error_message = Import::getImportErrorMessage($err_code); $conn->rollback(); $conn->setAttribute(Doctrine_Core::ATTR_AUTOCOMMIT, TRUE); $this->getUser()->setFlash("error", "Invalid file content on " . $fileName . " : " . $error_message); $this->redirect("edit_report", array("project" => $projectSlug, "product" => $productSlug, "environment" => $environment["name_slug"], "image" => $image["name_slug"], "id" => $testSessionId)); } } } else { // Delete new files $query = "SELECT fa.link\n\t\t\t\t\t\t\t\tFROM " . $qa_generic . ".file_attachment fa\n\t\t\t\t\t\t\t\tWHERE fa.table_entry_id = " . $testSessionId . "\n\t\t\t\t\t\t\t\t\tAND fa.table_name_id = " . $tableNameTestSessionId . "\n\t\t\t\t\t\t\t\t\tAND fa.id NOT IN (" . $fileAttachmentIdStringList . ")"; $results = Doctrine_Manager::getInstance()->getCurrentConnection()->execute($query)->fetchAll(PDO::FETCH_ASSOC); foreach ($results as $result) { unlink(sfConfig::get('sf_web_dir') . $result["link"]); } $conn->rollback(); $conn->setAttribute(Doctrine_Core::ATTR_AUTOCOMMIT, TRUE); $this->getUser()->setFlash("error", "File size limit reached"); $this->redirect("edit_report", array("project" => $projectSlug, "product" => $productSlug, "environment" => $environment["name_slug"], "image" => $image["name_slug"], "id" => $testSessionId)); } } } if ($similarFileFound) { $fileAttachmentStringResultIds = implode(",", $fileAttachmentResultIds); // Delete similar files and attachment entries $query = "SELECT fa.id, fa.link\n\t\t\t\t\t\tFROM " . $qa_generic . ".file_attachment fa\n\t\t\t\t\t\tWHERE fa.table_entry_id = " . $testSessionId . "\n\t\t\t\t\t\t\tAND fa.table_name_id = " . $tableNameTestSessionId . "\n\t\t\t\t\t\t\tAND fa.id IN (" . $fileAttachmentStringResultIds . ")"; $results = Doctrine_Manager::getInstance()->getCurrentConnection()->execute($query)->fetchAll(PDO::FETCH_ASSOC); foreach ($results as $result) { unlink(sfConfig::get('sf_web_dir') . $result["link"]); Doctrine_Core::getTable("FileAttachment")->deleteFileAttachmentById($result["id"], $conn); } } $conn->commit(); $conn->setAttribute(Doctrine_Core::ATTR_AUTOCOMMIT, TRUE); // // Clear cache for actions related to this test session // $cacheManager = $this->getContext()->getViewCacheManager(); // $cacheManager->remove("reports/session?project=".$projectSlug."&product=".$productSlug."&environment=".$environment["name_slug"]."&image=".$image["name_slug"]."?id=".$testSession["id"]); // Set flash for user and redirect to session display $this->getUser()->setFlash("notice", "Test session was updated successfully"); if (!empty($testSession["build_slug"])) { $this->redirect("build_session", array("project" => $projectSlug, "product" => $productSlug, "build" => $testSession["build_slug"], "environment" => $environment["name_slug"], "image" => $image["name_slug"], "id" => $request->getParameter("id"))); } else { $this->redirect("test_session", array("project" => $projectSlug, "product" => $productSlug, "environment" => $environment["name_slug"], "image" => $image["name_slug"], "id" => $request->getParameter("id"))); } } }
/** * Retrieves the encryption key from cache, or generations a new one in the instance one does not exists * @return string */ public static function getEncryptionKey() { $key = self::getConfig('encryptionKey', NULL, 'settings_', true); if ($key == NULL || $key == "") { try { $key = Crypto::CreateNewRandomKey(); } catch (CryptoTestFailedException $ex) { throw new CException('Encryption key generation failed'); } catch (CannotPerformOperationException $ex) { throw new CException('Encryption key generation failed'); } $config = new Configuration(); $config->attributes = array('key' => 'encryptionkey', 'value' => bin2hex($key)); if (!$config->save()) { throw new CException('Encryption key generation failed'); } } return hex2bin(self::getConfig('encryptionKey', NULL, 'settings_', true)); }
/** * This is a temporary way to add and install new cards via Github. * * Once CiiMS.org is setup, this functionality will be deprecated in favor of a download from CiiMS.org * @return boolean If the download, extraction, and install was successful */ public function actionAddCard() { // Only proceed on POST if (Cii::get($_POST, 'Card') !== NULL) { $repository = Cii::get($_POST['Card'], 'new'); if ($repository == NULL) { return false; } $repoInfo = explode('/', $repository); // Download the Card information from Github via cURL $curl = curl_init(); curl_setopt_array($curl, array(CURLOPT_RETURNTRANSFER => 1, CURLOPT_URL => 'https://raw.github.com/' . $repository . '/master/card.json')); $json = CJSON::decode(curl_exec($curl)); // If we have an invalid repo - abort if ($json == NULL) { throw new CHttpException(400, Yii::t('Dashboard.main', 'Unable to find valid card at that location.')); } $config = new Configuration(); $uuid = $config->generateUniqueId(); $config->key = 'dashboard_card_' . $uuid; $config->value = CJSON::encode(array('name' => Cii::get(Cii::get($json, 'name'), 'displayName'), 'class' => Cii::get(Cii::get($json, 'name'), 'name'), 'path' => 'application.runtime.cards.' . $uuid . '.' . $repoInfo[1] . '-master', 'folderName' => $uuid)); // Determine the runtime directory $runtimeDirectory = Yii::getPathOfAlias('application.runtime'); $downloadPath = $runtimeDirectory . DIRECTORY_SEPARATOR . 'cards' . DIRECTORY_SEPARATOR . $uuid . '.zip'; if (!is_writable($runtimeDirectory)) { throw new CHttpException(500, Yii::t('Dashboard.main', 'Runtime directory is not writable')); } $targetFile = fopen($downloadPath, 'w'); // Initiate the CURL request $ch = curl_init('https://github.com/' . $repository . '/archive/master.zip'); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true); curl_setopt($ch, CURLOPT_FILE, $targetFile); curl_exec($ch); // Extract the file $zip = new ZipArchive(); $res = $zip->open($downloadPath); // If we can open the file if ($res === true) { // Extract it to the appropriate location $extraction = $zip->extractTo(str_replace('.zip', '', $downloadPath)); // If we can extract it if ($extraction) { // Save the config in the database $config->save(); // Delete the zip file unlink($downloadPath); // Flush the cache Yii::app()->cache->delete('dashboard_cards_available'); Yii::app()->cache->delete('cards_in_category'); header('Content-Type: application/json'); // Output the json so we can display pretty stuff in the main view echo $config->value; // And return true return true; } } } return false; }
function _xls_insert_conf($key, $title, $value, $helperText, $configType, $options, $sortOrder = NULL, $templateSpecific = 0) { $conf = Configuration::LoadByKey($key); if (!$conf) { $conf = new Configuration(); } $conf->key_name = $key; $conf->title = $title; $conf->key_value = $value; $conf->helper_text = $helperText; $conf->configuration_type_id = $configType; $conf->options = $options; $query = <<<EOS \t\tSELECT IFNULL(MAX(sortOrder),0)+1 \t\tFROM xlsws_configuration \t\tWHERE configuration_type_id = '{$configType}'; EOS; if (!$sortOrder) { $sortOrder = Configuration::model()->findBySql($query); } $conf->sort_order = $sortOrder; $conf->template_specific = $templateSpecific; $conf->created = new CDbExpression('NOW()'); $conf->modified = new CDbExpression('NOW()'); if (!$conf->save()) { print_r($conf->getErrors()); } }