com.jporm.rm.query.delete.DeleteQueryImpl Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of jpo-rm Show documentation
There is a newer version: 8.9.0
/*******************************************************************************
 * Copyright 2013 Francesco Cina'
 *
 * Licensed 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.
 ******************************************************************************/
/*
 * ---------------------------------------------------------------------------- PROJECT : JPOrm CREATED BY : Francesco
 * Cina' ON : Feb 23, 2013 ----------------------------------------------------------------------------
 */
package com.jporm.rm.query.delete;

import java.util.ArrayList;
import java.util.Collection;
import java.util.stream.IntStream;

import com.jporm.commons.core.inject.ClassTool;
import com.jporm.commons.core.query.cache.SqlCache;
import com.jporm.commons.core.query.strategy.DeleteExecutionStrategy;
import com.jporm.commons.core.query.strategy.QueryExecutionStrategy;
import com.jporm.rm.session.SqlExecutor;
import com.jporm.sql.dialect.DBProfile;

/**
 * 
 * 
 * notes:
 * 
 * ON : Feb 23, 2013
 *
 * @author Francesco Cina'
 * @version $Revision
 */
public class DeleteQueryImpl implements DeleteQuery, DeleteExecutionStrategy {

    // private final BEAN bean;
    private final Collection beans;
    private final SqlExecutor sqlExecutor;
    private final DBProfile dbType;
    private final Class clazz;
    private final SqlCache sqlCache;
    private final ClassTool ormClassTool;

    /**
     * @param newBean
     * @param serviceCatalog
     * @param ormSession
     */
    public DeleteQueryImpl(final Collection beans, final Class clazz, final ClassTool ormClassTool, final SqlCache sqlCache, final SqlExecutor sqlExecutor,
            final DBProfile dbType) {
        this.beans = beans;
        this.clazz = clazz;
        this.ormClassTool = ormClassTool;
        this.sqlCache = sqlCache;
        this.sqlExecutor = sqlExecutor;
        this.dbType = dbType;
    }

    @Override
    public int execute() {
        return QueryExecutionStrategy.build(dbType).executeDelete(this);
    }

    @Override
    public int executeWithBatchUpdate() {
        String query = sqlCache.delete(clazz);
        String[] pks = ormClassTool.getDescriptor().getPrimaryKeyColumnJavaNames();

        // WITH BATCH UPDATE VERSION:
        Collection values = new ArrayList<>();
        beans.forEach(bean -> values.add(ormClassTool.getPersistor().getPropertyValues(pks, bean)));
        int[] result = sqlExecutor.batchUpdate(query, values);
        return IntStream.of(result).sum();
    }

    @Override
    public int executeWithSimpleUpdate() {
        String query = sqlCache.delete(clazz);
        String[] pks = ormClassTool.getDescriptor().getPrimaryKeyColumnJavaNames();

        // WITHOUT BATCH UPDATE VERSION:
        int result = 0;
        for (BEAN bean : beans) {
            Object[] values = ormClassTool.getPersistor().getPropertyValues(pks, bean);
            result += sqlExecutor.update(query, values);

        }
        return result;
    }

}