@@ -0,0 +1,2987 @@
+/*%0A * Copyright (c) 2017, University of Oslo%0A *%0A * All rights reserved.%0A * Redistribution and use in source and binary forms, with or without%0A * modification, are permitted provided that the following conditions are met:%0A * Redistributions of source code must retain the above copyright notice, this%0A * list of conditions and the following disclaimer.%0A *%0A * Redistributions in binary form must reproduce the above copyright notice,%0A * this list of conditions and the following disclaimer in the documentation%0A * and/or other materials provided with the distribution.%0A * Neither the name of the HISP project nor the names of its contributors may%0A * be used to endorse or promote products derived from this software without%0A * specific prior written permission.%0A *%0A * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS %22AS IS%22 AND%0A * ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED%0A * WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE%0A * DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR%0A * ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES%0A * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;%0A * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON%0A * ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT%0A * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS%0A * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.%0A */%0Apackage org.hisp.dhis.android.core.arch.db;%0A%0Aimport java.util.Collection;%0A%0Apublic class MultipleTableQueryBuilder %7B%0A%0A    private static final String NOT_NULL = %22 IS NOT NULL%22;%0A    private static final String SELECT = %22SELECT %22;%0A    private static final String WHERE = %22 WHERE %22;%0A    private static final String FROM = %22 FROM %22;%0A    private static final String UNION = %22 UNION %22;%0A    private static final String END_STR = %22;%22;%0A%0A    @SuppressWarnings(%22PMD.AvoidStringBufferField%22)%0A    private final StringBuilder clause = new StringBuilder();%0A    private boolean isFirst = true;%0A%0A    public MultipleTableQueryBuilder() %7B%0A    %7D%0A%0A    public MultipleTableQueryBuilder generateQuery(String columnName, Collection%3CString%3E tableNames) %7B%0A        for (String tableName : tableNames) %7B%0A            appendKeyValue(columnName, tableName);%0A        %7D%0A        clause.append(END_STR);%0A        return this;%0A    %7D%0A%0A    private MultipleTableQueryBuilder appendKeyValue(String column, String tableName) %7B%0A        String andOpt = isFirst ? %22%22 : UNION;%0A        isFirst = false;%0A        clause.append(andOpt).append(SELECT).append(column).append(FROM).append(tableName)%0A                .append(WHERE).append(column).append(NOT_NULL);%0A        return this;%0A    %7D%0A%0A    public String build() %7B%0A        if (clause.length() == 0) %7B%0A            throw new RuntimeException(%22No columns added%22);%0A        %7D else %7B%0A            return clause.toString();%0A        %7D%0A    %7D%0A%7D%0A

Add MultipleTableQueryBuilder