org.tinygroup.jsqlparser.statement.select.Pivot Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of org.tinygroup.jsqlparser Show documentation

There is a newer version: 3.4.9

Show newest version

/**
 *  Copyright (c) 1997-2013, www.tinygroup.org ([email protected]).
 *
 *  Licensed under the GPL, Version 3.0 (the "License");
 *  you may not use this file except in compliance with the License.
 *  You may obtain a copy of the License at
 *
 *       http://www.gnu.org/licenses/gpl.html
 *
 *  Unless required by applicable law or agreed to in writing, software
 *  distributed under the License is distributed on an "AS IS" BASIS,
 *  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 *  See the License for the specific language governing permissions and
 *  limitations under the License.
 */
package org.tinygroup.jsqlparser.statement.select;

import org.tinygroup.jsqlparser.schema.Column;

import java.io.Serializable;
import java.util.List;

public class Pivot implements Serializable {

    private List functionItems;

    private List forColumns;

    private List singleInItems;

    private List multiInItems;

    public void accept(PivotVisitor pivotVisitor) {
        pivotVisitor.visit(this);
    }

    public List getSingleInItems() {
        return singleInItems;
    }

    public void setSingleInItems(List singleInItems) {
        this.singleInItems = singleInItems;
    }

    public List getMultiInItems() {
        return multiInItems;
    }

    public void setMultiInItems(List multiInItems) {
        this.multiInItems = multiInItems;
    }

    public List getFunctionItems() {
        return functionItems;
    }

    public void setFunctionItems(List functionItems) {
        this.functionItems = functionItems;
    }

    public List getForColumns() {
        return forColumns;
    }

    public void setForColumns(List forColumns) {
        this.forColumns = forColumns;
    }

    public List getInItems() {
        return singleInItems == null ? multiInItems : singleInItems;
    }


    public String toString() {
        return "PIVOT (" +
                PlainSelect.getStringList(functionItems) +
                " FOR " + PlainSelect.getStringList(forColumns, true, forColumns != null && forColumns.size() > 1) +
                " IN " + PlainSelect.getStringList(getInItems(), true, true) + ")";
    }
}