public void Equals_Given_SameOutputs_DifferentIndexes_ActivityTools_AreNotEqual()
{
//---------------Set up test pack-------------------
var uniqueId = Guid.NewGuid().ToString();
var outputs = new List <Common.Interfaces.DB.IServiceOutputMapping>
{
new ServiceOutputMapping("d", "e", "f"),
new ServiceOutputMapping("a", "b", "c")
};
var outputs2 = new List <Common.Interfaces.DB.IServiceOutputMapping>
{
new ServiceOutputMapping("a", "b", "c"),
new ServiceOutputMapping("d", "e", "f")
};
var activity = new DsfPostgreSqlActivity()
{
UniqueID = uniqueId, Outputs = outputs
};
var activity1 = new DsfPostgreSqlActivity()
{
UniqueID = uniqueId, Outputs = outputs2
};
//---------------Assert Precondition----------------
Assert.IsNotNull(activity);
//---------------Execute Test ----------------------
var @equals = activity.Equals(activity1);
//---------------Test Result -----------------------
Assert.IsFalse(@equals);
}
public void PostgreSql_TestActionSetSourceAndTestClickOkHasQueryStringAndHeaders()
{
//------------Setup for test--------------------------
var mod = new PostgreSqlModel();
var act = new DsfPostgreSqlActivity();
//------------Execute Test---------------------------
var model = new PostgreSqlDatabaseDesignerViewModel(ModelItemUtils.CreateModelItem(act), mod, new SynchronousAsyncWorker());
model.ManageServiceInputViewModel = new InputViewForTest(model, mod);
model.SourceRegion.SelectedSource = model.SourceRegion.Sources.First();
model.ActionRegion.SelectedAction = model.ActionRegion.Actions.First();
model.InputArea.Inputs.Add(new ServiceInput("[[a]]", "asa"));
#pragma warning disable 4014
model.TestInputCommand.Execute();
#pragma warning restore 4014
model.ManageServiceInputViewModel.TestCommand.Execute(null);
model.ManageServiceInputViewModel.IsEnabled = true;
model.ManageServiceInputViewModel.OutputArea.Outputs = new List <IServiceOutputMapping> {
new ServiceOutputMapping("a", "b", "c"), new ServiceOutputMapping("a", "b", "c"), new ServiceOutputMapping("a", "b", "c")
};
model.ManageServiceInputViewModel.OkCommand.Execute(null);
#pragma warning restore 4014
//------------Assert Results-------------------------
Assert.IsFalse(model.SourceRegion.IsEnabled);
Assert.IsFalse(model.OutputsRegion.IsEnabled);
Assert.IsFalse(model.InputArea.IsEnabled);
Assert.IsFalse(model.ErrorRegion.IsEnabled);
Assert.IsTrue(model.ManageServiceInputViewModel.InputArea.Inputs.Count == 2);
Assert.IsTrue(model.ManageServiceInputViewModel.InputArea.Inputs.First().Name == "[[fname]]");
Assert.IsTrue(model.ManageServiceInputViewModel.InputArea.Inputs.Last().Name == "[[a]]");
}
public void PostgreSql_TestActionSetSourceAndTestClickOkHasMappingsErrorFromServer()
{
//------------Setup for test--------------------------
var mod = new PostgreSqlModel();
mod.HasRecError = true;
var act = new DsfPostgreSqlActivity();
//------------Execute Test---------------------------
var model = new PostgreSqlDatabaseDesignerViewModel(ModelItemUtils.CreateModelItem(act), mod, new SynchronousAsyncWorker());
model.ManageServiceInputViewModel = new InputViewForTest(model, mod);
model.SourceRegion.SelectedSource = model.SourceRegion.Sources.First();
#pragma warning disable 4014
model.TestInputCommand.Execute();
model.ManageServiceInputViewModel.TestCommand.Execute(null);
model.ManageServiceInputViewModel.IsEnabled = true;
model.ManageServiceInputViewModel.OutputArea.Outputs = new List <IServiceOutputMapping> {
new ServiceOutputMapping("a", "b", "c"), new ServiceOutputMapping("a", "b", "c"), new ServiceOutputMapping("a", "b", "c")
};
model.ManageServiceInputViewModel.OkCommand.Execute(null);
#pragma warning restore 4014
//------------Assert Results-------------------------
Assert.IsTrue(model.ErrorRegion.IsEnabled);
}
public void DataGridActivityFindMissingStrategy_GetActivityFields_PostgreSQL_ShouldReturnResults()
{
//------------Setup for test--------------------------
Dev2FindMissingStrategyFactory fac = new Dev2FindMissingStrategyFactory();
IFindMissingStrategy strategy = fac.CreateFindMissingStrategy(enFindMissingType.DataGridActivity);
var activity = new DsfPostgreSqlActivity
{
Inputs = new List <IServiceInput> {
new ServiceInput("Input1", "[[InputValue1]]"), new ServiceInput("Input2", "[[InputValue2]]"), new ServiceInput("Input3", "[[InputValue3]]")
},
Outputs = new List <IServiceOutputMapping> {
new ServiceOutputMapping("Output1", "OutputValue1", "rec"), new ServiceOutputMapping("Output2", "OutputValue2", "rec")
},
OnErrorVariable = "[[err]]",
OnErrorWorkflow = "[[errSvc]]"
};
//------------Execute Test---------------------------
var fields = strategy.GetActivityFields(activity);
//------------Assert Results-------------------------
Assert.AreEqual(7, fields.Count);
Assert.IsTrue(fields.Contains("[[InputValue1]]"));
Assert.IsTrue(fields.Contains("[[InputValue2]]"));
Assert.IsTrue(fields.Contains("[[InputValue3]]"));
Assert.IsTrue(fields.Contains("[[rec().OutputValue1]]"));
Assert.IsTrue(fields.Contains("[[rec().OutputValue2]]"));
Assert.IsTrue(fields.Contains("[[err]]"));
Assert.IsTrue(fields.Contains("[[errSvc]]"));
}
public void Equals_Given_SameInputsDifferentIndexes_ActivityTools_AreNotEqual()
{
//---------------Set up test pack-------------------
var uniqueId = Guid.NewGuid().ToString();
var inputs = new List <Common.Interfaces.DB.IServiceInput>
{
new ServiceInput("Input2", "[[InputValue2]]"),
new ServiceInput("Input1", "[[InputValue1]]")
};
var inputs2 = new List <Common.Interfaces.DB.IServiceInput>
{
new ServiceInput("Input1", "[[InputValue1]]"),
new ServiceInput("Input2", "[[InputValue2]]")
};
var activity = new DsfPostgreSqlActivity()
{
UniqueID = uniqueId, Inputs = inputs
};
var activity1 = new DsfPostgreSqlActivity()
{
UniqueID = uniqueId, Inputs = inputs2
};
//---------------Assert Precondition----------------
Assert.IsNotNull(activity);
//---------------Execute Test ----------------------
var @equals = activity.Equals(activity1);
//---------------Test Result -----------------------
Assert.IsFalse(@equals);
}
public PostgreSqlDatabaseDesignerViewModel GetViewModel()
{
var mod = new PostgreSqlModel();
var act = new DsfPostgreSqlActivity();
//------------Execute Test---------------------------
return(new PostgreSqlDatabaseDesignerViewModel(ModelItemUtils.CreateModelItem(act), mod, new SynchronousAsyncWorker()));
}
public void UniqueIDDifferent_EmptyPostgreDatabase_Object_Is_Not_Equal()
{
//---------------Set up test pack-------------------
var uniqueId = Guid.NewGuid().ToString();
var activity1 = new DsfPostgreSqlActivity();
var postgreDatabase = new DsfPostgreSqlActivity();
//---------------Assert Precondition----------------
Assert.IsNotNull(activity1);
//---------------Execute Test ----------------------
var @equals = activity1.Equals(postgreDatabase);
//---------------Test Result -----------------------
Assert.IsFalse(@equals);
}
public void SQLServer_VerifyCommandTimeout()
{
//------------Setup for test--------------------------
var mod = new PostgreSqlModel();
var act = new DsfPostgreSqlActivity();
//------------Execute Test---------------------------
using (var vm = new PostgreSqlDatabaseDesignerViewModel(ModelItemUtils.CreateModelItem(act), mod, new SynchronousAsyncWorker(), new ViewPropertyBuilder()))
{
vm.InputArea.CommandTimeout = 321;
//------------Assert Results-------------------------
var dbService = vm.ToModel();
Assert.AreEqual(321, dbService.CommandTimeout);
}
}
public void PostgreSql_Refresh_ShouldLoadRefreshActions()
{
//------------Setup for test--------------------------
var id = Guid.NewGuid();
var mod = new PostgreSqlModel();
var act = new DsfPostgreSqlActivity();
var sqlServer = new PostgreSqlDatabaseDesignerViewModel(ModelItemUtils.CreateModelItem(act), mod, new SynchronousAsyncWorker());
sqlServer.ManageServiceInputViewModel = new InputViewForTest(sqlServer, mod);
sqlServer.SourceRegion.SelectedSource = sqlServer.SourceRegion.Sources.First();
//------------Execute Test---------------------------
sqlServer.ActionRegion.RefreshActionsCommand.Execute(null);
//------------Assert Results-------------------------
Assert.IsTrue(sqlServer.SourceRegion.IsEnabled);
Assert.AreEqual(1, sqlServer.ActionRegion.Actions.Count);
}
public void PostgreSql_TestActionSetSource()
{
//------------Setup for test--------------------------
var mod = new PostgreSqlModel();
var act = new DsfPostgreSqlActivity();
//------------Execute Test---------------------------
var model = new PostgreSqlDatabaseDesignerViewModel(ModelItemUtils.CreateModelItem(act), mod, new SynchronousAsyncWorker());
model.ManageServiceInputViewModel = new InputViewForTest(model, mod);
model.SourceRegion.SelectedSource = model.SourceRegion.Sources.First();
//------------Assert Results-------------------------
Assert.IsTrue(model.SourceRegion.IsEnabled);
Assert.IsFalse(model.OutputsRegion.IsEnabled);
Assert.IsFalse(model.InputArea.IsEnabled);
Assert.IsTrue(model.ErrorRegion.IsEnabled);
}
public void GivenIDragAPostgresSqlServerDatabaseConnector()
{
var postgresActivity = new DsfPostgreSqlActivity();
var modelItem = ModelItemUtils.CreateModelItem(postgresActivity);
var mockServiceInputViewModel = new Mock <IManageServiceInputViewModel>();
var mockDbServiceModel = new Mock <IDbServiceModel>();
var mockEnvironmentRepo = new Mock <IServerRepository>();
var mockEnvironmentModel = new Mock <IServer>();
mockEnvironmentModel.Setup(model => model.IsConnected).Returns(true);
mockEnvironmentModel.Setup(model => model.IsLocalHost).Returns(true);
mockEnvironmentModel.Setup(model => model.EnvironmentID).Returns(Guid.Empty);
mockEnvironmentModel.Setup(model => model.IsLocalHostCheck()).Returns(false);
mockEnvironmentRepo.Setup(repository => repository.ActiveServer).Returns(mockEnvironmentModel.Object);
mockEnvironmentRepo.Setup(repository => repository.FindSingle(It.IsAny <Expression <Func <IServer, bool> > >())).Returns(mockEnvironmentModel.Object);
_postgresSqlSource = new DbSourceDefinition
{
Name = "DemoPostgres",
Type = enSourceType.PostgreSQL,
ServerName = "Localhost",
UserName = "******",
Password = "******",
AuthenticationType = Runtime.ServiceModel.Data.AuthenticationType.User
};
var dbSources = new ObservableCollection <IDbSource> {
_postgresSqlSource
};
mockDbServiceModel.Setup(model => model.RetrieveSources()).Returns(dbSources);
mockDbServiceModel.Setup(model => model.GetActions(_postgresSqlSource));
mockServiceInputViewModel.SetupAllProperties();
var postgresDesignerViewModel = new PostgreSqlDatabaseDesignerViewModel(modelItem, mockDbServiceModel.Object, new SynchronousAsyncWorker(), new ViewPropertyBuilder());
_scenarioContext.Add("viewModel", postgresDesignerViewModel);
_scenarioContext.Add("mockServiceInputViewModel", mockServiceInputViewModel);
_scenarioContext.Add("mockDbServiceModel", mockDbServiceModel);
}
public void UniqueIDEquals_EmptyPostgreDatabase_Object_Is_Equal()
{
//---------------Set up test pack-------------------
var uniqueId = Guid.NewGuid().ToString();
var postgreDatabase = new DsfPostgreSqlActivity()
{
UniqueID = uniqueId
};
var activity = new DsfPostgreSqlActivity()
{
UniqueID = uniqueId
};
//---------------Assert Precondition----------------
Assert.IsNotNull(postgreDatabase);
//---------------Execute Test ----------------------
var equals = postgreDatabase.Equals(activity);
//---------------Test Result -----------------------
Assert.IsTrue(@equals);
}
public void Equals_Given_Same_DisplayName_IsEqual()
{
//---------------Set up test pack-------------------
var uniqueId = Guid.NewGuid().ToString();
var activity1 = new DsfPostgreSqlActivity()
{
UniqueID = uniqueId, DisplayName = "a"
};
var postgreDatabase = new DsfPostgreSqlActivity()
{
UniqueID = uniqueId, DisplayName = "a"
};
//---------------Assert Precondition----------------
Assert.IsNotNull(activity1);
//---------------Execute Test ----------------------
var @equals = activity1.Equals(postgreDatabase);
//---------------Test Result -----------------------
Assert.IsTrue(@equals);
}
public void GivenIHaveWorkflowWithPostgresDatabaseConnector(string workflowName, string activityName)
{
var environmentModel = _scenarioContext.Get <IServer>("server");
environmentModel.Connect();
CreateNewResourceModel(workflowName, environmentModel);
CreateDBServiceModel(environmentModel);
var dbServiceModel = _scenarioContext.Get <ManageDbServiceModel>("dbServiceModel");
var posgreActivity = new DsfPostgreSqlActivity {
DisplayName = activityName
};
var modelItem = ModelItemUtils.CreateModelItem(posgreActivity);
var posgreDesignerViewModel = new PostgreSqlDatabaseDesignerViewModel(modelItem, dbServiceModel, new SynchronousAsyncWorker(), new ViewPropertyBuilder());
var serviceInputViewModel = new ManageDatabaseServiceInputViewModel(posgreDesignerViewModel, posgreDesignerViewModel.Model);
_commonSteps.AddActivityToActivityList(workflowName, activityName, posgreActivity);
DebugWriterSubscribe(environmentModel);
_scenarioContext.Add("viewModel", posgreDesignerViewModel);
_scenarioContext.Add("parentName", workflowName);
}
public void Equals_Given_Different_ProcedureName_Is_Not_Equal()
{
//---------------Set up test pack-------------------
var uniqueId = Guid.NewGuid().ToString();
var activity1 = new DsfPostgreSqlActivity()
{
UniqueID = uniqueId, ProcedureName = "A"
};
var postgreDatabase = new DsfPostgreSqlActivity()
{
UniqueID = uniqueId, ProcedureName = "ass"
};
//---------------Assert Precondition----------------
Assert.IsNotNull(activity1);
//---------------Execute Test ----------------------
var @equals = activity1.Equals(postgreDatabase);
//---------------Test Result -----------------------
Assert.IsFalse(@equals);
}
public void Equals_Given_Same_SourceId_IsEqual()
{
//---------------Set up test pack-------------------
var uniqueId = Guid.NewGuid().ToString();
var sourceId = Guid.NewGuid();;
var activity1 = new DsfPostgreSqlActivity()
{
UniqueID = uniqueId, SourceId = sourceId
};
var activity = new DsfPostgreSqlActivity()
{
UniqueID = uniqueId, SourceId = sourceId
};
//---------------Assert Precondition----------------
Assert.IsNotNull(activity1);
//---------------Execute Test ----------------------
var @equals = activity1.Equals(activity);
//---------------Test Result -----------------------
Assert.IsTrue(@equals);
}
public void Equals_Given_SameOutputs_ActivityTools_AreEqual()
{
//---------------Set up test pack-------------------
var uniqueId = Guid.NewGuid().ToString();
var outputs = new List <Common.Interfaces.DB.IServiceOutputMapping>();
var activity = new DsfPostgreSqlActivity()
{
UniqueID = uniqueId, Outputs = outputs
};
var activity1 = new DsfPostgreSqlActivity()
{
UniqueID = uniqueId, Outputs = outputs
};
//---------------Assert Precondition----------------
Assert.IsNotNull(activity);
//---------------Execute Test ----------------------
var @equals = activity.Equals(activity1);
//---------------Test Result -----------------------
Assert.IsTrue(@equals);
}
public static DsfPostgreSqlActivity GetDsfPostgreSqlActivity(DsfDatabaseActivity dbActivity, DbService service, DbSource source)
{
DsfPostgreSqlActivity dsfSqlServerDatabaseActivity = null;
if (dbActivity != null)
{
dsfSqlServerDatabaseActivity = new DsfPostgreSqlActivity
{
ResourceID = dbActivity.ResourceID,
DisplayName = dbActivity.DisplayName,
ProcedureName = service.Method.ExecuteAction,
SourceId = source.ResourceID,
Inputs = TranslateInputMappingToInputs(dbActivity.InputMapping),
Outputs = TranslateOutputMappingToOutputs(dbActivity.OutputMapping),
ToolboxFriendlyName = dbActivity.ToolboxFriendlyName,
IconPath = dbActivity.IconPath,
ServiceName = dbActivity.ServiceName,
DataTags = dbActivity.DataTags,
ResultValidationRequiredTags = dbActivity.ResultValidationRequiredTags,
ResultValidationExpression = dbActivity.ResultValidationExpression,
FriendlySourceName = dbActivity.FriendlySourceName,
EnvironmentID = dbActivity.EnvironmentID,
Type = dbActivity.Type,
ActionName = dbActivity.ActionName,
RunWorkflowAsync = dbActivity.RunWorkflowAsync,
Category = dbActivity.Category,
ServiceUri = dbActivity.ServiceUri,
ServiceServer = dbActivity.ServiceServer,
UniqueID = dbActivity.UniqueID,
ParentServiceName = dbActivity.ParentServiceName,
ParentServiceID = dbActivity.ParentServiceID,
ParentWorkflowInstanceId = dbActivity.ParentWorkflowInstanceId,
ParentInstanceID = dbActivity.ParentInstanceID,
};
}
return(dsfSqlServerDatabaseActivity);
}
public void GivenIOpenWorkflowWithPostgreSqlConnector()
{
var sourceId = Guid.NewGuid();
var inputs = new List <IServiceInput> {
new ServiceInput("Prefix", "[[Prefix]]")
};
var outputs = new List <IServiceOutputMapping>
{
new ServiceOutputMapping("name", "name", "getemployees"),
};
var postgresActivity = new DsfPostgreSqlActivity();
var modelItem = ModelItemUtils.CreateModelItem(postgresActivity);
var mockServiceInputViewModel = new Mock <IManageServiceInputViewModel>();
var mockDbServiceModel = new Mock <IDbServiceModel>();
var mockEnvironmentRepo = new Mock <IServerRepository>();
var mockEnvironmentModel = new Mock <IServer>();
mockEnvironmentModel.Setup(model => model.IsConnected).Returns(true);
mockEnvironmentModel.Setup(model => model.IsLocalHost).Returns(true);
mockEnvironmentModel.Setup(model => model.EnvironmentID).Returns(Guid.Empty);
mockEnvironmentModel.Setup(model => model.IsLocalHostCheck()).Returns(false);
mockEnvironmentRepo.Setup(repository => repository.ActiveServer).Returns(mockEnvironmentModel.Object);
mockEnvironmentRepo.Setup(repository => repository.FindSingle(It.IsAny <Expression <Func <IServer, bool> > >())).Returns(mockEnvironmentModel.Object);
_postgresSqlSource = new DbSourceDefinition
{
Name = "postgressql",
Type = enSourceType.PostgreSQL,
ServerName = "Localhost",
UserName = "******",
Password = "******",
AuthenticationType = Runtime.ServiceModel.Data.AuthenticationType.User
};
_testingDbSource = new DbSourceDefinition
{
Name = "testingDBSrc",
Type = enSourceType.PostgreSQL,
Id = sourceId
};
_selectedAction = new DbAction
{
Name = "getemployees",
Inputs = new List <IServiceInput> {
new ServiceInput("fname", "")
}
};
_getEmployees = new DbAction {
Name = "getemployees"
};
_getEmployees.Inputs = inputs;
var dbSources = new ObservableCollection <IDbSource> {
_testingDbSource, _postgresSqlSource
};
mockDbServiceModel.Setup(model => model.RetrieveSources()).Returns(dbSources);
mockDbServiceModel.Setup(model => model.GetActions(It.IsAny <IDbSource>())).Returns(new List <IDbAction> {
_getEmployees, _selectedAction
});
mockServiceInputViewModel.SetupAllProperties();
var postgresDesignerViewModel = new PostgreSqlDatabaseDesignerViewModel(modelItem, mockDbServiceModel.Object, new SynchronousAsyncWorker(), new ViewPropertyBuilder());
_scenarioContext.Add("viewModel", postgresDesignerViewModel);
_scenarioContext.Add("mockServiceInputViewModel", mockServiceInputViewModel);
_scenarioContext.Add("mockDbServiceModel", mockDbServiceModel);
}
