org.piraso.api.sql.SQLViewEntry.java Source code

Introduction

Here is the source code for org.piraso.api.sql.SQLViewEntry.java

Source

/*
 * Copyright (c) 2012. Piraso Alvin R. de Leon. All Rights Reserved.
 *
 * See the NOTICE file distributed with
 * this work for additional information regarding copyright ownership.
 * The Piraso licenses this file to You under the Apache License, Version 2.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.apache.org/licenses/LICENSE-2.0
 *
 * 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.piraso.api.sql;

import org.apache.commons.collections.MapUtils;
import org.codehaus.jackson.annotate.JsonIgnore;
import org.piraso.api.entry.ElapseTimeAware;
import org.piraso.api.entry.ElapseTimeEntry;
import org.piraso.api.entry.Entry;

import java.util.*;

/**
 * SQL View entry
 */
public class SQLViewEntry extends Entry implements ElapseTimeAware {

    private ElapseTimeEntry elapseTime;

    private Map<Integer, SQLParameterEntry> parameters;

    private String sql;

    public SQLViewEntry() {
    }

    public SQLViewEntry(String sql, Map<Integer, SQLParameterEntry> parameters, ElapseTimeEntry elapseTime) {
        this.sql = sql;
        this.parameters = new LinkedHashMap<Integer, SQLParameterEntry>(parameters);
        this.elapseTime = elapseTime;
    }

    public ElapseTimeEntry getElapseTime() {
        return elapseTime;
    }

    public void setElapseTime(ElapseTimeEntry elapseTime) {
        this.elapseTime = elapseTime;
    }

    public Map<Integer, SQLParameterEntry> getParameters() {
        return parameters;
    }

    public void setParameters(Map<Integer, SQLParameterEntry> parameters) {
        this.parameters = parameters;
    }

    public String getSql() {
        return sql;
    }

    @JsonIgnore
    public String getParameterReplacedSql() {
        if (MapUtils.isEmpty(parameters)) {
            return sql;
        }

        List<Integer> sorted = new ArrayList<Integer>(parameters.keySet());
        Collections.sort(sorted);

        StringBuilder buf = new StringBuilder(sql);

        for (Integer key : sorted) {
            SQLParameterEntry parameter = parameters.get(key);

            int index = buf.indexOf("?");
            if (index != -1) {
                buf.replace(index, index + 1, SQLParameterUtils.toPSLiteral(parameter));
            }
        }

        return buf.toString();
    }

    public void setSql(String sql) {
        this.sql = sql;
    }
}