/**
* @depends testGetDataWithAllHasOneOrOwnedRelationsSet
*/
public function testGetDataWithHasOneRelatedModel()
{
$super = User::getByUsername('super');
Yii::app()->user->userModel = $super;
$currencies = Currency::getAll();
$currencyValue = new CurrencyValue();
$currencyValue->value = 100;
$currencyValue->currency = $currencies[0];
$this->assertEquals('USD', $currencyValue->currency->code);
$testItem2 = new ExportTestModelItem2();
$testItem2->name = 'John';
$this->assertTrue($testItem2->save());
$testItem4 = new ExportTestModelItem4();
$testItem4->name = 'John';
$this->assertTrue($testItem4->save());
//HAS_MANY and MANY_MANY relationships should be ignored.
$testItem3_1 = new ExportTestModelItem3();
$testItem3_1->name = 'Kevin';
$this->assertTrue($testItem3_1->save());
$testItem3_2 = new ExportTestModelItem3();
$testItem3_2->name = 'Jim';
$this->assertTrue($testItem3_2->save());
$testItem = new ExportTestModelItem();
$testItem->firstName = 'Bob3';
$testItem->lastName = 'Bob3';
$testItem->boolean = true;
$testItem->date = '2002-04-03';
$testItem->dateTime = '2002-04-03 02:00:43';
$testItem->float = 54.22;
$testItem->integer = 10;
$testItem->phone = '21313213';
$testItem->string = 'aString';
$testItem->textArea = 'Some Text Area';
$testItem->url = 'http://www.asite.com';
$testItem->email = '*****@*****.**';
$testItem->owner = $super;
$testItem->currencyValue = $currencyValue;
$testItem->hasOne = $testItem2;
$testItem->hasMany->add($testItem3_1);
$testItem->hasMany->add($testItem3_2);
$testItem->hasOneAlso = $testItem4;
$createStamp = strtotime(DateTimeUtil::convertTimestampToDbFormatDateTime(time()));
$this->assertTrue($testItem->save());
$id = $testItem->id;
$testItem->forget();
unset($testItem);
$testItem = ExportTestModelItem::getById($id);
$adapter = new ModelToExportAdapter($testItem);
$data = $adapter->getData();
$headerData = $adapter->getHeaderData();
$compareData = array($id, 'stubDateTime', 'stubDateTime', 'super', 'super', 'super', 'Bob3', 'Bob3', '1', '2002-04-03', '2002-04-03 02:00:43', 54.22, 10, '21313213', 'aString', 'Some Text Area', 'http://www.asite.com', '*****@*****.**', null, 100, 'USD', null, null, null, null, '(None)', '(None)', null, null, null, null, null, null, null, null, null, null, null, null, null);
$compareHeaderData = array($testItem->getAttributeLabel('id'), $testItem->getAttributeLabel('createdDateTime'), $testItem->getAttributeLabel('modifiedDateTime'), $testItem->getAttributeLabel('createdByUser'), $testItem->getAttributeLabel('modifiedByUser'), $testItem->getAttributeLabel('owner'), $testItem->getAttributeLabel('firstName'), $testItem->getAttributeLabel('lastName'), $testItem->getAttributeLabel('boolean'), $testItem->getAttributeLabel('date'), $testItem->getAttributeLabel('dateTime'), $testItem->getAttributeLabel('float'), $testItem->getAttributeLabel('integer'), $testItem->getAttributeLabel('phone'), $testItem->getAttributeLabel('string'), $testItem->getAttributeLabel('textArea'), $testItem->getAttributeLabel('url'), $testItem->getAttributeLabel('email'), $testItem->getAttributeLabel('currency'), $testItem->getAttributeLabel('currencyValue'), $testItem->getAttributeLabel('currencyValue') . ' ' . 'Currency', $testItem->getAttributeLabel('dropDown'), $testItem->getAttributeLabel('radioDropDown'), $testItem->getAttributeLabel('multiDropDown'), $testItem->getAttributeLabel('tagCloud'), $testItem->getAttributeLabel('hasOne') . ' - ' . 'Name', $testItem->getAttributeLabel('hasOneAlso') . ' - ' . 'Name', 'Primary Email - Email Address', 'Primary Email - Is Invalid', 'Primary Email - Opt Out', 'Primary Address - City', 'Primary Address - Country', 'Primary Address - Postal Code', 'Primary Address - Street 1', 'Primary Address - Street 2', 'Primary Address - State', 'Secondary Email - Email Address', 'Secondary Email - Is Invalid', 'Secondary Email - Opt Out', $testItem->getAttributeLabel('user'));
// Because small delay in IO operation, allow tresholds
$createdDateTimeKey = array_search($testItem->getAttributeLabel('createdDateTime'), $headerData);
$modifiedDateTimeKey = array_search($testItem->getAttributeLabel('modifiedDateTime'), $headerData);
$this->assertEquals($createStamp, strtotime($data[$createdDateTimeKey]), '', 2);
$this->assertEquals($createStamp, strtotime($data[$modifiedDateTimeKey]), '', 2);
$data[$createdDateTimeKey] = 'stubDateTime';
$data[$modifiedDateTimeKey] = 'stubDateTime';
$this->assertEquals($compareData, $data);
$this->assertEquals($compareHeaderData, $headerData);
}
public function testGetDataWithHasOneRelatedModel()
{
$super = User::getByUsername('super');
Yii::app()->user->userModel = $super;
$multiSelectValues = array('Multi 1', 'Multi 2', 'Multi 3');
$customFieldData = CustomFieldData::getByName('ExportTestMultiDropDown');
$customFieldData->serializedData = serialize($multiSelectValues);
$save = $customFieldData->save();
assert('$save');
// Not Coding Standard
$tagCloudValues = array('Cloud 1', 'Cloud 2', 'Cloud 3');
$customFieldData = CustomFieldData::getByName('ExportTestTagCloud');
$customFieldData->serializedData = serialize($tagCloudValues);
$save = $customFieldData->save();
assert('$save');
// Not Coding Standard
$currencies = Currency::getAll();
$currencyValue = new CurrencyValue();
$currencyValue->value = 100;
$currencyValue->currency = $currencies[0];
$this->assertEquals('USD', $currencyValue->currency->code);
$testItem2 = new ExportTestModelItem2();
$testItem2->name = 'John';
$this->assertTrue($testItem2->save());
$testItem4 = new ExportTestModelItem4();
$testItem4->name = 'John';
$this->assertTrue($testItem4->save());
//HAS_MANY and MANY_MANY relationships should be ignored.
$testItem3_1 = new ExportTestModelItem3();
$testItem3_1->name = 'Kevin';
$this->assertTrue($testItem3_1->save());
$testItem3_2 = new ExportTestModelItem3();
$testItem3_2->name = 'Jim';
$this->assertTrue($testItem3_2->save());
$testItem = new ExportTestModelItem();
$testItem->firstName = 'Bob3';
$testItem->lastName = 'Bob3';
$testItem->boolean = true;
$testItem->date = '2002-04-03';
$testItem->dateTime = '2002-04-03 02:00:43';
$testItem->float = 54.22;
$testItem->integer = 10;
$testItem->phone = '21313213';
$testItem->string = 'aString';
$testItem->textArea = 'Some Text Area';
$testItem->url = 'http://www.asite.com';
$testItem->email = '*****@*****.**';
$testItem->owner = $super;
$testItem->currencyValue = $currencyValue;
$testItem->hasOne = $testItem2;
$testItem->hasMany->add($testItem3_1);
$testItem->hasMany->add($testItem3_2);
$testItem->hasOneAlso = $testItem4;
$customFieldValue = new CustomFieldValue();
$customFieldValue->value = 'Multi 1';
$testItem->multiDropDown->values->add($customFieldValue);
$customFieldValue = new CustomFieldValue();
$customFieldValue->value = 'Multi 3';
$testItem->multiDropDown->values->add($customFieldValue);
$customFieldValue = new CustomFieldValue();
$customFieldValue->value = 'Cloud 2';
$testItem->tagCloud->values->add($customFieldValue);
$customFieldValue = new CustomFieldValue();
$customFieldValue->value = 'Cloud 3';
$testItem->tagCloud->values->add($customFieldValue);
$createStamp = DateTimeUtil::convertTimestampToDbFormatDateTime(time());
$this->assertTrue($testItem->save());
$id = $testItem->id;
$testItem->forget();
unset($testItem);
$data = array();
$testItem = ExportTestModelItem::getById($id);
$adapter = new ModelToExportAdapter($testItem);
$data[] = $adapter->getData();
$headerData = $adapter->getHeaderData();
// Export data to csv, and then revert csv back to array, so we compare data
$csvData = ExportItemToCsvFileUtil::export($data, $headerData, '', false);
$revertedData = CsvParser::parseFromString($csvData);
// We are testing ModelToExportAdapter in details in another test
// so in this test we suppose that ModelToExportAdapter::getData
// return correct results
$adapter = new ModelToExportAdapter($testItem);
$compareData = $adapter->getData();
$compareHeaderData = $adapter->getHeaderData();
$this->assertEquals($compareHeaderData, array_keys($revertedData[0]));
$this->assertEquals($compareData, array_values($revertedData[0]));
}
