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 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 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 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); }