public void ImportDataFromExcel_TestBooleanConstraints_Valid( ) { EntityType type = ImportTestHelper.CreateTestBooleanEntityType( ); ImportRun importRun = ImportTestHelper.RunTest(type, "Boolean.csv", ImportFormat.CSV); //check for the import status Assert.That(importRun.ImportRunStatus_Enum, Is.EqualTo(WorkflowRunState_Enumeration.WorkflowRunCompleted), importRun.ImportMessages); Assert.That(importRun.ImportRecordsSucceeded, Is.EqualTo(13)); Assert.That(importRun.ImportRecordsTotal, Is.EqualTo(14)); Assert.That(importRun.ImportRecordsFailed, Is.EqualTo(1)); Assert.That(importRun.ImportMessages, Contains.Substring("Line 15: Value for 'Boolean_False' was formatted incorrectly")); var instances = Entity.GetInstancesOfType(type, false); Assert.That(instances, Has.Count.EqualTo(13)); }
public void ImportDataFromCSV_TestNumericConstraints_Valid( ) { EntityType type = ImportTestHelper.CreateTestNumericEntityType( ); ImportRun importRun = ImportTestHelper.RunTest(type, "Numeric.csv", ImportFormat.CSV); //check for the import status Assert.That(importRun.ImportRunStatus_Enum, Is.EqualTo(WorkflowRunState_Enumeration.WorkflowRunCompleted), importRun.ImportMessages); Assert.That(importRun.ImportRecordsSucceeded, Is.EqualTo(7)); Assert.That(importRun.ImportRecordsTotal, Is.EqualTo(10)); Assert.That(importRun.ImportRecordsFailed, Is.EqualTo(3)); Assert.That(importRun.ImportMessages, Contains.Substring("Line 2: 'Numeric' value must not be less than 10")); Assert.That(importRun.ImportMessages, Contains.Substring("Line 7: 'Numeric' value is required")); Assert.That(importRun.ImportMessages, Contains.Substring("Line 11: 'Numeric' value must not be greater than 99")); var instances = Entity.GetInstancesOfType(type, false); Assert.That(instances, Has.Count.EqualTo(7)); }
public void ImportDataFromCSV_TestStringConstraints_Valid( ) { EntityType type = ImportTestHelper.CreateTestStringEntityType( ); ImportRun importRun = ImportTestHelper.RunTest(type, "String.csv", ImportFormat.CSV); //check for the import status Assert.That(importRun.ImportRunStatus_Enum, Is.EqualTo(WorkflowRunState_Enumeration.WorkflowRunCompleted), importRun.ImportMessages); Assert.That(importRun.ImportRecordsSucceeded, Is.EqualTo(5)); Assert.That(importRun.ImportRecordsTotal, Is.EqualTo(9)); Assert.That(importRun.ImportRecordsFailed, Is.EqualTo(4)); Assert.That(importRun.ImportMessages, Contains.Substring("Line 2: 'State' length must not be less than 3")); Assert.That(importRun.ImportMessages, Contains.Substring("Line 7: 'City' value is required.")); Assert.That(importRun.ImportMessages, Contains.Substring("Line 8: 'City' value is required.")); Assert.That(importRun.ImportMessages, Contains.Substring("Line 3: 'String1' length must not be greater than 20")); // this should say line 4, but there's a problem in the .Net TextFieldParser var instances = Entity.GetInstancesOfType(type, false); Assert.That(instances, Has.Count.EqualTo(5)); }
public void ImportDataFromExcel_TestDecimalConstraints_Valid( ) { EntityType type = ImportTestHelper.CreateTestDecimalEntityType( ); ImportRun importRun = ImportTestHelper.RunTest(type, ExcelFile, ImportFormat.Excel, "Decimal"); //check for the import status Assert.That(importRun.ImportRunStatus_Enum, Is.EqualTo(WorkflowRunState_Enumeration.WorkflowRunCompleted), importRun.ImportMessages); Assert.That(importRun.ImportRecordsSucceeded, Is.EqualTo(5), importRun.ImportMessages); Assert.That(importRun.ImportRecordsTotal, Is.EqualTo(9)); Assert.That(importRun.ImportRecordsFailed, Is.EqualTo(4)); Assert.That(importRun.ImportMessages, Contains.Substring("Row 3: 'Decimal' value must not be less than 10")); Assert.That(importRun.ImportMessages, Contains.Substring("Row 6: 'Decimal' value must not be greater than 100")); Assert.That(importRun.ImportMessages, Contains.Substring("Row 7: 'Decimal' value is required")); Assert.That(importRun.ImportMessages, Contains.Substring("Row 8: 'Decimal' value must not be less than 10")); var instances = Entity.GetInstancesOfType(type, false); Assert.That(instances, Has.Count.EqualTo(5)); }
public void ImportDataFromCSV_TestDateConstraints_Valid( ) { EntityType type = ImportTestHelper.CreateTestDateEntityType( ); ImportRun importRun = ImportTestHelper.RunTest(type, "DateTime.csv", ImportFormat.CSV); //check for the import status Assert.That(importRun.ImportRunStatus_Enum, Is.EqualTo(WorkflowRunState_Enumeration.WorkflowRunCompleted), importRun.ImportMessages); Assert.That(importRun.ImportRecordsSucceeded, Is.EqualTo(5)); Assert.That(importRun.ImportRecordsTotal, Is.EqualTo(10)); Assert.That(importRun.ImportRecordsFailed, Is.EqualTo(5)); Assert.That(importRun.ImportMessages, Contains.Substring("Line 3: 'Entered Date' value must not be less than 1/06/2012")); Assert.That(importRun.ImportMessages, Contains.Substring("Line 6: 'Entered Date' value must not be greater than 30/06/2012")); Assert.That(importRun.ImportMessages, Contains.Substring("Line 7: 'Entered Date' value is required.")); Assert.That(importRun.ImportMessages, Contains.Substring("Line 8: 'Entered Date' value must not be less than 1/06/2012")); Assert.That(importRun.ImportMessages, Contains.Substring("Line 9: 'Entered Date' value must not be greater than 30/06/2012")); var instances = Entity.GetInstancesOfType(type, false); Assert.That(instances, Has.Count.EqualTo(5)); }