public async void AdminSetsAccountPassword(string userName, string password) { var statement = new AlterUserStatement(userName, new SetPasswordAction(password)); var result = await statement.ExecuteAsync(adminContext); Assert.NotNull(result); Assert.True(result.IsEmpty()); Assert.Equal(userName, userSet); Assert.Equal(password, newPassword); }
public async void AdminSetsAccountStatus(string userName, UserStatus status) { var statement = new AlterUserStatement(userName, new SetAccountStatusAction(status)); var result = await statement.ExecuteAsync(adminContext); Assert.NotNull(result); Assert.True(result.IsEmpty()); Assert.Equal(userName, userSet); Assert.Equal(status, newStatus); }
protected override SqlStatement VisitAlterUser(AlterUserStatement statement) { builder.AppendFormat("ALTER USER {0} ", statement.UserName); if (statement.AlterAction is SetUserRolesAction) { var setRoles = (SetUserRolesAction) statement.AlterAction; var roles = String.Join(", ", setRoles.Roles.Select(x => x.ToString()).ToArray()); builder.AppendFormat(" SET ROLE ", roles); } else if (statement.AlterAction is SetPasswordAction) { var setPassword = (SetPasswordAction) statement.AlterAction; builder.AppendFormat(" SET PASSWORD {0}", setPassword.PasswordExpression); } else if (statement.AlterAction is SetAccountStatusAction) { var setStatus = (SetAccountStatusAction) statement.AlterAction; builder.AppendFormat(" SET ACCOUNT STATUS {0}", setStatus.ActionType.ToString().ToUpperInvariant()); } return base.VisitAlterUser(statement); }
protected override SqlStatement VisitAlterUser(AlterUserStatement statement) { builder.AppendFormat("ALTER USER {0} ", statement.UserName); if (statement.AlterAction is SetUserRolesAction) { var setRoles = (SetUserRolesAction)statement.AlterAction; var roles = String.Join(", ", setRoles.Roles.Select(x => x.ToString()).ToArray()); builder.AppendFormat(" SET ROLE ", roles); } else if (statement.AlterAction is SetPasswordAction) { var setPassword = (SetPasswordAction)statement.AlterAction; builder.AppendFormat(" SET PASSWORD {0}", setPassword.PasswordExpression); } else if (statement.AlterAction is SetAccountStatusAction) { var setStatus = (SetAccountStatusAction)statement.AlterAction; builder.AppendFormat(" SET ACCOUNT STATUS {0}", setStatus.ActionType.ToString().ToUpperInvariant()); } return(base.VisitAlterUser(statement)); }
protected virtual SqlStatement VisitAlterUser(AlterUserStatement statement) { return new AlterUserStatement(statement.UserName, statement.AlterAction); }
public async void UserSetsAccountStatus(string userName, string password) { var statement = new AlterUserStatement(userName, new SetPasswordAction(password)); await Assert.ThrowsAsync <UnauthorizedAccessException>(() => statement.ExecuteAsync(userContext)); }
public void SetAccountStatus_ToString(string userName, string password, string expected) { var statement = new AlterUserStatement(userName, new SetPasswordAction(password)); Assert.Equal(expected, statement.ToSqlString()); }
protected virtual SqlStatement VisitAlterUser(AlterUserStatement statement) { return(new AlterUserStatement(statement.UserName, statement.AlterAction)); }