public void ValidateRow_runNotValid_LimitErrors()
{
//Arrange
DataGeneratorHelper dgh = new DataGeneratorHelper();
var errors = new List <Error>();
var testData = dgh.GenerateRowsWithRandomValuesBasedOnDatastructureWithErrors(dataStructure, ",", 1000000, true);
IEnumerable <string> vairableNames = dataStructure.Variables.Select(v => v.Label);
//generate file to read
Encoding encoding = Encoding.Default;
string path = Path.Combine(AppConfiguration.DataPath, "testdataforvalidation.txt");
if (File.Exists(path))
{
File.Delete(path);
}
using (StreamWriter sw = new StreamWriter(path))
{
string header = string.Join(",", vairableNames.ToArray());
sw.WriteLine(header);
foreach (var r in testData)
{
sw.WriteLine(r);
}
}
//Mock IOUtility
var ioUtilityMock = new Mock <IOUtility>();
ioUtilityMock.Setup(i => i.ConvertDateToCulture("2018")).Returns("2018");
try
{
AsciiFileReaderInfo afr = new AsciiFileReaderInfo();
afr.TextMarker = TextMarker.doubleQuotes;
afr.Seperator = TextSeperator.comma;
DataReader reader = new AsciiReader(dataStructure, afr, ioUtilityMock.Object);
var asciireader = (AsciiReader)reader;
//Act
var row = new List <string>();
using (Stream stream = reader.Open(path))
{
asciireader.ValidateFile(stream, "", 1);
}
//Assert
Assert.That(asciireader.ErrorMessages.Count, Is.EqualTo(1000));
}
catch (Exception ex)
{
throw ex;
}
}
private JObject UpdateData(JObject jObject)
{
if (jObject["Data"] is JObject)
{
int nMB = Int32.Parse(jObject["Data"]["AutoGenerate"]["nMegaByte"].ToString());
byte[] bytes = DataGeneratorHelper.GenerateBytes(nMB);
jObject["Data"] = bytes;
}
return(jObject);
}
public override void OnInspectorGUI()
{
base.OnInspectorGUI();
if (GUILayout.Button("CSVReadAndWriteTest"))
{
((CSVExample)target).CSVReadAndWriteTest();
}
if (GUILayout.Button("CreateOrRefreshDataConfig"))
{
var directoryName = Path.GetDirectoryName(((CSVExample)target).gameObject.scene.path);
DataGeneratorHelper.CreateDataByPath <ExampleTestData, ExampleTestDataConfig>(directoryName + "/ExampleTestData.csv", directoryName + "/ExampleTestDataConfig.asset");
Debug.Log("CreateOrRefreshDataConfig finish. Click me to select data config asset!", AssetDatabase.LoadMainAssetAtPath(directoryName + "/ExampleTestDataConfig.asset"));
}
}
private JObject UpdateData(JObject jObject)
{
if (jObject["Value"] is JObject)
{
int nMB = Int32.Parse(jObject["Value"]["AutoGenerate"]["nMegaByte"].ToString());
jObject["Value"] = DataGeneratorHelper.GenerateJsonString(nMB);
}
if (jObject["Name"] is JObject)
{
int length = Int32.Parse(jObject["Name"]["AutoGenerate"]["Length"].ToString());
jObject["Name"] = new string('X', length);
}
return(jObject);
}
public static void Main(string[] args)
{
var unis = DataGeneratorHelper.GenerateData(1000, 100, 10);
const int times = 50;
var mappers = new List <IMapper>
{
new ManualMapper(),
new AutoMapperConf(),
new EmitMapperConf(),
new ExpressMapperConf(),
new TinyMapperConf(),
new AgileMapperConf(),
new MapsterConf()
};
foreach (var mapper in mappers)
{
BenchHelper.Count(mapper.GetType().Name, () =>
{
var unisDtos = mapper.Map(unis);
}, times);
}
}
public void ValidateRow_runValid_noErrors()
{
//Arrange
DataGeneratorHelper dgh = new DataGeneratorHelper();
var errors = new List <Error>();
var testData = dgh.GenerateRowsWithRandomValuesBasedOnDatastructure(dataStructure, ",", 1000, true);
//generate file to read
Encoding encoding = Encoding.Default;
string path = Path.Combine(AppConfiguration.DataPath, "testdataforvalidation.txt");
if (File.Exists(path))
{
File.Delete(path);
}
using (StreamWriter sw = new StreamWriter(path))
{
foreach (var r in testData)
{
sw.WriteLine(r);
}
}
//Mock IOUtility
var ioUtilityMock = new Mock <IOUtility>();
ioUtilityMock.Setup(i => i.ConvertDateToCulture("2018")).Returns("2018");
try
{
AsciiFileReaderInfo afr = new AsciiFileReaderInfo();
afr.TextMarker = TextMarker.doubleQuotes;
afr.Seperator = TextSeperator.comma;
DataReader reader = new AsciiReader(dataStructure, new AsciiFileReaderInfo(), ioUtilityMock.Object);
IEnumerable <string> vairableNames = dataStructure.Variables.Select(v => v.Label);
List <VariableIdentifier> variableIdentifiers = reader.SetSubmitedVariableIdentifiers(vairableNames.ToList());
reader.ValidateComparisonWithDatatsructure(variableIdentifiers);
var asciireader = (AsciiReader)reader;
//Act
var row = new List <string>();
using (StreamReader streamReader = new StreamReader(path, encoding))
{
string line;
int index = 1;
char seperator = AsciiFileReaderInfo.GetSeperator(afr.Seperator);
while ((line = streamReader.ReadLine()) != null)
{
row = asciireader.rowToList(line, ',');
errors = asciireader.ValidateRow(row, index);
index++;
}
}
//Assert
Assert.That(errors.Count, Is.EqualTo(0));
}
catch (Exception ex)
{
throw ex;
}
}
public void InitializeFormulaTest()
{
_sheet = DataGeneratorHelper.GenerateCharacterSheet();
}
public override void UpdateDatabaseAfterUpdateSchema()
{
base.UpdateDatabaseAfterUpdateSchema();
var watch = new System.Diagnostics.Stopwatch();
watch.Start();
//Create departments.
Department devDepartment = ObjectSpace.FindObject <Department>(CriteriaOperator.Parse("Title == 'R&D'"));
if (devDepartment == null)
{
devDepartment = ObjectSpace.CreateObject <Department>();
devDepartment.Title = "R&D";
devDepartment.Office = "1";
devDepartment.Save();
}
Department supDepartment = ObjectSpace.FindObject <Department>(CriteriaOperator.Parse("Title == 'Technical Support'"));
if (supDepartment == null)
{
supDepartment = ObjectSpace.CreateObject <Department>();
supDepartment.Title = "Technical Support";
supDepartment.Office = "2";
supDepartment.Save();
}
Department mngDepartment = ObjectSpace.FindObject <Department>(CriteriaOperator.Parse("Title == 'Management'"));
if (mngDepartment == null)
{
mngDepartment = ObjectSpace.CreateObject <Department>();
mngDepartment.Title = "Management";
mngDepartment.Office = "3";
mngDepartment.Save();
}
//Create employees.
//Admin is a god that can do everything.
Employee administrator = ObjectSpace.FindObject <Employee>(CriteriaOperator.Parse("UserName == 'Admin'"));
if (administrator == null)
{
administrator = ObjectSpace.CreateObject <Employee>();
administrator.UserName = "******";
administrator.FirstName = "Admin";
administrator.LastName = "Admin";
administrator.Department = mngDepartment;
administrator.IsActive = true;
administrator.SetPassword(string.Empty);
administrator.Roles.Add(GetAdministratorRole());
administrator.Save();
}
//Sam is a manager and he can do everything with his own department
Employee managerSam = ObjectSpace.FindObject <Employee>(CriteriaOperator.Parse("UserName == 'Sam'"));
if (managerSam == null)
{
managerSam = ObjectSpace.CreateObject <Employee>();
managerSam.UserName = "******";
managerSam.FirstName = "Sam";
managerSam.LastName = "Jackson";
managerSam.IsActive = true;
managerSam.SetPassword(string.Empty);
managerSam.Department = devDepartment;
managerSam.Roles.Add(GetManagerRole());
managerSam.Save();
}
//John is an ordinary user within the Sam's department.
Employee userJohn = ObjectSpace.FindObject <Employee>(CriteriaOperator.Parse("UserName == 'John'"));
if (userJohn == null)
{
userJohn = ObjectSpace.CreateObject <Employee>();
userJohn.UserName = "******";
userJohn.FirstName = "John";
userJohn.LastName = "Doe";
userJohn.IsActive = true;
userJohn.SetPassword(string.Empty);
userJohn.Department = devDepartment;
userJohn.Roles.Add(GetUserRole());
userJohn.Save();
}
//Mary is a manager of another department.
Employee managerMary = ObjectSpace.FindObject <Employee>(CriteriaOperator.Parse("UserName == 'Mary'"));
if (managerMary == null)
{
managerMary = ObjectSpace.CreateObject <Employee>();
managerMary.UserName = "******";
managerMary.FirstName = "Mary";
managerMary.LastName = "Tellinson";
managerMary.IsActive = true;
managerMary.SetPassword(string.Empty);
managerMary.Department = supDepartment;
managerMary.Roles.Add(GetManagerRole());
managerMary.Save();
}
//Joe is an ordinary user within the Mary's department.
Employee userJoe = ObjectSpace.FindObject <Employee>(CriteriaOperator.Parse("UserName == 'Joe'"));
if (userJoe == null)
{
userJoe = ObjectSpace.CreateObject <Employee>();
userJoe.UserName = "******";
userJoe.FirstName = "Joe";
userJoe.LastName = "Pitt";
userJoe.IsActive = true;
userJoe.SetPassword(string.Empty);
userJoe.Department = supDepartment;
userJoe.Roles.Add(GetUserRole());
userJoe.Save();
}
Employee userJason = ObjectSpace.FindObject <Employee>(CriteriaOperator.Parse("UserName == 'Joe'"));
if (userJoe == null)
{
userJoe = ObjectSpace.CreateObject <Employee>();
userJoe.UserName = "******";
userJoe.FirstName = "Joe";
userJoe.LastName = "Connor";
userJoe.IsActive = true;
userJoe.SetPassword(string.Empty);
userJoe.Department = supDepartment;
userJoe.Roles.Add(GetUserRole());
userJoe.Save();
}
//Create tasks for employees.
if (ObjectSpace.FindObject <EmployeeTask>(CriteriaOperator.Parse("Subject == 'Do homework'")) == null)
{
EmployeeTask task = ObjectSpace.CreateObject <EmployeeTask>();
task.Subject = "Do homework";
task.AssignedTo = managerSam;
task.DueDate = DateTime.Now;
task.Status = TaskStatus.NotStarted;
task.Description = "This is a task for Sam";
task.Save();
}
for (int i = 0; i < 99; i++)
{
if (ObjectSpace.FindObject <EmployeeTask>(CriteriaOperator.Parse($"Subject == 'Prepare {i} coffee for everyone'")) == null)
{
EmployeeTask task = ObjectSpace.CreateObject <EmployeeTask>();
task.Subject = $"Prepare {i} coffee for everyone";
task.AssignedTo = userJohn;
task.DueDate = DateTime.Now;
task.Status = TaskStatus.InProgress;
task.Description = "This is a task for John";
task.Save();
}
if (ObjectSpace.FindObject <EmployeeTask>(CriteriaOperator.Parse($"Subject == 'Read {i} latest news'")) == null)
{
EmployeeTask task = ObjectSpace.CreateObject <EmployeeTask>();
task.Subject = $"Read {i} latest news";
task.AssignedTo = managerMary;
task.DueDate = DateTime.Now;
task.Status = TaskStatus.Completed;
task.Description = "This is a task for Mary";
task.Save();
}
if (ObjectSpace.FindObject <EmployeeTask>(CriteriaOperator.Parse($"Subject == 'Book {i} tickets'")) == null)
{
EmployeeTask task = ObjectSpace.CreateObject <EmployeeTask>();
task.Subject = $"Book {i} tickets";
task.AssignedTo = userJoe;
task.DueDate = DateTime.Now;
task.Status = TaskStatus.Deferred;
task.Description = "This is a task for Joe";
task.Save();
}
}
ObjectSpace.CommitChanges();
DataGeneratorHelper.GenerateCountries(ObjectSpace);
DataGeneratorHelper.GenerateCustomers(ObjectSpace, 100);
ObjectSpace.CommitChanges();
DataGeneratorHelper.GenerateInvoices(ObjectSpace, 1000);
ObjectSpace.CommitChanges();
watch.Stop();
Console.WriteLine($"Update Execution Time: {watch.ElapsedMilliseconds} ms");
//string name = "MyName";
//DomainObject1 theObject = ObjectSpace.FindObject<DomainObject1>(CriteriaOperator.Parse("Name=?", name));
//if(theObject == null) {
// theObject = ObjectSpace.CreateObject<DomainObject1>();
// theObject.Name = name;
//}
//ObjectSpace.CommitChanges(); //Uncomment this line to persist created object(s).
}
