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_redirect_to_specific_method() { var sqlGenerator = new AdvancedSqlServerMigrationSqlGeneratorForTests(); var grantTablePermissionOperation = new GrantTablePermissionOperation("table", "user", TablePermission.Alter); sqlGenerator.Generate( new MigrationOperation[] { grantTablePermissionOperation }, "2008"); Assert.True(sqlGenerator.GrantTablePermissionOpeartionCalled); }
/// <summary> /// Generate a SQL to grant permission on a table for specified user /// </summary> /// <param name="grantTablePermissionOperation">The operation to produce sql for.</param> public virtual void Generate(GrantTablePermissionOperation grantTablePermissionOperation) { using (var writer = Writer()) { writer.WriteLine( "GRANT {0} ON {1} TO {2}", grantTablePermissionOperation.Permission.ToString().ToUpper(), grantTablePermissionOperation.Table, grantTablePermissionOperation.User); this.Statement(writer); } }
public override void Generate(GrantTablePermissionOperation grantTablePermissionOperation) { GrantTablePermissionOpeartionCalled = true; }