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