/* * #%L * JSQLParser library * %% * Copyright (C) 2004 - 2013 JSQLParser * %% * This program is free software: you can redistribute it and/or modify * it under the terms of the GNU Lesser General Public License as * published by the Free Software Foundation, either version 2.1 of the * License, or (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Lesser Public License for more details. * * You should have received a copy of the GNU General Lesser Public * License along with this program. If not, see * <http://www.gnu.org/licenses/lgpl-2.1.html>. * #L% */ package net.sf.jsqlparser.util.deparser; import net.sf.jsqlparser.statement.create.view.CreateView; import net.sf.jsqlparser.statement.select.PlainSelect; import net.sf.jsqlparser.statement.select.SelectVisitor; /** * A class to de-parse (that is, tranform from JSqlParser hierarchy into a string) a * {@link net.sf.jsqlparser.statement.create.view.CreateView} */ public class CreateViewDeParser { private StringBuilder buffer; private SelectVisitor selectVisitor; /** * @param buffer the buffer that will be filled with the select */ public CreateViewDeParser(StringBuilder buffer) { SelectDeParser selectDeParser = new SelectDeParser(); selectDeParser.setBuffer(buffer); ExpressionDeParser expressionDeParser = new ExpressionDeParser(selectDeParser, buffer); selectDeParser.setExpressionVisitor(expressionDeParser); selectVisitor = selectDeParser; this.buffer = buffer; } public CreateViewDeParser(StringBuilder buffer, SelectVisitor selectVisitor) { this.buffer = buffer; this.selectVisitor = selectVisitor; } public void deParse(CreateView createView) { buffer.append("CREATE "); if (createView.isOrReplace()) { buffer.append("OR REPLACE "); } if (createView.isMaterialized()) { buffer.append("MATERIALIZED "); } buffer.append("VIEW ").append(createView.getView().getFullyQualifiedName()); if (createView.getColumnNames() != null) { buffer.append(PlainSelect.getStringList(createView.getColumnNames(), true, true)); } buffer.append(" AS "); createView.getSelectBody().accept(selectVisitor); } public StringBuilder getBuffer() { return buffer; } public void setBuffer(StringBuilder buffer) { this.buffer = buffer; } }