public void BulkImportData()
{
var entities = new List<Import.ImportEntity>();
var now = DateTime.Now.ToShortTimeString();
const int numberOfEntities = 1500;
for (var i = 0; i < numberOfEntities; i++)
{
var entityGuid = Guid.Parse("00000000-0000-0000-0000-" + i.ToString("000000000000"));
var entity = new Import.ImportEntity
{
EntityGuid = entityGuid,
AttributeSetStaticName = "4e0f8568-a2fe-435c-abda-0602dddeb400",
AssignmentObjectTypeId = Constants.DefaultAssignmentObjectTypeId
};
entity.Values = new Dictionary<string, List<IValueImportModel>>
{
{ "Name", new List<IValueImportModel>{new ValueImportModel<string>(entity) { Value = "Buchs " + now }}},
{ "Live", new List<IValueImportModel>{new ValueImportModel<bool?>(entity) { Value = true }}},
{ "NumberOfCards", new List<IValueImportModel>{new ValueImportModel<decimal?>(entity) { Value = 5 }}},
{ "Notes", new List<IValueImportModel>{new ValueImportModel<string>(entity) { Value = "Test 1234567890" }}},
{ "Uses2Reserve", new List<IValueImportModel>{new ValueImportModel<bool?>(entity) { Value = true }}},
{ "Website", new List<IValueImportModel>{new ValueImportModel<string>(entity) { Value = "http://www.2sic.com" }}},
{ "Email", new List<IValueImportModel>{new ValueImportModel<string>(entity) { Value = "*****@*****.**" }}},
{ "Price", new List<IValueImportModel>{new ValueImportModel<string>(entity) { Value = "40.-" }}},
{ "Canton", new List<IValueImportModel>{new ValueImportModel<string>(entity) { Value = "SG" }}},
{ "Now", new List<IValueImportModel>{new ValueImportModel<string>(entity) { Value = now }}},
};
entities.Add(entity);
}
var import = new Import.Import(2, 2, "BulkImportData", leaveExistingValuesUntouched: true);
import.RunImport(null, entities);
Assert.IsEmpty(import.ImportLog.Where(l => l.EntryType == EventLogEntryType.Error));
}
private Import.ImportEntity GetEntity(int assignmentObjectTypeId, string attributeSetStaticName, Guid? entityGuid, int? keyNumber, Import.ImportAttributeSet importAttributeSet, Guid? relatedEntity = null)
{
var entity = new Import.ImportEntity
{
AssignmentObjectTypeId = assignmentObjectTypeId,
AttributeSetStaticName = attributeSetStaticName,
EntityGuid = entityGuid,
KeyNumber = keyNumber
};
entity.Values = GetEntityValues(entity, importAttributeSet, relatedEntity);
return entity;
}
private List<Import.ImportEntity> GetAttributeMetaData(int attributeSetNumber, string now, string type)
{
var allEntity = new Import.ImportEntity { AttributeSetStaticName = "@All" };
allEntity.Values = new Dictionary<string, List<IValueImportModel>>
{
{"Name",new List<IValueImportModel>{new ValueImportModel<string>(allEntity) {Value = "Simple Attribute " + now + " " + attributeSetNumber + " " + type}}},
{"Notes",new List<IValueImportModel>{new ValueImportModel<string>(allEntity) {Value = "Notes for Simple Attribute " + now + " " + attributeSetNumber + " " + type}}},
{"VisibleInEditUI", new List<IValueImportModel> {new ValueImportModel<bool?>(allEntity) {Value = true}}}
};
Import.ImportEntity typeImportEntity = null;
switch (type)
{
case "DateTime":
typeImportEntity = new Import.ImportEntity { AttributeSetStaticName = "@DateTime" };
typeImportEntity.Values = new Dictionary<string, List<IValueImportModel>>
{
{ "UseTimePicker", new List<IValueImportModel> { new ValueImportModel<bool?>(typeImportEntity) { Value = true } } }
};
break;
case "Entity":
typeImportEntity = new Import.ImportEntity { AttributeSetStaticName = "@Entity" };
typeImportEntity.Values = new Dictionary<string, List<IValueImportModel>>
{
{"AllowMultiValue", new List<IValueImportModel> {new ValueImportModel<bool?>(typeImportEntity) {Value = true}}},
{"EntityType", new List<IValueImportModel> {new ValueImportModel<string>(typeImportEntity) {Value = ""}}}
};
break;
case "Hyperlink":
typeImportEntity = new Import.ImportEntity { AttributeSetStaticName = "@Hyperlink" };
typeImportEntity.Values = new Dictionary<string, List<IValueImportModel>>
{
{"DefaultDialog", new List<IValueImportModel> {new ValueImportModel<string>(typeImportEntity) {Value = "PagePicker"}}},
{"ShowPagePicker", new List<IValueImportModel> {new ValueImportModel<bool?>(typeImportEntity) {Value = true}}},
{"ShowImageManager", new List<IValueImportModel> {new ValueImportModel<bool?>(typeImportEntity) {Value = true}}},
{"ShowFileManager", new List<IValueImportModel> {new ValueImportModel<bool?>(typeImportEntity) {Value = true}}},
};
break;
case "Number":
typeImportEntity = new Import.ImportEntity { AttributeSetStaticName = "@Number" };
typeImportEntity.Values = new Dictionary<string, List<IValueImportModel>>
{
{"Decimals", new List<IValueImportModel> {new ValueImportModel<decimal?>(typeImportEntity) {Value = 0}}},
{"Min", new List<IValueImportModel> {new ValueImportModel<decimal?>(typeImportEntity) {Value = 0}}},
{"Max", new List<IValueImportModel> {new ValueImportModel<decimal?>(typeImportEntity) {Value = 360}}},
{"InputType", new List<IValueImportModel> {new ValueImportModel<string>(typeImportEntity) {Value = "gps"}}},
};
break;
case "String":
typeImportEntity = new Import.ImportEntity { AttributeSetStaticName = "@String" };
typeImportEntity.Values = new Dictionary<string, List<IValueImportModel>>
{
{"InputType", new List<IValueImportModel> {new ValueImportModel<string>(typeImportEntity) {Value = "wysiwyg"}}},
{"WysiwygHeight", new List<IValueImportModel> {new ValueImportModel<decimal?>(typeImportEntity) {Value = 250}}}
};
break;
}
var entities = new List<Import.ImportEntity> { allEntity };
if (typeImportEntity != null)
entities.Add(typeImportEntity);
return entities;
}
private static Import.ImportEntity GetSampleNewsEntity(EavContext db, Guid? entityGuid)
{
var attributeSetStaticName = db.AttributeSets.Where(a => a.AppID == db.AppId && a.Name == "News").Select(a => a.StaticName).Single();
var entity = new Import.ImportEntity
{
EntityGuid = entityGuid,
AttributeSetStaticName = attributeSetStaticName,
AssignmentObjectTypeId = Constants.DefaultAssignmentObjectTypeId
};
entity.Values = new Dictionary<string, List<IValueImportModel>>
{
{"Title", new List<IValueImportModel>
{
new ValueImportModel<string>(entity)
{
Value = "Fivth News en",
ValueDimensions = new List<Import.ValueDimension>
{
new Import.ValueDimension {DimensionExternalKey = "en-us", ReadOnly = false},
}
},
new ValueImportModel<string>(entity)
{
Value = "Fünfte News de",
ValueDimensions = new List<Import.ValueDimension>
{
new Import.ValueDimension {DimensionExternalKey = "de-ch", ReadOnly = false},
}
}
}},
{"Date", new List<IValueImportModel>
{
new ValueImportModel<DateTime?>(entity)
{
Value = new DateTime(2014,3,18),
ValueDimensions = new List<Import.ValueDimension>
{
new Import.ValueDimension{ DimensionExternalKey = "en-US", ReadOnly = false},
new Import.ValueDimension{ DimensionExternalKey = "de-CH", ReadOnly = true},
}
}
}},
{"Short", new List<IValueImportModel>
{
new ValueImportModel<string>(entity)
{
Value = "Third news short",
ValueDimensions = new List<Import.ValueDimension>{ new Import.ValueDimension{ DimensionExternalKey = "en-US", ReadOnly = false}}
},
new ValueImportModel<string>(entity)
{
Value = "Dritte News kurz",
ValueDimensions = new List<Import.ValueDimension>{ new Import.ValueDimension{ DimensionExternalKey = "de-CH", ReadOnly = false}}
}
}},
{"Long", new List<IValueImportModel>
{
new ValueImportModel<string>(entity)
{
Value = "Third news long",
ValueDimensions = new List<Import.ValueDimension>{ new Import.ValueDimension{ DimensionExternalKey = "en-US", ReadOnly = false}}
},
new ValueImportModel<string>(entity)
{
Value = "Dritte News lang",
ValueDimensions = new List<Import.ValueDimension>{ new Import.ValueDimension{ DimensionExternalKey = "de-CH", ReadOnly = false}}
}
}},
};
return entity;
}
public void UpdateExistingDataMultilingual(int appId = 2, int entityId = 5449)
{
var db = EavContext.Instance(appId: appId);
var entityGuid = db.Entities.Where(e => e.EntityID == entityId).Select(e => (Guid?)e.EntityGUID).SingleOrDefault();
var attributeSetStaticName = db.AttributeSets.Where(a => a.AppID == db.AppId && a.Name == "News").Select(a => a.StaticName).Single();
var entity = new Import.ImportEntity
{
EntityGuid = entityGuid,
AttributeSetStaticName = attributeSetStaticName,
AssignmentObjectTypeId = Constants.DefaultAssignmentObjectTypeId
};
// Title first Import
var titleValue = new List<IValueImportModel>
{
new ValueImportModel<string>(entity)
{
Value = "Third News en & de",
ValueDimensions = new List<Import.ValueDimension>
{
new Import.ValueDimension {DimensionExternalKey = "en-us", ReadOnly = false},
new Import.ValueDimension {DimensionExternalKey = "de-ch", ReadOnly = false},
}
}
};
// title second Import
if (entityGuid.HasValue)
titleValue = new List<IValueImportModel>
{
new ValueImportModel<string>(entity)
{
Value = "Third News en",
ValueDimensions = new List<Import.ValueDimension>
{
new Import.ValueDimension {DimensionExternalKey = "en-us", ReadOnly = false},
}
},
new ValueImportModel<string>(entity)
{
Value = "Third News de",
ValueDimensions = new List<Import.ValueDimension>
{
new Import.ValueDimension {DimensionExternalKey = "de-ch", ReadOnly = false},
}
}
};
entity.Values = new Dictionary<string, List<IValueImportModel>>
{
{"Title", titleValue},
{"Date", new List<IValueImportModel>
{
new ValueImportModel<DateTime?>(entity)
{
Value = new DateTime(2014,3,18),
ValueDimensions = new List<Import.ValueDimension>
{
new Import.ValueDimension{ DimensionExternalKey = "en-US", ReadOnly = false},
new Import.ValueDimension{ DimensionExternalKey = "de-CH", ReadOnly = true},
}
}
}},
{"Short", new List<IValueImportModel>
{
new ValueImportModel<string>(entity)
{
Value = "Third news short",
ValueDimensions = new List<Import.ValueDimension>{ new Import.ValueDimension{ DimensionExternalKey = "en-US", ReadOnly = false}}
},
new ValueImportModel<string>(entity)
{
Value = "Dritte News kurz",
ValueDimensions = new List<Import.ValueDimension>{ new Import.ValueDimension{ DimensionExternalKey = "de-CH", ReadOnly = false}}
}
}},
{"Long", new List<IValueImportModel>
{
new ValueImportModel<string>(entity)
{
Value = "Third news long",
ValueDimensions = new List<Import.ValueDimension>{ new Import.ValueDimension{ DimensionExternalKey = "en-US", ReadOnly = false}}
},
new ValueImportModel<string>(entity)
{
Value = "Dritte News lang",
ValueDimensions = new List<Import.ValueDimension>{ new Import.ValueDimension{ DimensionExternalKey = "de-CH", ReadOnly = false}}
}
}},
};
var entities = new List<Import.ImportEntity> { entity };
var import = new Import.Import(db.ZoneId, db.AppId, "UpdateExistingDataMultilingual", true);
import.RunImport(null, entities);
//Assert.IsEmpty(import.ImportLog);
Assert.IsFalse(import.ImportLog.Any(l => l.EntryType == EventLogEntryType.Error));
}
public void UpdateExistingData()
{
// Update Attribute Set
const string attributeSetStaticName = "AttributeSet_181655_1";
const string now = "181655";
var attributeSet = new Import.ImportAttributeSet
{
Attributes = GetAttributes(1, now),
Description = "New Description",
Name = "New Name",
Scope = "New Scope",
StaticName = attributeSetStaticName,
};
attributeSet.Attributes.Add(new Import.ImportAttribute { StaticName = "AttributeAddedLater", Type = "String" });
attributeSet.TitleAttribute = attributeSet.Attributes.Last();
const bool overwriteExistingEntityValues = true;
var import = new Import.Import(2, 2, "ImportTest2", overwriteExistingEntityValues);
var attributeSets = new List<Import.ImportAttributeSet> { attributeSet };
// Update Entity
const int entityId = 5483;
var db = new EavContext();
var entityGuid = db.Entities.Where(e => e.EntityID == entityId).Select(e => e.EntityGUID).Single();
var entity = new Import.ImportEntity
{
EntityGuid = entityGuid,
AttributeSetStaticName = attributeSetStaticName,
KeyNumber = 999,
AssignmentObjectTypeId = Constants.DefaultAssignmentObjectTypeId
};
entity.Values = GetEntityValues(entity, attributeSet, isUpdate: true, now: DateTime.Now.ToLongTimeString().Replace(":", ""));
var entities = new List<Import.ImportEntity> { entity };
import.RunImport(null, entities);
Assert.IsEmpty(import.ImportLog);
Assert.IsFalse(import.ImportLog.Any(l => l.EntryType == EventLogEntryType.Error));
}
