Method parseAlterRoleStatement

pkg/sql/parser/alter.go:148–212

parseAlterRoleStatement parses ALTER ROLE statements

(stmt *ast.AlterStatement)

// parseAlterRoleStatement parses ALTER ROLE statements
func (p *Parser) parseAlterRoleStatement(stmt *ast.AlterStatement) (*ast.AlterStatement, error) {
	stmt.Name = p.parseIdentAsString()
	op := &ast.AlterRoleOperation{}

	switch {
	case p.matchType(models.TokenTypeRename):
		if !p.matchType(models.TokenTypeTo) {
			return nil, p.expectedError("TO")
		}
		op.Type = ast.RenameRole
		op.NewName = p.parseIdentAsString()

	case p.matchType(models.TokenTypeAdd):
		if !p.matchType(models.TokenTypeMember) {
			return nil, p.expectedError("MEMBER")
		}
		op.Type = ast.AddMember
		op.MemberName = p.parseIdentAsString()

	case p.matchType(models.TokenTypeDrop):
		if !p.matchType(models.TokenTypeMember) {
			return nil, p.expectedError("MEMBER")
		}
		op.Type = ast.DropMember
		op.MemberName = p.parseIdentAsString()

	case p.matchType(models.TokenTypeSet):
		op.Type = ast.SetConfig
		op.ConfigName = p.parseIdentAsString()
		if p.matchType(models.TokenTypeTo) || p.matchType(models.TokenTypeEq) {
			expr, err := p.parseExpression()
			if err != nil {
				return nil, err
			}
			op.ConfigValue = expr
		}

	case p.matchType(models.TokenTypeReset):
		op.Type = ast.ResetConfig
		if p.matchType(models.TokenTypeAll) {
			op.ConfigName = "ALL"
		} else {
			op.ConfigName = p.parseIdentAsString()
		}

	case p.matchType(models.TokenTypeWith):
		op.Type = ast.WithOptions
		for {
			option, err := p.parseRoleOption()
			if err != nil {
				return nil, err
			}
			op.Options = append(op.Options, *option)
			if !p.matchType(models.TokenTypeComma) {
				break
			}
		}