com.silverpeas.gallery.dao.MediaOrderSQLQueryBuilder.java Source code

Introduction

Here is the source code for com.silverpeas.gallery.dao.MediaOrderSQLQueryBuilder.java

Source

/*
 * Copyright (C) 2000 - 2014 Silverpeas
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Affero General Public License as
 * published by the Free Software Foundation, either version 3 of the
 * License, or (at your option) any later version.
 *
 * As a special exception to the terms and conditions of version 3.0 of
 * the GPL, you may redistribute this Program in connection with Free/Libre
 * Open Source Software ("FLOSS") applications as described in Silverpeas's
 * FLOSS exception. You should have recieved a copy of the text describing
 * the FLOSS exception, and it is also available here:
 * "http://www.silverpeas.org/docs/core/legal/floss_exception.html"
 *
 * 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 Affero General Public License for more details.
 *
 * You should have received a copy of the GNU Affero General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 */
package com.silverpeas.gallery.dao;

import com.silverpeas.gallery.model.MediaOrderCriteriaProcessor;
import com.silverpeas.gallery.model.Order;
import org.apache.commons.lang.time.DateUtils;
import org.apache.commons.lang3.tuple.Pair;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

/**
 * A dynamic builder of a SQL query.
 */
public class MediaOrderSQLQueryBuilder implements MediaOrderCriteriaProcessor {

    private boolean done = false;
    private final StringBuilder sqlQuery = new StringBuilder();
    private final StringBuilder from = new StringBuilder();
    private final StringBuilder where = new StringBuilder();
    private final List<Object> parameters = new ArrayList<Object>();
    private String conjunction = "";

    @Override
    public void startProcessing() {
        sqlQuery.append("select O.orderId, O.userId, O.instanceId, O.createDate, O.processDate, O.processUser ");
        from.append("from SC_Gallery_Order O ");
    }

    @Override
    public void endProcessing() {
        sqlQuery.append(from.toString());
        if (where.length() > 0) {
            sqlQuery.append(" where ").append(where.toString());
        }
        done = true;
    }

    @Override
    public Pair<String, List<Object>> result() {
        return Pair.of(sqlQuery.toString(), parameters);
    }

    @Override
    public MediaOrderCriteriaProcessor then() {
        if (!done) {
            conjunction = " and ";
        }
        return this;
    }

    @Override
    public MediaOrderCriteriaProcessor processComponentInstance(String componentInstanceId) {
        if (!done) {
            where(conjunction).append("O.instanceId = ?");
            parameters.add(componentInstanceId);
            conjunction = "";
        }
        return this;
    }

    @Override
    public MediaOrderCriteriaProcessor processOrderer(String ordererId) {
        if (!done) {
            where(conjunction).append("O.userId = ?");
            parameters.add(ordererId);
            conjunction = "";
        }
        return this;
    }

    @Override
    public MediaOrderCriteriaProcessor processNbDaysAfterThatDeleteAnOrder(final Date referenceDate,
            final int nbDaysAfterThatDeleteAnOrder) {
        if (!done) {
            where(conjunction).append("O.createDate < ?");
            parameters.add(DateUtils.addDays(referenceDate, -nbDaysAfterThatDeleteAnOrder));
            conjunction = "";
        }
        return this;
    }

    @Override
    public MediaOrderCriteriaProcessor processIdentifiers(List<String> identifiers) {
        if (!done) {
            StringBuilder params = new StringBuilder();
            for (String identifier : identifiers) {
                if (params.length() > 0) {
                    params.append(",");
                }
                params.append("?");
                parameters.add(identifier);
            }
            where(conjunction).append("O.orderId in (").append(params.toString()).append(")");
            conjunction = "";
        }
        return this;
    }

    @Override
    public List<Order> orderingResult(final List<Order> orders) {
        return orders;
    }

    /**
     * Centralization to perform the where clause.
     * @param conjunction
     * @return
     */
    private StringBuilder where(String conjunction) {
        if (where.length() > 0) {
            where.append(conjunction);
        }
        return where;
    }
}