Account Suspended
Account Suspended
This Account has been suspended.
Contact your hosting provider for more information.
 All Data Structures Functions Variables Pages
ImportMappingUtilTest.php
1 <?php
2  /*********************************************************************************
3  * Zurmo is a customer relationship management program developed by
4  * Zurmo, Inc. Copyright (C) 2017 Zurmo Inc.
5  *
6  * Zurmo is free software; you can redistribute it and/or modify it under
7  * the terms of the GNU Affero General Public License version 3 as published by the
8  * Free Software Foundation with the addition of the following permission added
9  * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
10  * IN WHICH THE COPYRIGHT IS OWNED BY ZURMO, ZURMO DISCLAIMS THE WARRANTY
11  * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
12  *
13  * Zurmo is distributed in the hope that it will be useful, but WITHOUT
14  * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
15  * FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
16  * details.
17  *
18  * You should have received a copy of the GNU Affero General Public License along with
19  * this program; if not, see http://www.gnu.org/licenses or write to the Free
20  * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
21  * 02110-1301 USA.
22  *
23  * You can contact Zurmo, Inc. with a mailing address at 27 North Wacker Drive
24  * Suite 370 Chicago, IL 60606. or at email address contact@zurmo.com.
25  *
26  * The interactive user interfaces in original and modified versions
27  * of this program must display Appropriate Legal Notices, as required under
28  * Section 5 of the GNU Affero General Public License version 3.
29  *
30  * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
31  * these Appropriate Legal Notices must retain the display of the Zurmo
32  * logo and Zurmo copyright notice. If the display of the logo is not reasonably
33  * feasible for technical reasons, the Appropriate Legal Notices must display the words
34  * "Copyright Zurmo Inc. 2017. All rights reserved".
35  ********************************************************************************/
36 
38  {
39  public static function setUpBeforeClass()
40  {
41  parent::setUpBeforeClass();
42  SecurityTestHelper::createSuperAdmin();
43  }
44 
45  public function testMakeMappingDataByTableName()
46  {
47  $testTableName = 'testimporttable';
48  $this->assertTrue(ImportTestHelper::createTempTableByFileNameAndTableName('importTest.csv', $testTableName, true));
49  $mappingData = ImportMappingUtil::makeMappingDataByTableName($testTableName);
50  $compareData = array(
51  'column_0' => array('type' => 'importColumn', 'attributeIndexOrDerivedType' => null, 'mappingRulesData' => null),
52  'column_1' => array('type' => 'importColumn', 'attributeIndexOrDerivedType' => null, 'mappingRulesData' => null),
53  'column_2' => array('type' => 'importColumn', 'attributeIndexOrDerivedType' => null, 'mappingRulesData' => null),
54  );
55  $this->assertEquals($compareData, $mappingData);
56  }
57 
62  {
63  $testTableName = 'testimporttable';
64  $this->assertTrue(ImportTestHelper::createTempTableByFileNameAndTableName('importTest3.csv', $testTableName));
66  }
67 
68  public function testGetMappedAttributeIndicesOrDerivedAttributeTypesByMappingData()
69  {
70  $mappingData = array(
71  'column_0' => array('type' => 'importColumn', 'attributeIndexOrDerivedType' => 'a', 'mappingRulesData' => null),
72  'column_1' => array('type' => 'importColumn', 'attributeIndexOrDerivedType' => 'b', 'mappingRulesData' => null),
73  'column_2' => array('type' => 'importColumn', 'attributeIndexOrDerivedType' => 'c', 'mappingRulesData' => null),
74  );
76  $this->assertEquals(array('a', 'b', 'c'), $data);
77 
78  $mappingData = array(
79  'column_0' => array('type' => 'importColumn', 'attributeIndexOrDerivedType' => null, 'mappingRulesData' => null),
80  );
82  $this->assertNull($data);
83  }
84 
85  public function testMakeExtraColumnNameByColumnCount()
86  {
87  $this->assertEquals('column_5', ImportMappingUtil::makeExtraColumnNameByColumnCount(4));
88  }
89 
90  public function testReIndexExtraColumnNamesByPostData()
91  {
92  $postData = array(
93  'column_0' => array('type' => 'importColumn'),
94  'column_1' => array('type' => 'importColumn'),
95  'column_2' => array('type' => 'importColumn'),
96  'column_5' => array('type' => 'extraColumn'),
97  'column_55' => array('type' => 'extraColumn'),
98  );
99  $reIndexedPostData = ImportMappingUtil::reIndexExtraColumnNamesByPostData($postData);
100  $compareData = array(
101  'column_0' => array('type' => 'importColumn'),
102  'column_1' => array('type' => 'importColumn'),
103  'column_2' => array('type' => 'importColumn'),
104  'column_3' => array('type' => 'extraColumn'),
105  'column_4' => array('type' => 'extraColumn'),
106  );
107  $this->assertEquals($compareData, $reIndexedPostData);
108  }
109 
110  public function testMakeColumnNamesAndAttributeIndexOrDerivedTypeLabels()
111  {
112  Yii::app()->user->userModel = User::getByUsername('super');
113  $mappingData = array(
114  'column_0' => array('type' => 'importColumn', 'attributeIndexOrDerivedType' => 'string', 'mappingRulesData' => null),
115  'column_1' => array('type' => 'importColumn', 'attributeIndexOrDerivedType' => null, 'mappingRulesData' => null),
116  'column_2' => array('type' => 'importColumn', 'attributeIndexOrDerivedType' => 'FullName', 'mappingRulesData' => null),
117  );
118  $data = ImportMappingUtil::makeColumnNamesAndAttributeIndexOrDerivedTypeLabels($mappingData, 'ImportModelTestItem');
119  $compareData = array('column_0' => 'String', 'column_1' => null, 'column_2' => 'Full Name');
120  $this->assertEquals($compareData, $data);
121  }
122  }
123 ?>
static getByUsername($username)
Definition: User.php:49
static reIndexExtraColumnNamesByPostData($postData)
static makeMappingDataByTableName($tableName)
static makeExtraColumnNameByColumnCount($columnCount)
static getMappedAttributeIndicesOrDerivedAttributeTypesByMappingData($mappingData)
static makeColumnNamesAndAttributeIndexOrDerivedTypeLabels($mappingData, $importRulesType)
Generated on Thu Aug 6 2020 07:10:31
Account Suspended
Account Suspended
This Account has been suspended.
Contact your hosting provider for more information.