@@ -0,0 +1,2991 @@
+/*%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 */%0A%0Apackage org.hisp.dhis.android.core.common;%0A%0Aimport org.hisp.dhis.android.core.data.database.DatabaseAdapter;%0A%0Aimport java.util.Collection;%0A%0Apublic class DataOrphanCleanerImpl%3CP extends ObjectWithUidInterface, C extends ObjectWithUidInterface%3E%0A        implements OrphanCleaner%3CP, C%3E %7B%0A%0A    private final String tableName;%0A    private final String parentColumn;%0A    private final String stateColumn;%0A    private final DatabaseAdapter databaseAdapter;%0A%0A    public DataOrphanCleanerImpl(String tableName, String parentColumn, String stateColumn,%0A                                 DatabaseAdapter databaseAdapter) %7B%0A        this.tableName = tableName;%0A        this.parentColumn = parentColumn;%0A        this.stateColumn = stateColumn;%0A        this.databaseAdapter = databaseAdapter;%0A    %7D%0A%0A    public boolean deleteOrphan(P parent, Collection%3CC%3E children) %7B%0A        if (parent == null %7C%7C children == null) %7B%0A            return false;%0A        %7D%0A%0A        String childrenUids = UidsHelper.commaSeparatedUidsWithSingleQuotationMarks(children);%0A        String clause =%0A                parentColumn + %22='%22 + parent.uid() + %22'%22%0A                        + %22 AND %22%0A                        + stateColumn + %22='%22 + State.TO_POST + %22'%22%0A                        + %22 AND %22%0A                        + BaseIdentifiableObjectModel.Columns.UID + %22 NOT IN (%22 + childrenUids + %22);%22;%0A        return databaseAdapter.database().delete(tableName, clause, null) %3E 0;%0A    %7D%0A%7D

create DataOrphanCleanerImpl