예제 #1
0
        public void Sql_ExecuteSetup_TableCreated()
        {
            //Create table
            dbUnderTest.ExecuteAdhoc($"Create table test(Id Int);");

            var result = dbUnderTest.GetActual("Select count(*) from Information_Schema.Tables WHERE Table_Name = 'Test'");

            Assert.That(result, Is.EqualTo(1));
        }
        public void DeployProjectToCatalogTask_Execute_DeploysProject()
        {
            //act
            string args = $@"SsisBuild.proj /t:SSISDeploy /p:SSISProj=TestSsisProject,Configuration=Development,ProjectName=TestSsisProject,SSISServer={ssisServer},FolderName=NewFolder,SsisVersion=2017";

            RunDeployment(args);

            //Assert
            var actual = ssisdb.GetActual(@"Select 1 From catalog.projects p 
                                        join catalog.folders f on p.folder_id = f.folder_id
                                        where f.name = 'NewFolder'
                                        and p.name = 'TestSsisProject'");

            Assert.That(actual, Is.EqualTo(1));
        }