com.concur.dao.ArchiveRunDaoImpl.java Source code

Introduction

Here is the source code for com.concur.dao.ArchiveRunDaoImpl.java

Source

/*
 * Copyright 2002-2013 the original author or authors.
 *
 * 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.
 */
package com.concur.dao;

import com.concur.model.ArchiveRun;
import com.concur.model.EntityInfo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.datasource.DriverManagerDataSource;
import org.springframework.stereotype.Repository;

import javax.sql.DataSource;
import java.util.Collection;

/**
 * @author Ken Krebs
 * @author Juergen Hoeller
 * @author Rob Harrop
 * @author Sam Brannen
 * @author Thomas Risberg
 * @author Mark Fisher
 */
@Repository
public class ArchiveRunDaoImpl implements ArchiveRunDao {

    //    @Autowired
    @Qualifier("jdbcDW")
    private JdbcTemplate jdbcTemplate;

    private DataSource dataSource;

    @Autowired
    private HostDaoImpl hostDaoImpl;

    public ArchiveRunDaoImpl() {
    }

    @Override
    public Collection<ArchiveRun> findArchiveRuns() throws DataAccessException {
        System.out.println("in archive run com.concur.dao impl");

        return this.jdbcTemplate.query("SELECT  etl_batch_key job_key, etl_status job_status, "
                + "DATEDIFF(MINUTE, etl_start_dttm, etl_end_dttm) job_duration " + "FROM dbo.dim_etl_batch "
                + "WHERE job_type = 'DW_GEXP_ARCHIVE' " + "AND etl_status NOT IN ('RUNNING') "
                + "ORDER BY etl_batch_key", BeanPropertyRowMapper.newInstance(ArchiveRun.class));
    }

    /**
     * based on the entity connection info, build the datasource object
     * @param entityInfo
     * @return
     */
    public DataSource getDataSource(EntityInfo entityInfo) {
        DriverManagerDataSource dataSource = new DriverManagerDataSource();
        dataSource.setDriverClassName("net.sourceforge.jtds.jdbc.Driver");
        dataSource.setUrl("jdbc:jtds:sqlserver://192.168.24.145:1433/" + entityInfo.getSchemaName() + ";user="
                + entityInfo.getUsername() + ";password=4wg");
        dataSource.setUsername(entityInfo.getUsername());
        //        dataSource.setPassword("4wg");

        return dataSource;
    }

    @Override
    public Collection<ArchiveRun> findArchiveRun(String entity) throws DataAccessException {
        EntityInfo entityInfo = hostDaoImpl.getEntityKey(entity);
        jdbcTemplate = new JdbcTemplate(getDataSource(entityInfo));

        return this.jdbcTemplate.query("SELECT  etl_batch_key job_key, etl_status job_status, "
                + "DATEDIFF(MINUTE, etl_start_dttm, etl_end_dttm) job_duration " + "FROM dbo.dim_etl_batch "
                + "WHERE job_type = 'DW_GEXP_ARCHIVE' " + "AND etl_status NOT IN ('RUNNING') "
                + "ORDER BY etl_batch_key", BeanPropertyRowMapper.newInstance(ArchiveRun.class));
    }
}