package se.ssb.lots.springconfig;

import org.hibernate.SessionFactory;
import org.hibernate.cfg.AnnotationConfiguration;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Scope;
import se.ssb.lots.domain.Sample;
import se.ssb.lots.migrators.Migrator;
import se.ssb.lots.persistence.dao.migrator.MigratorDao;
import se.ssb.lots.persistence.dao.migrator.MigratorDaoImpl;
import se.ssb.lots.persistence.dao.sample.SampleDao;
import se.ssb.lots.persistence.dao.sample.SampleDaoImpl;

@Configuration
public class SpringPersistenceConfiguration {
    @Bean
    @Scope("singleton")
    @Autowired
    MigratorDao getMigratorDao(SessionFactory sessionFactory) {
        return new MigratorDaoImpl(sessionFactory);
    }

    @Bean
    @Scope("singleton")
    @Autowired
    SampleDao getSampleDao(SessionFactory sessionFactory) {
        return new SampleDaoImpl(sessionFactory);
    }

    @Bean
    @Scope("singleton")
    SessionFactory getSessionFactory() {
        AnnotationConfiguration config = new AnnotationConfiguration();
        config.setProperty("hibernate.connection.pool_size", "1").
                setProperty("hibernate.connection.autocommit", "true").
                setProperty("hibernate.show_sql", "true").
                setProperty("hibernate.current_session_context_class", "thread").
                setProperty("hibernate.hbm2ddl.auto", "create-drop").
                setProperty("hibernate.dialect", "org.hibernate.dialect.MySQL5Dialect").
                setProperty("hibernate.connection.driver_class", "com.mysql.jdbc.Driver").
                setProperty("hibernate.connection.url", "jdbc:mysql://localhost/spacedtestdb").
                setProperty("hibernate.connection.username", "root").
                setProperty("hibernate.connection.password", "");

        annotateClasses(config);
        return config.buildSessionFactory();
    }

    private void annotateClasses(AnnotationConfiguration config) {
        config.addAnnotatedClass(Sample.class);
        config.addAnnotatedClass(Migrator.class);
    }

}