public void CreateView(IConnectionManager connection) { //Arrange //Act CreateViewTask.CreateOrAlter(connection, "View1", "SELECT 1 AS Test"); //Assert Assert.True(IfTableOrViewExistsTask.IsExisting(connection, "View1")); }
public void CreateViewLogging() { //Arrange //Act CreateViewTask.CreateOrAlter(SqlConnection, "dbo.CreateView", "SELECT 1 AS Test"); //Assert Assert.Equal(2, CountLogEntries("CreateViewTask")); }
public void DropViewLogging() { //Arrange CreateViewTask.CreateOrAlter(Connection, "dbo.DropView", "SELECT 1 AS Test"); //Act DropViewTask.Drop(Connection, "dbo.DropView"); //Assert Assert.Equal(2, CountLogEntries("DROPVIEW")); }
public void CreateView(IConnectionManager connection) { //Arrange //Act CreateViewTask.CreateOrAlter(connection, "View1", "SELECT 1 AS test"); //Assert Assert.True(IfTableOrViewExistsTask.IsExisting(connection, "View1")); var td = TableDefinition.FromTableName(connection, "View1"); Assert.Contains(td.Columns, col => col.Name == "test"); }
public void Drop(IConnectionManager connection) { //Arrange CreateViewTask.CreateOrAlter(connection, "DropViewTest", "SELECT 1 AS Test"); Assert.True(IfTableOrViewExistsTask.IsExisting(connection, "DropViewTest")); //Act DropViewTask.Drop(connection, "DropViewTest"); //Assert Assert.False(IfTableOrViewExistsTask.IsExisting(connection, "DropTableTest")); }
public void AlterView(IConnectionManager connection) { //Arrange CreateViewTask.CreateOrAlter(connection, "View2", "SELECT 1 AS Test"); Assert.True(IfExistsTask.IsExisting(connection, "View2")); //Act CreateViewTask.CreateOrAlter(connection, "View2", "SELECT 5 AS Test"); //Assert if (connection.GetType() == typeof(SqlConnectionManager)) { Assert.Equal(1, RowCountTask.Count(connection, "sys.objects", "type = 'V' AND object_id = object_id('dbo.View2') AND create_date <> modify_date")); } Assert.True(IfExistsTask.IsExisting(connection, "View2")); }
public void CreateView(IConnectionManager connection) { //Arrange string viewtext = "SELECT 1 AS test"; if (connection.GetType() == typeof(OracleConnectionManager)) { viewtext += " FROM DUAL"; } //Act CreateViewTask.CreateOrAlter(connection, "View1", viewtext); //Assert Assert.True(IfTableOrViewExistsTask.IsExisting(connection, "View1")); var td = TableDefinition.FromTableName(connection, "View1"); Assert.Contains(td.Columns, col => col.Name.ToLower() == "test"); }
public void Drop(IConnectionManager connection) { //Arrange string viewtext = "SELECT 1 AS test"; if (connection.GetType() == typeof(OracleConnectionManager)) { viewtext += " FROM DUAL"; } CreateViewTask.CreateOrAlter(connection, "DropViewTest", viewtext); Assert.True(IfTableOrViewExistsTask.IsExisting(connection, "DropViewTest")); //Act DropViewTask.Drop(connection, "DropViewTest"); //Assert Assert.False(IfTableOrViewExistsTask.IsExisting(connection, "DropTableTest")); }
public void DifferentColumnsInView(IConnectionManager connection) { //Arrange FourColumnsTableFixture s4c = new FourColumnsTableFixture(connection, "dbsource_extended"); s4c.InsertTestData(); CreateViewTask.CreateOrAlter(connection, "DbSourceViewExtended", $"SELECT {s4c.QB}Col2{s4c.QE}, {s4c.QB}Col4{s4c.QE} FROM dbsource_extended"); FourColumnsTableFixture d4c = new FourColumnsTableFixture(connection, "DbDestinationExtended", 1); //Act DbSource <MyExtendedRow> source = new DbSource <MyExtendedRow>("DbSourceViewExtended", connection); DbDestination <MyExtendedRow> dest = new DbDestination <MyExtendedRow>("DbDestinationExtended", connection); source.LinkTo(dest); source.Execute(); dest.Wait(); //Assert d4c.AssertTestData(); }
public void SimpleFlow(IConnectionManager connection) { //Arrange TwoColumnsTableFixture source2Columns = new TwoColumnsTableFixture(connection, "dbsource_simple"); source2Columns.InsertTestData(); CreateViewTask.CreateOrAlter(connection, "DbSourceView", "SELECT * FROM dbsource_simple"); TwoColumnsTableFixture dest2Columns = new TwoColumnsTableFixture(connection, "DbDestinationSimple"); //Act DbSource <MySimpleRow> source = new DbSource <MySimpleRow>("DbSourceView", connection); DbDestination <MySimpleRow> dest = new DbDestination <MySimpleRow>("DbDestinationSimple", connection); source.LinkTo(dest); source.Execute(); dest.Wait(); //Assert dest2Columns.AssertTestData(); }