public void Generate_RevokeTablePermissionOperation_produce_valid_statement()
{
var operation = new RevokeTablePermissionOperation("dbo.table", "user", TablePermission.Insert);
var sqlGenerator = new ExtendedSqlServerMigrationSqlGenerator();
var sql = sqlGenerator.Generate(new MigrationOperation[] { operation }, "2008").Join(ss => ss.Sql, Environment.NewLine);
Assert.Contains("REVOKE INSERT ON dbo.table TO user", sql);
}
public void Generate_GrantTablePermissionOperation_produce_valid_statement()
{
var operation = new GrantTablePermissionOperation("dbo.table", "user", TablePermission.Update);
var sqlGenerator = new ExtendedSqlServerMigrationSqlGenerator();
var sql = sqlGenerator.Generate(new MigrationOperation[] { operation }, "2008").Join(ss => ss.Sql, Environment.NewLine);
Assert.Contains("GRANT UPDATE ON dbo.table TO user", sql);
}
public void Generate_SqlFileOperation_produce_sql_file_statements()
{
var operation = new SqlFileOperation(@".\fixtures\SqlFileOperation.sql");
var sqlGenerator = new ExtendedSqlServerMigrationSqlGenerator();
var sql = sqlGenerator.Generate(new MigrationOperation[] { operation }, "2008").Join(ss => ss.Sql, Environment.NewLine);
Assert.Contains("--drop database", sql);
}
public void Generate_DropViewOperation_produce_valid_statement()
{
var operation = new DropViewOperation("ViewName");
var sqlGenerator = new ExtendedSqlServerMigrationSqlGenerator();
var sql = sqlGenerator.Generate(new MigrationOperation[] { operation }, "2008").Join(ss => ss.Sql, Environment.NewLine);
Assert.Contains("DROP VIEW ViewName", sql);
}
public void Generate_CreateViewOperation_produce_valid_statement()
{
var operation = new CreateViewOperation("ViewName", "SELECT * FROM dbo.TableName");
var sqlGenerator = new ExtendedSqlServerMigrationSqlGenerator();
var sql = sqlGenerator.Generate(new MigrationOperation[] { operation }, "2008").Join(ss => ss.Sql, Environment.NewLine);
Assert.Contains("CREATE VIEW ViewName AS SELECT * FROM dbo.TableName", sql);
}
public void Generate_DatabaseCollationOperation_produce_valid_statement()
{
var operation = new DatabaseCollationOperation("TestsDB", SqlServerDatabaseCollations.Latin1_General_CI_AS);
var sqlGenerator = new ExtendedSqlServerMigrationSqlGenerator();
var sql = sqlGenerator.Generate(new MigrationOperation[] { operation }, "2008").Join(ss => ss.Sql, Environment.NewLine);
Assert.Contains("ALTER DATABASE TestsDB COLLATE Latin1_General_CI_AS", sql);
}
public void Generate_SqlResourceOperation_produce_sql_file_statements()
{
var operation =
new SqlResourceOperation(typeof(ExtendedSqlServerMigrationSqlGeneratorTests).Assembly, "UnitTests.fixtures.SqlResourceOperation.sql");
var sqlGenerator = new ExtendedSqlServerMigrationSqlGenerator();
var sql = sqlGenerator.Generate(new MigrationOperation[] { operation }, "2008").Join(ss => ss.Sql, Environment.NewLine);
Assert.Contains("--drop database", sql);
}