GrantDeParser.java

/*-
 * #%L
 * JSQLParser library
 * %%
 * Copyright (C) 2004 - 2020 JSQLParser
 * %%
 * Dual licensed under GNU LGPL 2.1 or Apache License 2.0
 * #L%
 */
package net.sf.jsqlparser.util.deparser;

import java.util.Iterator;

import net.sf.jsqlparser.statement.grant.Grant;

public class GrantDeParser extends AbstractDeParser<Grant> {

    public GrantDeParser(StringBuilder buffer) {
        super(buffer);
    }

    @Override
    public void deParse(Grant grant) {
        builder.append("GRANT ");
        if (grant.getRole() != null) {
            builder.append(grant.getRole());
        } else {
            for (Iterator<String> iter = grant.getPrivileges().iterator(); iter.hasNext();) {
                String privilege = iter.next();
                builder.append(privilege);
                if (iter.hasNext()) {
                    builder.append(", ");
                }
            }
            builder.append(" ON ");
            builder.append(grant.getObjectName());
        }
        builder.append(" TO ");
        for (Iterator<String> iter = grant.getUsers().iterator(); iter.hasNext();) {
            String user = iter.next();
            builder.append(user);
            if (iter.hasNext()) {
                builder.append(", ");
            }
        }
    }

}