FabricantIteStepConfig.java
package com.sintia.ffl.admin.optique.services.batch.refpromoteur.export.ite;
import com.sintia.ffl.admin.optique.dal.entities.FabricantIte;
import com.sintia.ffl.admin.staging.FileUtils;
import com.sintia.ffl.admin.staging.GenerericJDBCItemReadFromDB;
import com.sintia.ffl.admin.staging.step.export.jdbc.AbstractSinglePromoteurJDBCExportStepConfig;
import com.sintia.ffl.adminui.commons.enums.TypeStaging;
import com.sintia.ffl.core.commons.enums.CodePromoteur;
import org.springframework.batch.core.Step;
import org.springframework.batch.core.configuration.annotation.StepScope;
import org.springframework.batch.integration.async.AsyncItemWriter;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.batch.core.repository.JobRepository;
import org.springframework.transaction.PlatformTransactionManager;
import javax.sql.DataSource;
import java.io.IOException;
import java.sql.Timestamp;
@Configuration
public class FabricantIteStepConfig extends AbstractSinglePromoteurJDBCExportStepConfig<FabricantIte> {
private static final String QUERY = "select c_opto_code_fabricant, l_fabricant, b_saisie, d_creation, d_maj, id_fabricant_ite " +
"from fabricant_ite";
public FabricantIteStepConfig() {
super(TypeStaging.REF_PROMOTEUR,
(rs, rowNum) -> {
Timestamp dCreation = rs.getTimestamp("d_creation");
Timestamp dMaj = rs.getTimestamp("d_maj");
return new FabricantIte(
rs.getInt("id_fabricant_ite"),
rs.getString("c_opto_code_fabricant"),
rs.getString("l_fabricant"),
rs.getString("b_saisie"),
dCreation == null ? null : dCreation.toLocalDateTime(),
dMaj == null ? null : dMaj.toLocalDateTime(),
null,
null
);
},
CodePromoteur.ITE);
}
@Bean
public Step fabricantIteStep(JobRepository jobRepository, PlatformTransactionManager transactionManager, FileUtils fileUtils,
DataSource dataSource) throws IOException {
return super.buildStep( jobRepository, transactionManager, fileUtils, dataSource);
}
@Bean("fabricantIteReader")
@StepScope
@Override
protected GenerericJDBCItemReadFromDB<FabricantIte> reader(
DataSource dataSource,
@Value("#{jobParameters['idPromoteur']}") Integer idPromoteur,
@Value("#{jobParameters['codePromoteur']}") String codePromoteur) throws IOException {
return super.buildReader(dataSource, QUERY, codePromoteur);
}
@Bean("fabricantIteWriter")
@StepScope
@Override
public AsyncItemWriter<FabricantIte> writer(
FileUtils fileUtils,
@Value("#{jobParameters['envSource'] ?: 'pprod'}") String envSource,
@Value("#{jobParameters['envCible'] ?: 'pprod'}") String envCible,
@Value("#{jobParameters['codePromoteur']}") String codePromoteur
) throws IOException {
return super.buildWriter(fileUtils, envSource, envCible, codePromoteur);
}
}