private int DropProcedure(string cleanProcName) { var dropProcedure = "IF ( OBJECT_ID('" + cleanProcName + "') IS NOT NULL ) DROP PROCEDURE [dbo].[" + cleanProcName + "]"; var dropResult = SqlHelper.RunSqlCommand(dropProcedure); return(dropResult); }
public void Add_A_New_InputOnSqlProcedure_Expect_New_IS_InputAdded() { const string procName = "TestingAddingANewInput"; Setup(procName); IDatabaseInputRegion databaseInputRegion = new DatabaseInputRegion(_modelItem, _dbActionRegion); Assert.AreEqual(1, databaseInputRegion.Inputs.Count); Assert.AreEqual("ProductId", databaseInputRegion.Inputs.Single().Name); Assert.AreEqual("[[ProductId]]", databaseInputRegion.Inputs.Single().Value); //testing here const string alterProcedure = "ALTER procedure [dbo].[" + procName + "](@ProductId int,@ProductId1 int,@ProductId2 int) as Begin select * from Country select * from City end"; var alterTableResults = SqlHelper.RunSqlCommand(alterProcedure); Assert.AreEqual(-1, alterTableResults); _dbActionRegion.RefreshActionsCommand.Execute(null); Assert.IsNotNull(_dbActionRegion.Actions, "No Actions were generated for source: " + _selectedSource); var procActionsToInputs = _dbActionRegion.Actions.Single(p => p.Name.EndsWith(procName)); Assert.AreEqual("ProductId", procActionsToInputs.Inputs.ToList()[0].Name); Assert.AreEqual("[[ProductId]]", procActionsToInputs.Inputs.ToList()[0].Value); Assert.AreEqual("ProductId1", procActionsToInputs.Inputs.ToList()[1].Name); Assert.AreEqual("[[ProductId1]]", procActionsToInputs.Inputs.ToList()[1].Value); Assert.AreEqual("ProductId2", procActionsToInputs.Inputs.ToList()[2].Name); Assert.AreEqual("[[ProductId2]]", procActionsToInputs.Inputs.ToList()[2].Value); }
public void Change_sql_source_verify_Empty_Inputs() { var newName = Guid.NewGuid().ToString(); var cleanProcName = newName.Replace("-", "").Replace(" ", ""); try { var createProcedure = "CREATE procedure [dbo].[" + cleanProcName + "](@ProductId int) as Begin select * from Country select * from City end"; var result = SqlHelper.RunSqlCommand(createProcedure); Assert.AreEqual(-1, result); Setup(cleanProcName); var mockSource = new Mock <IDbSource>(); IDatabaseInputRegion databaseInputRegion = new DatabaseInputRegion(_modelItem, _dbActionRegion); Assert.AreEqual(1, databaseInputRegion.Inputs.Count); Assert.AreEqual("ProductId", databaseInputRegion.Inputs.Single().Name); Assert.AreEqual("[[ProductId]]", databaseInputRegion.Inputs.Single().Value); //add testing here _source.SelectedSource = mockSource.Object; Assert.AreEqual(0, databaseInputRegion.Inputs.Count); } finally { var dropResult = DropProcedure(cleanProcName); Assert.AreEqual(-1, dropResult); } }
int DropProcedure(string cleanProcName) { var dropProcedure = "IF ( OBJECT_ID('" + cleanProcName + "') IS NOT NULL ) DROP PROCEDURE [dbo].[" + cleanProcName + "]"; var dropResult = SqlHelper.RunSqlCommand(_containerOps.Container.IP, _containerOps.Container.Port, dropProcedure); return(dropResult); }
int DropProcedure(string cleanProcName) { var dropProcedure = "IF ( OBJECT_ID('" + cleanProcName + "') IS NOT NULL ) DROP PROCEDURE [dbo].[" + cleanProcName + "]"; var dropResult = SqlHelper.RunSqlCommand(Depends.EnableDocker?Depends.RigOpsIP:Depends.SVRDEVIP, Depends.EnableDocker?_containerOps.Container.Port:"1433", dropProcedure); return(dropResult); }
public void change_sql_source_verify_Empty_Inputs() { var newName = Guid.NewGuid().ToString(); var cleanProcName = newName.Replace("-", "").Replace(" ", ""); var createProcedure = "CREATE procedure [dbo].[" + cleanProcName + "](@ProductId int) as Begin select * from Country select * from City end"; var result = SqlHelper.RunSqlCommand(createProcedure); Assert.AreEqual(-1, result); var inputs = new List <IServiceInput>() { new ServiceInput("ProductId", "[[ProductId]]") { ActionName = "dbo." + cleanProcName } }; var sqlActivity = new DsfSqlServerDatabaseActivity() { Inputs = inputs, ActionName = "dbo." + cleanProcName, ProcedureName = "dbo." + cleanProcName, SourceId = new Guid("b9184f70-64ea-4dc5-b23b-02fcd5f91082") }; var modelItem = ModelItemUtils.CreateModelItem(sqlActivity); var environmentModel = ServerRepository.Instance.Source; environmentModel.Connect(); var environmentConnection = environmentModel.Connection; var controllerFactory = new CommunicationControllerFactory(); var _proxyLayer = new StudioServerProxy(controllerFactory, environmentConnection); var mock = new Mock <IShellViewModel>(); var dbServiceModel = new ManageDbServiceModel(new StudioResourceUpdateManager(controllerFactory, environmentConnection) , _proxyLayer.QueryManagerProxy , mock.Object , environmentModel); var source = new DatabaseSourceRegion(dbServiceModel, modelItem, Common.Interfaces.Core.DynamicServices.enSourceType.SqlDatabase); var selectedSource = source.Sources.Single(a => a.Id == sqlActivity.SourceId); source.SelectedSource = selectedSource; var actionRegion = new DbActionRegion(dbServiceModel, modelItem, source, new SynchronousAsyncWorker()); var mockSource = new Mock <IDbSource>(); IDatabaseInputRegion databaseInputRegion = new DatabaseInputRegion(modelItem, actionRegion); Assert.AreEqual(1, databaseInputRegion.Inputs.Count); Assert.AreEqual("ProductId", databaseInputRegion.Inputs.Single().Name); Assert.AreEqual("[[ProductId]]", databaseInputRegion.Inputs.Single().Value); //add testing here source.SelectedSource = mockSource.Object; Assert.AreEqual(0, databaseInputRegion.Inputs.Count); }
public void Add_A_New_InputOnSqlProcedure_Expect_New_IS_InputAdded() { var newName = Guid.NewGuid().ToString(); var cleanProcName = newName.Replace("-", "").Replace(" ", ""); var dropProcedure = "USE [Dev2TestingDB] DROP PROCEDURE [dbo].[" + cleanProcName + "]"; var createProcedure = "CREATE procedure [dbo].[" + cleanProcName + "](@ProductId int) as Begin select * from Country select * from City end"; var result = SqlHelper.RunSqlCommand(createProcedure); Assert.AreEqual(-1, result); var inputs = new List <IServiceInput>() { new ServiceInput("ProductId", "[[ProductId]]") { ActionName = "dbo." + cleanProcName } }; var sqlActivity = new DsfSqlServerDatabaseActivity() { Inputs = inputs, ActionName = "dbo." + cleanProcName, ProcedureName = "dbo." + cleanProcName, SourceId = new Guid("b9184f70-64ea-4dc5-b23b-02fcd5f91082") }; var modelItem = ModelItemUtils.CreateModelItem(sqlActivity); var environmentModel = ServerRepository.Instance.Source; environmentModel.Connect(); var environmentConnection = environmentModel.Connection; var controllerFactory = new CommunicationControllerFactory(); var _proxyLayer = new StudioServerProxy(controllerFactory, environmentConnection); var mock = new Mock <IShellViewModel>(); var dbServiceModel = new ManageDbServiceModel(new StudioResourceUpdateManager(controllerFactory, environmentConnection) , _proxyLayer.QueryManagerProxy , mock.Object , environmentModel); var source = new DatabaseSourceRegion(dbServiceModel, modelItem, Common.Interfaces.Core.DynamicServices.enSourceType.SqlDatabase); var selectedSource = source.Sources.Single(a => a.Id == sqlActivity.SourceId); source.SelectedSource = selectedSource; var actionRegion = new DbActionRegion(dbServiceModel, modelItem, source, new SynchronousAsyncWorker()); var diffAction = actionRegion.Actions.First(p => p.Name != sqlActivity.ProcedureName); IDatabaseInputRegion databaseInputRegion = new DatabaseInputRegion(modelItem, actionRegion); Assert.AreEqual(1, databaseInputRegion.Inputs.Count); Assert.AreEqual("ProductId", databaseInputRegion.Inputs.Single().Name); Assert.AreEqual("[[ProductId]]", databaseInputRegion.Inputs.Single().Value); //add testing here var alterProcedure = "ALTER procedure [dbo].[" + cleanProcName + "](@ProductId int,@ProductId1 int,@ProductId2 int) as Begin select * from Country select * from City end"; //actionRegion.SelectedAction = diffAction;//trigger action changes var alterTableResults = SqlHelper.RunSqlCommand(alterProcedure); actionRegion.RefreshActionsCommand.Execute(null); var underTest = actionRegion.Actions.Single(p => p.Name.EndsWith(cleanProcName)); Assert.AreEqual(3, databaseInputRegion.Inputs.Count); Assert.AreEqual("ProductId", underTest.Inputs.ToList()[0].Name); Assert.AreEqual("ProductId1", underTest.Inputs.ToList()[1].Name); Assert.AreEqual("ProductId2", underTest.Inputs.ToList()[2].Name); Assert.AreEqual("ProductId", databaseInputRegion.Inputs.ToList()[0].Name); Assert.AreEqual("[[ProductId]]", databaseInputRegion.Inputs.ToList()[0].Value); Assert.AreEqual("ProductId1", databaseInputRegion.Inputs.ToList()[1].Name); Assert.AreEqual("[[ProductId1]]", databaseInputRegion.Inputs.ToList()[1].Value); Assert.AreEqual("ProductId2", databaseInputRegion.Inputs.ToList()[2].Name); Assert.AreEqual("[[ProductId2]]", databaseInputRegion.Inputs.ToList()[2].Value); Assert.AreEqual(-1, alterTableResults); var resultForDrop = SqlHelper.RunSqlCommand(dropProcedure); Assert.AreEqual(-1, resultForDrop); }