public void DropViewLogging() { //Arrange CreateViewTask.CreateOrAlter(SqlConnection, "dbo.DropView", "SELECT 1 AS Test"); //Act DropViewTask.Drop(SqlConnection, "dbo.DropView"); //Assert Assert.Equal(2, CountLogEntries("DropViewTask")); }
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 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")); }