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