malinink / easy-tests

import javax.sql.DataSource;

import org.apache.ibatis.datasource.pooled.PooledDataSource;

import org.apache.ibatis.session.SqlSessionFactory;

import org.mybatis.spring.SqlSessionFactoryBean;

import org.mybatis.spring.annotation.MapperScan;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.context.annotation.Bean;

import org.springframework.context.annotation.Configuration;

import org.springframework.context.annotation.PropertySource;

import org.springframework.core.env.Environment;

import org.springframework.jdbc.datasource.DataSourceTransactionManager;

/**

 * @author malinink

 */

@Configuration

@MapperScan("easytests.core.mappers")

@PropertySource("classpath:database.properties")

public class DatabaseConfig {

    @Autowired

    private Environment env;

    @Bean

    public DataSource getDataSource() {

        final PooledDataSource dataSource = new PooledDataSource();

        dataSource.setDriver(env.getProperty("driver"));

        dataSource.setUrl(env.getProperty("url"));

        dataSource.setUsername(env.getProperty("username"));

        dataSource.setPassword(env.getProperty("password"));

        return dataSource;

    }

    @Bean

    public SqlSessionFactory sqlSessionFactory() throws Exception {

        final SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();

        sessionFactory.setDataSource(getDataSource());

        return sessionFactory.getObject();

    }

}