public function testSaveModelFromPostSuccessfulSave()
{
//Unfreeze since the test model is not part of the standard schema.
$freezeWhenComplete = false;
if (RedBeanDatabase::isFrozen()) {
RedBeanDatabase::unfreeze();
$freezeWhenComplete = true;
}
Yii::app()->user->userModel = User::getByUsername('super');
$savedSuccessfully = false;
$modelToStringValue = null;
$postData = array('member' => 'abc');
$model = new OwnedSecurableTestItem();
$this->assertFalse($model->hasErrors());
$controllerUtil = new ZurmoControllerUtil();
$model = $controllerUtil->saveModelFromPost($postData, $model, $savedSuccessfully, $modelToStringValue);
$this->assertTrue($savedSuccessfully);
$this->assertEquals('abc', $modelToStringValue);
$this->assertFalse($model->hasErrors());
$this->assertTrue($model->id > 0);
//Re-freeze if needed.
if ($freezeWhenComplete) {
RedBeanDatabase::freeze();
}
}
public function setup()
{
parent::setUp();
$freeze = false;
if (RedBeanDatabase::isFrozen()) {
RedBeanDatabase::unfreeze();
$freeze = true;
}
$this->freeze = $freeze;
}
public function setUp()
{
parent::setUp();
Yii::app()->user->userModel = User::getByUsername('super');
$freeze = false;
if (RedBeanDatabase::isFrozen()) {
RedBeanDatabase::unfreeze();
$freeze = true;
}
$this->freeze = $freeze;
}
public function setup()
{
parent::setUp();
Yii::app()->user->userModel = User::getByUsername('super');
DisplayAttributeForReportForm::resetCount();
$freeze = false;
if (RedBeanDatabase::isFrozen()) {
RedBeanDatabase::unfreeze();
$freeze = true;
}
$this->freeze = $freeze;
}
public function setUp()
{
parent::setUp();
if (strlen(Yii::app()->params['testApiUrl']) > 0) {
$this->serverUrl = Yii::app()->params['testApiUrl'];
}
$freeze = false;
if (RedBeanDatabase::isFrozen()) {
RedBeanDatabase::unfreeze();
$freeze = true;
}
$this->freeze = $freeze;
}
public function setup()
{
parent::setUp();
Yii::app()->user->userModel = User::getByUsername('super');
DisplayAttributeForReportForm::resetCount();
ModelRelationsAndAttributesToSummableReportAdapter::forgetAll();
ModelRelationsAndAttributesToRowsAndColumnsReportAdapter::forgetAll();
ModelRelationsAndAttributesToMatrixReportAdapter::forgetAll();
$freeze = false;
if (RedBeanDatabase::isFrozen()) {
RedBeanDatabase::unfreeze();
$freeze = true;
}
$this->freeze = $freeze;
}
public function testSequentialProcessViewFactory()
{
Yii::app()->user->userModel = User::getByUsername('super');
$freezeWhenComplete = false;
//Unfreeze since the test model is not part of the standard schema.
if (RedBeanDatabase::isFrozen()) {
RedBeanDatabase::unfreeze();
$freezeWhenComplete = true;
}
$testModels = ImportModelTestItem::getAll();
$this->assertEquals(0, count($testModels));
$import = new Import();
$mappingData = array('column_0' => array('attributeIndexOrDerivedType' => 'string', 'type' => 'importColumn', 'mappingRulesData' => array('DefaultValueModelAttributeMappingRuleForm' => array('defaultValue' => null))), 'column_23' => array('attributeIndexOrDerivedType' => 'FullName', 'type' => 'importColumn', 'mappingRulesData' => array('FullNameDefaultValueModelAttributeMappingRuleForm' => array('defaultValue' => null))));
$serializedData['importRulesType'] = 'ImportModelTestItem';
$serializedData['mappingData'] = $mappingData;
$serializedData['firstRowIsHeaderRow'] = true;
$import->serializedData = serialize($serializedData);
$this->assertTrue($import->save());
ImportTestHelper::createTempTableByFileNameAndTableName('importAnalyzerTest.csv', $import->getTempTableName());
$config = array('pagination' => array('pageSize' => 2));
$dataProvider = new ImportDataProvider($import->getTempTableName(), true, $config);
$sequentialProcess = new ImportCreateUpdateModelsSequentialProcess($import, $dataProvider);
$sequentialProcess->run(null, null);
$route = 'default/someAction';
$view = SequentialProcessViewFactory::makeBySequentialProcess($sequentialProcess, $route);
$content = $view->render();
$this->assertNotNull($content);
$this->assertEquals('SequentialProcessView', get_class($view));
$this->assertEquals('processRows', $sequentialProcess->getNextStep());
//Now process the first run. Will process page 0.
$sequentialProcess = new ImportCreateUpdateModelsSequentialProcess($import, $dataProvider);
$sequentialProcess->run('processRows', null);
$route = 'default/someAction';
$view = SequentialProcessViewFactory::makeBySequentialProcess($sequentialProcess, $route);
$content = $view->render();
$this->assertNotNull($content);
$this->assertEquals('SequentialProcessView', get_class($view));
$this->assertEquals(array('page' => 1), $sequentialProcess->getNextParams());
//Confirm 2 models were successfully added.
$testModels = ImportModelTestItem::getAll();
$this->assertEquals(2, count($testModels));
//Re-freeze if needed.
if ($freezeWhenComplete) {
RedBeanDatabase::freeze();
}
}
/**
* Given a file resource, convert the file into a database table based on the table name provided.
* Assumes the file is a csv.
* @param resource $fileHandle
* @param string $tableName
* @return true on success.
*/
public static function makeDatabaseTableByFileHandleAndTableName($fileHandle, $tableName, $delimiter = ',', $enclosure = "'")
{
assert('gettype($fileHandle) == "resource"');
assert('is_string($tableName)');
assert('$tableName == strtolower($tableName)');
assert('$delimiter != null && is_string($delimiter)');
assert('$enclosure != null && is_string($enclosure)');
$freezeWhenComplete = false;
if (RedBeanDatabase::isFrozen()) {
RedBeanDatabase::unfreeze();
$freezeWhenComplete = true;
}
R::exec("drop table if exists {$tableName}");
$columns = self::optimizeTableImportColumnsAndGetColumnNames($fileHandle, $tableName, $delimiter, $enclosure);
rewind($fileHandle);
self::convertCsvIntoRowsInTable($fileHandle, $tableName, $delimiter, $enclosure, $columns);
self::optimizeTableNonImportColumns($tableName);
if ($freezeWhenComplete) {
RedBeanDatabase::freeze();
}
return true;
}
/**
* @depends testAutoBuildDatabase
*/
public function testAutoBuildUpgrade()
{
$this->unfreezeWhenDone = false;
if (RedBeanDatabase::isFrozen()) {
RedBeanDatabase::unfreeze();
$this->unfreezeWhenDone = true;
}
// adding Text Field
$metadata = Account::getMetadata();
$metadata['Account']['members'][] = 'newField';
$rules = array('newField', 'type', 'type' => 'string');
$metadata['Account']['rules'][] = $rules;
$metadata['Account']['members'][] = 'string128';
$rules = array('string128', 'type', 'type' => 'string');
$metadata['Account']['rules'][] = $rules;
$rules = array('string128', 'length', 'min' => 3, 'max' => 128);
$metadata['Account']['rules'][] = $rules;
$metadata['Account']['members'][] = 'string555';
$rules = array('string555', 'type', 'type' => 'string');
$metadata['Account']['rules'][] = $rules;
$rules = array('string555', 'length', 'min' => 1, 'max' => 555);
$metadata['Account']['rules'][] = $rules;
$metadata['Account']['members'][] = 'string100000';
$rules = array('string100000', 'type', 'type' => 'string');
$metadata['Account']['rules'][] = $rules;
$rules = array('string100000', 'length', 'min' => 1, 'max' => 100000);
$metadata['Account']['rules'][] = $rules;
$metadata['Account']['members'][] = 'textField';
$rules = array('textField', 'type', 'type' => 'text');
$metadata['Account']['rules'][] = $rules;
$metadata['Account']['members'][] = 'longTextField';
$rules = array('longTextField', 'type', 'type' => 'longtext');
$metadata['Account']['rules'][] = $rules;
$metadata['Account']['members'][] = 'dateField';
$rules = array('dateField', 'type', 'type' => 'date');
$metadata['Account']['rules'][] = $rules;
$metadata['Account']['members'][] = 'booleanField';
$rules = array('booleanField', 'boolean');
$metadata['Account']['rules'][] = $rules;
$metadata['Account']['members'][] = 'integerField';
$rules = array('integerField', 'type', 'type' => 'integer');
$metadata['Account']['rules'][] = $rules;
$metadata['Account']['members'][] = 'dateTimeField';
$rules = array('dateTimeField', 'type', 'type' => 'datetime');
$metadata['Account']['rules'][] = $rules;
$metadata['Account']['members'][] = 'urlField';
$rules = array('urlField', 'url');
$metadata['Account']['rules'][] = $rules;
$metadata['Account']['members'][] = 'floatField';
$rules = array('floatField', 'type', 'type' => 'float');
$metadata['Account']['rules'][] = $rules;
$metadata['Account']['members'][] = 'longTextField';
$rules = array('longTextField', 'type', 'type' => 'longtext');
$metadata['Account']['rules'][] = $rules;
$metadata['Account']['members'][] = 'blobField';
$rules = array('blobField', 'type', 'type' => 'blob');
$metadata['Account']['rules'][] = $rules;
$metadata['Account']['members'][] = 'longBlobField';
$rules = array('longBlobField', 'type', 'type' => 'longblob');
$metadata['Account']['rules'][] = $rules;
Account::setMetadata($metadata);
$super = User::getByUsername('super');
Yii::app()->user->userModel = $super;
$messageLogger = new MessageLogger();
$beforeRowCount = DatabaseCompatibilityUtil::getTableRowsCountTotal();
InstallUtil::autoBuildDatabase($messageLogger);
$afterRowCount = DatabaseCompatibilityUtil::getTableRowsCountTotal();
$this->assertEquals($beforeRowCount, $afterRowCount);
//Check Account fields
$tableName = RedBeanModel::getTableName('Account');
$columns = R::$writer->getColumns($tableName);
$this->assertEquals('text', $columns['newfield']);
$this->assertEquals('varchar(128)', $columns['string128']);
$this->assertEquals('text', $columns['string555']);
$this->assertEquals('longtext', $columns['string100000']);
$this->assertEquals('text', $columns['textfield']);
$this->assertEquals('date', $columns['datefield']);
$this->assertEquals('tinyint(1)', $columns['booleanfield']);
$this->assertEquals('int(11) unsigned', $columns['integerfield']);
$this->assertEquals('datetime', $columns['datetimefield']);
$this->assertEquals('varchar(255)', $columns['urlfield']);
$this->assertEquals('double', $columns['floatfield']);
$this->assertEquals('longtext', $columns['longtextfield']);
$this->assertEquals('blob', $columns['blobfield']);
$this->assertEquals('longblob', $columns['longblobfield']);
$account = new Account();
$account->name = 'Test Name';
$account->owner = $super;
$randomString = str_repeat("Aa", 64);
$account->string128 = $randomString;
$this->assertTrue($account->save());
$metadata = Account::getMetadata();
foreach ($metadata['Account']['rules'] as $key => $rule) {
if ($rule[0] == 'string128' && $rule[1] == 'length') {
$metadata['Account']['rules'][$key]['max'] = 64;
}
}
Account::setMetadata($metadata);
InstallUtil::autoBuildDatabase($messageLogger);
RedBeanModel::forgetAll();
$modifiedAccount = Account::getById($account->id);
$this->assertEquals($randomString, $modifiedAccount->string128);
//Check Account fields
$tableName = RedBeanModel::getTableName('Account');
$columns = R::$writer->getColumns($tableName);
$this->assertEquals('varchar(128)', $columns['string128']);
}
public static function setUpBeforeClass()
{
parent::setUpBeforeClass();
// We need to unfreeze here as we are working with custom field values
self::$freeze = false;
if (RedBeanDatabase::isFrozen()) {
RedBeanDatabase::unfreeze();
self::$freeze = true;
}
SecurityTestHelper::createSuperAdmin();
SecurityTestHelper::createUsers();
self::$super = User::getByUsername('super');
Yii::app()->user->userModel = self::$super;
$currencies = Currency::getAll();
$currencyValue1 = new CurrencyValue();
$currencyValue1->value = 100;
$currencyValue1->currency = $currencies[0];
$multiDropDownCustomFieldData1 = new CustomFieldData();
$multiDropDownCustomFieldData1->name = 'multiDropDown1';
$multiDropDownCustomFieldData1->serializedData = serialize(array('Ten', 11, 'XII'));
$saved = $multiDropDownCustomFieldData1->save();
assert('$saved');
// Not Coding Standard
$multiDropDownCustomFieldValue1 = new CustomFieldValue();
$multiDropDownCustomFieldValue1->value = 'Ten';
$multiDropDownCustomFieldValue2 = new CustomFieldValue();
$multiDropDownCustomFieldValue2->value = 11;
$multiDropDownCustomFieldValue3 = new CustomFieldValue();
$multiDropDownCustomFieldValue3->value = 'XII';
$tagCustomFieldData1 = new CustomFieldData();
$tagCustomFieldData1->name = 'tagCloud1';
$tagCustomFieldData1->serializedData = serialize(array('Apache', 'PHP'));
$saved = $tagCustomFieldData1->save();
assert('$saved');
// Not Coding Standard
$tagCustomFieldValue1 = new CustomFieldValue();
$tagCustomFieldValue1->value = 'PHP';
$tagCustomFieldValue2 = new CustomFieldValue();
$tagCustomFieldValue2->value = 'Apache';
$primaryEmail1 = new Email();
$primaryEmail1->emailAddress = "*****@*****.**";
$primaryEmail1->isInvalid = true;
$primaryEmail1->optOut = false;
$secondaryEmail1 = new Email();
$secondaryEmail1->emailAddress = "*****@*****.**";
$secondaryEmail1->isInvalid = false;
$secondaryEmail1->optOut = true;
$address1 = new Address();
$address1->street1 = "SomeStreet1";
$address1->street2 = "SomeStreet2";
$address1->city = "SomeCity";
$address1->state = "SomeState";
$address1->postalCode = 1111;
$address1->country = "SomeCountry";
$likeContactState1 = new ContactState();
$likeContactState1->name = 'Customer';
$likeContactState1->order = 0;
$users = User::getAll();
$user1 = new User();
$user1->lastName = 'Kevin';
$user1->hash = 'rieWoy3aijohP6chaigaokohs1oovohf';
$user1->language = 'es';
$user1->timeZone = 'America/Chicago';
$user1->username = '******';
$user1->currency = $currencies[0];
$user1->manager = $users[0];
//Custom attribute
$attributeForm = new TextAttributeForm();
$attributeForm->attributeName = 'custom';
$attributeForm->attributeLabels = array('en' => 'test label en');
$modelAttributesAdapterClassName = $attributeForm::getModelAttributeAdapterNameForSavingAttributeFormData();
$adapter = new $modelAttributesAdapterClassName(new EmailTemplateModelTestItem());
$adapter->setAttributeMetadataFromForm($attributeForm);
$model = new EmailTemplateModelTestItem();
$model->string = 'abc';
$model->firstName = 'James';
$model->lastName = 'Jackson';
$model->phone = 1122334455;
$model->boolean = true;
$model->date = '2008-12-31';
$model->dateTime = '2008-12-31 07:48:04';
$model->textArea = 'Multiple Lines\\nOf Text';
$model->url = 'http://www.zurmo.com/';
$model->integer = 999;
$model->float = 999.999;
$model->currencyValue = $currencyValue1;
$model->dropDown->value = "DropdownSelectedValue";
$model->radioDropDown->value = "RadioDropdownSelectedValue";
$model->primaryEmail = $primaryEmail1;
$model->secondaryEmail = $secondaryEmail1;
$model->primaryAddress = $address1;
$model->likeContactState = $likeContactState1;
$model->user = $user1;
$model->multiDropDown->data = $multiDropDownCustomFieldData1;
$model->tagCloud->data = $tagCustomFieldData1;
$model->multiDropDown->values->add($multiDropDownCustomFieldValue1);
$model->multiDropDown->values->add($multiDropDownCustomFieldValue2);
$model->multiDropDown->values->add($multiDropDownCustomFieldValue3);
$model->tagCloud->values->add($tagCustomFieldValue1);
$model->tagCloud->values->add($tagCustomFieldValue2);
$model->customCstm = 'text custom';
$saved = $model->save();
assert('$saved');
// Not Coding Standard
self::$emailTemplate = $model;
// Update all values but do not save the model.
$multiDropDownCustomFieldData2 = new CustomFieldData();
$multiDropDownCustomFieldData2->name = 'multiDropDown2';
$multiDropDownCustomFieldData2->serializedData = serialize(array('Thirteen', 14, 'XV'));
$saved = $multiDropDownCustomFieldData2->save();
assert('$saved');
// Not Coding Standard
$multiDropDownCustomFieldValue4 = new CustomFieldValue();
$multiDropDownCustomFieldValue4->value = 'Thirteen';
$multiDropDownCustomFieldValue5 = new CustomFieldValue();
$multiDropDownCustomFieldValue5->value = 14;
$multiDropDownCustomFieldValue6 = new CustomFieldValue();
$multiDropDownCustomFieldValue6->value = 'XV';
$tagCustomFieldData2 = new CustomFieldData();
$tagCustomFieldData2->name = 'tagCloud2';
$tagCustomFieldData2->serializedData = serialize(array('Nginx', 'Python'));
$saved = $tagCustomFieldData2->save();
assert('$saved');
// Not Coding Standard
$tagCustomFieldValue3 = new CustomFieldValue();
$tagCustomFieldValue3->value = 'Python';
$tagCustomFieldValue4 = new CustomFieldValue();
$tagCustomFieldValue4->value = 'Nginx';
self::$emailTemplate->string = 'def';
self::$emailTemplate->firstName = 'Jane';
self::$emailTemplate->lastName = 'Bond';
self::$emailTemplate->phone = 66778899;
self::$emailTemplate->boolean = false;
self::$emailTemplate->date = '2009-12-31';
self::$emailTemplate->dateTime = '2009-12-31 07:48:04';
self::$emailTemplate->textArea = 'Multiple Lines\\nOf\\nText';
self::$emailTemplate->url = 'http://www.zurmo.org/';
self::$emailTemplate->integer = 888;
self::$emailTemplate->float = 888.888;
self::$emailTemplate->currencyValue->value = 99;
self::$emailTemplate->dropDown->value = "DropdownSelectedVal";
self::$emailTemplate->radioDropDown->value = "RadioDropdownSelectedVal";
self::$emailTemplate->primaryEmail->emailAddress = "*****@*****.**";
self::$emailTemplate->primaryEmail->isInvalid = false;
self::$emailTemplate->primaryEmail->optOut = true;
self::$emailTemplate->secondaryEmail->emailAddress = "*****@*****.**";
self::$emailTemplate->secondaryEmail->isInvalid = true;
self::$emailTemplate->secondaryEmail->optOut = false;
self::$emailTemplate->primaryAddress->street1 = "SomeOtherStreet1";
self::$emailTemplate->primaryAddress->street2 = "SomeOtherStreet2";
self::$emailTemplate->primaryAddress->city = "SomeOtherCity";
self::$emailTemplate->primaryAddress->state = "SomeOtherState";
self::$emailTemplate->primaryAddress->postalCode = 2222;
self::$emailTemplate->primaryAddress->country = "SomeOtherCountry";
self::$emailTemplate->likeContactState->name = 'New';
self::$emailTemplate->likeContactState->order = 1;
self::$emailTemplate->user->lastName = 'Dean';
self::$emailTemplate->user->hash = 'teo8eghaipaC5ahngahleiyaebofu6oo';
self::$emailTemplate->user->language = 'en';
self::$emailTemplate->user->timeZone = 'America/Denver';
self::$emailTemplate->user->username = '******';
self::$emailTemplate->multiDropDown->data = $multiDropDownCustomFieldData2;
self::$emailTemplate->multiDropDown->values->remove($multiDropDownCustomFieldValue1);
self::$emailTemplate->multiDropDown->values->remove($multiDropDownCustomFieldValue2);
self::$emailTemplate->multiDropDown->values->remove($multiDropDownCustomFieldValue3);
self::$emailTemplate->multiDropDown->values->add($multiDropDownCustomFieldValue4);
self::$emailTemplate->multiDropDown->values->add($multiDropDownCustomFieldValue5);
self::$emailTemplate->multiDropDown->values->add($multiDropDownCustomFieldValue6);
self::$emailTemplate->tagCloud->data = $tagCustomFieldData2;
self::$emailTemplate->tagCloud->values->remove($tagCustomFieldValue1);
self::$emailTemplate->tagCloud->values->remove($tagCustomFieldValue2);
self::$emailTemplate->tagCloud->values->add($tagCustomFieldValue3);
self::$emailTemplate->tagCloud->values->add($tagCustomFieldValue4);
self::$emailTemplate->customCstm = 'text custom changed';
self::$content = 'Current: [[STRING]] [[FIRST^NAME]] [[LAST^NAME]] ' . '[[PHONE]] Old: [[WAS%STRING]] [[WAS%FIRST^NAME]] ' . '[[WAS%LAST^NAME]] [[WAS%PHONE]]';
self::$compareContent = 'Current: def Jane Bond 66778899 Old: abc James ' . 'Jackson 1122334455';
}
public static function setUpBeforeClass()
{
parent::setUpBeforeClass();
self::$freeze = false;
if (RedBeanDatabase::isFrozen()) {
RedBeanDatabase::unfreeze();
self::$freeze = true;
}
SecurityTestHelper::createSuperAdmin();
SecurityTestHelper::createUsers();
self::$super = User::getByUsername('super');
Yii::app()->user->userModel = self::$super;
$currencies = Currency::getAll();
$currencyValue = new CurrencyValue();
$currencyValue->value = 100;
$currencyValue->currency = $currencies[0];
$multiDropDownCustomFieldData = new CustomFieldData();
$multiDropDownCustomFieldData->name = 'multiDropDown';
$multiDropDownCustomFieldData->serializedData = serialize(array('Ten', 11, 'XII'));
$saved = $multiDropDownCustomFieldData->save();
assert('$saved');
// Not Coding Standard
$multiDropDownCustomFieldValue1 = new CustomFieldValue();
$multiDropDownCustomFieldValue1->value = 'Ten';
$multiDropDownCustomFieldValue2 = new CustomFieldValue();
$multiDropDownCustomFieldValue2->value = 11;
$multiDropDownCustomFieldValue3 = new CustomFieldValue();
$multiDropDownCustomFieldValue3->value = 'XII';
$tagCustomFieldData = new CustomFieldData();
$tagCustomFieldData->name = 'tagCloud';
$tagCustomFieldData->serializedData = serialize(array('Apache', 'PHP'));
$saved = $tagCustomFieldData->save();
assert('$saved');
// Not Coding Standard
$tagCustomFieldValue1 = new CustomFieldValue();
$tagCustomFieldValue1->value = 'PHP';
$tagCustomFieldValue2 = new CustomFieldValue();
$tagCustomFieldValue2->value = 'Apache';
$primaryEmail = new Email();
$primaryEmail->emailAddress = "*****@*****.**";
$primaryEmail->isInvalid = true;
$primaryEmail->optOut = false;
$secondaryEmail = new Email();
$secondaryEmail->emailAddress = "*****@*****.**";
$secondaryEmail->isInvalid = false;
$secondaryEmail->optOut = true;
$address = new Address();
$address->street1 = "SomeStreet1";
$address->street2 = "SomeStreet2";
$address->city = "SomeCity";
$address->state = "SomeState";
$address->postalCode = 1111;
$address->country = "SomeCountry";
$likeContactState = new ContactState();
$likeContactState->name = 'Customer';
$likeContactState->order = 0;
$users = User::getAll();
$user = new User();
$user->lastName = 'Kevin';
$user->hash = 'rieWoy3aijohP6chaigaokohs1oovohf';
$user->language = 'es';
$user->timeZone = 'America/Chicago';
$user->username = '******';
$user->currency = $currencies[0];
$user->manager = $users[0];
//Custom attribute
$attributeForm = new TextAttributeForm();
$attributeForm->attributeName = 'custom';
$attributeForm->attributeLabels = array('en' => 'test label en');
$modelAttributesAdapterClassName = $attributeForm::getModelAttributeAdapterNameForSavingAttributeFormData();
$adapter = new $modelAttributesAdapterClassName(new EmailTemplateModelTestItem());
$adapter->setAttributeMetadataFromForm($attributeForm);
$model = new EmailTemplateModelTestItem();
$model->string = 'abc';
$model->firstName = 'James';
$model->lastName = 'Jackson';
$model->phone = 1122334455;
$model->boolean = true;
$model->date = '2008-12-31';
$model->dateTime = '2008-12-31 07:48:04';
$model->textArea = 'Multiple Lines\\nOf Text';
$model->url = 'http://www.zurmo.com/';
$model->integer = 999;
$model->float = 999.999;
$model->currencyValue = $currencyValue;
$model->dropDown->value = "DropdownSelectedValue";
$model->radioDropDown->value = "RadioDropdownSelectedValue";
$model->primaryEmail = $primaryEmail;
$model->secondaryEmail = $secondaryEmail;
$model->primaryAddress = $address;
$model->likeContactState = $likeContactState;
$model->user = $user;
$model->multiDropDown->data = $multiDropDownCustomFieldData;
$model->tagCloud->data = $tagCustomFieldData;
$model->multiDropDown->values->add($multiDropDownCustomFieldValue1);
$model->multiDropDown->values->add($multiDropDownCustomFieldValue2);
$model->multiDropDown->values->add($multiDropDownCustomFieldValue3);
$model->tagCloud->values->add($tagCustomFieldValue1);
$model->tagCloud->values->add($tagCustomFieldValue2);
$model->customCstm = 'text custom';
$saved = $model->save();
assert('$saved');
// Not Coding Standard
self::$emailTemplate = $model;
self::$content = '[[STRING]] [[FIRST^NAME]] [[LAST^NAME]] [[PHONE]]';
self::$compareContent = 'abc James Jackson 1122334455';
}
/**
* From the command line, run the autobuild method which will effectively update
* the database schema.
*/
public static function runAutoBuildFromUpdateSchemaCommand($messageLogger)
{
assert('$messageLogger instanceof MessageLogger');
ForgetAllCacheUtil::forgetAllCaches();
$freezeWhenDone = false;
if (RedBeanDatabase::isFrozen()) {
RedBeanDatabase::unfreeze();
$freezeWhenDone = true;
}
self::autoBuildDatabase($messageLogger);
if ($freezeWhenDone) {
RedBeanDatabase::freeze();
}
// Send notification to super admin to clean assets folder(optional).
$message = new NotificationMessage();
$message->textContent = Zurmo::t('InstallModule', 'Please delete all files from assets folder on server.');
$rules = new ClearAssetsFolderNotificationRules();
NotificationsUtil::submit($message, $rules);
return true;
}
/**
* @param array $modelClassNames
* @param MessageLogger $messageLogger
*/
public static function manageFrozenStateAndAutoBuildModels(array $modelClassNames, &$messageLogger)
{
RedBeanDatabase::unfreeze();
self::autoBuildModels($modelClassNames, $messageLogger);
RedBeanDatabase::freeze();
}
/**
* @depends testSimpleImportWithStringAndFullNameWhichAreRequiredAttributeOnImportTestModelItem
*/
public function testSettingExplicitReadWriteModelPermissionsDuringImport()
{
Yii::app()->user->userModel = User::getByUsername('super');
$testModels = ImportModelTestItem::getAll();
$this->assertEquals(0, count($testModels));
//Add a read only user for import. Then all models should be readable by jim in addition to super.
$explicitReadWriteModelPermissions = new ExplicitReadWriteModelPermissions();
$explicitReadWriteModelPermissions->addReadOnlyPermitable(User::getByUsername('jim'));
//Unfreeze since the test model is not part of the standard schema.
$freezeWhenComplete = false;
if (RedBeanDatabase::isFrozen()) {
RedBeanDatabase::unfreeze();
$freezeWhenComplete = true;
}
$testModels = ImportModelTestItem::getAll();
$this->assertEquals(0, count($testModels));
$import = new Import();
$serializedData['importRulesType'] = 'ImportModelTestItem';
$serializedData['firstRowIsHeaderRow'] = true;
$import->serializedData = serialize($serializedData);
$this->assertTrue($import->save());
ImportTestHelper::createTempTableByFileNameAndTableName('importAnalyzerTest.csv', $import->getTempTableName());
$this->assertEquals(13, ImportDatabaseUtil::getCount($import->getTempTableName()));
// includes header rows.
$mappingData = array('column_0' => array('attributeIndexOrDerivedType' => 'string', 'type' => 'importColumn', 'mappingRulesData' => array('DefaultValueModelAttributeMappingRuleForm' => array('defaultValue' => null))), 'column_23' => array('attributeIndexOrDerivedType' => 'FullName', 'type' => 'importColumn', 'mappingRulesData' => array('FullNameDefaultValueModelAttributeMappingRuleForm' => array('defaultValue' => null))));
$importRules = ImportRulesUtil::makeImportRulesByType('ImportModelTestItem');
$page = 0;
$config = array('pagination' => array('pageSize' => 3));
//This way all rows are processed.
$dataProvider = new ImportDataProvider($import->getTempTableName(), true, $config);
$dataProvider->getPagination()->setCurrentPage($page);
$importResultsUtil = new ImportResultsUtil($import);
$messageLogger = new ImportMessageLogger();
ImportUtil::importByDataProvider($dataProvider, $importRules, $mappingData, $importResultsUtil, $explicitReadWriteModelPermissions, $messageLogger);
$importResultsUtil->processStatusAndMessagesForEachRow();
//Confirm that 3 models where created.
$testModels = ImportModelTestItem::getAll();
$this->assertEquals(3, count($testModels));
$jim = User::getByUsername('jim');
foreach ($testModels as $model) {
$this->assertEquals(array(Permission::READ, Permission::NONE), $model->getExplicitActualPermissions($jim));
}
//Clear out data in table
R::exec("delete from " . ImportModelTestItem::getTableName('ImportModelTestItem'));
//Now test with read/write permissions being set.
$explicitReadWriteModelPermissions = new ExplicitReadWriteModelPermissions();
$explicitReadWriteModelPermissions->addReadWritePermitable(User::getByUsername('jim'));
$dataProvider = new ImportDataProvider($import->getTempTableName(), true, $config);
$dataProvider->getPagination()->setCurrentPage($page);
$importResultsUtil = new ImportResultsUtil($import);
$messageLogger = new ImportMessageLogger();
ImportUtil::importByDataProvider($dataProvider, $importRules, $mappingData, $importResultsUtil, $explicitReadWriteModelPermissions, $messageLogger);
$importResultsUtil->processStatusAndMessagesForEachRow();
//Confirm that 3 models where created.
$testModels = ImportModelTestItem::getAll();
$this->assertEquals(3, count($testModels));
$jim = User::getByUsername('jim');
foreach ($testModels as $model) {
$this->assertEquals(array(Permission::READ_WRITE_CHANGE_PERMISSIONS_CHANGE_OWNER, Permission::NONE), $model->getExplicitActualPermissions($jim));
}
//Re-freeze if needed.
if ($freezeWhenComplete) {
RedBeanDatabase::freeze();
}
}
public static function createImportModelTestItem4($name)
{
$freeze = false;
if (RedBeanDatabase::isFrozen()) {
RedBeanDatabase::unfreeze();
$freeze = true;
}
$model = new ImportModelTestItem4();
$model->name = $name;
$saved = $model->save();
assert('$saved');
if ($freeze) {
RedBeanDatabase::freeze();
}
return $model;
}
protected function createImportTempTable($columnCount, $tableName)
{
$freezeWhenComplete = false;
if (RedBeanDatabase::isFrozen()) {
RedBeanDatabase::unfreeze();
$freezeWhenComplete = true;
}
$newBean = R::dispense($tableName);
for ($i = 0; $i < $columnCount; $i++) {
$columnName = 'column_' . $i;
$newBean->{$columnName} = str_repeat(' ', 50);
$columns[] = $columnName;
}
R::store($newBean);
R::trash($newBean);
R::wipe($tableName);
ImportDatabaseUtil::optimizeTableNonImportColumns($tableName);
R::wipe($tableName);
if ($freezeWhenComplete) {
RedBeanDatabase::freeze();
}
}
