コード例 #1
0
ファイル: CustomExportTest.php プロジェクト: noikiy/owaspbwa
 /**
  * Test case for save() method for existing custom export definition
  */
 public function testSaveUpdate()
 {
     $countBefore = $this->_count();
     // save with duplicate name should throw exception
     $export = new CustomExport();
     // we set id = 2, so save should update the record with id=2
     $export->setId(2);
     $export->setName("Export 1");
     $export->setAssignedFields(array("empId", "street1", "gender"));
     try {
         $export->save();
         $this->fail("Exception should be thrown on duplicate name");
     } catch (CustomExportException $e) {
         $this->assertEquals(CustomExportException::DUPLICATE_EXPORT_NAME, $e->getCode());
     }
     // save with empty fields should throw exception
     $export->setName("New Export 1");
     $export->setAssignedFields(array());
     try {
         $export->save();
         $this->fail("Exception should be thrown on empty assigned fields");
     } catch (CustomExportException $e) {
         $this->assertEquals(CustomExportException::NO_ASSIGNED_FIELDS, $e->getCode());
     }
     $export->setName("New Export 1");
     $export->setAssignedFields(null);
     try {
         $export->save();
         $this->fail("Exception should be thrown on empty assigned fields");
     } catch (CustomExportException $e) {
         $this->assertEquals(CustomExportException::NO_ASSIGNED_FIELDS, $e->getCode());
     }
     // save with field not in field list should throw exception
     $export->setName("New Export 1");
     $export->setAssignedFields(array("firstName", "lastName", "EmployeeId"));
     try {
         $export->save();
         $this->fail("Exception should be thrown on invalid field");
     } catch (CustomExportException $e) {
         $this->assertEquals(CustomExportException::INVALID_FIELD_NAME, $e->getCode());
     }
     // save with field count != header count should throw exception
     $export->setName("New Export 1");
     $export->setAssignedFields(array("empId", "street1", "gender"));
     $export->setHeadings(array("Employee Id", "Street 1", "Street 2", "Gender"));
     try {
         $export->save();
         $this->fail("Exception should be thrown on header count mismatch");
     } catch (CustomExportException $e) {
         $this->assertEquals(CustomExportException::HEADER_COUNT_DOESNT_MATCH_FIELD_COUNT, $e->getCode());
     }
     // save with header containing comma should throw exception
     $export->setName("New Export 1");
     $export->setAssignedFields(array("empId", "street1", "gender"));
     $export->setHeadings(array("Employee Id", "Street 1", "Street, 2"));
     try {
         $export->save();
         $this->fail("Exception should be thrown on invalid header name");
     } catch (CustomExportException $e) {
         $this->assertEquals(CustomExportException::INVALID_HEADER_NAME, $e->getCode());
     }
     // valid save, verify data saved
     $export->setName("New Export 1");
     $export->setAssignedFields(array("empId", "street1", "gender"));
     $export->setHeadings(array("Employee Id", "Street 1", "Gender"));
     $export->save();
     $id = $export->getId();
     // verify id not changed
     $this->assertTrue(!empty($id));
     $this->assertEquals(2, $id);
     // verify saved
     $name = $export->getName();
     $fields = implode(",", $export->getAssignedFields());
     $header = implode(",", $export->getHeadings());
     $countAfter = $this->_count();
     $this->assertEquals($countAfter, $countBefore);
     $count = $this->_count("export_id={$id} AND name='{$name}' AND fields='{$fields}' AND headings='{$header}'");
     $this->assertEquals(1, $count, "Not Updated");
     // Save without changing anything
     $export->save();
     $id = $export->getId();
     // verify id not changed
     $this->assertTrue(!empty($id));
     $this->assertEquals(2, $id);
     $countAfter = $this->_count();
     $this->assertEquals($countAfter, $countBefore);
     $count = $this->_count("export_id={$id} AND name='{$name}' AND fields='{$fields}' AND headings='{$header}'");
     $this->assertEquals(1, $count, "Not Updated");
 }