public void WhenViewChanged()
{
//arrange
var sb = new List <CompareResult>();
var writer = new ComparisonWriter(SqlType.SqlServer);
var target = new CompareViews(sb, writer);
var baseViews = new List <DatabaseView> {
CreateView()
};
var view = CreateView();
const string orderByName = " ORDER BY NAME";
view.Sql += orderByName;
var compareViews = new List <DatabaseView> {
view
};
//act
target.Execute(baseViews, compareViews);
var result = string.Join(Environment.NewLine, sb.Select(x => x.Script).ToArray());
//assert
Assert.IsTrue(result.Contains("DROP VIEW"));
Assert.IsTrue(result.Contains("CREATE VIEW"));
Assert.IsTrue(result.Contains(orderByName));
}
public void WhenViewsIdenticalWithDifferentFormatSql()
{
//arrange
var sb = new List <CompareResult>();
var writer = new ComparisonWriter(SqlType.SqlServer);
var target = new CompareViews(sb, writer);
var databaseView = CreateView();
databaseView.Sql = @"
create view ""Alphabetical list of products"" AS
SELECT Products.*, Categories.CategoryName
FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID
WHERE (((Products.Discontinued)=0))
";
var baseViews = new List <DatabaseView> {
databaseView
};
var databaseView2 = CreateView();
databaseView2.Sql = @"create view [dbo].[Alphabetical list of products] AS
SELECT Products.*, Categories.CategoryName
FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID
WHERE (((Products.Discontinued)=0))";
var compareViews = new List <DatabaseView> {
databaseView2
};
//act
target.Execute(baseViews, compareViews);
var result = string.Join(Environment.NewLine, sb.Select(x => x.Script).ToArray());
//assert
Assert.IsTrue(string.IsNullOrEmpty(result));
}
public void WhenViewChanged()
{
//arrange
var sb = new StringBuilder();
var writer = new ComparisonWriter(SqlType.SqlServer);
var target = new CompareViews(sb, writer);
var baseViews = new List <DatabaseView> {
CreateView()
};
var view = CreateView();
const string orderByName = " ORDER BY NAME";
view.Sql += orderByName;
var compareViews = new List <DatabaseView> {
view
};
//act
target.Execute(baseViews, compareViews);
var result = sb.ToString();
//assert
Assert.IsTrue(result.Contains("DROP VIEW"));
Assert.IsTrue(result.Contains("CREATE VIEW"));
Assert.IsTrue(result.Contains(orderByName));
}
public void WhenViewAdded()
{
//arrange
var sb = new List <CompareResult>();
var writer = new ComparisonWriter(SqlType.SqlServer);
var target = new CompareViews(sb, writer);
var baseViews = new List <DatabaseView>();
var compareViews = new List <DatabaseView> {
CreateView()
};
//act
target.Execute(baseViews, compareViews);
var result = string.Join(Environment.NewLine, sb.Select(x => x.Script).ToArray());
//assert
Assert.IsTrue(result.Contains("CREATE VIEW"));
}
public void WhenViewAdded()
{
//arrange
var sb = new StringBuilder();
var writer = new ComparisonWriter(SqlType.SqlServer);
var target = new CompareViews(sb, writer);
var baseViews = new List <DatabaseView>();
var compareViews = new List <DatabaseView> {
CreateView()
};
//act
target.Execute(baseViews, compareViews);
var result = sb.ToString();
//assert
Assert.IsTrue(result.Contains("CREATE VIEW"));
}
public void WhenViewsIdentical()
{
//arrange
var sb = new StringBuilder();
var writer = new ComparisonWriter(SqlType.SqlServer);
var target = new CompareViews(sb, writer);
var baseViews = new List <DatabaseView> {
CreateView()
};
var compareViews = new List <DatabaseView> {
CreateView()
};
//act
target.Execute(baseViews, compareViews);
var result = sb.ToString();
//assert
Assert.IsTrue(string.IsNullOrEmpty(result));
}
