net.n2oapp.framework.engine.sql.JdbcInvocationEngine Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of n2o-engine-sql Show documentation
There is a newer version: 7.4.18
package net.n2oapp.framework.engine.sql;

import net.n2oapp.framework.api.data.ActionInvocationEngine;
import net.n2oapp.framework.api.exception.N2oException;
import net.n2oapp.framework.api.exception.N2oUserException;
import net.n2oapp.framework.api.metadata.global.dao.invocation.model.DataSourceAware;
import net.n2oapp.framework.api.metadata.global.dao.invocation.model.N2oInvocation;
import net.n2oapp.routing.datasource.JndiRoutingDataSourceTemplate;
import org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate;

import java.util.List;
import java.util.Map;

import static net.n2oapp.framework.engine.sql.InvocationUtil.mapAndListsToJson;

/**
 * Абстрактный сервис выполнения jdbc запросов
 */
@Deprecated
public abstract class JdbcInvocationEngine implements ActionInvocationEngine {
    private JndiRoutingDataSourceTemplate jndiRoutingDataSourceTemplate;
    private NamedParameterJdbcTemplate namedParameterJdbcTemplate;

    public JdbcInvocationEngine(NamedParameterJdbcTemplate namedParameterJdbcTemplate) {
        this.namedParameterJdbcTemplate = namedParameterJdbcTemplate;
    }

    public JdbcInvocationEngine(NamedParameterJdbcTemplate namedParameterJdbcTemplate,
                                JndiRoutingDataSourceTemplate jndiRoutingDataSourceTemplate) {
        this.jndiRoutingDataSourceTemplate = jndiRoutingDataSourceTemplate;
        this.namedParameterJdbcTemplate = namedParameterJdbcTemplate;
    }

    protected abstract List getQueries(T invocation);

    protected Object[] execute(String jndiName, final List queries, final Map args) {
        if (jndiRoutingDataSourceTemplate != null)
            return jndiRoutingDataSourceTemplate.execute(jndiName, transactionStatus -> executeSql(queries, args));
        else
            return executeSql(queries, args);
    }

    private Object[] executeSql(List queries, Map args) {
        try {
            return SqlJpqlUtil.executeQueries(namedParameterJdbcTemplate, queries, args);
        } catch (N2oException e) {
            String summary = InvocationUtil.findSqlSummary(e);
            if (summary != null)
                throw new N2oUserException(summary);
            throw e;
        }
    }

    public JndiRoutingDataSourceTemplate getJndiRoutingDataSourceTemplate() {
        return jndiRoutingDataSourceTemplate;
    }

    public void setJndiRoutingDataSourceTemplate(JndiRoutingDataSourceTemplate jndiRoutingDataSourceTemplate) {
        this.jndiRoutingDataSourceTemplate = jndiRoutingDataSourceTemplate;
    }

    public void setNamedParameterJdbcTemplate(NamedParameterJdbcTemplate namedParameterJdbcTemplate) {
        this.namedParameterJdbcTemplate = namedParameterJdbcTemplate;
    }

}