@Configuration
@EnableTransactionManagement
@ComponentScan({"su.vistar.ourdistrict.persistence", "su.vistar.ourdistrict.service"})
public class DataSourceTestConfig {

    @Bean
    public DataSource dataSource() {
        DriverManagerDataSource dataSource = new DriverManagerDataSource();
        dataSource.setDriverClassName("com.mysql.jdbc.Driver");
        dataSource.setUrl("jdbc:mysql://localhost:3306/my_territory_test");
        dataSource.setUsername("root");
        dataSource.setPassword("");

        Properties properties = new Properties();
        properties.put("characterEncoding", "UTF-8");

        dataSource.setConnectionProperties(properties);
        return dataSource;
    }

    @Bean
    public LocalSessionFactoryBean sessionFactory() {
        LocalSessionFactoryBean sessionFactory = new LocalSessionFactoryBean();
        sessionFactory.setDataSource(dataSource());
        sessionFactory.setPackagesToScan("su.vistar.ourdistrict.persistence.entity");

        Properties properties = new Properties();
        properties.put("hibernate.show_sql", "true");
        properties.put("hibernate.format_sql", "true");
        properties.put("hibernate.dialect", "org.hibernate.dialect.MySQLDialect");
        sessionFactory.setHibernateProperties(properties);

        return sessionFactory;
    }

    @Bean
    public HibernateTransactionManager transactionManager(SessionFactory s) {
        HibernateTransactionManager txManager = new HibernateTransactionManager();
        txManager.setSessionFactory(s);
        return txManager;
    }

    @Bean
    public TransactionTemplate transactionTemplate(HibernateTransactionManager tm) {
        TransactionTemplate template = new TransactionTemplate();
        template.setTransactionManager(tm);
        return template;
    }
}