public void ManageDatabaseServiceInputViewModel_Properties()
{
var mod = new SqlServerModel();
var act = new DsfSqlServerDatabaseActivity()
{
SourceId = mod.Sources[0].Id,
Outputs = new List <IServiceOutputMapping> {
new ServiceOutputMapping("a", "b", "c"), new ServiceOutputMapping("d", "e", "f")
},
ServiceName = "dsfBob"
};
var sqlServer = new SqlServerDatabaseDesignerViewModel(ModelItemUtils.CreateModelItem(act), mod, new SynchronousAsyncWorker(), new ViewPropertyBuilder());
var vm = new ManageDatabaseServiceInputViewModel(sqlServer, mod);
var lst = new List <IServiceInput>();
vm.InputArea.Inputs = lst;
Assert.AreEqual(lst.Count, vm.InputArea.Inputs.Count);
var lsto = new List <IServiceOutputMapping>();
vm.OutputArea.Outputs = lsto;
Assert.AreEqual(lsto, vm.OutputArea.Outputs);
vm.TestResultsAvailable = true;
Assert.IsTrue(vm.TestResultsAvailable);
vm.OkSelected = true;
Assert.IsTrue(vm.OkSelected);
vm.IsTestResultsEmptyRows = true;
Assert.IsTrue(vm.IsTestResultsEmptyRows);
vm.IsTesting = true;
Assert.IsTrue(vm.IsTesting);
Assert.IsNotNull(vm.Model);
}
public void ManageDatabaseServiceInputViewModel_TestAction()
{
var called = false;
var calledOk = false;
var mod = new SqlServerModel();
var act = new DsfSqlServerDatabaseActivity
{
SourceId = mod.Sources[0].Id,
Outputs = new List <IServiceOutputMapping> {
new ServiceOutputMapping("a", "b", "c"), new ServiceOutputMapping("d", "e", "f")
},
ServiceName = "dsfBob"
};
var sqlServer = new SqlServerDatabaseDesignerViewModel(ModelItemUtils.CreateModelItem(act), mod, new SynchronousAsyncWorker(), new ViewPropertyBuilder());
var vm = new ManageDatabaseServiceInputViewModel(sqlServer, mod);
vm.TestAction = () => { called = true; };
vm.OkAction = () =>
{
calledOk = true;
};
vm.TestAction();
vm.OkAction();
//------------Assert Results-------------------------
Assert.IsTrue(called);
Assert.IsTrue(calledOk);
}
public void ManageDatabaseServiceInputViewModel_WithOneColumn_TestActionSetSourceAndTestClickOk()
{
//------------Setup for test--------------------------
var mod = new SqlServerModelWithOneColumnReturn();
var act = new DsfSqlServerDatabaseActivity();
var sqlServer = new SqlServerDatabaseDesignerViewModel(ModelItemUtils.CreateModelItem(act), mod, new SynchronousAsyncWorker(), new ViewPropertyBuilder());
var inputview = new ManageDatabaseServiceInputViewModel(sqlServer, mod);
inputview.Model = new DatabaseService()
{
Source = new DbSourceDefinition(), Action = new DbAction()
{
Inputs = new List <IServiceInput>(), Name = "bob"
},
};
inputview.TryExecuteTest();
//------------Execute Test---------------------------
Assert.IsTrue(inputview.TestPassed);
Assert.IsFalse(inputview.TestFailed);
Assert.AreEqual(string.Empty, inputview.TestMessage);
Assert.IsFalse(inputview.ShowTestMessage);
inputview.ExecuteOk();
//------------Execute Ok---------------------------
Assert.IsTrue(sqlServer.SourceRegion.IsEnabled);
Assert.IsTrue(sqlServer.InputArea.IsEnabled);
Assert.IsTrue(sqlServer.OutputsRegion.IsEnabled);
//------------Assert Results-------------------------
Assert.AreEqual(1, sqlServer.OutputsRegion.Outputs.Count);
}
public void ManageDatabaseServiceInputViewModel_RestoreRegion_DoesNothing()
{
//------------Setup for test--------------------------
var mod = new SqlServerModel();
var act = new DsfSqlServerDatabaseActivity();
var sqlServer = new SqlServerDatabaseDesignerViewModel(ModelItemUtils.CreateModelItem(act), mod, new SynchronousAsyncWorker(), new ViewPropertyBuilder());
var inputview = new ManageDatabaseServiceInputViewModel(sqlServer, mod);
inputview.Model = new DatabaseService();
//------------Execute Test---------------------------
inputview.RestoreRegion(null);
//------------Assert Results-------------------------
Assert.IsTrue(true, "Error RestoreRegion should do nothing");
}
public void ManageDatabaseServiceInputViewModelCloneRegion_ReturnsNull()
{
//------------Setup for test--------------------------
var mod = new SqlServerModel();
var act = new DsfSqlServerDatabaseActivity();
var sqlServer = new SqlServerDatabaseDesignerViewModel(ModelItemUtils.CreateModelItem(act), mod, new SynchronousAsyncWorker(), new ViewPropertyBuilder());
var inputview = new ManageDatabaseServiceInputViewModel(sqlServer, mod);
inputview.Model = new DatabaseService();
//------------Execute Test---------------------------
var clone = inputview.CloneRegion();
//------------Assert Results-------------------------
Assert.AreEqual(inputview, clone);
}
public void ManageDatabaseServiceInputViewModel_PropertyChangedHandler()
{
//------------Setup for test--------------------------
var mod = new SqlServerModel();
var act = new DsfSqlServerDatabaseActivity();
var called = false;
var sqlServer = new SqlServerDatabaseDesignerViewModel(ModelItemUtils.CreateModelItem(act), mod, new SynchronousAsyncWorker(), new ViewPropertyBuilder());
var inputview = new ManageDatabaseServiceInputViewModel(sqlServer, mod);
inputview.PropertyChanged += (sender, args) => called = true;
inputview.Model = new DatabaseService();
//------------Execute Test---------------------------
inputview.TryExecuteTest();
//------------Assert Results-------------------------
Assert.IsTrue(called);
}
public void ManageDatabaseServiceInputViewModelOkAction_Exception()
{
//------------Setup for test--------------------------
var mod = new SqlServerModel();
mod.HasRecError = true;
var act = new DsfSqlServerDatabaseActivity();
var sqlServer = new SqlServerDatabaseDesignerViewModel(ModelItemUtils.CreateModelItem(act), mod, new SynchronousAsyncWorker(), new ViewPropertyBuilder());
var inputview = new ManageDatabaseServiceInputViewModel(sqlServer, mod);
sqlServer.OutputsRegion.Outputs = null;
//------------Execute Test---------------------------
inputview.ExecuteOk();
//------------Assert Results-------------------------
Assert.IsTrue(inputview.Errors.Count == 1);
}
public void ManageDatabaseServiceInputViewModel_Ctor()
{
var mod = new SqlServerModel();
var act = new DsfSqlServerDatabaseActivity
{
SourceId = mod.Sources[0].Id,
Outputs = new List <IServiceOutputMapping> {
new ServiceOutputMapping("a", "b", "c"), new ServiceOutputMapping("d", "e", "f")
},
ServiceName = "dsfBob"
};
var sqlServer = new SqlServerDatabaseDesignerViewModel(ModelItemUtils.CreateModelItem(act), mod, new SynchronousAsyncWorker(), new ViewPropertyBuilder());
//------------Assert Results-------------------------
var vm = new ManageDatabaseServiceInputViewModel(sqlServer, mod);
Assert.IsNotNull(vm.CloseCommand);
Assert.IsNotNull(vm.CloseCommand);
}
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 GivenIHaveWorkflowWithMySqlDatabaseConnector(string workflowName, string activityName)
{
var environmentModel = _scenarioContext.Get <IServer>("server");
environmentModel.Connect();
_containerOps = TestLauncher.StartLocalMySQLContainer(Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location), "TestResults"));
CreateNewResourceModel(workflowName, environmentModel);
CreateDBServiceModel(environmentModel);
var dbServiceModel = _scenarioContext.Get <ManageDbServiceModel>("dbServiceModel");
var mySqlActivity = new DsfMySqlDatabaseActivity {
DisplayName = activityName
};
var modelItem = ModelItemUtils.CreateModelItem(mySqlActivity);
var mysqlDesignerViewModel = new MySqlDatabaseDesignerViewModel(modelItem, dbServiceModel, new SynchronousAsyncWorker(), new ViewPropertyBuilder());
var serviceInputViewModel = new ManageDatabaseServiceInputViewModel(mysqlDesignerViewModel, mysqlDesignerViewModel.Model);
_commonSteps.AddActivityToActivityList(workflowName, activityName, mySqlActivity);
DebugWriterSubscribe(environmentModel);
_scenarioContext.Add("viewModel", mysqlDesignerViewModel);
_scenarioContext.Add("parentName", workflowName);
}
public void ManageDatabaseServiceInputViewModel_TestActionSetSourceAndTestClickClose()
{
//------------Setup for test--------------------------
var mod = new SqlServerModel();
var act = new DsfSqlServerDatabaseActivity();
var sqlServer = new SqlServerDatabaseDesignerViewModel(ModelItemUtils.CreateModelItem(act), mod, new SynchronousAsyncWorker(), new ViewPropertyBuilder());
var inputview = new ManageDatabaseServiceInputViewModel(sqlServer, mod);
inputview.Model = new DatabaseService();
inputview.ExecuteClose();
//------------Execute Ok---------------------------
Assert.IsNull(inputview.OutputArea.Outputs);
Assert.IsTrue(sqlServer.SourceRegion.IsEnabled);
Assert.IsFalse(sqlServer.OutputsRegion.IsEnabled);
Assert.IsTrue(sqlServer.InputArea.IsEnabled);
Assert.IsTrue(sqlServer.ErrorRegion.IsEnabled);
Assert.IsFalse(sqlServer.ManageServiceInputViewModel.InputArea.IsEnabled);
//------------Assert Results-------------------------
}
public void ManageDatabaseServiceInputViewModel_TestActionSetSourceAndReturnNoDataMessage()
{
//------------Setup for test--------------------------
var mod = new SqlServerModel();
mod.ReturnsNoColumns = true;
var act = new DsfSqlServerDatabaseActivity();
var sqlServer = new SqlServerDatabaseDesignerViewModel(ModelItemUtils.CreateModelItem(act), mod, new SynchronousAsyncWorker(), new ViewPropertyBuilder());
var inputview = new ManageDatabaseServiceInputViewModel(sqlServer, mod);
inputview.Model = new DatabaseService()
{
Source = new DbSourceDefinition(), Action = new DbAction()
{
Inputs = new List <IServiceInput>(), Name = ""
},
};
inputview.TryExecuteTest();
Assert.IsTrue(inputview.TestPassed);
Assert.IsFalse(inputview.TestFailed);
Assert.AreEqual("No data returned. ", inputview.TestMessage);
Assert.IsTrue(inputview.ShowTestMessage);
}
