public void Oracle_Ctor_EmptyModelItem()
{
//------------Setup for test--------------------------
CustomContainer.LoadedTypes = new List <Type>()
{
typeof(ManageDbServiceModel)
};
var mockMainViewModel = new Mock <IShellViewModel>();
var mockHelpViewModel = new Mock <IHelpWindowViewModel>();
mockHelpViewModel.Setup(model => model.UpdateHelpText(It.IsAny <string>())).Verifiable();
mockMainViewModel.Setup(model => model.HelpViewModel).Returns(mockHelpViewModel.Object);
var server = new Mock <IServer>();
var updatemanager = new Mock <IStudioUpdateManager>();
var queryManager = new Mock <IQueryManager>();
queryManager.Setup(manager => manager.FetchDbSources()).Returns(new List <IDbSource>());
server.Setup(server1 => server1.UpdateRepository).Returns(updatemanager.Object);
server.Setup(server1 => server1.QueryProxy).Returns(queryManager.Object);
mockMainViewModel.Setup(model => model.ActiveServer).Returns(server.Object);
CustomContainer.Register(mockMainViewModel.Object);
var act = new DsfOracleDatabaseActivity();
//------------Execute Test---------------------------
var oracle = new OracleDatabaseDesignerViewModel(ModelItemUtils.CreateModelItem(act), new SynchronousAsyncWorker(), new ViewPropertyBuilder());
//------------Assert Results-------------------------
Assert.IsTrue(oracle.SourceRegion.IsEnabled);
Assert.IsFalse(oracle.OutputsRegion.IsEnabled);
Assert.IsFalse(oracle.InputArea.IsEnabled);
Assert.IsTrue(oracle.ErrorRegion.IsEnabled);
}
public void Oracle_MethodName_ClearErrors()
{
//------------Setup for test--------------------------
CustomContainer.LoadedTypes = new List <Type>()
{
typeof(ManageDbServiceModel)
};
var mockMainViewModel = new Mock <IShellViewModel>();
var mockHelpViewModel = new Mock <IHelpWindowViewModel>();
mockHelpViewModel.Setup(model => model.UpdateHelpText(It.IsAny <string>())).Verifiable();
mockMainViewModel.Setup(model => model.HelpViewModel).Returns(mockHelpViewModel.Object);
var server = new Mock <IServer>();
var updatemanager = new Mock <IStudioUpdateManager>();
var queryManager = new Mock <IQueryManager>();
queryManager.Setup(manager => manager.FetchDbSources()).Returns(new List <IDbSource>());
server.Setup(server1 => server1.UpdateRepository).Returns(updatemanager.Object);
server.Setup(server1 => server1.QueryProxy).Returns(queryManager.Object);
mockMainViewModel.Setup(model => model.ActiveServer).Returns(server.Object);
CustomContainer.Register(mockMainViewModel.Object);
var mod = new OracleModel();
var act = new DsfOracleDatabaseActivity();
var oracle = new OracleDatabaseDesignerViewModel(ModelItemUtils.CreateModelItem(act), new SynchronousAsyncWorker(), new ViewPropertyBuilder());
//------------Execute Test---------------------------
oracle.ClearValidationMemoWithNoFoundError();
//------------Assert Results-------------------------
Assert.IsNull(oracle.Errors);
Assert.AreEqual(oracle.DesignValidationErrors.Count, 1);
}
public void Oracle_TestActionSetSourceAndTestClickOkHasMappings()
{
//------------Setup for test--------------------------
CustomContainer.LoadedTypes = new List <Type>()
{
typeof(ManageDbServiceModel)
};
var mockMainViewModel = new Mock <IShellViewModel>();
var mockHelpViewModel = new Mock <IHelpWindowViewModel>();
mockHelpViewModel.Setup(model => model.UpdateHelpText(It.IsAny <string>())).Verifiable();
mockMainViewModel.Setup(model => model.HelpViewModel).Returns(mockHelpViewModel.Object);
var server = new Mock <IServer>();
var updatemanager = new Mock <IStudioUpdateManager>();
var queryManager = new Mock <IQueryManager>();
queryManager.Setup(manager => manager.FetchDbSources()).Returns(new List <IDbSource>());
server.Setup(server1 => server1.UpdateRepository).Returns(updatemanager.Object);
server.Setup(server1 => server1.QueryProxy).Returns(queryManager.Object);
mockMainViewModel.Setup(model => model.ActiveServer).Returns(server.Object);
CustomContainer.Register(mockMainViewModel.Object);
var mod = new OracleModel();
var act = new DsfOracleDatabaseActivity();
//------------Execute Test---------------------------
var oracle = new OracleDatabaseDesignerViewModel(ModelItemUtils.CreateModelItem(act), new SynchronousAsyncWorker(), new ViewPropertyBuilder());
oracle.ManageServiceInputViewModel = new InputViewForTest(oracle, mod);
oracle.SourceRegion.SelectedSource = mod.Sources.First();
#pragma warning disable 4014
oracle.TestInputCommand.Execute(null);
oracle.ManageServiceInputViewModel.TestCommand.Execute(null);
oracle.ManageServiceInputViewModel.IsEnabled = true;
oracle.ManageServiceInputViewModel.OutputArea.Outputs = new List <IServiceOutputMapping> {
new ServiceOutputMapping("a", "b", "c"), new ServiceOutputMapping("a", "b", "c"), new ServiceOutputMapping("a", "b", "c")
};
oracle.ManageServiceInputViewModel.Model = new DatabaseService()
{
Action = new DbAction()
{
Inputs = new List <IServiceInput>(), Name = "bob"
}
};
oracle.ManageServiceInputViewModel.OkCommand.Execute(null);
#pragma warning restore 4014
//------------Assert Results-------------------------
Assert.IsTrue(oracle.SourceRegion.IsEnabled);
Assert.IsTrue(oracle.OutputsRegion.IsEnabled);
Assert.IsTrue(oracle.InputArea.IsEnabled);
Assert.IsTrue(oracle.ErrorRegion.IsEnabled);
Assert.IsFalse(oracle.ManageServiceInputViewModel.InputArea.IsEnabled);
Assert.AreEqual(0, oracle.ManageServiceInputViewModel.Errors.Count);
}
public void Oracle_VerifyCommandTimeout()
{
//------------Setup for test--------------------------
var mod = new OracleModel();
var act = new DsfOracleDatabaseActivity();
//------------Execute Test---------------------------
using (var vm = new OracleDatabaseDesignerViewModel(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 GivenIOpenNewOracleDbWorkflow()
{
var oracleServerActivity = new DsfOracleDatabaseActivity();
var modelItem = ModelItemUtils.CreateModelItem(oracleServerActivity);
var mockInputArea = new Mock <IGenerateInputArea>();
var mockOutputArea = new Mock <IGenerateOutputArea>();
var mockDatabaseInputViewModel = new Mock <IManageDatabaseInputViewModel>();
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);
_greenPointSource = new DbSourceDefinition
{
Name = "GreenPoint",
Type = enSourceType.Oracle,
ServerName = "Localhost",
UserName = "******",
Password = "******",
AuthenticationType = Runtime.ServiceModel.Data.AuthenticationType.User
};
var dbSources = new ObservableCollection <IDbSource> {
_greenPointSource
};
mockDbServiceModel.Setup(model => model.RetrieveSources()).Returns(dbSources);
var mockAction = new Mock <Action>(MockBehavior.Default);
mockDatabaseInputViewModel.SetupGet(model => model.InputArea).Returns(mockInputArea.Object);
mockDatabaseInputViewModel.SetupGet(model => model.OutputArea).Returns(mockOutputArea.Object);
mockDatabaseInputViewModel.Setup(model => model.TestAction).Returns(mockAction.Object);
mockDatabaseInputViewModel.Setup(model => model.OkAction).Returns(mockAction.Object);
var oracleServerDesignerViewModel = new OracleDatabaseDesignerViewModel(modelItem, mockDbServiceModel.Object, new SynchronousAsyncWorker(), new ViewPropertyBuilder());
oracleServerDesignerViewModel.ManageServiceInputViewModel = mockDatabaseInputViewModel.Object;
AddScenarioContext(oracleServerDesignerViewModel, mockDatabaseInputViewModel, mockDbServiceModel);
}
public void GivenIHaveWorkflowWithOracleDatabaseConnector(string workflowName, string activityName)
{
var environmentModel = _scenarioContext.Get <IServer>("server");
environmentModel.Connect();
CreateNewResourceModel(workflowName, environmentModel);
CreateDBServiceModel(environmentModel);
var dbServiceModel = _scenarioContext.Get <ManageDbServiceModel>("dbServiceModel");
var oracleActivity = new DsfOracleDatabaseActivity {
DisplayName = activityName
};
var modelItem = ModelItemUtils.CreateModelItem(oracleActivity);
var oracleDesignerViewModel = new OracleDatabaseDesignerViewModel(modelItem, dbServiceModel, new SynchronousAsyncWorker(), new ViewPropertyBuilder());
var serviceInputViewModel = new ManageDatabaseServiceInputViewModel(oracleDesignerViewModel, oracleDesignerViewModel.Model);
_commonSteps.AddActivityToActivityList(workflowName, activityName, oracleActivity);
DebugWriterSubscribe(environmentModel);
_scenarioContext.Add("viewModel", oracleDesignerViewModel);
_scenarioContext.Add("parentName", workflowName);
}
public void Oracle_Refresh_ShouldLoadRefreshActions()
{
//------------Setup for test--------------------------
CustomContainer.LoadedTypes = new List <Type>()
{
typeof(ManageDbServiceModel)
};
var mockMainViewModel = new Mock <IShellViewModel>();
var mockHelpViewModel = new Mock <IHelpWindowViewModel>();
mockHelpViewModel.Setup(model => model.UpdateHelpText(It.IsAny <string>())).Verifiable();
mockMainViewModel.Setup(model => model.HelpViewModel).Returns(mockHelpViewModel.Object);
var server = new Mock <IServer>();
var updatemanager = new Mock <IStudioUpdateManager>();
var queryManager = new Mock <IQueryManager>();
queryManager.Setup(manager => manager.FetchDbSources()).Returns(new List <IDbSource>());
server.Setup(server1 => server1.UpdateRepository).Returns(updatemanager.Object);
server.Setup(server1 => server1.QueryProxy).Returns(queryManager.Object);
mockMainViewModel.Setup(model => model.ActiveServer).Returns(server.Object);
CustomContainer.Register(mockMainViewModel.Object);
var mod = new OracleModel();
var act = new DsfOracleDatabaseActivity();
var oracle = new OracleDatabaseDesignerViewModel(ModelItemUtils.CreateModelItem(act), mod, new SynchronousAsyncWorker(), new ViewPropertyBuilder());
oracle.ManageServiceInputViewModel = new InputViewForTest(oracle, mod);
oracle.SourceRegion.SelectedSource = mod.Sources.First();
oracle.ActionRegion.IsRefreshing = false;
//------------Execute Test---------------------------
oracle.ActionRegion.RefreshActionsCommand.Execute(null);
//------------Assert Results-------------------------
Assert.IsTrue(oracle.SourceRegion.IsEnabled);
Assert.AreEqual(1, oracle.ActionRegion.Actions.Count);
}
public void Oracle_UpdateHelp_ShouldCallToHelpViewMode()
{
//------------Setup for test--------------------------
CustomContainer.LoadedTypes = new List <Type>()
{
typeof(ManageDbServiceModel)
};
var mockMainViewModel = new Mock <IShellViewModel>();
var mockHelpViewModel = new Mock <IHelpWindowViewModel>();
mockHelpViewModel.Setup(model => model.UpdateHelpText(It.IsAny <string>())).Verifiable();
mockMainViewModel.Setup(model => model.HelpViewModel).Returns(mockHelpViewModel.Object);
var server = new Mock <IServer>();
var updatemanager = new Mock <IStudioUpdateManager>();
var queryManager = new Mock <IQueryManager>();
queryManager.Setup(manager => manager.FetchDbSources()).Returns(new List <IDbSource>());
server.Setup(server1 => server1.UpdateRepository).Returns(updatemanager.Object);
server.Setup(server1 => server1.QueryProxy).Returns(queryManager.Object);
mockMainViewModel.Setup(model => model.ActiveServer).Returns(server.Object);
CustomContainer.Register(mockMainViewModel.Object);
var mod = new OracleModel();
mod.HasRecError = true;
var act = new DsfOracleDatabaseActivity();
var oracle = new OracleDatabaseDesignerViewModel(ModelItemUtils.CreateModelItem(act), new SynchronousAsyncWorker(), new ViewPropertyBuilder());
//------------Execute Test---------------------------
oracle.UpdateHelpDescriptor("help");
//------------Assert Results-------------------------
mockHelpViewModel.Verify(model => model.UpdateHelpText(It.IsAny <string>()), Times.Once());
}
void AddScenarioContext(OracleDatabaseDesignerViewModel oracleServerDesignerViewModel, Mock <IManageDatabaseInputViewModel> mockDatabaseInputViewModel, Mock <IDbServiceModel> mockDbServiceModel)
{
ScenarioContext.Current.Add("viewModel", oracleServerDesignerViewModel);
ScenarioContext.Current.Add("mockDatabaseInputViewModel", mockDatabaseInputViewModel);
ScenarioContext.Current.Add("mockDbServiceModel", mockDbServiceModel);
}
public void GivenIOpenWolf()
{
var sourceId = Guid.NewGuid();
var inputs = new List <IServiceInput> {
new ServiceInput("Prefix", "[[Prefix]]")
};
var outputs = new List <IServiceOutputMapping>
{
new ServiceOutputMapping("CountryID", "CountryID", "dbo_Pr_CitiesGetCountries"),
new ServiceOutputMapping("Description", "Description", "dbo_Pr_CitiesGetCountries")
};
var oracleServerActivity = new DsfOracleDatabaseActivity
{
SourceId = sourceId,
ProcedureName = "dbo.Pr_CitiesGetCountries",
Inputs = inputs,
Outputs = outputs
};
var modelItem = ModelItemUtils.CreateModelItem(oracleServerActivity);
var mockDatabaseInputViewModel = new Mock <IManageDatabaseInputViewModel>();
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);
_greenPointSource = new DbSourceDefinition
{
Name = "GreenPoint",
Type = enSourceType.Oracle
};
_testingDbSource = new DbSourceDefinition
{
Name = "testingDBSrc",
Type = enSourceType.Oracle,
Id = sourceId
};
_importOrderAction = new DbAction
{
Name = "dbo.ImportOrder",
Inputs = new List <IServiceInput> {
new ServiceInput("ProductId", "")
}
};
_getCountriesAction = new DbAction {
Name = "dbo.Pr_CitiesGetCountries"
};
_getCountriesAction.Inputs = inputs;
var dbSources = new ObservableCollection <IDbSource> {
_testingDbSource, _greenPointSource
};
mockDbServiceModel.Setup(model => model.RetrieveSources()).Returns(dbSources);
mockDbServiceModel.Setup(model => model.GetActions(It.IsAny <IDbSource>())).Returns(new List <IDbAction> {
_getCountriesAction, _importOrderAction
});
mockDatabaseInputViewModel.SetupAllProperties();
var oracleDatabaseDesignerViewModel = new OracleDatabaseDesignerViewModel(modelItem, mockDbServiceModel.Object, new SynchronousAsyncWorker(), new ViewPropertyBuilder());
ScenarioContext.Current.Add("viewModel", oracleDatabaseDesignerViewModel);
ScenarioContext.Current.Add("mockDatabaseInputViewModel", mockDatabaseInputViewModel);
ScenarioContext.Current.Add("mockDbServiceModel", mockDbServiceModel);
}
